Comments - How do you undo replication on the master database
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Hello, I forgot to post the configuration..
Centos 7 MariaDB 10.1
The following files were either modified or created after the change was made to my.cnf (for the replication) and the database restarted. The file ibdata1 was renamed to ibdata1.bak after the first failure but a new one was created on DB restart. I am not sure what else needs to be changed in addition to removing the updates made to the contents in the my.cnf file.
-rw-rw----. 1 mysql mysql 24576 Feb 10 23:15 aria_log.00000001 -rw-rw----. 1 mysql mysql 52 Feb 10 23:15 aria_log_control -rw-rw----. 1 mysql mysql 50331648 Feb 10 23:02 ib_logfile101 -rw-rw----. 1 mysql mysql 12582912 Feb 10 23:02 ibdata1 -rw-rw----. 1 mysql mysql 114 Feb 10 21:58 master.info -rw-rw----. 1 mysql mysql 31 Feb 10 21:58 relay-log.info -rw-rw----. 1 mysql mysql 2678 Feb 10 21:58 data01-relay-bin.index -rw-rw----. 1 mysql mysql 249 Feb 10 21:58 data01-relay-bin.000103 -rw-rw----. 1 mysql mysql 189 Feb 10 21:58 master-mty.info -rw-rw----. 1 mysql mysql 62 Feb 10 21:58 relay-log-mty.info -rw-rw----. 1 mysql mysql 99240 Feb 10 21:58 data01-relay-bin-mty.index -rw-rw----. 1 mysql mysql 249 Feb 10 21:58 data01-relay-bin-mty.003308 -rw-rw----. 1 mysql mysql 192 Feb 10 21:58 master-lstc.info -rw-rw----. 1 mysql mysql 67 Feb 10 21:58 relay-log-lstc.info -rw-rw----. 1 mysql mysql 3503 Feb 10 21:58 data01-relay-bin-lstc.index -rw-rw----. 1 mysql mysql 249 Feb 10 21:58 data01-relay-bin-lstc.000113 -rw-rw----. 1 mysql mysql 5 Feb 10 21:58 data01.pid -rw-rw----. 1 mysql mysql 24576 Feb 10 21:58 tc.log -rw-rw----. 1 mysql mysql 50331648 Feb 10 21:58 ib_logfile0 -rw-rw----. 1 mysql mysql 1421869056 Feb 10 21:58 ibdata1.bak <= This was renamed after the initial failure and a new one was created after restart -rw-rw----. 1 mysql mysql 50331648 Feb 10 21:58 ib_logfile1 -rw-rw----. 1 mysql mysql 0 Feb 10 21:50 master1-bin.index
This problem has been resolved. There were a number of new files created (included above) as a result of updating the my.cnf file with this info "[mariadb] log-bin server_id=1 log-basename=master1". All newly created files were removed and mysql restarted.