Skip to main content
Database Administrators

Return to Answer

replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
Source Link
Community Bot
Community Bot
  • 1

To be sure that in case replication were to start I set the MASTER parameters to be wrong so the replication would not work. After doing this, even if I ran STOP SLAVE and STOP SLAVE SQL_THREAD; the server kept trying to restart replication, causing the log file to fill up.

The only way to get through MySQL's head that I wanted replication to stop was to follow the suggestion in How do I completely disable MySQL replicationHow do I completely disable MySQL replication and stop the mysql service and delete the master.info and relay-log.info files.

To be sure that in case replication were to start I set the MASTER parameters to be wrong so the replication would not work. After doing this, even if I ran STOP SLAVE and STOP SLAVE SQL_THREAD; the server kept trying to restart replication, causing the log file to fill up.

The only way to get through MySQL's head that I wanted replication to stop was to follow the suggestion in How do I completely disable MySQL replication and stop the mysql service and delete the master.info and relay-log.info files.

To be sure that in case replication were to start I set the MASTER parameters to be wrong so the replication would not work. After doing this, even if I ran STOP SLAVE and STOP SLAVE SQL_THREAD; the server kept trying to restart replication, causing the log file to fill up.

The only way to get through MySQL's head that I wanted replication to stop was to follow the suggestion in How do I completely disable MySQL replication and stop the mysql service and delete the master.info and relay-log.info files.

Source Link
rlandster
rlandster
  • 375
  • 3
  • 11

To be sure that in case replication were to start I set the MASTER parameters to be wrong so the replication would not work. After doing this, even if I ran STOP SLAVE and STOP SLAVE SQL_THREAD; the server kept trying to restart replication, causing the log file to fill up.

The only way to get through MySQL's head that I wanted replication to stop was to follow the suggestion in How do I completely disable MySQL replication and stop the mysql service and delete the master.info and relay-log.info files.