MySQL Forums
Forum List  »  Install & Repo

Re: Multiple MySQL instance on centos 7
Posted by: Suaib Pattathody
Date: November 15, 2016 06:38AM

[root@db services]# systemctl status mysqld@replica01
mysqld@replica01.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld@.service; enabled; vendor preset: disabled)
Active: activating (start) since Sun 2016-11-13 15:58:34 CET; 1 day 20h ago
Main PID: 27600 (code=exited, status=0/SUCCESS)
CGroup: /system.slice/system-mysqld.slice/mysqld@replica01.service

Nov 13 15:59:02 xx.xx.xx mysqld[28771]: 2016-11-13T14:59:02.088078Z 0 [Note] InnoDB: Check that you do not already have another mysqld process u...og files.
Nov 13 15:59:03 xx.xx.xx mysqld[28771]: 2016-11-13T14:59:03.088247Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
Nov 13 15:59:03 xx.xx.xx mysqld[28771]: 2016-11-13T14:59:03.088299Z 0 [Note] InnoDB: Check that you do not already have another mysqld process u...og files.
Nov 13 15:59:04 xx.xx.xx mysqld[28771]: 2016-11-13T14:59:04.088460Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
Nov 13 15:59:04 xx.xx.xx mysqld[28771]: 2016-11-13T14:59:04.088536Z 0 [Note] InnoDB: Check that you do not already have another mysqld process u...og files.
Nov 13 15:59:05 xx.xx.xx mysqld[28771]: 2016-11-13T14:59:05.088691Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
Nov 13 15:59:05 xx.xx.xx mysqld[28771]: 2016-11-13T14:59:05.088745Z 0 [Note] InnoDB: Check that you do not already have another mysqld process u...og files.
Nov 13 15:59:06 xx.xx.xx mysqld[28771]: 2016-11-13T14:59:06.088904Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
Nov 13 15:59:06 xx.xx.xx mysqld[28771]: 2016-11-13T14:59:06.088954Z 0 [Note] InnoDB: Check that you do not already have another mysqld process u...og files.
Nov 13 15:59:06 xx.xx.xx systemd[1]: PID file /var/run/mysqld/mysqld-replica01.pid not readable (yet?) after start.
Hint: Some lines were ellipsized, use -l to show in full.
-------------
[root@db services]# ps -eafw|grep mysql
mysql 6758 1 10 Nov14 ? 02:50:40 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
root 27556 25562 0 12:00 pts/0 00:00:00 grep --color=auto mysql
----------------
[root@db services]# ls -lisa /var/log/mysql-replica01
total 4
202352193 0 drwxr-xr-x. 2 root root 6 Nov 14 09:47 .
67109037 4 drwxr-xr-x. 8 root root 4096 Nov 13 15:29 ..

[root@db services]# ls -lisa /var/run/mysqld/mysql-replica01.pid
ls: cannot access /var/run/mysqld/mysql-replica01.pid: No such file or directory

[root@db services]# ls -lisa /var/lib/mysql-replica01
total 110600
1051617 0 drwxr-x--x. 2 mysql mysql 96 Nov 14 09:38 .
134320262 4 drwxr-xr-x. 27 root root 4096 Nov 15 01:22 ..
1053147 0 -rw-r-----. 1 mysql mysql 0 Nov 14 09:38 db-bin.index
1053162 4 -rw-r-----. 1 mysql mysql 209 Nov 14 09:38 ib_buffer_pool
1053158 49152 -rw-r-----. 1 mysql mysql 50331648 Nov 14 09:38 ib_logfile0
1053159 49152 -rw-r-----. 1 mysql mysql 50331648 Nov 14 09:38 ib_logfile1
1053157 12288 -rw-r-----. 1 mysql mysql 12582912 Nov 14 09:38 ibdata1
[root@db services]#

Options: ReplyQuote


Subject
Written By
Posted
Re: Multiple MySQL instance on centos 7
November 15, 2016 06:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.