MySQL Forums
Forum List  »  Replication

How do I break a master-master back to master-slave ?
Posted by: yvonne kire
Date: June 18, 2012 06:04PM

q: How do I break a master-master back to master-slave ?

I have a DB that used to be a master-master setup
I now want it to be a master-slave configuration again
but it thinks it's still a slave to another db !!!
How do I break this ?
What parameter in the my.cnf file makes it think it's a slave to another DB?

I remove this parameters and restart mysql
- will it then stop thinking it is a slave?

relay-log = /var/log/mysql/relay-logs/mysqld-relay-bin.log
relay-log-index = /var/log/mysql/relay-logs/mysqld-relay-bin.index
relay-log-info-file = /var/log/mysql/relay-logs/relay-log.info
relay-log-purge = 1 #1=true , 0=false
auto_increment_increment = 10
auto_increment_offset = 7

===========================================

If I do > Show slave status ;
it gives the hole list of slave info
and slave running is : NO
but
I want it to give nothing ie empty results

===================================================

maatkit: mk-slave-info: list it as a slave !!!

Localhost
Version 5.0.77-log
Server ID 700
Uptime 65+22:46:40 (started 2012-04-13T17:54:50)
Replication Is a slave, has 3 slaves connected, is not read_only
Filters
Binary logging unknown
Slave status seconds behind, not running, no errors
Slave mode unknown
IN

Options: ReplyQuote


Subject
Views
Written By
Posted
How do I break a master-master back to master-slave ?
2305
June 18, 2012 06:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.