Jump to content

cbtshares

Members
  • Posts

    1
  • Joined

  • Last visited

  • Speed Test

    My Results

cbtshares's Achievements

Earning Trust

Earning Trust (1/10)

0

Reputation

  1. Good day, Hello, I have a serious issue.I have configure mysql Mater /slave replication and it works fine.Just that if the main DB server goes everything goes.So I configured Master /Master(Or hoped to) , so I started. On the slave server, I in put this in my.cnf mysql> grant replication slave, replication client on *.* to 'slave_user'@'10.0.0.1' identified by '[password removed by TMN Admin]'; FLUSH PRIVILEGES; //////EDIT YOUR MY.CNF FILE ON THE MAIN SERVER TO LOOK LIKE THIS [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql old_passwords=1 server-id=1 master-host = 10.0.0.1 master-port = 3306 master-user = slave_user master-password = [password removed by TMN Admin] master-connect-retry=60 slave-skip-errors = 1062 [mysqld_safe] log-bin = /var/log/mysql/mysql-bin.log log-slave-updates log-bin-index = /var/log/mysql/log-bin.index log-error = /var/log/mysqld.log relay-log = /var/log/mysql/relay.log relay-log-info-file = /var/log/mysql/relay-log.info relay-log-index = /var/log/mysql/relay-log.index master-info-file = /var/log/mysql/master.info auto_increment_increment = 10 auto_increment_offset = 1 replicate-same-server-id = 0 pid-file=/var/run/mysqld/mysqld.pid Restarted and all was well.... Then on my Master I in put the same values but changed the server id and ip address, then I restarted. Then all hell broke loose, It dropped all my tables, and deleted my entire database and my site was down...I managed to make the slave the master and am now in the process of configuring back the M/S replication , and then the M/M but dont want this to happen again.Can anyone tell me what I did wrong.? The logs just say error in dropping tables, as does the "Show slave StaTUS"
×
×
  • Create New...