1
vote
2answers
211 views

Is it possible to create a mysql slave from start of masters binlog without copying data first?

info: my tables are all innodb. i know i can create a mysql slave by copying the data from master to slave and noting the position in the binlog and set that on the slave. thus the slave should be ...
5
votes
2answers
2k views

Way to avoid server downtime when creating Master - Slave relationship?

I am preparing for setting up a MySQL master-slave or master-master relationship. Right now I have a single MySQL production server, and of course I don't want a lot of downtime while I connect the ...
1
vote
3answers
715 views

MySQL / InnoDB replication: how to perform crash recovery?

How do I perform crash recovery in a MySQL/InnoDB Master-Slave asynchronous replication setup? Specifically: If a slave crashes, how do I make it syncs up with the master after I bring it back up? ...
2
votes
2answers
1k views

Restoring a slave MySQL database from raw backups of master gives InnoDB tablespace errors

I have a master/slave replication setup where I use InnoDB and MyISAM tables in over 7000 databases that I want to copy from my master to the slave to restore replication. Both servers were running ...
3
votes
2answers
351 views

What is the best way to check the status of a MySQL slave that is replicating from a master?

Specifically I have a set of InnoDB tables and we are backing these up into MyISAM tables to provide full text search. The slave DB routinely falls behind the Master. I am looking for advice on ...