MySQL5.6レプリケーションを試す

mysqlfailover-health.log

Replication Health Status
+-----------+-------+---------+--------+------------+---------------------------------------------------------------------------------------+---------------+-------------------+-----------------+------------+-------------+--------------+------------------+---------------+-----------+----------------+------------+---------------+
| host      | port  | role    | state  | gtid_mode  | health                                                                                | version       | master_log_file   | master_log_pos  | IO_Thread  | SQL_Thread  | Secs_Behind  | Remaining_Delay  | IO_Error_Num  | IO_Error  | SQL_Error_Num  | SQL_Error  | Trans_Behind  |
+-----------+-------+---------+--------+------------+---------------------------------------------------------------------------------------+---------------+-------------------+-----------------+------------+-------------+--------------+------------------+---------------+-----------+----------------+------------+---------------+
| debian00  | 3306  | MASTER  | UP     | ON         | OK                                                                                    | 5.6.7-rc-log  | mysql-bin.000006  | 339             |            |             |              |                  |               |           |                |            |               |
| debian01  | 3306  | SLAVE   | UP     | ON         | Slave delay is 8 seconds behind master., No, Slave has 1 transactions behind master.  | 5.6.7-rc-log  | mysql-bin.000006  | 339             | Yes        | Yes         | 8            | No               | 0             |           | 0              |            | 1             |
| debian02  | 3306  | SLAVE   | UP     | ON         | Binary log and Relay log filters differ.                                              | 5.6.7-rc-log  | mysql-bin.000006  | 339             | Yes        | Yes         | 0            | No               | 0             |           | 0              |            | 0             |
+-----------+-------+---------+--------+------------+---------------------------------------------------------------------------------------+---------------+-------------------+-----------------+------------+-------------+--------------+------------------+---------------+-----------+----------------+------------+---------------+