Jump to content
fwk

Server Replication with FM EasySync? Can it be reasonably done

Recommended Posts

fwk    0

Hi,

has anybody ever tried setting up more at least two servers and using FM EasySync to keep the data synchronized on them? As far as I understand this would require some kind of separate sync worker machine to keep some kind of master DB.

Regards

Franz

Share this post


Link to post
Share on other sites
Wim Decorte    455

What's the purpose of the sever-to-server sync?  To have the 2nd server as a standby or would users actively hit both servers?

Share this post


Link to post
Share on other sites
fwk    0
On 2.4.2017 at 0:27 AM, Wim Decorte said:

What's the purpose of the sever-to-server sync?  To have the 2nd server as a standby or would users actively hit both servers?

Users would actively hit both servers while they are up and connected to the internet.

So while everything is fine you got double the bandwidth. And one could even stop one of the Servers for maintenance without disrupting service.

Share this post


Link to post
Share on other sites
Wim Decorte    455
4 hours ago, fwk said:

Users would actively hit both servers while they are up and connected to the internet.

So while everything is fine you got double the bandwidth. 

 

If you're thinking 'bandwidth' as in network throughput then that is rarely a bottleneck.  Processing power is.  Or in the network realm: latency.  Having filemaker servers that are more local to the users makes sense from that perspective but not from a pure bandwidth perspective.

server-to-server syncs can be done but it is a ton of work and requires an extremely stable and monitored deployment; so do it only for the right reasons and start by monitoring your current bottlenecks so that you don't try to solve a problem that doesn't need solving.

The go-to product for this kind of server-to-server sync has been SyncDek; now rebranded to http://www.syncserverpro.com/

I do believe that MirrorSync also offers server-to-server sync.

I definitely would not use FMEasySync since it is an abandoned product; for this kind of thing you need something that offers support.

 

  • Like 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Similar Content

    • By vratnayaka
      Hello Everyone,
       
      We have a filemaker file that is damaged. When we try to recover it, filemaker suggests we stop using the file and extract the data. We however continued using the file anyway as it is a crucial part of the overall system. At the same time I started creating the file from scratch. The file itself is quite big, more than 100 fields and 800000 records. It's been around for about 10 years therefore the fields have just kept adding. 
       
      These are the steps I followed to create the new file ;
       
      1. Create a new filemaker file with the same name as the old one.
      2. Create all the tables that were in the old file.
      3. Create all datasources as in the old file.
      4. Sort the old database fields by type and copy over all fields except calculations and summaries.
      5. Create all relations from scratch; to be exactly the same as the old file.
      6. Copy over all calculations and summaries to new file.
      7. Check all look ups to make sure all fields referenced are valid.
      8. Go through each layout in the old file and create new layouts in the new file WITH JUST THE LAYOUT NAME (So that scripts can be imported from the old file without losing references to layouts)
      9. Copy all scripts from  the old file in to the new one.
      10. Copy all value lists from the old file to the new one.
      11. Go through all layouts and copy all the layout objects in to the new layouts.  12. Import all records from the old file.
      13. Test buttons and layouts to see if all fields and scripts are correctly referenced.
       
      I performed all above steps and I managed to create a fully functional brand new replication of the old corrupted file. 
       
      I decided to take the file and test how it runs together with all the other files, I retrieved a back up of the entire solution, replaced the old file with the new one and started checking other files referencing the newly replicated file.
       
      The relationship structure shows that the file replicated is correctly referenced as a datasource but the fields matched within the relation are unknown or are incorrect fields. Refer to attached image. 
       
      I am confused to as why this is the case, the filenames are exactly the same as the old file. Shouldn't the relations pick this up? I thought perhaps this is due to the order the fields were added to the old one. i.e. the creation orders. I then decided to take the fields off and copy them back in the same creation order as the old file, copy over the new file to a brand new copy of the solution. This made no difference, the external files were still referencing the wrong fields or were unknown. 
       
      I am very curious as to why this is, I know very little about the internal structure of filemaker, I am pretty sure filemaker does not assign an unique id to each field. Even if it did, creating the fields in the same creation order should assign the same id as the ones in the older file. Can anyone shed some light on this?
       
      I am going to see what the replies are going to be before I put the new file live and rebuild the external relation references, which is going to be a lengthy process.
       
      Thank you in advance.
×

Important Information

By using this site, you agree to our Terms of Use.