Shulou(Shulou.com)06/01 Report--

Environment: mysql master and slave, one host, one standby. They're all virtual machines. The standby machine is only used for backup, not for business. Turn off the host mysql service, shut down the host system, and add memory. The standby phone remains the same.

Turn on the mainframe. Add up the memory. EIPDB1:~ # free-m total used free shared buffers cached Mem: 48274 2509 45764 019 378-/ + buffers/cache: 2111 46162 Swap: 10236 0 10236 enable mysql service error report. EIPDB1:~ # mysqld service status 171016 23:57:43 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

171016 23:57:43 [ERROR] Aborting

171016 23:57:43 [Note] mysqld: Shutdown complete

EIPDB1:~ # service mysqld status MySQL is running but PID file could not be found failed EIPDB1:~ # service mysqld start Starting MySQL. Server quit without updating PID file (/ eipdb1/mysql/data/EIPDB1.pid).

Solution: check first, there is plenty of space, no problem. EIPDB1:/usr/local # df-h Filesystem Size Used Avail Use% Mounted on / dev/sda3 40G 9.1G 29G 25% / devtmpfs 24G 356K 24G 1% / devtmpfs 24G 100K 24G 1% / dev/shm / dev/sda1 98M 75M 19M 80% / boot / dev/sdb1 490G 26G 465G 6% / eipdb1

It may be that the mysqld process is stuck and killed the process. EIPDB1:~ # ps aux | grep mysql root 3442 0.0 11292 1576? S Oct16 0:00 / bin/sh / eipdb1/mysql/bin/mysqld_safe-- datadir=/eipdb1/mysql/data-- pid-file=/eipdb1/mysql/data/EIPDB1.pid mysql 4034 4.2 3.1 5907700 1538808? Sl Oct16 1:12 / eipdb1/mysql/bin/mysqld-- basedir=/eipdb1/mysql-- datadir=/eipdb1/mysql/data-- plugin-dir=/eipdb1/mysql/lib/plugin-- user=mysql-- log-error=/eipdb1/mysql/data/EIPDB1.err-- pid-file=/eipdb1/mysql/data/EIPDB1.pid-- socket=/tmp/mysql.sock-- port=3306 root 5588 0.0 5704 800 pts/0 S + 00:22 0:00 grep mysql

EIPDB1:~ # kill-9 3442 EIPDB1:/usr/local # kill-9 4034

Restart the mysql service: EIPDB1:/usr/local # service mysqld start Starting MySQL... Done EIPDB1:/usr/local # service mysqld status MySQL running (6322) done EIPDB1:/usr/local # ps aux | grep mysql root 5733 0.0 11504 1596 pts/0 S 00:30 0:00 / bin/sh / eipdb1/mysql/bin/mysqld_safe-- datadir=/eipdb1/mysql/data-- pid-file=/eipdb1/mysql/data/EIPDB1.pid mysql 6322 1.02.1 5839204 1065996 pts/0 Sl 00:30 0:01 / eipdb1/mysql/bin/mysqld-- basedir=/eipdb1 / mysql-- datadir=/eipdb1/mysql/data-- plugin-dir=/eipdb1/mysql/lib/plugin-- user=mysql-- log-error=/eipdb1/mysql/data/EIPDB1.err-- pid-file=/eipdb1/mysql/data/EIPDB1.pid-- socket=/tmp/mysql.sock-- port=3306 root 6398 0.0 5700 800 pts/0 S + 00:32 0:00 grep mysql

Synchronization of slave database is normal: mysql > show slave status\ G * * 1. Row * * Slave_IO_State: Waiting for master to send event Master_Host: 10.0.2.206 Master_User: slave_user Master_Port: 3306 Connect_Retry: 60 Master_Log_File: master-binlog.000062 Read_Master_Log_Pos: 44601 Relay_ Log_File: eipdb2-relay-bin.000166 Relay_Log_Pos: 44751 Relay_Master_Log_File: master-binlog.000062 Slave_IO_Running: Yes Slave_SQL_Running: Yes

Done.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.