RE: changing a slave to a master in mysql replication

2002-09-03 Thread Vicky Gonzalez
Bhavin Vyas wrote Tuesday, September 03, 2002 9:02 PM in response to: >>To: Vicky Gonzalez; [EMAIL PROTECTED] >>Subject: Re: changing a slave to a master in mysql replication >>bin-log in 'needed' for a server to act as a master. This will make the server log all i

changing a slave to a master in mysql replication

2002-09-03 Thread Vicky Gonzalez
Currently to make a slave a master, the docs say you need to set the bin-log option in my.cnf on the slave, and that will make the transition to master quicker. I know I can manually change a slave to a master by stopping the slave process, stop mysql, take a snapshot of the databases, copy ove

mysql replication protocol

2002-08-30 Thread Vicky Gonzalez
Hi, Does anyone know what protocol is used for the mysql replication process? Is it TCP or something proprietary? Thanks! ~Vicky - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lis

High Availability and MySql Replication

2002-08-19 Thread Vicky Gonzalez
Hi, I was hoping someone here might know the best way to setup a mySQL replication environment where master->slave can be flipped to slave<-master. NOTE: I am NOT looking for a master<=3D>master bi-directional updating solution. This is a solution for HA, so when the master "dies" the slave b

RE: Replication Question

2002-08-13 Thread Vicky Gonzalez
From: Paul DuBois on August 13, 2002 11:13 AM wrote in response: At 11:10 -0700 8/13/02, Vicky Gonzalez wrote: >Hi all, > >I am a newbie here. I was hoping someone would be able to tell me if >hostnames for the Linux OS is required for MySql Replication, and if >so why? I have b

Replication Question

2002-08-13 Thread Vicky Gonzalez
Hi all, I am a newbie here. I was hoping someone would be able to tell me if hostnames for the Linux OS is required for MySql Replication, and if so why? I have been combing the manual and archives, but had no luck in finding this answer. Any and all help is greatly appreciated. Thanks!!! ~Vi