mysql 多级主从_mysql5.7 多级主从+multisource

最新推荐文章于 2021-06-04 13:17:51 发布

独处着匠人

最新推荐文章于 2021-06-04 13:17:51 发布

阅读量333

点赞数

文章标签： mysql 多级主从

本文链接：https://blog.csdn.net/weixin_42236014/article/details/113281127

版权

mysqlday5 mysql5.7 多级主从+multisource

1.安装软件

# 操作系统 RHEL7.2

# 下载软件(rpm；本地yum源；在线yum源；)

http://classroom.example.com/materials/mysql-5.7.repo

# /etc/yum.repos.d/

# yum clean all;yum makecache

# yum list|grep mysql

mysql-community-server 5.7

# yum install ----报错，软件冲突：mariadb-libs 5.5 /var/lib/mysql/*

# rpm -e --nodeps mariadb-libs

# 服务器端

软件名 mysql-community-server 5.7

servicemysqld

daemonmysqld

配置文件/etc/my.cnf

/etc/my.cnf.d/*.cnf

数据文件/var/lib/mysql

启动日志 /var/log/mysqld.log

# 客户端

软件名mysql-community-client 5.7

命令mysql

mysqladmin

mysqlbinlog

mysqldump

-------------------------------------------------------------------

# 启动服务

查看进程 ps -ef|grep mysqld

systemctl status mysqld

查看端口 netstat -lunpt|grep mysqld

3306

-------------------------------------------------------------------

# mysql 5.7 初始密码

grep password /var/log/mysqld.log

mysqladmin -uroot -p'' password ''

------------------------------------------------------------

# 登陆数据库

mysql -uroot -p''

mysql.user表的结构变化了，原先的password列改为了authentication_string列

-----------------------------------------------------------------------------

服务器ip

功能软件

mastera172.25.0.11主服务器mysql-community-client 5.7

masterb172.25.0.12从mysql-community-client 5.7

slavea172.25.0.13从mysql-community-client 5.7

slaveb172.25.0.14从mysql-community-client 5.7

------------------------

主服务器

systemctl stop firewalld#

setenforce 0

1.configure /etc/my.cnf修改配置文件

---------------------------------------------------------------

log-bin=/var/lib/mysql-log/mastera

server-id=1

# master_log_file master_log_pos===>master_auto_position=1

gtid_mode = ON

enforce_gtid_consistency = 1

-----------------------------------------------------------------------------

创建二进制日志存放目录mkdir /var/lib/mysql-log/

修改UGO权限 selinux权限 chown mysql. /var/lib/mysql-log/

systemctl restart mysqld#重启服务

2.grant replication slave@'172.25.X.%' #授权

##grant replication slave on *.* to slave@'172.25.8.%' identified by '(Uploo00king)';

3.mysqldump\tar\lvm\innobackupex #全备份

从服务器

1.configure

server-id=2

server-id=3

server-id=4

gtid_mode = ON

enforce_gtid_consistency = 1

2.mysql -uroot -p'' < mysql.all.sql

3.change mastert to

master_host='ip'

master_user='slave'

master_password=''

master_auto_position=1

##change master to master_host='172.25.8.12',master_user='slave',master_password='(Uploo00king)',master_auto_position=1;

4.start slave;

5.show slave status\G;

-------------------------------------------------

多主从在配置文件/etc/my.cnf

master-info-repository = TABLE

relay-log-info-repository = TABLE

**********************************************************

mysql5.7 多级主从、Multi-Source

servera

172.25.0.10

serverb

172.25.0.11

serverc

172.25.0.12

serverd

172.25.0.13

==============================================

systemctl stop firewalld

setenforce 0

==============================================

servera~d

1.install

# mount 172.25.254.250:/content /mnt

# cd /mnt/uplooking/mysql/mysql5.7

# rpm -e --nodeps mariadb-libs

# yum localinstall -y *.rpm

2.start service

# systemctl start mysqld

3.change password

# grep password /var/log/mysqld.log

2016-05-04T07:37:31.642343Z 1 [Note] A temporary password is generated for root@localhost:

&ig:,eto:7:T

# mysqladmin -uroot -p'&ig:,eto:7:T' password "U:pl:oo00king:"

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

Warning: Since password will be sent to server in plain text, use ssl connection to ensure password

safety.

===============================================

servera

1.create database

# mysql -uroot -pU:pl:oo00king:

>create database db1;

>use db1;

>create table t1 (no int);

>insert into t1 values (1);

>\q

2.mysqldump

# mysqldump -uroot -pU:pl:oo00king: --all-databases --single-transaction > /tmp/mysql.all.sql

# for i in 11 12 13 ;do scp /tmp/mysql.all.sql root@172.25.15.$i:/tmp;done

serverb~d

1. 导入全备份

# mysql -uroot -pU:pl:oo00king: < /tmp/mysql.all.sql

2. 刷新授权

15# mysql -uroot -pU:pl:oo00king

>flush privileges;

===============================================

1./etc/my.cnf

servera~serverb

*****************

#vim etc/my.cnf

log-bin=/var/lib/mysql-log/servera

server-id=1(server-id=2)

gtid_mode = ON

enforce_gtid_consistency = 1

serverc~serverd

****************

#vim etc/my.cnf

server-id=3

gtid_mode = ON

enforce_gtid_consistency = 1

master-info-repository = TABLE

relay-log-info-repository = TABLE

2. 重新启动服务

servera~serverd

# systemctl restart mysqld

================================================

M1-->M2

1.servera M1 授权 M2

# mysql -uroot -pU:pl:oo00king

>grant replication slave on *.* to slave@172.25.0.11 identified by "uplooking";

>flush privileges;

2.serverb M2 change master

# mysql -uroot -pU:pl:oo00king

>change

master

master_host="172.25.0.10",master_user="slave",master_password="uplooking",master_auto_position=

>start slave;

>show slave status\G;

==========================================================

M2-->M1

161.servera M2 授权 M1

>grant replication slave on *.* to slave@172.25.0.10 identified by "uplooking";

>flush privileges;

>change

master

master_host="172.25.0.11",master_user="slave",master_password="uplooking",master_auto_position=

>slave start;

>show slave status\G;

==========================================================

M1&M2-->Slaves

1.servera M1 授权 Slaves

# mysql -uroot -pU:pl:oo00king

>grant replication slave on *.* to slave@172.25.0.12 identified by "uplooking";

>grant replication slave on *.* to slave@172.25.0.13 identified by "uplooking";

>flush privileges;

2.serverc~d

# mysql -uroot -pU:pl:oo00king

mysql>

change

master

master_host="172.25.0.11",master_user="slave",master_password="(Uploo00king)",master_log_file='

mastera.000002',master_log_pos=1634 for channel 'mastera';

Query OK, 0 rows affected, 2 warnings (0.24 sec)

mysql>

change

master

master_host="172.25.0.12",master_user="slave",master_password="(Uploo00king)",master_log_file='

serverb.000002',master_log_pos=894 for channel 'masterb';

>slave start;

>show slave status\G;

========================================================

测试

1.M1 写,Slaves 是否同步到

2.M1 坏了,M2 写,slaves 是否同步到了

-------------------------------------------------

[root@slaveb0 ~]# mysql -uroot -p'(Uploo00king)'

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 4

Server version: 5.7.10 MySQL Community Server (GPL)

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> stop slave;

Query OK, 0 rows affected (0.07 sec)

mysql> change master to master_host='172.25.0.11',master_user='slave',master_password='(Uploo00king)',master_auto_position=0;

Query OK, 0 rows affected, 2 warnings (0.19 sec)

mysql> change master to master_host=' ';

Query OK, 0 rows affected (0.22 sec)

mysql> change master to master_host='172.25.0.11',master_user='slave',master_password='(Uploo00king)',master_log_file='mastera.000002',master_log_pos=356 for channel 'mastera';

Query OK, 0 rows affected, 2 warnings (0.36 sec)

mysql> change master to master_host='172.25.0.12',master_user='slave',master_password='(Uploo00king)',master_log_file='masterb.000001',master_log_pos=154 for channel 'masterb';

Query OK, 0 rows affected, 2 warnings (0.36 sec)

mysql> start slave;

Query OK, 0 rows affected (0.09 sec)

mysql> show slave status\G;

*************************** 1. row ***************************

Slave_IO_State: Connecting to master

Master_Host:

Master_User: slave

Master_Port: 3306

Connect_Retry: 60

Master_Log_File:

Read_Master_Log_Pos: 4

Relay_Log_File: slaveb0-relay-bin.000001

Relay_Log_Pos: 4

Relay_Master_Log_File:

Slave_IO_Running: Connecting

Slave_SQL_Running: Yes

Replicate_Do_DB:

Replicate_Ignore_DB:

Replicate_Do_Table:

Replicate_Ignore_Table:

Replicate_Wild_Do_Table:

Replicate_Wild_Ignore_Table:

Last_Errno: 0

Last_Error:

Skip_Counter: 0

Exec_Master_Log_Pos: 0

Relay_Log_Space: 154

Until_Condition: None

Until_Log_File:

Until_Log_Pos: 0

Master_SSL_Allowed: No

Master_SSL_CA_File:

Master_SSL_CA_Path:

Master_SSL_Cert:

Master_SSL_Cipher:

Master_SSL_Key:

Seconds_Behind_Master: 0

Master_SSL_Verify_Server_Cert: No

Last_IO_Errno: 2005

Last_IO_Error: error connecting to master 'slave@ :3306' - retry-time: 60 retries: 1

Last_SQL_Errno: 0

Last_SQL_Error:

Replicate_Ignore_Server_Ids:

Master_Server_Id: 0

Master_UUID:

Master_Info_File: mysql.slave_master_info

SQL_Delay: 0

SQL_Remaining_Delay: NULL

Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates

Master_Retry_Count: 86400

Master_Bind:

Last_IO_Error_Timestamp: 160902 16:09:51

Last_SQL_Error_Timestamp:

Master_SSL_Crl:

Master_SSL_Crlpath:

Retrieved_Gtid_Set:

Executed_Gtid_Set: c9b0fabb-70be-11e6-87c2-52540000000b:1-3

Auto_Position: 0

Replicate_Rewrite_DB:

Channel_Name:

Master_TLS_Version:

*************************** 2. row ***************************

Slave_IO_State: Waiting for master to send event

Master_Host: 172.25.0.11

Master_User: slave

Master_Port: 3306

Connect_Retry: 60

Master_Log_File: mastera.000002

Read_Master_Log_Pos: 356

Relay_Log_File: slaveb0-relay-bin-mastera.000002

Relay_Log_Pos: 318

Relay_Master_Log_File: mastera.000002

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

Replicate_Do_DB:

Replicate_Ignore_DB:

Replicate_Do_Table:

Replicate_Ignore_Table:

Replicate_Wild_Do_Table:

Replicate_Wild_Ignore_Table:

Last_Errno: 0

Last_Error:

Skip_Counter: 0

Exec_Master_Log_Pos: 356

Relay_Log_Space: 535

Until_Condition: None

Until_Log_File:

Until_Log_Pos: 0

Master_SSL_Allowed: No

Master_SSL_CA_File:

Master_SSL_CA_Path:

Master_SSL_Cert:

Master_SSL_Cipher:

Master_SSL_Key:

Seconds_Behind_Master: 0

Master_SSL_Verify_Server_Cert: No

Last_IO_Errno: 0

Last_IO_Error:

Last_SQL_Errno: 0

Last_SQL_Error:

Replicate_Ignore_Server_Ids:

Master_Server_Id: 1

Master_UUID: c9b0fabb-70be-11e6-87c2-52540000000b

Master_Info_File: mysql.slave_master_info

SQL_Delay: 0

SQL_Remaining_Delay: NULL

Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates

Master_Retry_Count: 86400

Master_Bind:

Last_IO_Error_Timestamp:

Last_SQL_Error_Timestamp:

Master_SSL_Crl:

Master_SSL_Crlpath:

Retrieved_Gtid_Set:

Executed_Gtid_Set: c9b0fabb-70be-11e6-87c2-52540000000b:1-3

Auto_Position: 0

Replicate_Rewrite_DB:

Channel_Name: mastera

Master_TLS_Version:

*************************** 3. row ***************************

Slave_IO_State: Waiting for master to send event

Master_Host: 172.25.0.12

Master_User: slave

Master_Port: 3306

Connect_Retry: 60

Master_Log_File: masterb.000001

Read_Master_Log_Pos: 154

Relay_Log_File: slaveb0-relay-bin-masterb.000002

Relay_Log_Pos: 318

Relay_Master_Log_File: masterb.000001

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

Replicate_Do_DB:

Replicate_Ignore_DB:

Replicate_Do_Table:

Replicate_Ignore_Table:

Replicate_Wild_Do_Table:

Replicate_Wild_Ignore_Table:

Last_Errno: 0

Last_Error:

Skip_Counter: 0

Exec_Master_Log_Pos: 154

Relay_Log_Space: 535

Until_Condition: None

Until_Log_File:

Until_Log_Pos: 0

Master_SSL_Allowed: No

Master_SSL_CA_File:

Master_SSL_CA_Path:

Master_SSL_Cert:

Master_SSL_Cipher:

Master_SSL_Key:

Seconds_Behind_Master: 0

Master_SSL_Verify_Server_Cert: No

Last_IO_Errno: 0

Last_IO_Error:

Last_SQL_Errno: 0

Last_SQL_Error:

Replicate_Ignore_Server_Ids:

Master_Server_Id: 2

Master_UUID: 0aca83bf-70d6-11e6-9d7c-52540000000c

Master_Info_File: mysql.slave_master_info

SQL_Delay: 0

SQL_Remaining_Delay: NULL

Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates

Master_Retry_Count: 86400

Master_Bind:

Last_IO_Error_Timestamp:

Last_SQL_Error_Timestamp:

Master_SSL_Crl:

Master_SSL_Crlpath:

Retrieved_Gtid_Set:

Executed_Gtid_Set: c9b0fabb-70be-11e6-87c2-52540000000b:1-3

Auto_Position: 0

Replicate_Rewrite_DB:

Channel_Name: masterb

Master_TLS_Version:

3 rows in set (0.00 sec)

=======================================

# 详细步骤(重置mastera)

[root@mastera0 ~]# yum install -y wget vim net-tools

[root@mastera0 ~]# wget http://classroom.example.com/materials/mysql-5.7.repo -P /etc/yum.repos.d/

--2016-09-02 11:25:09-- http://classroom.example.com/materials/mysql-5.7.repo

Resolving classroom.example.com (classroom.example.com)... 172.25.254.254

Connecting to classroom.example.com (classroom.example.com)|172.25.254.254|:80... connected.

HTTP request sent, awaiting response... 200 OK

Length: 141 [application/x-troff-man]

Saving to: ‘/etc/yum.repos.d/mysql-5.7.repo’

100%[==========================================================>] 141 --.-K/s in 0s

2016-09-02 11:25:09 (18.1 MB/s) - ‘/etc/yum.repos.d/mysql-5.7.repo’ saved [141/141]

[root@mastera0 ~]# ll /etc/yum.repos.d/

total 12

-rw-r--r--. 1 root root 141 May 4 02:57 mysql-5.7.repo

-rw-r--r--. 1 root root 358 Apr 24 14:28 redhat.repo

-rw-r--r--. 1 root root 135 Apr 24 14:41 rhel_dvd.repo

[root@mastera0 ~]# yum clean all

Loaded plugins: product-id, search-disabled-repos, subscription-manager

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

Cleaning repos: mysql5.7 rhel_dvd

Cleaning up everything

[root@mastera0 ~]# yum makecache

Loaded plugins: product-id, search-disabled-repos, subscription-manager

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

mysql5.7 | 2.9 kB 00:00:00

rhel_dvd | 4.1 kB 00:00:00

(1/7): mysql5.7/filelists_db | 3.7 kB 00:00:00

(2/7): mysql5.7/other_db | 2.5 kB 00:00:00

(3/7): mysql5.7/primary_db | 6.8 kB 00:00:00

(4/7): rhel_dvd/group_gz | 136 kB 00:00:00

(5/7): rhel_dvd/filelists_db | 3.2 MB 00:00:00

(6/7): rhel_dvd/primary_db | 3.6 MB 00:00:00

(7/7): rhel_dvd/other_db | 1.4 MB 00:00:00

Metadata Cache Created

[root@mastera0 ~]# yum makecache

Loaded plugins: product-id, search-disabled-repos, subscription-manager

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

mysql5.7 | 2.9 kB 00:00:00

rhel_dvd | 4.1 kB 00:00:00

Metadata Cache Created

[root@mastera0 ~]#

[root@mastera0 ~]# yum list|grep mysql

akonadi-mysql.x86_64 1.9.2-4.el7 rhel_dvd

dovecot-mysql.x86_64 1:2.2.10-5.el7 rhel_dvd

libdbi-dbd-mysql.x86_64 0.8.3-16.el7 rhel_dvd

mysql-community-client.x86_64 5.7.10-1.el7 mysql5.7

mysql-community-common.x86_64 5.7.10-1.el7 mysql5.7

mysql-community-libs.x86_64 5.7.10-1.el7 mysql5.7

mysql-community-server.x86_64 5.7.10-1.el7 mysql5.7

mysql-connector-java.noarch 1:5.1.25-3.el7 rhel_dvd

mysql-connector-odbc.x86_64 5.2.5-6.el7 rhel_dvd

pcp-pmda-mysql.x86_64 3.10.6-2.el7 rhel_dvd

php-mysql.x86_64 5.4.16-36.el7_1 rhel_dvd

qt-mysql.i686 1:4.8.5-11.el7 rhel_dvd

qt-mysql.x86_64 1:4.8.5-11.el7 rhel_dvd

rsyslog-mysql.x86_64 7.4.7-12.el7 rhel_dvd

[root@mastera0 ~]# yum install -y mysql-community-server

Loaded plugins: product-id, search-disabled-repos, subscription-manager

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

Resolving Dependencies

--> Running transaction check

---> Package mysql-community-server.x86_64 0:5.7.10-1.el7 will be installed

--> Processing Dependency: mysql-community-common(x86-64) = 5.7.10-1.el7 for package: mysql-community-server-5.7.10-1.el7.x86_64

--> Processing Dependency: mysql-community-client(x86-64) = 5.7.10-1.el7 for package: mysql-community-server-5.7.10-1.el7.x86_64

--> Running transaction check

---> Package mysql-community-client.x86_64 0:5.7.10-1.el7 will be installed

--> Processing Dependency: mysql-community-libs(x86-64) = 5.7.10-1.el7 for package: mysql-community-client-5.7.10-1.el7.x86_64

---> Package mysql-community-common.x86_64 0:5.7.10-1.el7 will be installed

--> Running transaction check

---> Package mariadb-libs.x86_64 1:5.5.44-2.el7 will be obsoleted

--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64

--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64

---> Package mysql-community-libs.x86_64 0:5.7.10-1.el7 will be obsoleting

--> Finished Dependency Resolution

Error: Package: 2:postfix-2.10.1-6.el7.x86_64 (@anaconda/7.2)

Requires: libmysqlclient.so.18(libmysqlclient_18)(64bit)

Removing: 1:mariadb-libs-5.5.44-2.el7.x86_64 (@anaconda/7.2)

libmysqlclient.so.18(libmysqlclient_18)(64bit)

Obsoleted By: mysql-community-libs-5.7.10-1.el7.x86_64 (mysql5.7)

Not found

Error: Package: 2:postfix-2.10.1-6.el7.x86_64 (@anaconda/7.2)

Requires: libmysqlclient.so.18()(64bit)

Removing: 1:mariadb-libs-5.5.44-2.el7.x86_64 (@anaconda/7.2)

libmysqlclient.so.18()(64bit)

Obsoleted By: mysql-community-libs-5.7.10-1.el7.x86_64 (mysql5.7)

~libmysqlclient.so.20()(64bit)

You could try using --skip-broken to work around the problem

You could try running: rpm -Va --nofiles --nodigest

[root@mastera0 ~]#

[root@mastera0 ~]# rpm -e --nodeps mariadb-libs

[root@mastera0 ~]# rpm -qa|grep mariadb

[root@mastera0 ~]# yum install -y mysql-community-server

Loaded plugins: product-id, search-disabled-repos, subscription-manager

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

Resolving Dependencies

--> Running transaction check

---> Package mysql-community-server.x86_64 0:5.7.10-1.el7 will be installed

--> Processing Dependency: mysql-community-common(x86-64) = 5.7.10-1.el7 for package: mysql-community-server-5.7.10-1.el7.x86_64

--> Processing Dependency: mysql-community-client(x86-64) = 5.7.10-1.el7 for package: mysql-community-server-5.7.10-1.el7.x86_64

--> Running transaction check

---> Package mysql-community-client.x86_64 0:5.7.10-1.el7 will be installed

--> Processing Dependency: mysql-community-libs(x86-64) = 5.7.10-1.el7 for package: mysql-community-client-5.7.10-1.el7.x86_64

---> Package mysql-community-common.x86_64 0:5.7.10-1.el7 will be installed

--> Running transaction check

---> Package mysql-community-libs.x86_64 0:5.7.10-1.el7 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================

Package Arch Version Repository Size

====================================================================================================

Installing:

mysql-community-server x86_64 5.7.10-1.el7 mysql5.7 142 M

Installing for dependencies:

mysql-community-client x86_64 5.7.10-1.el7 mysql5.7 24 M

mysql-community-common x86_64 5.7.10-1.el7 mysql5.7 269 k

mysql-community-libs x86_64 5.7.10-1.el7 mysql5.7 2.2 M

Transaction Summary

====================================================================================================

Install 1 Package (+3 Dependent packages)

Total download size: 169 M

Installed size: 773 M

Downloading packages:

(1/4): mysql-community-common-5.7.10-1.el7.x86_64.rpm | 269 kB 00:00:00

(2/4): mysql-community-libs-5.7.10-1.el7.x86_64.rpm | 2.2 MB 00:00:00

(3/4): mysql-community-client-5.7.10-1.el7.x86_64.rpm | 24 MB 00:00:00

(4/4): mysql-community-server-5.7.10-1.el7.x86_64.rpm | 142 MB 00:00:05

----------------------------------------------------------------------------------------------------

Total 30 MB/s | 169 MB 00:00:05

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Warning: RPMDB altered outside of yum.

** Found 2 pre-existing rpmdb problem(s), 'yum check' output follows:

2:postfix-2.10.1-6.el7.x86_64 has missing requires of libmysqlclient.so.18()(64bit)

2:postfix-2.10.1-6.el7.x86_64 has missing requires of libmysqlclient.so.18(libmysqlclient_18)(64bit)

Installing : mysql-community-common-5.7.10-1.el7.x86_64 1/4

Installing : mysql-community-libs-5.7.10-1.el7.x86_64 2/4

Installing : mysql-community-client-5.7.10-1.el7.x86_64 3/4

Installing : mysql-community-server-5.7.10-1.el7.x86_64 4/4

Verifying : mysql-community-server-5.7.10-1.el7.x86_64 1/4

Verifying : mysql-community-common-5.7.10-1.el7.x86_64 2/4

Verifying : mysql-community-libs-5.7.10-1.el7.x86_64 3/4

Verifying : mysql-community-client-5.7.10-1.el7.x86_64 4/4

Installed:

mysql-community-server.x86_64 0:5.7.10-1.el7

Dependency Installed:

mysql-community-client.x86_64 0:5.7.10-1.el7 mysql-community-common.x86_64 0:5.7.10-1.el7

mysql-community-libs.x86_64 0:5.7.10-1.el7

Complete!

[root@mastera0 ~]#

[root@mastera0 ~]# rpm -ql mysql-community-server

/etc/logrotate.d/mysql

/etc/my.cnf

/etc/my.cnf.d

/usr/bin/innochecksum

/usr/bin/lz4_decompress

/usr/bin/my_print_defaults

/usr/bin/myisam_ftdump

/usr/bin/myisamchk

/usr/bin/myisamlog

/usr/bin/myisampack

/usr/bin/mysql_install_db

/usr/bin/mysql_plugin

/usr/bin/mysql_secure_installation

/usr/bin/mysql_ssl_rsa_setup

/usr/bin/mysql_tzinfo_to_sql

/usr/bin/mysql_upgrade

/usr/bin/mysqld_pre_systemd

/usr/bin/mysqldumpslow

/usr/bin/perror

/usr/bin/replace

/usr/bin/resolve_stack_dump

/usr/bin/resolveip

/usr/bin/zlib_decompress

/usr/lib/systemd/system/mysqld.service

/usr/lib/tmpfiles.d/mysql.conf

/usr/lib64/mysql/mecab

/usr/lib64/mysql/mecab/dic

/usr/lib64/mysql/mecab/dic/ipadic_euc-jp

/usr/lib64/mysql/mecab/dic/ipadic_euc-jp/char.bin

/usr/lib64/mysql/mecab/dic/ipadic_euc-jp/dicrc

/usr/lib64/mysql/mecab/dic/ipadic_euc-jp/left-id.def

/usr/lib64/mysql/mecab/dic/ipadic_euc-jp/matrix.bin

/usr/lib64/mysql/mecab/dic/ipadic_euc-jp/pos-id.def

/usr/lib64/mysql/mecab/dic/ipadic_euc-jp/rewrite.def

/usr/lib64/mysql/mecab/dic/ipadic_euc-jp/right-id.def

/usr/lib64/mysql/mecab/dic/ipadic_euc-jp/sys.dic

/usr/lib64/mysql/mecab/dic/ipadic_euc-jp/unk.dic

/usr/lib64/mysql/mecab/dic/ipadic_sjis

/usr/lib64/mysql/mecab/dic/ipadic_sjis/char.bin

/usr/lib64/mysql/mecab/dic/ipadic_sjis/dicrc

/usr/lib64/mysql/mecab/dic/ipadic_sjis/left-id.def

/usr/lib64/mysql/mecab/dic/ipadic_sjis/matrix.bin

/usr/lib64/mysql/mecab/dic/ipadic_sjis/pos-id.def

/usr/lib64/mysql/mecab/dic/ipadic_sjis/rewrite.def

/usr/lib64/mysql/mecab/dic/ipadic_sjis/right-id.def

/usr/lib64/mysql/mecab/dic/ipadic_sjis/sys.dic

/usr/lib64/mysql/mecab/dic/ipadic_sjis/unk.dic

/usr/lib64/mysql/mecab/dic/ipadic_utf-8

/usr/lib64/mysql/mecab/dic/ipadic_utf-8/char.bin

/usr/lib64/mysql/mecab/dic/ipadic_utf-8/dicrc

/usr/lib64/mysql/mecab/dic/ipadic_utf-8/left-id.def

/usr/lib64/mysql/mecab/dic/ipadic_utf-8/matrix.bin

/usr/lib64/mysql/mecab/dic/ipadic_utf-8/pos-id.def

/usr/lib64/mysql/mecab/dic/ipadic_utf-8/rewrite.def

/usr/lib64/mysql/mecab/dic/ipadic_utf-8/right-id.def

/usr/lib64/mysql/mecab/dic/ipadic_utf-8/sys.dic

/usr/lib64/mysql/mecab/dic/ipadic_utf-8/unk.dic

/usr/lib64/mysql/mecab/etc

/usr/lib64/mysql/mecab/etc/mecabrc

/usr/lib64/mysql/plugin

/usr/lib64/mysql/plugin/adt_null.so

/usr/lib64/mysql/plugin/auth_socket.so

/usr/lib64/mysql/plugin/debug

/usr/lib64/mysql/plugin/debug/adt_null.so

/usr/lib64/mysql/plugin/debug/auth_socket.so

/usr/lib64/mysql/plugin/debug/ha_example.so

/usr/lib64/mysql/plugin/debug/innodb_engine.so

/usr/lib64/mysql/plugin/debug/libmemcached.so

/usr/lib64/mysql/plugin/debug/libpluginmecab.so

/usr/lib64/mysql/plugin/debug/locking_service.so

/usr/lib64/mysql/plugin/debug/mypluglib.so

/usr/lib64/mysql/plugin/debug/mysql_no_login.so

/usr/lib64/mysql/plugin/debug/rewrite_example.so

/usr/lib64/mysql/plugin/debug/rewriter.so

/usr/lib64/mysql/plugin/debug/semisync_master.so

/usr/lib64/mysql/plugin/debug/semisync_slave.so

/usr/lib64/mysql/plugin/debug/validate_password.so

/usr/lib64/mysql/plugin/debug/version_token.so

/usr/lib64/mysql/plugin/ha_example.so

/usr/lib64/mysql/plugin/innodb_engine.so

/usr/lib64/mysql/plugin/libmemcached.so

/usr/lib64/mysql/plugin/libpluginmecab.so

/usr/lib64/mysql/plugin/locking_service.so

/usr/lib64/mysql/plugin/mypluglib.so

/usr/lib64/mysql/plugin/mysql_no_login.so

/usr/lib64/mysql/plugin/rewrite_example.so

/usr/lib64/mysql/plugin/rewriter.so

/usr/lib64/mysql/plugin/semisync_master.so

/usr/lib64/mysql/plugin/semisync_slave.so

/usr/lib64/mysql/plugin/validate_password.so

/usr/lib64/mysql/plugin/version_token.so

/usr/sbin/mysqld

/usr/sbin/mysqld-debug

/usr/share/doc/mysql-community-server-5.7.10

/usr/share/doc/mysql-community-server-5.7.10/COPYING

/usr/share/doc/mysql-community-server-5.7.10/ChangeLog

/usr/share/doc/mysql-community-server-5.7.10/INFO_BIN

/usr/share/doc/mysql-community-server-5.7.10/INFO_SRC

/usr/share/doc/mysql-community-server-5.7.10/README

/usr/share/doc/mysql-community-server-5.7.10/my-default.cnf

/usr/share/man/man1/innochecksum.1.gz

/usr/share/man/man1/lz4_decompress.1.gz

/usr/share/man/man1/my_print_defaults.1.gz

/usr/share/man/man1/myisam_ftdump.1.gz

/usr/share/man/man1/myisamchk.1.gz

/usr/share/man/man1/myisamlog.1.gz

/usr/share/man/man1/myisampack.1.gz

/usr/share/man/man1/mysql.server.1.gz

/usr/share/man/man1/mysql_install_db.1.gz

/usr/share/man/man1/mysql_plugin.1.gz

/usr/share/man/man1/mysql_secure_installation.1.gz

/usr/share/man/man1/mysql_ssl_rsa_setup.1.gz

/usr/share/man/man1/mysql_tzinfo_to_sql.1.gz

/usr/share/man/man1/mysql_upgrade.1.gz

/usr/share/man/man1/mysqld_multi.1.gz

/usr/share/man/man1/mysqld_safe.1.gz

/usr/share/man/man1/mysqldumpslow.1.gz

/usr/share/man/man1/mysqlman.1.gz

/usr/share/man/man1/perror.1.gz

/usr/share/man/man1/replace.1.gz

/usr/share/man/man1/resolve_stack_dump.1.gz

/usr/share/man/man1/resolveip.1.gz

/usr/share/man/man1/zlib_decompress.1.gz

/usr/share/man/man8/mysqld.8.gz

/usr/share/mysql/dictionary.txt

/usr/share/mysql/fill_help_tables.sql

/usr/share/mysql/innodb_memcached_config.sql

/usr/share/mysql/install_rewriter.sql

/usr/share/mysql/magic

/usr/share/mysql/my-default.cnf

/usr/share/mysql/mysql-log-rotate

/usr/share/mysql/mysql_security_commands.sql

/usr/share/mysql/mysql_sys_schema.sql

/usr/share/mysql/mysql_system_tables.sql

/usr/share/mysql/mysql_system_tables_data.sql

/usr/share/mysql/mysql_test_data_timezone.sql

/usr/share/mysql/uninstall_rewriter.sql

/var/lib/mysql

/var/lib/mysql-files

/var/run/mysqld

[root@mastera0 ~]# ll /var/log/mysqld.log

-rw-r--r--. 1 root root 0 Sep 2 11:29 /var/log/mysqld.log

[root@mastera0 ~]#

[root@mastera0 ~]# rpm -ql mysql-community-client

/usr/bin/mysql

/usr/bin/mysql_config

/usr/bin/mysql_config-64

/usr/bin/mysql_config_editor

/usr/bin/mysqladmin

/usr/bin/mysqlbinlog

/usr/bin/mysqlcheck

/usr/bin/mysqldump

/usr/bin/mysqlimport

/usr/bin/mysqlpump

/usr/bin/mysqlshow

/usr/bin/mysqlslap

/usr/share/doc/mysql-community-client-5.7.10

/usr/share/doc/mysql-community-client-5.7.10/COPYING

/usr/share/doc/mysql-community-client-5.7.10/README

/usr/share/man/man1/mysql.1.gz

/usr/share/man/man1/mysql_config_editor.1.gz

/usr/share/man/man1/mysqladmin.1.gz

/usr/share/man/man1/mysqlbinlog.1.gz

/usr/share/man/man1/mysqlcheck.1.gz

/usr/share/man/man1/mysqldump.1.gz

/usr/share/man/man1/mysqlimport.1.gz

/usr/share/man/man1/mysqlpump.1.gz

/usr/share/man/man1/mysqlshow.1.gz

/usr/share/man/man1/mysqlslap.1.gz

[root@mastera0 ~]#

[root@mastera0 ~]# systemctl start mysqld

[root@mastera0 ~]# systemctl status mysqld

● mysqld.service - MySQL Server

Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)

Active: active (running) since Fri 2016-09-02 11:39:30 CST; 7s ago

Process: 9540 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)

Process: 9466 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

Main PID: 9543 (mysqld)

CGroup: /system.slice/mysqld.service

└─9543 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.p...

Sep 02 11:38:58 mastera0.example.com systemd[1]: Starting MySQL Server...

Sep 02 11:39:30 mastera0.example.com systemd[1]: Started MySQL Server.

[root@mastera0 ~]# ps -ef|grep mysqld

mysql 9543 1 0 11:39 ? 00:00:00 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

root 9573 2368 0 11:40 pts/0 00:00:00 grep --color=auto mysqld

[root@mastera0 ~]# netstat -luntp|grep mysqld

tcp6 0 0 :::3306 :::* LISTEN 9543/mysqld

[root@mastera0 ~]#

[root@mastera0 ~]# mysql

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

[root@mastera0 ~]# grep password /var/log/mysqld.log

2016-09-02T03:39:01.230715Z 1 [Note] A temporary password is generated for root@localhost: piBUQLFXh7%x

2016-09-02T03:42:27.789548Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)

[root@mastera0 ~]# mysql -uroot -p'piBUQLFXh7%x'

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 3

Server version: 5.7.10

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> show databases;

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

mysql> \q

Bye

[root@mastera0 ~]#

[root@mastera0 ~]# mysqladmin -uroot -p'piBUQLFXh7%x' password '(Uploo00king)'

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

Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.

[root@mastera0 ~]# ls -a

. anaconda-ks.cfg .bash_logout .bashrc .mysql_history

.. .bash_history .bash_profile .cshrc .tcshrc

[root@mastera0 ~]# ls

anaconda-ks.cfg

[root@mastera0 ~]# mysql -uroot -p'(Uploo00king)'

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 5

Server version: 5.7.10 MySQL Community Server (GPL)

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> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sys |

+--------------------+

4 rows in set (0.00 sec)

mysql> desc mysql.user;

+------------------------+-----------------------------------+------+-----+-----------------------+-------+

+------------------------+-----------------------------------+------+-----+-----------------------+-------+

| Host | char(60) | NO | PRI | | |

| User | char(32) | NO | PRI | | |

| Select_priv | enum('N','Y') | NO | | N | |

| Insert_priv | enum('N','Y') | NO | | N | |

| Update_priv | enum('N','Y') | NO | | N | |

| Delete_priv | enum('N','Y') | NO | | N | |

| Create_priv | enum('N','Y') | NO | | N | |

| Drop_priv | enum('N','Y') | NO | | N | |

| Reload_priv | enum('N','Y') | NO | | N | |

| Shutdown_priv | enum('N','Y') | NO | | N | |

| Process_priv | enum('N','Y') | NO | | N | |

| File_priv | enum('N','Y') | NO | | N | |

| Grant_priv | enum('N','Y') | NO | | N | |

| References_priv | enum('N','Y') | NO | | N | |

| Index_priv | enum('N','Y') | NO | | N | |

| Alter_priv | enum('N','Y') | NO | | N | |

| Show_db_priv | enum('N','Y') | NO | | N | |

| Super_priv | enum('N','Y') | NO | | N | |

| Create_tmp_table_priv | enum('N','Y') | NO | | N | |

| Lock_tables_priv | enum('N','Y') | NO | | N | |

| Execute_priv | enum('N','Y') | NO | | N | |

| Repl_slave_priv | enum('N','Y') | NO | | N | |

| Repl_client_priv | enum('N','Y') | NO | | N | |

| Create_view_priv | enum('N','Y') | NO | | N | |

| Show_view_priv | enum('N','Y') | NO | | N | |

| Create_routine_priv | enum('N','Y') | NO | | N | |

| Alter_routine_priv | enum('N','Y') | NO | | N | |

| Create_user_priv | enum('N','Y') | NO | | N | |

| Event_priv | enum('N','Y') | NO | | N | |

| Trigger_priv | enum('N','Y') | NO | | N | |

| Create_tablespace_priv | enum('N','Y') | NO | | N | |

| max_questions | int(11) unsigned | NO | | 0 | |

| max_updates | int(11) unsigned | NO | | 0 | |

| max_connections | int(11) unsigned | NO | | 0 | |

| max_user_connections | int(11) unsigned | NO | | 0 | |

| password_expired | enum('N','Y') | NO | | N | |

| account_locked | enum('N','Y') | NO | | N | |

+------------------------+-----------------------------------+------+-----+-----------------------+-------+

45 rows in set (0.00 sec)

mysql>

独处着匠人

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
mysql 多级主从_mysql5.7 多级主从+multisource

mysqlday5 mysql5.7 多级主从+multisource1.安装软件# 操作系统 RHEL7.2# 下载软件(rpm；本地yum源；在线yum源；)http://classroom.example.com/materials/mysql-5.7.repo# /etc/yum.repos.d/# yum clean all;yum makecache# yum list|grep m...
复制链接

扫一扫