Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves).

learn more… | top users | synonyms

4
votes
2answers
3k views

MySQL slave replication reset with no Master Downtime (using MyISAM)

Root of the issue: In all instructions for creating a slave on a running master requires flush tables with read lock. We use MyISAM, so we can't just use --single transaction to get consistent table ...
3
votes
5answers
4k views

How can I back up and replicate a large MySQL database?

How can I backup a large database in mysql? And what is the best way to replicate the database? what i'm looking for is backing up large database with large amount of data in a small time limit ...
43
votes
9answers
51k views

How can I export the privileges from MySQL and then import to a new server?

I know how to export/import the databases using mysqldump & that's fine but how do I get the privileges into the new server. For extra points, there are a couple of existing databases on the new ...
3
votes
3answers
922 views

mysql master-slave setup with synchronous replication

I have a very trivial mysql master->slave setup going on between two servers. The problem is, replication is asynchronous, and this can cause issues (even on a low latency link), if the master server ...
1
vote
3answers
2k views

MySQL in star topology

I have one central database with all the data in MySQL 5.1-lastest-stable. I want to hook up multiple clients in a master-master relationship. Question How do I setup a star topology with 1 central ...
-1
votes
6answers
242 views

backing up large database with large amount of data in a small time limit then restoring it within a small time of limit? [closed]

Backing up large database with large amount of data in a small time limit then restoring it within a small time of limit? Any useful ideas?
2
votes
2answers
160 views

Mysql replication server both master slave

I have a mysql db in my box. Can I replicate it to another db on the same box? ie, the same box would be both master and slave(s). Are there other ways of achieving this? (I'm thinking ...
0
votes
2answers
497 views

How do I sync a subset of tables between two databases on the same mysql database server

would like to be able to sync a subset of tables between two mysql databases that are running on the same server. One of the databases acts as the master where inserts, updates and deletes can be ...
11
votes
3answers
2k views

MySQL replication across geographically separate servers

My organisation has been looking into how to spread our servers around geographically while keeping backups very up to date, and ideally spreading the load. The initial thing I have in mind is Rails ...
1
vote
5answers
5k views

MySQL slave out of sync with master

Our slave, which is just used for backups, is out of sync. It has crashed out on a key restraint. I would like to find a way to resync up the slave without taking the master offline, I know I can do ...
15
votes
2answers
1k views

Is it ok to replicate the `mysql` database?

When I originally set up my master-to-master replication, I used: binlog-ignore-db=mysql and have been syncing the user accounts and grants manually. This is simply how it was done in the how-to I ...
2
votes
3answers
938 views

How to scale out mySQL with many Database Server (say 20 database servers)

To scale from 1 MySQL Database server to 4-5 server is very clear from the documentation by MySQL official developer website: http://dev.mysql.com/doc/refman/5.1/en/replication-solutions-scaleout.html ...
3
votes
1answer
340 views

Using Amazon RDS (or similar) as a slave

Officially, RDS instances can't be directly set up to slave non-RDS databases. My production master is MySQL running on Hetzner and I want an RDS instance to closely follow it for backup purposes, ...
2
votes
1answer
439 views

error setting up replication from mssql to mysql

I'm trying to setup replication from SQL Server 2005 to MySql 5.1.53. I am able to add the publication without any problem. However, when I go to add the subscription I get this error: OLE DB or ...
2
votes
3answers
2k views

Help me understand mk-heartbeat

Seconds_Behind_Master from SHOW SLAVE STATUS is considered an unreliable measure of Slave lag. mk-heartbeat is often offered as a reliable alternative. Now mk-heartbeat does not even need the Slave ...
2
votes
2answers
406 views

Why is MySQL Replication so complicated?

It seems so simple: I have two servers running MySQL, one has a nice big database of important stuff, the other is an empty shell ready to be used as a replication slave. These are the steps I should ...
1
vote
3answers
339 views

MySQL HA Solutions

I am evaluating the options to build MySQL HA and found the below solutions Percona XtraDB Cluster, Tungsten Replicator, and MySQL Cluster. Could you please help me to choose the best one with ...
1
vote
2answers
231 views

mysql replication 1x master, 1x slave

I have just setup one master and one slave server, but its not working.. On my website I connect to the slave server and I insert some rows, but they do not appear on the master and vice versa.. What ...
1
vote
2answers
714 views

What is the easiest way to move mysql from linux box one my local Vista box?

I am fairly new to mysql...be gentle. I am trying to move mysql db from linux box to windows box where I do all the development. Can someone tell, or reference me, how to do it step by steps? ...
0
votes
1answer
110 views

Setup MySQL replication - multiple machines?

i read a lot of mysql server repliaction tutorials, but there's no hint, if the slave server is on a second machine or on the same server but just another mysqld process? any advice? thanks in ...
0
votes
0answers
187 views

MySQL is killing the server IO

I manage a fairly large/busy vBulletin forums (running on gigenet cloud), the database is ~ 10 GB (~9 milion posts, ~60 queries per second), lately MySQL have been grinding the disk like there's no ...
0
votes
1answer
115 views

What is the best of two approaches to achieve DB Replication?

we have two approaches to achieve DB Replication: Master-Master replication. Master, 1 Primary Slave, 1 Secondary slave. I am planning to analyze these two approaches and prepare a comparison ...
0
votes
3answers
1k views

Two way, multi-site replication in MySQL

We have MySQL 5.1 databases at 5 separate locations that we need to keep as synced as possible. Each office needs to read/write from/to the local server at that office, but I need the DB at each ...
0
votes
2answers
847 views

SAN + MySQL replication- is that what I want for my load-balanced Drupal cluster?

I need to put together a Drupal instance using Drupal's built-in multisite features, which will allow me to use a single code base for all the sites- a big time-saver and headache-preventer. We're ...