Jump to content
Stavie

mysql Multiple MySQL Hub --> FileMaker Client

Recommended Posts

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

Hi Stavie - I've read your questions several times, but I'm just not understanding this part. Could you rephrase and provide more detail?

Quote

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.

 

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 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.

  • Who Viewed the Topic

    9 members have viewed this topic:
    tomjets  360Works  jayivan  Amber360Works  doughemi  Lee Smith  Jesse Barnum  bcooney  Stavie 
×

Important Information

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