MySQL Master-slave processing

1. Database Startup:

Service mysqld start;

******.pid failed Data folder does not have write permission chmod–r 755 Data

/usr/local/mysql-proxy/bin/mysql-proxy--DEFAULTS-FILE=/USR/LOCAL/MYSQL-PROXY/CONF/ONLINE.CNF &

or: cd/usr/local/mysql-proxy/bin/

./mysql-proxyd Online Start

MySQL Agent Pool Boot

Database latency:

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;

If:

Slave_io_running:no
Slave_sql_running:yes

Locate the Master_host corresponding IP Host, log on to the host

(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;

View MySQL Maximum number of connections: Show variables like ' max_connections ';

View current MySQL The connection status: show full processlist;

To set the MySQL variable temporarily:

Set global max_connections = 3000; Fail after reboot

Vim/etc/my.cnf

MySQL Master-slave processing