mysql主從處理

標籤：

1.        資料庫啟動：

service mysqld start;

******.pid failed   data檔案夾沒有寫入許可權 chmod –R 755 data

/usr/local/mysql-proxy/bin/mysql-proxy --defaults-file=/usr/local/mysql-proxy/conf/online.cnf &

或者：cd /usr/local/mysql-proxy/bin/

./mysql-proxyd online start

mysql代理池啟動

資料庫延遲：

show slave status;

Slave_IO_Running: Yes 
Slave_SQL_Running: No 

stop slave;

set global sql_slave_skip_counter =1;

start slave;

show slave status;

如果：

Slave_IO_Running: No 
Slave_SQL_Running: Yes

   

 找到Master_Host對應IP的主機，登入主機

( 132)mysql> show master status;

+------------------+----------+--------------+---------------------------------------------+-------------------+

| File  | Position | Binlog_Do_DB | Binlog_Ignore_DB         | Executed_Gtid_Set |

+------------------+----------+--------------+---------------------------------------------+-------------------+

|mysql-bin.000031|20345138||mysql,performance_schema,information_schema |      |

+------------------+----------+--------------+---------------------------------------------+-------------------+

(131) mysql > stop slave;

(131) mysql > stop slave;

(131) mysql > change master to master_Log_File=‘mysql-bin.000031‘, Master_Log_Pos=20345138;

(131) mysql > start slave;

show master status;

查看mysql的最大串連數：show variables like ‘max_connections’;

查看當前mysql的串連狀況： show full processlist;

臨時設定mysql變數：

set global max_connections = 3000;   // 重啟後失效

vim /etc/my.cnf

mysql主從處理