Design advice required

Question

0.00/5 (No votes)

See more:

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 Hayden

Updated 5-Oct-12 11:07am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

**AmitGajjar** · Accepted Answer · 2012-10-05T16:18:00

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

Posted 5-Oct-12 16:18pm

AmitGajjar

Comments

Ger Hayden 6-Oct-12 5:04am

I will have a fixed number of known clients.

Ger Hayden 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 6-Oct-12 5:34am

Have you think about mirroring ?

Ger Hayden 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 7-Oct-12 8:42am

In that can you can seprate log database to prevent log from synchronize.

AmitGajjar 7-Oct-12 8:42am

You can also create scheduler task to schedule the synchronization process.