Adding replica server in a mixed MyISAM/InnoDB multi-master env?

2004-06-10 Thread Tabor J. Wells
Hello, I have a fairly complicated and large MySQL installation that I need to add a new slave server to and I'm uncertain about the best way to get this done with the least risk to my live environment and least downtime of my existing masters. I'm hoping that someone here can suggest the best way

Re: Adding replica server in a mixed MyISAM/InnoDB multi-master env?

2004-06-11 Thread Egor Egorov
"Tabor J. Wells" <[EMAIL PROTECTED]> wrote: > Is it safe to just shutdown ServerB, copy all of the mysql data dir (including > the ibdata files) to ServerC, restart ServerB, and then change the my.cnf of > ServerC to set a new server-id, master-host, replicate-do-db entries and start > ServerC?

Re: Adding replica server in a mixed MyISAM/InnoDB multi-master env?

2004-06-11 Thread Tabor J. Wells
On Fri, Jun 11, 2004 at 03:38:05PM +0300, Egor Egorov <[EMAIL PROTECTED]> is thought to have said: > "Tabor J. Wells" <[EMAIL PROTECTED]> wrote: > > > > Is it safe to just shutdown ServerB, copy all of the mysql data dir (including > > the ibdata files) to ServerC, restart ServerB, and then chan

Re: Adding replica server in a mixed MyISAM/InnoDB multi-master env?

2004-06-21 Thread Tabor J. Wells
On Thu, Jun 10, 2004 at 12:04:52PM -0400, Tabor J. Wells <[EMAIL PROTECTED]> is thought to have said: > I have a fairly complicated and large MySQL installation that I need to add > a new slave server to and I'm uncertain about the best way to get this done > with the least risk to my live environ