
Sur enigma:

/usr/bin/pt-heartbeat --daemonize -D webbike --update -h enigma --password=mpkj6ajfa

pt-heartbeat --daemonize -D webbike --update -h enigma --password=mpkj6ajfa
pt-heartbeat -D webbike --master-server-id 1 --check colossius --password=mpkj6ajfa
pt-heartbeat -D webbike --master-server-id 2 --check enigma --password=mpkj6ajfa

sur colossius:

/usr/bin/pt-heartbeat --daemonize -D webbike --update -h colossius --password=mpkj6ajfa

pt-heartbeat --daemonize -D webbike --update -h colossius --password=mpkj6ajfa
pt-heartbeat -D webbike --master-server-id 2 --check enigma --password=mpkj6ajfa
pt-heartbeat -D webbike --master-server-id 1 --check colossius --password=mpkj6ajfa


root@enigma:/var/lib/mysql/webbike# pt-slave-find --host enigma --password=mpkj6ajfa
enigma
Version         5.6.24-72.2-log
Server ID       1
Uptime          18:22 (started 2015-06-04T10:06:34)
Replication     Is a slave, has 1 slaves connected, is not read_only
Filters         replicate_do_db=webbike
Binary logging  STATEMENT
Slave status    0 seconds behind, running, no errors
Slave mode      STRICT
Auto-increment  increment 10, offset 1
InnoDB version  5.6.24-72.2
+- colossius
   Version         5.6.22-71.0-log
   Server ID       2
   Uptime          72+14:15:23 (started 2015-03-23T19:09:34)
   Replication     Is a slave, has 1 slaves connected, is not read_only
   Filters         replicate_do_db=webbike
   Binary logging  STATEMENT
   Slave status     seconds behind, not running, error 1146
   Slave mode      STRICT
   Auto-increment  increment 10, offset 1
   InnoDB version  5.6.22-71.0

root@enigma:/var/lib/mysql/webbike# pt-slave-find --host colossius --password=mpkj6ajfa
colossius
Version         5.6.22-71.0-log
Server ID       2
Uptime          72+14:15:36 (started 2015-03-23T19:09:33)
Replication     Is a slave, has 1 slaves connected, is not read_only
Filters         replicate_do_db=webbike
Binary logging  STATEMENT
Slave status     seconds behind, not running, error 1146
Slave mode      STRICT
Auto-increment  increment 10, offset 1
InnoDB version  5.6.22-71.0
+- enigma
   Version         5.6.24-72.2-log
   Server ID       1
   Uptime          18:35 (started 2015-06-04T10:06:34)
   Replication     Is a slave, has 1 slaves connected, is not read_only
   Filters         replicate_do_db=webbike
   Binary logging  STATEMENT
   Slave status    0 seconds behind, running, no errors
   Slave mode      STRICT
   Auto-increment  increment 10, offset 1
   InnoDB version  5.6.24-72.2



0 * * * * pt-slave-restart --monitor --stop --sentinel /tmp/pt-slave-restartup --password=mpkj6ajfa --log /var/log/pt-slave-restartup.log





