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)

Add comment

Please register in our forum first to comment.

Comments

By: Anonymous

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. 

By: Anonymous

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...

 

By: Mudasir Mirza

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.

By: Frantisek Pida Preissler

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.

By: max524

Hi,

do you install

Ruby / JAVA Virtual Machine /  Tungsten Replicator

on the Web server or on one of Master?

Tank you for your answer.

Kr