I got a standalone application where I update 3 db at one time. One on local db, one is central db and one more is the its exact copy of local db in the central server. So I have been using the normal begin and commit when there is no problem I commit for all 3 one by one. I know is not a function supported by .net connector. So at times it fails to update the central db. Any solution please?
Jump to Post
The MySQL Enterprise edition supoports replication based on row changes or on statements.
Instead of commiting the same change 3 times, you only will need to do the change in the local db and will be replicated on the central ones automatically.
All 5 Replies
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.