Comments on How To Set Up Multi-Master Replication Using Tungsten And MySQL-Proxy For MySQL High Availability On Ubuntu 10.04.3 LTS
How To Set Up Multi-Master Replication Using Tungsten And MySQL-Proxy For MySQL High Availability On Ubuntu 10.04.3 LTS This tutorial is based on my experience setting up Tungsten Replicator and MySQL-Proxy for a client's production setup.
5 Comment(s)
Comments
Multi-master as it stands here doesn't provide anything over standard MySQL replication and has all the same drawbacks with the additional overhead of going through the flaky MySQL-Proxy and managing Tungsten.
Except that Tungsten Replicator is superior to MySQL replication. MySQL replication is horribly unreliable, and once it crashes it is horrible to get back in sync, requires downtime or "read only" master time...
Hi,
Great article, just wanted to ask one thing. What will be the behavior in the case when two "INSERT / UPDATE / ALTER" queries are received at the same time, How will this be handled in this scenario.
Hi,
good article and easy installation. I want to try install servers like this post, but on Debian Wheezy.
I want to install high availability mysql servers for my client, but is not good to have classical replication. Is not easy to restore back broken replication on production servers. This article looking good for replacing one broken server with the new one.
My question is only: Is it possible to do this with separate mysql-proxy? I think, it is not important to install it to the web servers.
Hi,
do you install
Ruby / JAVA Virtual Machine / Tungsten Replicatoron the Web server or on one of Master?
Tank you for your answer.
Kr