Dear All,
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?
newbie14
0
Posting Pro
Recommended Answers
Jump to PostThe 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.
Jump to PostOn this page, there is the following info:
Replication Modes
MySQL Replication is asynchronous and enables data to be replicated from one MySQL Master to one or more MySQL Slaves. Plus, MySQL Replication supports multiple logging types to optimize performance for each of the types of updates …
All 5 Replies
lolafuertes
145
Master Poster
newbie14
0
Posting Pro
lolafuertes
145
Master Poster
newbie14
0
Posting Pro
lolafuertes
145
Master Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.