Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: MySQL
My system has 36 tables. The client will notify the service of changes to 6 of them in real time, while the service will then distribute all that real time data to the other clients. Nightly the service will distribute updates to the other 30 tables to all clients.
 
Now I can maintain export flags on each table and poll each one via its own thread, or I can fire a trigger to add a row to a changelog table and just poll it.
 
Are there practical considerations or is this just a question of style?
Posted 5-Oct-12 11:05am
Ger Hayden23.9K
Edited 5-Oct-12 11:07am
v2

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Hi,
 
What i understand is, you have separate databases on client computer and you need to synchronize with central server database.
 
If you do not have changes in number of client or location of the client then you can update your central database that can update your client databases at that time. As we are using Linked server in MSSQL the similar way you can use MySQL FEDERATED Storage Engine[^]. You can also use mirroring. But Please provide more information what can be suitagle on your scenario.
 
Thanks
  Permalink  
Comments
Ger Hayden at 6-Oct-12 5:04am
   
I will have a fixed number of known clients.
Ger Hayden at 6-Oct-12 5:06am
   
I've taken a look at the FEDERATED Solutions. The client databases will be on busses and constant connectivity cannot be gauranteed.
@AmitGajjar at 6-Oct-12 5:34am
   
Have you think about mirroring ?
Ger Hayden at 6-Oct-12 14:21pm
   
No they would be quite equal. All clients will feed in logs as well as sales/validation. The logs will not be redistributed. Customer accounts will only live in the back office and only the balance will ever reach the clients.
@AmitGajjar at 7-Oct-12 8:42am
   
In that can you can seprate log database to prevent log from synchronize.
@AmitGajjar at 7-Oct-12 8:42am
   
You can also create scheduler task to schedule the synchronization process.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 253
1 Maciej Los 205
2 Nguyen.H.H.Dang 190
3 Peter Leow 185
4 arvind mepani 162


Advertise | Privacy | Mobile
Web02 | 2.8.140709.1 | Last Updated 5 Oct 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid