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.
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
