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 environment
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 change
of
the data and that the replication will work as expected?
If this isn't the best way to set up replication for an already-running
server with a mixture of InnoDB and MyISAM tables, what is?
Thanks,
Tabor
--
Tabor J. Wells
.
--
Tabor J. Wells [EMAIL PROTECTED]
Fsck It! Just another victim of the ambient morality
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual