mysql 双主从 keepalived，给mysql 做 HA
作者 佚名技术
来源 Linux系统
浏览
发布时间 2012-03-30
| one 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) mysql> use zabbix; Database changed mysql> select count(*) from history; ---------- | count(*) | ---------- | 8741821 | ---------- 1 row in set (0.00 sec) server b 192.168.5.86 为从 为主 mysql> show slave status\G; *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.5.85 Master_User: rep Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 85811437 Relay_Log_File: master86-relay-bin.000002 Relay_Log_Pos: 85811582 Relay_Master_Log_File: mysql-bin.000003 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: 85811437 Relay_Log_Space: 85811740 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) ERROR: No query specified mysql> show master status\G; *************************** 1. row *************************** File: mysql-bin.000003 Position: 106 Binlog_Do_DB: Binlog_Ignore_DB: mysql,test,information_schema 1 row in set (0.00 sec) mysql> use zabbix; Database changed mysql> select count(*) from history; ---------- | count(*) | ---------- | 8741821 | ---------- 1 row in set (0.00 sec) 4 测试步骤 a 用 clinet 连接 vip mysql -h 192.168.5.88 -uzongming -p mysql> show databases; -------------------- | Database | -------------------- | information_schema | | mysql | | test | | zabbix | --------- |
凌众科技专业提供服务器租用、服务器托管、企业邮局、虚拟主机等服务，公司网站：http://www.lingzhong.cn 为了给广大客户了解更多的技术信息，本技术文章收集来源于网络,凌众科技尊重文章作者的版权，如果有涉及你的版权有必要删除你的文章，请和我们联系。以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢! |
你可能对下面的文章感兴趣
关于mysql 双主从 keepalived，给mysql 做 HA的所有评论
