Re: synchronizing mysql database in two diferrent places
Hello, You might try MySQL's inbuilt replication feature. If you want a more simple approach, might take a look at SQLyog's Data Sync Wizard. More information can be found at http://www.webyog.com I think they have a article on the same subject in SitePoint. You might google it. Karam --- Eko Budiharto <[EMAIL PROTECTED]> wrote: > Hi, > I a facing a situation where I have two database > server in two different > places that has exactly the same database. The thing > is if the database > is modified in either one of the places, both > database has to be updated > lively. > Can someone tell me who done this already? Please > help. > I am looking forward to a favorable reply from you. > Thank you. > __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: synchronizing mysql database in two diferrent places
Hi. MySQL replication currently does not support any locking protocol between master and slave to guarantee the atomicity of a distributed (cross-server) update. See: http://dev.mysql.com/doc/mysql/en/Replication_FAQ.html >"Eko Budiharto" <[EMAIL PROTECTED]> wrote: > >Hi, >I a facing a situation where I have two database server in two different >places that has exactly the same database. The thing is if the database >is modified in either one of the places, both database has to be updated >lively. >Can someone tell me who done this already? Please help. >I am looking forward to a favorable reply from you. Thank you. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
