1ãé¦å
è¦å¨æ¬å°å»ºç«ä¸¤ä¸ªmysqlæå¡ï¼åèè¿éï¼ï¼æå®ä¸åç端å£ãæè¿éä¸ä¸ªä¸»ï¼3306ï¼ï¼ä¸ä¸ªä»ï¼3307ï¼ã
2ãç¶åä¿®æ¹ä¸»é
ç½®æ件:
[mysqld]
server-id = 1
binlog-do-db=test #è¦åæ¥çæ°æ®åº
#binlog-ignore-db=mysql #ä¸åæ¥çæ°æ®åº,å¦ææå®äºbinlog-do-dbè¿éåºè¯¥å¯ä»¥ä¸ç¨æå®ç
log-bin=mysql-bin #è¦çæçäºè¿å¶æ¥è®°æ件å称
ä¿®æ¹ä»é
ç½®æ件:
[mysqld]
server-id = 2
log-bin = mysql-bin
replicate-do-db=test
3ãå¨ä¸»åºæ·»å ä¸ä¸ªç¨æ· repl 并æå®replicationæé
create user 'repl'@'127.0.0.1' identified by 'asdf';
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'127.0.0.1'; -- --è¿éææå®æ°æ®åºï¼test.*ï¼æ¶æ¥éï¼èæå®å
¨åºï¼*.*ï¼æ¶ä¼æåã
4ãä¿æ主ä»mysqlçtestæ°æ®åºåå§ç¶æä¸è´ã
ä¸è¬æ¯å
å°ææç表å 读éï¼ç¶åcopyç£çä¸çæ°æ®åºæ件夹ãæè¿éç´æ¥åæ¢æå¡ï¼ç¶åå°æ°æ®æ件æ·è´è¿å»ã
5ãå¨ä¸»æ°æ®åºéé¢è¿è¡show master status;è®°ä¸fileåpositionå段对åºçåæ°ã
mysql> show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000001 | 107 | test | |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
6ãå¨ä»åºè®¾ç½®å®çmasterï¼
mysql> change master to master_host='127.0.0.1',master_port=3306,master_user='repl',master_password='asdf',master_log_file='mysql-bin.000001',master_log_pos=107;
Query OK, 0 rows affected (0.19 sec)
è¿éçmaster_log_fileåmaster_log_pos对åºåæshow master statusè®°ä¸çåæ°ã
7ãå¨ä»åºå¼å¯ä»æ°æ®åºå¤å¶åè½ã
slave start;
mysql> slave start;
Query OK, 0 rows affected (0.00 sec)
å¨ä»åºå¯ä»¥éè¿show slave statusæ¥æ¥çä¸äºåæ°ã
8. æ¤æ¶å¨ä¸»åºå建表ææå
¥æ°æ®ï¼å¨ä»åºå°±ä¼å¾å¿«ä¹è½çå°äºã
-- 主åº
mysql> create table tianyc_02(b int);
Query OK, 0 rows affected (0.16 sec)
mysql> insert into tianyc_02 values(2013);
Query OK, 1 row affected (0.13 sec)
-- ä»åº
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| tianyc_01 |
| tianyc_02 |
+----------------+
2 rows in set (0.00 sec)
mysql> select * from tianyc_02;
+------+
| b |
+------+
| 2013 |
+------+
1 row in set (0.00 sec)
åçï¼å¯ä»¥æ建第äºã第ä¸ä¸ªä»èç¹ã
åèï¼
http://blog.sina.com.cn/s/blog_4d06da1f01010m55.htmlå¤æ³¨ï¼ä¸¤ä¸ªæå¡çserve_idå¿
é¡»ä¸åï¼å¦åå¨å¼å¯å¤å¶åè½æ¶ä¼æ示é误
mysql> slave start;
ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO