Followers 1

Multiple MySQL Hub --> FileMaker Client

By Stavie, November 24, 2017 in MirrorSync by 360Works

Recommended Posts

Stavie 0

Posted November 24, 2017

We have a complex MySQL and PHP; multi-tenanted application which we are now looking at syncing to an offline portable FileMaker model.

I have essentially solved every problem thus far and have MirrorSync running properly.

My challenge is this: Our main MySQL database works in tandem with a second MySQL database; the second database contains 25 million property records.

The working set of data which needs to be synchronised is a small subset of data from the primary; and a single record from the secondary database into the mobile version of the application which consists of a single FileMaker file with identical tables to that of the primary mysql database and a table identical to that of that of the secondary.

How do sync the two seperate databases in a single configuration? Or is that even possible. I could see that I could generate two seperate configurations; and perhaps split the mobile version into two seperate FileMaker files; i'm just wondering if there is a smarter way to go about what I need to achieve.

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 in

Already have an account? Sign in here.

Followers 1

Go To Topic Listing MirrorSync by 360Works

Similar Content
- Multiple MySQL Hub --> FileMaker Client
  By Stavie
  
  We have a complex MySQL and PHP; multi-tenanted application which we are now looking at syncing to an offline portable FileMaker model.
  I have essentially solved every problem thus far and have MirrorSync running properly.
  My challenge is this: Our main MySQL database works in tandem with a second MySQL database; the second database contains 25 million property records.
  The working set of data which needs to be synchronised is a small subset of data from the primary; and a single record from the secondary database into the mobile version of the application which consists of a single FileMaker file with identical tables to that of the primary mysql database and a table identical to that of that of the secondary.
  How do sync the two seperate databases in a single configuration? Or is that even possible. I could see that I could generate two seperate configurations; and perhaps split the mobile version into two seperate FileMaker files; i'm just wondering if there is a smarter way to go about what I need to achieve.