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

This article mainly introduces how to install Mysql8.0.13, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Mysql database installation:

1.groupadd mysql-g 1100 & & useradd mysql-u 1100-g 1100

2.mkdir-p / opt/mysql/8.0.13/ {data,logs,redo,undo,extend,pid} & & chown-R mysql:mysql / opt/mysql

3.xz-d mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz

4.tar-xvf mysql-8.0.13-linux-glibc2.12-x86_64.tar-C / home/mysql & & chown-R mysql:mysql / home/mysql

5.mv / home/mysql/mysql-8.0.13-linux-glibc2.12-x86_64 / home/mysql/8.0.13

6.rpm-qf / etc/my.cnf

7.rpm-e-nodeps xxxxx

8.cp / tmp/my.cnf / etc/ (if not, copy / etc/my.cnf of 10.1.117.106)

9.yum install numactl.x86_64

10./home/mysql/8.0.13/bin/mysqld-defaults-file=/etc/my.cnf-initialize-insecure

11.cp / home/mysql/8.0.13/support-files/mysql.server / etc/init.d/mysql.server

12.cd / etc/init.d/

13.mv mysql.server mysqld

14.service mysqld start

Starting Mysql...ERROR! The Server quit without updating PID file

Resolve:

Check mysql-error.log, the error is missing / opt/mysql/backup directory, and then create and modify the owner

Master-slave configuration: run on the above basis

-run on 2

Mysql > CHANGE MASTER TO

MASTER_HOST='10.x.x.1'

MASTER_USER='user_repl'

MASTER_PASSWORD='repl_user'

MASTER_PORT=3102

MASTER_AUTO_POSITION=1

Mysql > start slave

Mysql > show slave status\ G

-- run on 1

Mysql >

CHANGE MASTER TO

MASTER_HOST='10.x.x.2'

MASTER_USER='user_repl'

MASTER_PASSWORD='repl_user'

MASTER_PORT=3102

MASTER_AUTO_POSITION=1

Mysql > start slave

Mysql > show slave status\ G

Turn on concurrency

Vi / etc/my.cnf

Configuration parameters:

Slave_parallel_workers=8

Restart mysql

Thank you for reading this article carefully. I hope the article "how to install Mysql8.0.13" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.