[TriLUG] MySql replication

Rick DeNatale rick.denatale at gmail.com
Thu Jul 6 15:29:08 EDT 2006

I've been meaning to set up a slave mysql server so that I can leave
the main server running while taking backup snapshots from the slave.

I just discovered the fact that MySql seems to make it pretty easy to
have multiple instances of the daemon running on the same machine, so
I'm starting to think more seriously about this.

Has anyone done this?  I'm wondering what's involved in getting a new
slave up to sync with a master with long-lived existing databases.  Do
I copy the database directory hierarchy somewhere, configure the slave
to go there and use different ports, then add binary logging to the
master and hook up the slave to it?

Rick DeNatale

IPMS/USA Region 12 Coordinator

Visit the Project Mercury Wiki Site

More information about the TriLUG mailing list