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 http://ipmsr12.denhaven2.com/ Visit the Project Mercury Wiki Site http://www.mercuryspacecraft.com/ -- TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug TriLUG Organizational FAQ : http://trilug.org/faq/ TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
