Hello
I have an little issue with Percona-Server-server-56 Version : 5.6.21 Release : rel70.1.el6 Arch : x86_64
I have created 2 my.cnf with defaults values as follows:
# cat /etc/my.cnf
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
pid-file = /var/lib/mysql/vm-template.pid
log-error = /var/lib/mysql/vm-template.err
[mysqld]
user = mysql
basedir = /usr
datadir = /var/lib/mysql
port = 3306
socket = /var/lib/mysql/mysql.sock
pid-file = /var/lib/mysql/vm-template.pid
log-error = /var/lib/mysql/vm-template.err
log-bin = /var/lib/mysql/mysql-bin
innodb_data_home_dir = /var/lib/mysql
# cat /etc/my1.cnf
# my.cnf for secondary mysql server
[client]
#password = your_password
port = 3307
socket = /var/lib/mysql1/mysql1.sock
pid-file = /var/lib/mysql1/vm-template1.pid
log-error = /var/lib/mysql1/vm-template1.err
[mysqld]
user = mysql
basedir = /usr
datadir = /var/lib/mysql1
port = 3307
socket = /var/lib/mysql1/mysql1.sock
pid-file = /var/lib/mysql1/vm-template1.pid
log-error = /var/lib/mysql1/vm-template1.err
log-bin = /var/lib/mysql1/mysql-bin1
innodb_data_home_dir = /var/lib/mysql1
And i created an start up script for the second instance. Both servers works without issues if i start them manualy
# /etc/init.d/mysqld start
Starting MySQL (Percona Server). SUCCESS!
# /etc/init.d/mysqld1 start
Starting MySQL1 (Percona Server). SUCCESS!
# /etc/init.d/mysqld status
SUCCESS! MySQL (Percona Server) running (2620)
# /etc/init.d/mysqld1 status
SUCCESS! MySQL1 (Percona Server) running (2875)
but when i reboot the server i get this in the boot log
Starting MySQL (Percona Server) SUCCESS!
Starting MySQL1 (Percona Server). ERROR! The server quit without updating PID file (/var/lib/mysql1/vm-template1.pid).
The question is what i did wrong
Thank you in advance