This blog is NOFOLLOW Free!

The magic space of the IT find what you seek or get lost

17Mar/101

Howto really completely disable mysql replication

There are many possibilites howto setup a mysql replication. Here you will find a hopefully completly Howto really disable it. This is very usefull for example if you want to make your slave a primary (standalone) server.

Connect to the mysql shell:

mysql -uroot -p

Commands:

STOP SLAVE;
RESET SLAVE;
change master to master_host='', master_user='',  master_password='';

And now some changes to your my.cnf

vi /etc/mysql/my.cnf
* Comment out everyline starting with "master-"
* add this to your mysqld section
        skip-slave-start

Now only a restart of your mysqld should be done.

About kTitan

 
Comments (1) Trackbacks (0)
  1. THANK YOU….


Leave a comment

Connect with Facebook


No trackbacks yet.