准备2台服务器信息：
|
服务器IP
|
服务器用户名 |
服务器密码
|
操作系统
|
数据库类型
|
数据库IP
|
数据库用户名
|
数据库密码
|
服务器设置
|
|
192.168.3.4
|
root
|
123456
|
Centos7
|
Mysql
|
192.168.3.4
|
root
|
123456Abc
|
master
|
|
192.168.3.5
|
root
|
123456
|
Redhat7
|
Mysql
|
192.168.3.5
|
root
|
123456Abc
|
slave
|
1.192.168.3.4 上已经安装配置mysql，192.168.3.5按照如下步骤设置mysql：
【1】192.168.3.5 上安装mysql
[root@marklin ~]# cd /usr/local/mysql
[root@marklin mysql]# ll
total 580020
-rw-r--r--. 1 root root 593940480 Mar 25 22:50 mysql-5.7.21-1.el7.x86_64.rpm-bundle.tar
[root@marklin mysql]# tar -xvf mysql-5.7.21-1.el7.x86_64.rpm-bundle.tar
mysql-community-embedded-devel-5.7.21-1.el7.x86_64.rpm
mysql-community-minimal-debuginfo-5.7.21-1.el7.x86_64.rpm
mysql-community-common-5.7.21-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.21-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.21-1.el7.x86_64.rpm
mysql-community-server-minimal-5.7.21-1.el7.x86_64.rpm
mysql-community-client-5.7.21-1.el7.x86_64.rpm
mysql-community-server-5.7.21-1.el7.x86_64.rpm
mysql-community-embedded-5.7.21-1.el7.x86_64.rpm
mysql-community-test-5.7.21-1.el7.x86_64.rpm
mysql-community-devel-5.7.21-1.el7.x86_64.rpm
mysql-community-libs-5.7.21-1.el7.x86_64.rpm
[root@marklin mysql]# rpm -qa|grep mariadb
mariadb-libs-5.5.52-1.el7.x86_64
mariadb-server-5.5.52-1.el7.x86_64
mariadb-5.5.52-1.el7.x86_64
[root@marklin mysql]# rpm -e --nodeps mariadb-server-5.5.56-2.el7.x86_64
error: package mariadb-server-5.5.56-2.el7.x86_64 is not installed
[root@marklin mysql]# rpm -e --nodeps mariadb-server-5.5.52-1.el7.x86_64
[root@marklin mysql]# rpm -e --nodeps mariadb-libs-5.5.52-1.el7.x86_64
[root@marklin mysql]# rpm -e --nodeps mariadb-5.5.52-1.el7.x86_64
[root@marklin mysql]# rpm -qa|grep mariadb
[root@marklin mysql]# rpm -ivh mysql-community-common-5.7.21-1.el7.x86_64.rpm
warning: mysql-community-common-5.7.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-common-5.7.21-1.e################################# [100%]
[root@marklin mysql]# rpm -ivh mysql-community-libs-5.7.21-1.el7.x86_64.rpm
warning: mysql-community-libs-5.7.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-libs-5.7.21-1.el7################################# [100%]
[root@marklin mysql]# rpm -ivh mysql-community-devel-5.7.21-1.el7.x86_64.rpm
warning: mysql-community-devel-5.7.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-devel-5.7.21-1.el################################# [100%]
[root@marklin mysql]# rpm -ivh mysql-community-libs-compat-5.7.21-1.el7.x86_64.rpm
warning: mysql-community-libs-compat-5.7.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-libs-compat-5.7.2################################# [100%]
[root@marklin mysql]# rpm -ivh mysql-community-embedded-5.7.21-1.el7.x86_64.rpm
warning: mysql-community-embedded-5.7.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-embedded-5.7.21-1################################# [100%]
[root@marklin mysql]# rpm -ivh mysql-community-embedded-devel-5.7.21-1.el7.x86_64.rpm
warning: mysql-community-embedded-devel-5.7.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-embedded-devel-5.################################# [100%]
[root@marklin mysql]# rpm -ivh mysql-community-embedded-compat-5.7.21-1.el7.x86_64.rpm
warning: mysql-community-embedded-compat-5.7.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-embedded-compat-5################################# [100%]
[root@marklin mysql]# rpm -ivh mysql-community-client-5.7.21-1.el7.x86_64.rpm
warning: mysql-community-client-5.7.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-client-5.7.21-1.e################################# [100%]
[root@marklin mysql]# rpm -ivh mysql-community-server-5.7.21-1.el7.x86_64.rpm
warning: mysql-community-server-5.7.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-server-5.7.21-1.e################################# [100%]
[root@marklin mysql]# yum install perl-JSON.noarch
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
There are no enabled repos.
Run "yum repolist all" to see the repos you have.
To enable Red Hat Subscription Management repositories:
subscription-manager repos --enable <repo>
To enable custom repositories:
yum-config-manager --enable <repo>
[root@marklin mysql]# mysql-community-test-5.7.21-1.el7.x86_64.rpm
bash: mysql-community-test-5.7.21-1.el7.x86_64.rpm: command not found...
[root@marklin mysql]# rpm -ivh mysql-community-test-5.7.21-1.el7.x86_64.rpm
warning: mysql-community-test-5.7.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
perl(JSON) is needed by mysql-community-test-5.7.21-1.el7.x86_64
[root@marklin mysql]# yum repolist all
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
repolist: 0
[root@marklin mysql]# ll
total 1160144
-rw-r--r--. 1 root root 593940480 Mar 25 22:50 mysql-5.7.21-1.el7.x86_64.rpm-bundle.tar
-rw-r--r--. 1 7155 31415 25107316 Dec 28 20:53 mysql-community-client-5.7.21-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 278844 Dec 28 20:53 mysql-community-common-5.7.21-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 3779988 Dec 28 20:53 mysql-community-devel-5.7.21-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 46256768 Dec 28 20:53 mysql-community-embedded-5.7.21-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 24078148 Dec 28 20:53 mysql-community-embedded-compat-5.7.21-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 128571868 Dec 28 20:53 mysql-community-embedded-devel-5.7.21-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 2238596 Dec 28 20:53 mysql-community-libs-5.7.21-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 2115904 Dec 28 20:54 mysql-community-libs-compat-5.7.21-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 55662616 Dec 28 20:54 mysql-community-minimal-debuginfo-5.7.21-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 171890056 Dec 28 20:54 mysql-community-server-5.7.21-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 15289580 Dec 28 20:54 mysql-community-server-minimal-5.7.21-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 118654584 Dec 28 20:54 mysql-community-test-5.7.21-1.el7.x86_64.rpm
-rw-r--r--. 1 root root 98112 Mar 25 23:03 perl-JSON-2.59-2.el7.noarch.rpm
[root@marklin mysql]# rpm -ivh perl-JSON-2.59-2.el7.noarch.rpm
warning: perl-JSON-2.59-2.el7.noarch.rpm: Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:perl-JSON-2.59-2.el7 ################################# [100%]
[root@marklin mysql]# rpm -ivh mysql-community-test-5.7.21-1.el7.x86_64.rpm
warning: mysql-community-test-5.7.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-test-5.7.21-1.el7################################# [100%]
[root@marklin mysql]#
【2】配置192.168.3.5
[root@marklin mysql]# systemctl start mysqld.service
[root@marklin mysql]# service mysqld status
Redirecting to /bin/systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Sun 2018-03-25 23:08:51 CST; 4s ago
Docs: man:mysqld(8)
Process: 3928 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
Process: 3842 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 3931 (mysqld)
CGroup: /system.slice/mysqld.service
└─3931 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
Mar 25 23:08:33 marklin.com systemd[1]: Starting MySQL Server...
Mar 25 23:08:51 marklin.com systemd[1]: Started MySQL Server.
[root@marklin mysql]# cat /var/log/mysqld.log | grep password
2018-03-25T15:08:45.982603Z 1 [Note] A temporary password is generated for root@localhost: dZ),Jr:vo6Tg
[root@marklin mysql]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@marklin mysql]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.21
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> set global validate_password_policy=0;
Query OK, 0 rows affected (0.01 sec)
mysql> set global validate_password_mixed_case_count=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_number_count=3;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_special_char_count=0;
Query OK, 0 rows affected (0.00 sec)
mysql> et global validate_password_length=3;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'et global validate_password_length=3' at line 1
mysql> set global validate_password_length=3;
Query OK, 0 rows affected (0.00 sec)
mysql> set password for 'root'@'localhost' = password('123456Abc');
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> show variables like 'validate_password%';
+--------------------------------------+-------+
| Variable_name | Value |
+--------------------------------------+-------+
| validate_password_check_user_name | OFF |
| validate_password_dictionary_file | |
| validate_password_length | 3 |
| validate_password_mixed_case_count | 0 |
| validate_password_number_count | 3 |
| validate_password_policy | LOW |
| validate_password_special_char_count | 0 |
+--------------------------------------+-------+
7 rows in set (0.00 sec)
mysql> grant all privileges on *.* to 'root'@'%' identified by '123456Abc' with grant option;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql>
【3】配置优化：
mysql> set @@global.slow_query_log = on;
Query OK, 0 rows affected (0.00 sec)
mysql> set @@global.log_slow_admin_statements=1;
Query OK, 0 rows affected (0.00 sec)
mysql> set global min_examined_row_limit=100;
Query OK, 0 rows affected (0.00 sec)
mysql> set global log_queries_not_using_indexes=1;
Query OK, 0 rows affected (0.00 sec)
mysql> set global log_throttle_queries_not_using_indexes=10;
Query OK, 0 rows affected (0.00 sec)
mysql> set @@global.log_queries_not_using_indexes=on;
Query OK, 0 rows affected (0.00 sec)
mysql> set global general_log=on;
Query OK, 0 rows affected (0.00 sec)
mysql> set global log_output='file,table';
Query OK, 0 rows affected (0.04 sec)
mysql> set @@global.log_queries_not_using_indexes=on;
Query OK, 0 rows affected (0.01 sec)
mysql>
2.Mysql主从配置：
[1]Master主数据库服务器配置
主从配置的数据库：mark-apple-amber,ark-apple-orchid,mark-apple-knight
(1).Xhell5输入：vim /etc/my.cnf，配置内容如下：
#Setting server-id
server-id=1
log-bin=mysql-master-bin
log-bin-index=mysql-master-bin.index
sync_binlog=1
binlog-ignore-db=mysql
binlog-do-db=mark-apple-amber,mark-apple-orchid,mark-apple-knight
log-slave-updates
(2)重启master数据库服务，输入：service mysqld restart
[root@marklin ~]# service mysqld restart
Redirecting to /bin/systemctl restart mysqld.service
[root@marklin ~]# service mysqld status
Redirecting to /bin/systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Sun 2018-03-25 06:26:43 EDT; 12s ago
Docs: man:mysqld(8)
Process: 52432 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
Process: 52409 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 52434 (mysqld)
CGroup: /system.slice/mysqld.service
└─52434 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
Mar 25 06:26:41 marklin.com systemd[1]: Starting MySQL Server...
Mar 25 06:26:43 marklin.com systemd[1]: Started MySQL Server.
[root@marklin ~]#
(3)master数据库创建授权：grant file on *.* to 'root'@'192.168.3.%' identified by '123456Abc';
mysql> grant file on *.* to 'root'@'192.168.3.%' identified by '123456Abc';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
修改密码策略：
set global validate_password_policy=0;
set global validate_password_length=1;
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_length=1;
Query OK, 0 rows affected (0.00 sec)
mysql> grant file on *.* to 'root'@'192.168.3.%' identified by '123456Abc';
Query OK, 0 rows affected, 1 warning (0.00 sec)
（4）查看master主库日志情况：show master status;
mysql> show master status;
+------------------+----------+-----------------------------------------------------+---------------------------------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+-----------------------------------------------------+---------------------------------------------+-------------------+
| mysql-bin.000002 | 422 | mark-apple-amber,ark-apple-orchid,mark-apple-knight | performance_schema,information_schema,mysql | |
+------------------+----------+-----------------------------------------------------+---------------------------------------------+-------------------+
1 row in set (0.00 sec)
mysql>
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_length=1;
Query OK, 0 rows affected (0.00 sec)
mysql> grant file on *.* to 'root'@'192.168.3.%' identified by '123456Abc';
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> grant replication slave on *.* to slave@'192.168.3.%' identified by '123456Abc';
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> grant replication slave,super,reload on mark-apple-amber.* to 'root'@'192.168.3.%' identified by '123456Abc';
ERROR 1046 (3D000): No database selected
mysql> grant replication slave,super,reload on *.* to 'root'@'192.168.3.%' identified by '123456Abc';
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> show master status;
+-------------------------+----------+------------------------------------------------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+-------------------------+----------+------------------------------------------------------+------------------+-------------------+
| mysql-master-bin.000001 | 1188 | mark-apple-amber,mark-apple-orchid,mark-apple-knight | mysql | |
+-------------------------+----------+------------------------------------------------------+------------------+-------------------+
1 row in set (0.00 sec)
mysql>
[2]Slave从数据库服务器配置
(1).Xhell5输入：vim /etc/my.cnf，配置内容如下：
#Setting server-id
log-bin=mysql-bin
server-id=2
log-bin-index=mysql-bin.index
binlog-ignore-db=information_schema
binlog-ignore-db=mysql
replicate-do-db=mark-apple-amber,ark-apple-orchid,mark-apple-knight
replicate-ignore-db=mysql
log-slave-update
slave-skip-errors=all
slave-net-timeout=60
sync_master_info=1
master-host=192.168.3.4
master-user=root
master-password=123456Abc
master-port=3306
(2)重启master数据库服务，输入：service mysqld restart
[root@marklin ~]# service mysqld restart
Redirecting to /bin/systemctl restart mysqld.service
[root@marklin ~]# service mysqld status
Redirecting to /bin/systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Sun 2018-03-25 06:26:43 EDT; 12s ago
Docs: man:mysqld(8)
Process: 52432 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
Process: 52409 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 52434 (mysqld)
CGroup: /system.slice/mysqld.service
└─52434 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
Mar 25 06:26:41 marklin.com systemd[1]: Starting MySQL Server...
Mar 25 06:26:43 marklin.com systemd[1]: Started MySQL Server.
[root@marklin ~]#
(3) 配置连接主服务器的信息：
mysql> stop slave;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> change master to master_host='192.168.3.4', master_user='root', master_password='123456Abc', master_log_file='mysql-bin.000002', master_log_pos=422;
Query OK, 0 rows affected, 2 warnings (0.29 sec)
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
(3) 查看从服务器状态：show slave status \G;
mysql> show slave status \G;
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: 192.168.3.4
Master_User: root
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000002
Read_Master_Log_Pos: 422
Relay_Log_File: marklin-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: mysql-bin.000002
Slave_IO_Running: Connecting
Slave_SQL_Running: Yes
Replicate_Do_DB: mark-apple-amber,ark-apple-orchid,mark-apple-knight
Replicate_Ignore_DB: mysql
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: 422
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: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 2003
Last_IO_Error: error connecting to master 'root@192.168.3.4:3306' - retry-time: 60 retries: 2
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 0
Master_UUID:
Master_Info_File: /var/lib/mysql/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: 180326 03:12:45
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
1 row in set (0.00 sec)
ERROR:
No query specified
mysql>
mysql> stop slave;
Query OK, 0 rows affected (0.00 sec)
mysql> change master to master_host='192.168.3.4', master_user='root', master_password='123456Abc', master_log_file='mysql-master-bin.000001', master_log_pos=1188;
Query OK, 0 rows affected, 2 warnings (0.02 sec)
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: 192.168.3.4
Master_User: root
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-master-bin.000001
Read_Master_Log_Pos: 1188
Relay_Log_File: marklin-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: mysql-master-bin.000001
Slave_IO_Running: Connecting
Slave_SQL_Running: Yes
Replicate_Do_DB: mark-apple-amber,ark-apple-orchid,mark-apple-knight
Replicate_Ignore_DB: mysql
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: 1188
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: NULL
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: 0
Master_UUID:
Master_Info_File: /var/lib/mysql/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:
Auto_Position: 0
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
1 row in set (0.00 sec)
ERROR:
No query specified
mysql>
3.测试Mysql主从配置：
相关推荐
mysql配置文件
在linux环境下配置Mysql主从同步,文档非常详细
Linux环境MySQL 5.7安装及主从配置
MySQL主从复制配置文档和MySQL在Linux环境下的编译安装配置文档，第一次上传资源不会更改资源分，知道如何更改的大佬请私信下，我这个本想0分分享的。
Linux下MySQL数据库的主从同步配置的好处是可以把这个方式当做是一个备份的方法，用来实现读写分离，缓解一个数据库的压力。让运行海量数据的时候无论是从速度还是效率上都大大提高，Mysql的主从复制至少是需要两个...
环境：192.168.0.1 （Master） 192.168.0.2 (Slave) MySQL Version:Ver 14.14 Distrib 5.1.48, for pc-linux-gnu (i686) using readline 5.1 1、登录Master服务器,修改my.cnf,添加如下内容； server-id = 1 //...
16-启动drbd并配置主从同步数据.avi 17-drbd服务的常见故障及排查方法.avi 18-挂载测试数据库同步及查看备节点数据.avi 第十四部 MySQL高可用综合实战（完整版32节） 01-重要课前思想mp4 02-MySQL高可用需求与架构...
MySQL在Linux环境下的安装 文件引擎MyISAM与InnoDB比较 LOAD DATA INFILE/mysqldump DBA的分析命令 MySQL的系统配置参数、诊断操作系统的状态 MySQL的分库分表，分区 MySQL的索引 SQL语句优化的分析方法 MySQL的主从...
linux环境Mysql 5.7.13安装教程分享给大家，供大家参考，具体内容如下 1系统约定 安装文件下载目录：/data/software Mysql目录安装位置：/usr/local/mysql 数据库保存位置：/data/mysql 日志保存位置：/data/log/...
又叫做主从复制，是通过二进制日志文件完成的，注意：mysql 数据库的版本，两个数据库版本要相同 系统环境: 主服务器master IP： 192.168.0.88 从服务器slave IP： 192.168.0.99 单向同步 注意要点 1、只需要把需要...
1、在安装MySQL数据库服务器前，确保你的linux系统是可以连接网络的，下面我们将通过源码方式来安装mysql首先通过putty登入进你的Linux系统，确保系统中已经安装的gcc c++ 等编译环境，因为mysql从5.5版本开始是使用...
Linux虚拟机：VMware +ubuntu16.04.4 windows本机：Navicat for MySQL 1、虚拟机中下载安装MySQL VMware下载安装和ubuntu16.04.4下载安装，请自行百度查询，本文默认这些已经安装好了。 在虚拟机中Ctrl+Alt+T打开一...
前文已述，因为需要测试mysql的主从配置方案，所以要安装多个mysql。这次是在ubuntu kylin 14.10上安装多个mysql 5.7.14。 系统环境：ubuntu kylin 14.10，64位系统 mysql版本：5.7.14社区版 mysql下载地址：...
现在的网站一般大点的，都采用有数据库主从分离、读写分离，即起到备份作用也可以减轻数据库的读写的压力，一直听说过这些，但是自己从没有自己动手亲手实践过，今天有时间实践一下，记录下过程。 实验环境 我准备了...
2.删除MySQL目录及相关文件，我存放的位置是D:\mysql-5.6.3，即删除这个目录即可 3.删除注册表信息只需删除以下三条即可 HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL HKEY_LO
《mysql管理之道：性能调优、高可用与监控》由资深mysql专家撰写，以最新的mysql版本为基础，以构建高性能mysql服务器为核心，从故障诊断、表设计、sql优化、性能参数调优、mydumper逻辑、xtrabackup热备份与恢复、...
此资源为shardingsphere 调研专题使用的mysql 主从环境。需要准备docker compose环境。（仅支持mac和linux Windows自行搭建） 内容：一个master mysql docker实例，一个slave docker实例 内置3个库，mydb，mydb0，...
（1）Linux系统 在SSH中执行下面的命令即可将MySQL密码重置为diavps 代码如下: rm -f reset-mysql-root-password.phps wget ... 脚本中第13行中的以安全模式启动MySQL的命令会因MySQL安装路径不同而不同。...