RE: Stopping Replication
Re: webserver2-relay-bin.{some#}
Because you've deleted the master.info file found in the SLAVE server
therefore these files( relay logs) are no longer needed. Mind you, you
will not be able resume or restart replication. Replication at your site
will have to be setup from 'scratch'.
Thanks
-Original Message-
From: Jesse [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 24, 2007 4:26 PM
To: Brown, Charles; Michael Dykman; Gerald L. Clark
Cc: MySQL List
Subject: Re: Stopping Replication
Thanks,
I've removed these files. Also, there are a BUNCH of files named
webserver2-relay-bin.{some#} in the data folder. Can I delete all of
these (including the .index file)?
Thanks,
Jesse
- Original Message -
From: Brown, Charles [EMAIL PROTECTED]
To: Michael Dykman [EMAIL PROTECTED]; Gerald L. Clark
[EMAIL PROTECTED]
Cc: Jesse [EMAIL PROTECTED]; MySQL List mysql@lists.mysql.com
Sent: Tuesday, April 24, 2007 4:31 PM
Subject: RE: Stopping Replication
(Read ref manual: 6.4)
Here's the best kept secret:
The Slave has two files called master. info and relay-log.info. The
slave uses these two files to keep track of how much of the master's
binary log it has processed and all pertinent info about the master( i.e
userid, password, hostname) are all documented in the master.info file.
Did you say you would like to stop replication - PERIOD! Delete these
files or use CHANGE MASTER TO statement to change replication
parameters.
Why: The contents of master.info overrides some of the server options
specified on the command line or in my.cnf. (Read ref manual: 6.4)
-Original Message-
From: Michael Dykman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 24, 2007 2:35 PM
To: Gerald L. Clark
Cc: Jesse; MySQL List
Subject: Re: Stopping Replication
you mill also do well to eliminate the master.nfo file from your data
directory.
On 4/24/07, Gerald L. Clark [EMAIL PROTECTED] wrote:
Jesse wrote:
I'm trying to stop replication between two servers that I've got
here.
I set it up originally, to play with it and see how it works.
However,
I now want to use these two servers separately.
I have edited the my.ini file on both the server and slave machines,
and
removed the server-id from them. I have also executed a stop slave
on
the slave server. However, it appears that when I stop and re-start
the
server that was the slave, it tries to re-start replication again,
because I get the error, Failed to create slave threads in the
event
log.
What else do I need to do to stop the replication process?
Thanks,
Jesse
You have to remove the master information from the slave's my.ini
file.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
- michael dykman
- [EMAIL PROTECTED]
- All models are wrong. Some models are useful.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.
If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.
If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.
Thank you.
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.
If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.
If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.
Thank you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Stopping Replication
Jesse wrote: I'm trying to stop replication between two servers that I've got here. I set it up originally, to play with it and see how it works. However, I now want to use these two servers separately. I have edited the my.ini file on both the server and slave machines, and removed the server-id from them. I have also executed a stop slave on the slave server. However, it appears that when I stop and re-start the server that was the slave, it tries to re-start replication again, because I get the error, Failed to create slave threads in the event log. What else do I need to do to stop the replication process? Thanks, Jesse You have to remove the master information from the slave's my.ini file. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Stopping Replication
you mill also do well to eliminate the master.nfo file from your data directory. On 4/24/07, Gerald L. Clark [EMAIL PROTECTED] wrote: Jesse wrote: I'm trying to stop replication between two servers that I've got here. I set it up originally, to play with it and see how it works. However, I now want to use these two servers separately. I have edited the my.ini file on both the server and slave machines, and removed the server-id from them. I have also executed a stop slave on the slave server. However, it appears that when I stop and re-start the server that was the slave, it tries to re-start replication again, because I get the error, Failed to create slave threads in the event log. What else do I need to do to stop the replication process? Thanks, Jesse You have to remove the master information from the slave's my.ini file. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Stopping Replication
(Read ref manual: 6.4) Here's the best kept secret: The Slave has two files called master. info and relay-log.info. The slave uses these two files to keep track of how much of the master's binary log it has processed and all pertinent info about the master( i.e userid, password, hostname) are all documented in the master.info file. Did you say you would like to stop replication - PERIOD! Delete these files or use CHANGE MASTER TO statement to change replication parameters. Why: The contents of master.info overrides some of the server options specified on the command line or in my.cnf. (Read ref manual: 6.4) -Original Message- From: Michael Dykman [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 24, 2007 2:35 PM To: Gerald L. Clark Cc: Jesse; MySQL List Subject: Re: Stopping Replication you mill also do well to eliminate the master.nfo file from your data directory. On 4/24/07, Gerald L. Clark [EMAIL PROTECTED] wrote: Jesse wrote: I'm trying to stop replication between two servers that I've got here. I set it up originally, to play with it and see how it works. However, I now want to use these two servers separately. I have edited the my.ini file on both the server and slave machines, and removed the server-id from them. I have also executed a stop slave on the slave server. However, it appears that when I stop and re-start the server that was the slave, it tries to re-start replication again, because I get the error, Failed to create slave threads in the event log. What else do I need to do to stop the replication process? Thanks, Jesse You have to remove the master information from the slave's my.ini file. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Stopping Replication
Thanks,
I've removed these files. Also, there are a BUNCH of files named
webserver2-relay-bin.{some#} in the data folder. Can I delete all of
these (including the .index file)?
Thanks,
Jesse
- Original Message -
From: Brown, Charles [EMAIL PROTECTED]
To: Michael Dykman [EMAIL PROTECTED]; Gerald L. Clark
[EMAIL PROTECTED]
Cc: Jesse [EMAIL PROTECTED]; MySQL List mysql@lists.mysql.com
Sent: Tuesday, April 24, 2007 4:31 PM
Subject: RE: Stopping Replication
(Read ref manual: 6.4)
Here's the best kept secret:
The Slave has two files called master. info and relay-log.info. The
slave uses these two files to keep track of how much of the master's
binary log it has processed and all pertinent info about the master( i.e
userid, password, hostname) are all documented in the master.info file.
Did you say you would like to stop replication - PERIOD! Delete these
files or use CHANGE MASTER TO statement to change replication
parameters.
Why: The contents of master.info overrides some of the server options
specified on the command line or in my.cnf. (Read ref manual: 6.4)
-Original Message-
From: Michael Dykman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 24, 2007 2:35 PM
To: Gerald L. Clark
Cc: Jesse; MySQL List
Subject: Re: Stopping Replication
you mill also do well to eliminate the master.nfo file from your data
directory.
On 4/24/07, Gerald L. Clark [EMAIL PROTECTED] wrote:
Jesse wrote:
I'm trying to stop replication between two servers that I've got
here.
I set it up originally, to play with it and see how it works.
However,
I now want to use these two servers separately.
I have edited the my.ini file on both the server and slave machines,
and
removed the server-id from them. I have also executed a stop slave
on
the slave server. However, it appears that when I stop and re-start
the
server that was the slave, it tries to re-start replication again,
because I get the error, Failed to create slave threads in the
event
log.
What else do I need to do to stop the replication process?
Thanks,
Jesse
You have to remove the master information from the slave's my.ini
file.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
- michael dykman
- [EMAIL PROTECTED]
- All models are wrong. Some models are useful.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.
If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.
If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.
Thank you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
