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

1
vote
2answers
212 views

What is the best way to change the replication scheme of 2 currently replicated slaves?

I have MySQL replication set up in production as follows: DB1 -> DB2 DB1 -> BAK Where DB2 and BAK are slaves to DB1. All 3 servers are in sync (0 seconds behind the master) and have 30+ GB of ...
1
vote
2answers
498 views

A few tables are still out of sync after running mk-table-sync

I have 1 master and 2 slaves. I am using MySQL 5.1.42 on all servers. I am attempting to use mk-table-checksum to verify that their data is in sync, but I am getting unexpected results on one of ...
0
votes
2answers
308 views

Keeping two servers in sync - secondary server only to be booted for the backup, or in outage

I've just started a new Software Development job but I've basically been given loads of sysadmin stuff to do because the development team consists of only 2 people + the CTO. I've got pretty much zero ...
0
votes
2answers
129 views

Mysql Replication restart

I have a slave db (db1) that I moved into the master position after my master db (db2) died. I brought up a new slave db (db3) from a day old snapshot of db1, my problem is trying to figure out which ...
0
votes
2answers
525 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 ...