Full complete MySQL database replication? Ideas? What do people do?

Currently I have two Linux servers running MySQL, one sitting on a rack right next to me under a 10 Mbit/s upload pipe (main server) and another some couple of miles away on a 3 Mbit/s upload pipe (mirror).

I want to be able to replicate data on both servers continuously, but have run into several roadblocks. One of them being, under MySQL master/slave configurations, every now and then, some statements drop (!), meaning; some people logging on to the mirror URL don't see data that I know is on the main server and vice versa. Let's say this happens on a meaningful block of data once every month, so I can live with it and assume it's a "lost packet" issue (i.e., god knows, but we'll compensate).

The other most important (and annoying) recurring issue is that, when for some reason we do a major upload or update (or reboot) on one end and have to sever the link, then LOAD DATA FROM MASTER doesn't work and I have to manually dump on one end and upload on the other, quite a task nowadays moving some .5 TB worth of data.

Is there software for this? I know MySQL (the "corporation") offers this as a VERY expensive service (full database replication). What do people out there do? The way it's structured, we run an automatic failover where if one server is not up, then the main URL just resolves to the other server.

This question and answers originated from www.stackoverflow.com
Question by (8/6/2008 6:24:42 PM)

Answer
Answer by
Find More Answers
Related Topics  mysql  replication
Related Questions

  • How do I completely disable MySQL replication

    I am running dual master MySQL replication and now want to move to a single database with no replication. How do I completely disable replication on both databases?

  • What can we do in MySQL 5.0 Replication to address bandwidth concerns?

    I am developing an application to run on the client PC (Win) which is configured with a MySQL server 5.1 instance that will act as read-only slave to the remote master. The remote master has dozens …

  • MySql - Two slave database replication

    I want to achieve same server replication, such a way there will be two databases replicating one database on same server Here is my configuration in my.ini enter code here server-id=1 log-…

  • Is it possible to do N-master => 1-slave replication with MySQL?

    I want to make a dedicated SLAVE machine for data replication of three database on three different servers. In other words, I want to do Multiple Master => SIngle Slave replication. Is there any …

  • MySQL Database Replication for Multiple Tables

    Previously, I have experience in doing the following database replication. (1) I have 2 tables within 1 database in Machine A (2) I update 2 tables in Machine A (3) Machine A will replicate…

  • MySQL replication of only one database

    I just wanted to check on the replication setup I've got working. The plan was to replicate just one database, so per the MySQL documentation I used the replicate-do-db flag in my MySQL configuratio…

  • Mysql replication, one database server process

    Possible Duplicate: Mysql replication server both master slave On my development box, I want to experiment with a replication setup. But I don't want to create several mysqld processes…

  • Mysql Replication-- restricting drop database statements

    we have a master-slave mysql replication setup. The master has multiple databases and they get created and dropped, fairly often. I would like to restrict the slave to not drop the databases. I co…

  • MySQL Database Replication and Server Load

    I have an online service with around 5000 MySQL databases. Now, I am interested in building a development area of the exactly same environment in my office, therefore, I am about to setup MySQL repl…

  • repairing mysql replication

    We were running out of the disk space on slave because of relay-bin files, so I stopped the mysql server, deleted the relay-bin files. changed my.cnf file to point the relay log to another location.…