Mysql-backup

Adresse : 10.13.102.104

pour vérifier la réplication :

sur mysql :

# mysql
>SHOW SLAVE HOSTS;

doit retourner :

+-----------+--------------------+------+-------------------+-----------+
| Server_id | Host               | Port | Rpl_recovery_rank | Master_id |
+-----------+--------------------+------+-------------------+-----------+
|         2 | mysql.dr13.cnrs.fr | 3306 |                 0 |         1 |
+-----------+--------------------+------+-------------------+-----------+
1 row in set (0.00 sec)

Sur mysql-backup :

# mysql -u root -p k72muzik
>SHOW SLAVE STATUS\G
*************************** 1. row ***************************
              Slave_IO_State: Waiting for master to send event
                 Master_Host: 193.49.133.9
                 Master_User: repl
                 Master_Port: 3306
               Connect_Retry: 60
             Master_Log_File: mysql-bin.093233
         Read_Master_Log_Pos: 96483
              Relay_Log_File: mysqld-relay-bin.075140
               Relay_Log_Pos: 96628
       Relay_Master_Log_File: mysql-bin.093233
            Slave_IO_Running: Yes
           Slave_SQL_Running: Yes
             Replicate_Do_DB:
         Replicate_Ignore_DB:
          Replicate_Do_Table:
      Replicate_Ignore_Table:
     Replicate_Wild_Do_Table:
 Replicate_Wild_Ignore_Table:
                  Last_Errno: 0
                  Last_Error:
                Skip_Counter: 0
         Exec_Master_Log_Pos: 96483
             Relay_Log_Space: 96827
             Until_Condition: None
              Until_Log_File:
               Until_Log_Pos: 0
          Master_SSL_Allowed: No
          Master_SSL_CA_File:
          Master_SSL_CA_Path:
             Master_SSL_Cert:
           Master_SSL_Cipher:
              Master_SSL_Key:
       Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
               Last_IO_Errno: 0
               Last_IO_Error:
              Last_SQL_Errno: 0
              Last_SQL_Error:
1 row in set (0.00 sec)