Shell implementation, using mysqld_multi to automatically do multiple instance slave databases: using the help shell implementation, using mysqld_multi to automatically do multiple instance slave database 01 # sh doallslave. sh use help 02 help view help information 03 automatic allslave slave database script use help 04 slavename can only be xxx_xxx such command example: add a new slave database with three parameters addslave slavename ip mysql.tar-name rootpasswd06. Example: addslave slavename login using passwd 07 delete one slave database with three parameters delslave slavename08 example: delslave slavename09 use 1: add a new slave database 10sh doallslave. sh addslave lqcq_t110.0. 4.1/usr/home/lijiuyang/41test_20130913_mysql.tar the mysql-root Password 11 you entered is placed completely! Start generating the configuration file 12/usr/doslave/confbak is have13my. cnf and dblist have been modified! 14zqtx-bin.0000031593638969116/usr/local/bin/mysql-uroot-p the entered password -- socket =/tmp/mysql_lqcq_t1.sock17 ************* * ************** 1. row ************************** 18 Slave_IO_State: Waiting for master to send event19 Master_Host: 10.0.4.120 Master_User: rep2master_port: 330622 Connect_Retry: 6023 Master_Log_File: zqtx-bin.00000324 Read_Master_Log_Pos: 93640402125 Relay_Log_File: lqcq_t1-rela Y-bin.00000226 Relay_Log_Pos: 1145827 rows: zqtx-bin.00000328 rows: Yes29 Slave_ SQL _Running: Yes30 rows: 31 rows: 32 Replicate_Do_Table: 33 rows: 34 rows: 36 Last_Errno: 037 Last_Error: 38 Skip_Counter: 039 Exec_Master_Log_Pos: 93640091540 Relay_Log_Space: 1456441 Until_Condition: No Ne42 Until_Log_File: 43 Until_Log_Pos: 044 kernel: No45 kernel: 46 kernel: 47 Master_SSL_Cert: 48 kernel: 49 Master_SSL_Key: 50 Seconds_Behind_Master: 30851 server: 10.0.4.1 slave database! Refresh and view php slave database monitoring 52 use 2: delete an old slave database 53 # sh doallslave. sh delslave lqcq_t154 Delete 55/usr/db_backups/lqcq_t1_mysql_backup! 56mysqld1405714058 has been deleted. Please refresh the prerequisites for using slave database monitoring 59: Check and modify my. cnf configuration, ensure that the format is the same as below 61 [mysqld139] 62 socket =/tmp/queues # Serial = 3447 # zq2013_s14_mysql_backup64pid-file =/usr/db_backups/zq2013_s14_mysql_backup/zq2013_s14.pid # Serial =/usr/db/ zq2013_s14_mysql_backup # zq2013_s14_mysql_backup66server_id = 213149 # zq2013_s14_mysql_backu