Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to use the OEL7.2 system system to manage the source code installation of mysql5.7", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "how to use the OEL7.2 system system to manage source code installation of mysql5.7" bar!

1 description

Use the OEL7.2 system system to manage the source code installation of mysql5.7 multiple instances.

2 operating environment

2.1OS info

OEL7.2 x64

3 process design

Edit / etc/my.cnf, this article creates two instances of mysqld@3307.service and mysqld@3308.service, corresponding to ports 3307 and 3308, respectively. Create the appropriate instance directory.

Copy the systemd service file, copy the mysqld@.service file of / usr/local/mysql/usr/lib/systemd/system/ in the mysql base directory to the system / usr/lib/systemd/system directory, and rename it to a file that matches the multi-instance name.

Systemctl daemon-reload

Systemctl start mysqld@3307.service

Systemctl start mysqld@.service3308

4 detailed step operation

[root@localhost ~] # vi / etc/my.cnf

[root@localhost ~] # cat! $

Cat / etc/my.cnf

[mysqld@3307]

Datadir=/usr/local/mysql/data/3307

Socket=/usr/local/mysql/data/3307/mysql.sock

Port=3307

Log-error=/var/log/mysqld-service3307.log

[mysqld@3308]

Datadir=/usr/local/mysql/data/3308

Socket=/usr/local/mysql/data/3308/mysql.sock

Port=3308

Log-error=/var/log/mysqld-service3308.log

[root@localhost] # mkdir-p / usr/local/mysql/data/3307

[root@localhost] # mkdir-p / usr/local/mysql/data/3308

[root@localhost] # chown-R mysql.mysql / usr/local/mysql/data/

[root@localhost ~] # cd / usr/lib/systemd/system

[root@localhost system] # ls-l mysqld*

-rw-r--r--. 1 root root 1637 May 3 03:07 mysqld.service

-rw-r--r--. 1 root root 1668 May 3 03:07 mysqld@.service

[root@localhost system] # cp mysqld@.service mysqld@3307

[root@localhost system] # cp mysqld@.service mysqld@3308

[root@localhost system] # systemctl daemon-reload

[root@localhost system] # mkdir / var/run/mysqld/

[root@localhost system] # chown-R mysql.mysql / var/run/mysqld

[root@localhost system] # cd / var/log/

[root@localhost log] # ls-lrt | tail

-rw-r--r--. 1 root root 8460 May 8 01:20 boot.log

-rw-. 1 root root 1739 May 8 01:20 cron

-rw-r--r--. 1 root root 360 May 8 01:20 wpa_supplicant.log

-rw-. 1 root root 594 May 8 01:20 maillog

-rw-rw-r--. 1 root utmp 22656 May 8 01:21 wtmp

-rw-r--r--. 1 root root 291416 May 8 01:21 lastlog

-rw-r-. 1 mysql mysql 4377 May 8 01:24 mysqld-service3307.log

-rw-r-. 1 mysql mysql 4449 May 8 01:24 mysqld-service3308.log

-rw-. 1 root root 540273 May 8 01:24 messages

-rw-. 1 root root 7764 May 8 01:24 secure

[root@localhost log] # grep password mysqld-service3307.log

2018-05-07T17:24:01.123362Z 1 [Note] A temporary password is generated for root@localhost: x&aQ/IT&p5%u

[root@localhost log] # grep password mysqld-service3308.log

2018-05-07T17:24:17.635837Z 1 [Note] A temporary password is generated for root@localhost: xt2aq-KYGWnt

[root@localhost log] # / usr/local/mysql/bin/mysql-uroot-pallexroomaQ _ p5% u'- S / usr/local/mysql/data/3307/mysql.sock

Mysql: [Warning] Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor. Commands end with; or\ g.

Your MySQL connection id is 2

Server version: 5.7.22

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

Affiliates. Other names may be trademarks of their respective

Owners.

Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.

Mysql > exit

Bye

[root@localhost log] # / usr/local/mysql/bin/mysql-uroot-pauxt2aqmurKYGWnt'-S / usr/local/mysql/data/3308/mysql.sock

Mysql: [Warning] Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor. Commands end with; or\ g.

Your MySQL connection id is 2

Server version: 5.7.22

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

Affiliates. Other names may be trademarks of their respective

Owners.

Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.

Mysql > exit

Bye

[root@localhost log] #

[root@localhost log] # systemctl stop mysqld@330*

[root@localhost log] # ps-ef | grep mysql

Root 3328 2861 0 01:32 pts/0 00:00:00 grep-color=auto mysql

[root@localhost log] # systemctl start mysqld@330*

[root@localhost log] # ps-ef | grep mysql

Root 3335 2861 0 01:32 pts/0 00:00:00 grep-color=auto mysql

[root@localhost log] # systemctl start mysqld@330*

[root@localhost log] # systemctl start mysqld@3307

[root@localhost log] # systemctl start mysqld@3308

[root@localhost log] # ps-ef | grep mysql

Mysql 3367 1 5 01:32? 00:00:00 / usr/local/mysql/bin/mysqld-defaults-group-suffix=@3307-daemonize-pid-file=/var/run/mysqld/mysqld-3307.pid

Mysql 3420 1 10 01:32? 00:00:00 / usr/local/mysql/bin/mysqld-defaults-group-suffix=@3308-daemonize-pid-file=/var/run/mysqld/mysqld-3308.pid

Root 3449 2861 0 01:32 pts/0 00:00:00 grep-color=auto mysql

[root@localhost log] # systemctl stop mysqld@330*

[root@localhost log] # ps-ef | grep mysql

Root 3459 2861 0 01:32 pts/0 00:00:00 grep-color=auto mysql

[root@localhost log] # systemctl start mysqld@330*

[root@localhost log] # ps-ef | grep mysql

Root 3466 2861 0 01:33 pts/0 00:00:00 grep-color=auto mysql

[root@localhost log] #

Thank you for reading, the above is the content of "how to use OEL7.2 system system to manage source code installation of mysql5.7". After the study of this article, I believe you have a deeper understanding of how to use OEL7.2 system system to manage source code installation of mysql5.7. The specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.