Replicación de servidores MySQL

En una replicacion de base de datos existen los componenetes:servidor esclavo y servidor mestro ...


mysql> GRANT FILE , REPLICATION SLAVE ON *.*
-> TO 'replica'@'172.16.3.10' IDENTIFIED BY 'replica';
mysql> FLUSH PRIVILEGES;
mysql> FLUSH TABLES WITH READ LOCK;
mysql> QUIT


# /usr/local/mysql/bin/mysql -u admin1 -p --socket=/chroot/mysql/tmp/mysql.sock



mysql> SHOW MASTER STATUS;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000019 | 98 | | |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
mysql> QUIT



Publicar un comentario