Re: Database restore

On 05-02-15 15:11, Reindl Harald wrote:
>
> Am 05.02.2015 um 15:00 schrieb Curtis Maurand:
>> Thanks, I'll give that a shot while i look at replicatuon which I've
>> never been able to make work
>
> there is nothing difficult and is configured within 5 minutes
I disagree, the learning curve is not 5 minutes long (but well worth 
your time)
>
> just enable binlog on the current server, rsync the datadir to the new 
> slave and start replication there

Instead of using rsync, consider xtrabackup. When all your tables are 
innodb (no myisam), it allows you to create a backup without stopping 
the server (except for configuration changes, binlog needs to be enabled 
before making the backup)

http://www.percona.com/doc/percona-xtrabackup/2.2/

I've written a blog post about it a few years back: 
http://techblog.procurios.nl/k/n618/news/view/56429/14863/how-to-migrate-mysql-databases-without-downtime.html

But seriously: master-master mysql replication (or the galera solution) 
should be a bare minimum on ALL database servers you deploy from now on.