MySQL Replication Issues

ebrahim1981 said:
What do you need help with?
Click to expand...

We got a HeadOffice in durban...and branches in various locations...our software uses MYSQL as backend...i want all updates at headoffice to UPDATE branches...and any updates at branches...to be updated back at HeadOFfice....

we had the CIRCULAR replication working...so HO->BranchA->BranchB->BranchC->HO.....so any update anywhere...was updating the others...but its breaking every few days...and we can't find out why...and where...

So, need some advice on how to do it...best solution for us was MULTI-MASTER Replication...but afaik Mysql does not support it...
 
There is though a third party tool "Tungsten" we trying to get it working if we can...but still not sure...is it a good solution...or u guys recommend something else?
 
How are the branches connected? Replication will probably break more often then your current set up if the connections between the machines isn't very stable.
 
Replication will work fine, even with unstable connections, the problem will come in when changes are made to the same record and then the replication rules you setup will kick in.
When you say it is "breaking", can you provide details of the problem??
 
we have setup OPENVPN between the branches...and besides a few connection problems...here and there...the vpn is consistent...

Basically we updating our Stock Values and Orders between the branches....Breaking means....When orders recd. at one Branch...are not replicated back to Headoffice and/or other branches...and Stock Values are not updating...and vice versa...

about the same record updates...that will always be the case...say we sold itemA...in Branch1....so stock updated there...and then we sold same item at Branch2...headoffice data is updated for Stock-In-Hand for that same item...Or recd. order at Branch1...same order is then edited at Branch1...and also at HeadOffice...shud not be a problem as such...bcoz its running off the queuing system FIFO...so whoever updates first...updates the db...and thus replicator updates other branches...

besides that...what u guys suggest we shud use to get better results in such case...i mean Mysql is gud enough...or change to SQL Server/Oracle etc...if they provide better replication solution.
 
I have used SQL Server replication and know that I did not get the problem you experiencing.
Seems strange you getting that problem, as that is the basis of replication and if that is not working, then replication in that product is not working. Are you using the latest version of MySQL with all patches/updates applied?? Maybe contact MySQL team to find out if there is a bug and how you can overcome it!!
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X