首页 / MYSQL / MySQL5.7.10多元复制功能搭建

MySQL5.7.10多元复制功能搭建

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了MySQL5.7.10多元复制功能搭建，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含14582字，纯文字阅读大概需要21分钟。

内容图文

MySQL5.7.10多元复制功能搭建

1.环境：centos6.5
[root@mysql-m1 mysql-5.7.10]# cat /etc/redhat-release
CentOS release 6.5 (Final)
主机：

mysql-m1   192.168.56.21
mysql -m2  192.168.56.22
mysql-s    192.168.56.23

现在是mysql-m1数据库已经搭建好，我使用自己的虚拟机进行clone 就省去多次安装数据库。
2.确保两个主库的server_id log-bin 开启并且三个库的server_id 不同：

[root@mysql-m1 aliyun]# sed -n ‘36,37p‘ /etc/my.cnf
log-bin = /aliyun/data/mysqllogs/bin-log/mysql-bin
server_id = 1

[root@mysql-m2 mysql-5.7.10]# sed -n ‘36,37p‘ /etc/my.cnf
log-bin = /aliyun/data/mysqllogs/bin-log/mysql-bin
server_id = 2
[root@mysql-s mysql-5.7.10]# sed -n ‘36,37p‘ /etc/my.cnf
log-bin = /aliyun/data/mysqllogs/bin-log/mysql-bin
server_id = 3

3.master上创建测试库和表：
3.1登陆数据库mysql-m1创建库test01 和表h1：

[root@mysql-m1 tmp]# mysql -uroot -p -S /tmp/mysql.sock

mysql> create database test01;
Query OK, 1 row affected (0.01 sec)
mysql> use test01;
Database changed

mysql> CREATE TABLE `h1` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `b1` int(11) DEFAULT NULL,   `b2` int(11) DEFAULT NULL,   `b3` int(11) GENERATED ALWAYS AS ((`b1` + `b2`)) VIRTUAL,   PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
Query OK, 0 rows affected (0.03 sec)

mysql> desc h1;
+-------+---------+------+-----+---------+-------------------+
| Field | Type    | Null | Key | Default | Extra             |
+-------+---------+------+-----+---------+-------------------+
| id    | int(11) | NO   | PRI | NULL    | auto_increment    |
| b1    | int(11) | YES  |     | NULL    |                   |
| b2    | int(11) | YES  |     | NULL    |                   |
| b3    | int(11) | YES  |     | NULL    | VIRTUAL GENERATED |
+-------+---------+------+-----+---------+-------------------+
4 rows in set (0.00 sec)

mysql> insert into h1(b1,b2) values(2,2);
Query OK, 1 row affected (0.00 sec)

mysql> select * from h1;
+----+------+------+------+
| id | b1   | b2   | b3   |
+----+------+------+------+
|  1 |    2 |    2 |    4 |
+----+------+------+------+
1 row in set (0.00 sec)

3.2登陆数据库mysql-m2创建库test01 和表和h2：

mysql> create database test01;
Query OK, 1 row affected (0.03 sec)

mysql>  CREATE TABLE `h2` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `e1` int(11) DEFAULT NULL,   `e2` int(11) DEFAULT NULL,   `e3` int(11) GENERATED ALWAYS AS ((`e1` + `e2`)) VIRTUAL,   PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
Query OK, 0 rows affected (0.02 sec)

mysql> insert into h2(e1,e2) values(3,3);
Query OK, 1 row affected (0.06 sec)

mysql> select * from h2;
+----+------+------+------+
| id | e1   | e2   | e3   |
+----+------+------+------+
|  1 |    3 |    3 |    6 |
+----+------+------+------+
1 row in set (0.00 sec)

以下不停库锁表，自动切割bin-log日志，全量备份bin-log，导入从库中（此方法只适合5.5版本以下的数据库备份，不适合5.7版本的数据库备份，有待验证）（不是这篇文档的步骤）

[root@mysql-m1 bin-log]# mysqldump -uroot -p -S /tmp/mysql.sock --master-data=2 -A -B -R -x -F --events|gzip >/tmp/m1.sql.gz

[root@mysql-m2 mysql-5.7.10]#  mysqldump -uroot -p -S /tmp/mysql.sock --master-data=2 -A -B -R -x -F --events|gzip >/tmp/m2.sql.gz

适合5.7版本的多元同步的数据库备份(不同的表同步到一个数据库中):

[root@mysql-m1 tmp]#  mysqldump -uroot -p123456 --master-data=2 --single-transaction --databases  --add-drop-database  test01  >m1.sql
[root@mysql-m2 tmp]#  mysqldump -uroot -p123456 --master-data=2 --single-transaction --databases  --add-drop-database  test01  >m2.sql
[root@mysql-m1 tmp]# cat m1.sql|grep "CHANGE MASTER"
-- CHANGE MASTER TO MASTER_LOG_FILE=‘mysql-bin.000012‘, MASTER_LOG_POS=154;
[root@mysql-m2 tmp]#  cat m2.sql|grep "CHANGE MASTER"
-- CHANGE MASTER TO MASTER_LOG_FILE=‘mysql-bin.000010‘, MASTER_LOG_POS=154;

[root@mysql-m1 tmp]#  scp -rp -P22 m1.sql 192.168.56.23:/tmp/
[root@mysql-m2 tmp]#  scp -rp -P22 m2.sql 192.168.56.23:/tmp/

4.slave上操作：

[root@mysql-s tmp]# ll /tmp/
total 396
-rw-r--r--. 1 root  root  199233 May  8 01:15 m1.sql
-rw-r--r--. 1 root  root  199243 May  8 01:14 m2.sql
srwxrwxrwx. 1 mysql mysql      0 May  8 00:35 mysql.sock
-rw-------. 1 mysql mysql      5 May  8 00:35 mysql.sock.lock

[root@mysql-s tmp]# mysql -uroot -p -S /tmp/mysql.sock
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| txt001             |
+--------------------+
5 rows in set (0.06 sec)

分别在Slave上把Master_1和Master_2的数据导入Slave服务器，在导入前先修改从库的MySQL存储master-info和relay-info的方式，即从文件存储改为表存储，在my.cnf里添加以下选择：(注意此修改的是从库)

[root@mysql-s tmp]# cat -n /etc/my.cnf|sed -n ‘36,39p‘
    36  log-bin = /aliyun/data/mysqllogs/bin-log/mysql-bin
    37  server_id = 1
    38  master_info_repository=TABLE
    39  relay_log_info_repository=TABLE

或者再MySQL从库命令行操作：

[root@mysql-s ~]# mysql -uroot -p -S /tmp/mysql.sock
mysql> stop slave;
mysql> SET GLOBAL master_info_repository = ‘TABLE‘;
Query OK, 0 rows affected (0.00 sec)
mysql> SET GLOBAL relay_log_info_repository = ‘TABLE‘;
Query OK, 0 rows affected (0.00 sec)

把数据导入数据库：
[root@mysql-s tmp]# mysql -uroot -p -S /tmp/mysql.sock </tmp/m2.sql
[root@mysql-s tmp]# mysql -uroot -p -S /tmp/mysql.sock </tmp/m1.sql

[root@mysql-s ~]# mysql -uroot -p -S /tmp/mysql.sock
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| test01             |
| txt001             |
+--------------------+
6 rows in set (0.00 sec)

mysql> use test01;
Database changed
mysql> show tables;
+------------------+
| Tables_in_test01 |
+------------------+
| h1               |
| h2               |
+------------------+
2 rows in set (0.00 sec)

mysql> select * from h1;
+----+------+------+------+
| id | b1   | b2   | b3   |
+----+------+------+------+
|  1 |    2 |    2 |    4 |
+----+------+------+------+
1 row in set (0.00 sec)

mysql> select * from h2;
+----+------+------+------+
| id | e1   | e2   | e3   |
+----+------+------+------+
|  1 |    3 |    3 |    6 |
+----+------+------+------+
1 row in set (0.00 sec)

5.在mysql-m1和mysql-m2上创建复制账号：
这个操作跟MySQL 5.7之前版本一样：
在mysql-m1上创建

mysql> grant replication slave on *.* to ‘rep‘@‘192.168.56.23‘ identified by ‘123456‘;
mysql> flush privileges;（必须刷新权限否则不生效的）

在mysql-m2上创建

mysql> grant replication slave on *.* to ‘rep‘@‘192.168.56.23‘ identified by ‘123456‘;
Query OK, 0 rows affected, 1 warning (0.02 sec
mysql> flush privileges; （必须刷新权限否则不生效的）

6.在slave从库上操作进行change master :

[root@mysql-s ~]# mysql -uroot -p -S /tmp/mysql.sock
mysql> change master to MASTER_HOST=‘192.168.56.21‘ ,MASTER_USER=‘rep‘ ,MASTER_PASSWORD=‘123456‘ ,MASTER_LOG_FILE=‘mysql-bin.000012‘ ,MASTER_LOG_POS=154 FOR CHANNEL ‘mysql-m1‘;
Query OK, 0 rows affected, 2 warnings (0.01 sec)

mysql>  change master to MASTER_HOST=‘192.168.56.22‘ ,MASTER_USER=‘rep‘ ,MASTER_PASSWORD=‘123456‘ ,MASTER_LOG_FILE=‘mysql-bin.000010‘ ,MASTER_LOG_POS=154 FOR CHANNEL ‘mysql-m2‘;
Query OK, 0 rows affected, 2 warnings (0.03 sec)

mysql> start slave for CHANNEL ‘mysql-m1‘;
Query OK, 0 rows affected (0.02 sec)

mysql> start slave for CHANNEL ‘mysql-m2‘;
Query OK, 0 rows affected (0.00 sec)

mysql>

[root@mysql-s ~]# mysql -uroot -p123456 -S /tmp/mysql.sock -e "SHOW SLAVE STATUS FOR CHANNEL ‘mysql-m1‘\G"|egrep "Slave_IO_Running|Slave_SQL_Running"
mysql: [Warning] Using a password on the command line interface can be insecure.
Slave_IO_Running: Connecting (报错) 此处为yes才是正常的
Slave_SQL_Running: Yes
Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
7.同步报错解决方法:

7.1.看错误日志:
[root@mysql-s ~]# cat /aliyun/data/mysql/mysql_3306.err

7.2.检查防火墙是否关闭:
（从库本地和主库本地的防火墙）

[root@mysql-s ~]# mysql -urep -p123456 -h192.168.56.21
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘192.168.56.21‘ (113)

[root@mysql-s ~]# mysql -urep -p123456 -h192.168.56.22
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘192.168.56.22‘ (113)

[root@mysql-s ~]# /etc/init.d/iptables stop
iptables: Setting chains to policy ACCEPT: filter          [  OK  ]
iptables: Flushing firewall rules:                         [  OK  ]
iptables: Unloading modules:   
[root@mysql-m1 tmp]# /etc/init.d/iptables stop
iptables: Setting chains to policy ACCEPT: filter          [  OK  ]
iptables: Flushing firewall rules:                         [  OK  ]
iptables: Unloading modules:  

[root@mysql-m2 tmp]# /etc/init.d/iptables stop
iptables: Setting chains to policy ACCEPT: filter          [  OK  ]
iptables: Flushing firewall rules:                         [  OK  ]
iptables: Unloading modules:                               [  OK  ]
[root@mysql-m2 tmp]#

7.3. 修改/ect/my.cnf中server_id 未生效:

[root@mysql-s ~]# mysql -urep -p123456 -h192.168.56.21 成功连接
但是从库连接mysql-m1还是报错：
但是从库连接mysql-m2还是报错：

[root@mysql-s ~]# mysql -uroot -p123456 -S /tmp/mysql.sock -e "SHOW SLAVE STATUS FOR CHANNEL ‘mysql-m1‘\G"|egrep  "Slave_IO_Running|Slave_SQL_Running|Last_IO_Error"
mysql: [Warning] Using a password on the command line interface can be insecure.
             Slave_IO_Running: No
            Slave_SQL_Running: Yes
                Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).
      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
      Last_IO_Error_Timestamp: 160508 03:03:05

原因是/ect/my.cnf 配置文件中修改server_id时。没有重启服务，所以修改没有生效
[root@mysql-s mysql-5.7.10]# cd /aliyun/server/mysql-5.7.10/
pkill mysqld
[root@mysql-s mysql-5.7.10]# sh start_mysql.sh
三个数据库都同样操作

7.4.但是还是报错:

 [root@mysql-s ~]# mysql -uroot -p123456 -S /tmp/mysql.sock -e "SHOW SLAVE STATUS FOR CHANNEL ‘mysql-m1‘\G"|egrep  "Slave_IO_Running|Slave_SQL_Running|Last_IO_Error"
mysql: [Warning] Using a password on the command line interface can be insecure.
             Slave_IO_Running: No
            Slave_SQL_Running: Yes
                Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work.
      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
      Last_IO_Error_Timestamp: 160508 03:23:36

原因是mysql-s 虚拟机是基于mysql-m1的虚拟机克隆过来的，mysqlm1上的文件auto.cnf和mysql-s /mysql=m2上文件的auto.cnf 是一样的，所以报错

[root@mysql-s mysql]# cat /aliyun/data/mysql/auto.cnf 
[auto]
server-uuid=3652e06e-1467-11e6-ab9f-000c2970db66

[root@mysql-m1 mysql-5.7.10]# cat /aliyun/data/mysql/auto.cnf 
[auto]
server-uuid=3652e06e-1467-11e6-ab9f-000c2970db66
[root@mysql-m2 mysql-5.7.10]# cat /aliyun/data/mysql/auto.cnf 
[auto]
server-uuid=3652e06e-1467-11e6-ab9f-000c2970db66
把这三个auto.cnf文件中的数值改成随便不一样的就行。然后依次重启数据库，就好了

[root@mysql-s mysql-5.7.10]# mysql -uroot -p123456 -S /tmp/mysql.sock -e "SHOW SLAVE STATUS FOR CHANNEL ‘mysql-m1‘\G"|egrep  "Slave_IO_Running|Slave_SQL_Running|Last_IO_Error"
mysql: [Warning] Using a password on the command line interface can be insecure.
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
                Last_IO_Error: 
      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
      Last_IO_Error_Timestamp:

可以通过查看performance_schema相关的表查看同步状态，执行命令：

mysql> SELECT * FROM performance_schema.replication_connection_status;
监控复制状态
+--------------+------------+--------------------------------------+-----------+---------------+---------------------------+--------------------------+--------------------------+-------------------+--------------------+----------------------+
| CHANNEL_NAME | GROUP_NAME | SOURCE_UUID                          | THREAD_ID | SERVICE_STATE | COUNT_RECEIVED_HEARTBEATS | LAST_HEARTBEAT_TIMESTAMP | RECEIVED_TRANSACTION_SET | LAST_ERROR_NUMBER | LAST_ERROR_MESSAGE | LAST_ERROR_TIMESTAMP |
+--------------+------------+--------------------------------------+-----------+---------------+---------------------------+--------------------------+--------------------------+-------------------+--------------------+----------------------+
| mysql-m1     |            | 3652e06e-1467-11e1-ab9f-000c2970db66 |      NULL | OFF           |                        37 | 2016-05-08 04:26:38      |                          |                 0 |                    | 0000-00-00 00:00:00  |
| mysql-m2     |            | 3652e06e-1467-11e6-ab9f-000c2970db66 |        41 | ON            |                        47 | 2016-05-08 04:51:32      |                          |                 0 |                    | 0000-00-00 00:00:00  |
+--------------
+------------+--------------------------------------+-----------+---------------+---------------------------+--------------------------+--------------------------+-------------------+--------------------+----------------------+

mysql> stop slave;(停止时必须同时开启各个slave，否则不能同步)

Query OK, 0 rows affected (0.01 sec)

mysql> set global sql_slave_skip_counter=10;
mysql> start slave for CHANNEL ‘mysql-m1‘;
mysql> start slave for CHANNEL ‘mysql-m2‘;
mysql> SHOW SLAVE STATUS FOR CHANNEL ‘mysql-m1‘\G
mysql> SHOW SLAVE STATUS FOR CHANNEL ‘mysql-m2‘\G

8.MySQL 5.7的多源复制用处：
8.1、MySQL 5.7的多源复制，能有效的解决分库分表的数据统计问题，同时也可以实现在一台从服务器对多台主服务器的数据备份。

8.2、MySQL 5.7的多源复制的出现，我们就不需要使用MariaDB 的多主一从的架构了，让很多小伙伴又看到了新的希望。
参考资料：

http://dev.mysql.com/doc/refman/5.7/en/change-master-to.html
http://www.longlong.asia/2015/10/21/mysql57-new-features.html

MySQL-5.7文档看考资料：
http://www.cnblogs.com/xuanzhi201111/p/5148113.html
mysql多元复制资料地址
http://www.mamicode.com/info-detail-1189601.html
mysql 数据库5.7编译安装
http://www.cnblogs.com/xuanzhi201111/p/5148113.html
http://www.mamicode.com/info-detail-1189601.html
http://huqiji.iteye.com/blog/2068613

MySQL5.7.10多元复制功能搭建

标签：orm 编译安装 sel tran server-id mod pos html table

本文系统来源：http://blog.51cto.com/wujianwei/2066178

内容总结

以上是互联网集市为您收集整理的MySQL5.7.10多元复制功能搭建全部内容，希望文章能够帮你解决MySQL5.7.10多元复制功能搭建所遇到的程序开发问题。如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/498215.html

来源：【匿名】

【上一篇】mysql sql分页查询语句【下一篇】用IE远程创建Mysql数据库的简易程序

更多 ►

【MySQL5.7.10多元复制功能搭建】教程文章相关的互联网学习教程文章

windows2016 安装mysql5.7

下载msi安装包，一路下一步。安装好后，做下简单配置。默认的my.ini和datadir在C:\ProgramData\MySQL Server 5.7下更改默认my.ini的方法为修改注册表[HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\MySQL57]修改ImagePath 中的参数即可还有一点要注意的就是，修改了my.ini中的datadir后，一定要给network service的读写权限原文：http://www.cnblogs.com/draweye/p/6824518.html

centeros7远程访问mysql5.7【代码】

先启动firewall防火墙：service firewalld start打开3306端口：firewall-cmd --add-port=3306/tcp --permanentmysql授权root账户远程访问：update mysql.user set Host=‘%‘where HOST=‘localhost‘ and User=‘root‘;flush privileges;重启mysql服务器：service mysqld restart搞定收工！！！！抱怨一句，今天上海好热啊原文：http://www.cnblogs.com/wenhainan/p/7249741.html

MySQL5.7传输表空间——迁移分区表

Mysql 传输表空间--将InnoDB分区表复制到另一个实例（二）实验环境：（都是mysql5.7）源库：192.168.2.200 mysql5.7.16 zhangdb下的emp_2分区表的目标库：192.168.2.100 mysql5.7.18 test下（将zhangdb的emp表，导入到目标库的test schema下）--：在源数据库中创建测试分区表emp_2，然后导入数据MySQL [zhangdb]> CREATE TABLE emp_2(id BIGINT unsigned NOT NULL AUTO_INCREMENT,x VARCHAR(500) NOT NULL,y ...

学习笔记--mysql5.7新版本

mysql5.7 在redhat6上安装新版本的mysql，若存在旧版本的mysql应卸载掉mysql —version 查看mysql版本rpm -qa | grep mysql 查看已经安装的mysql(需卸载的mysql包)新版本安装包：mysql-5.7.11-1.el6.x86_64.rpm-bundle.tar解压并安装：yum install -y mysql-community-*安装成功后启动mysql服务：/etc/init.d/mysqld start执行mysql_secure_installation进行安全初始化向导[root@server1 mnt]# mysql_secure_installation Secu...

mysql5.7忘记密码时，修改root密码【代码】

（1）.由于MySQL5.7在安装完后，第一次启动时，会在root目录下生产一个随机的密码，文件名为 .mysql_secret 所以，登录时需要用随机密码登录，然后通过以下命令修改密码 “SET PASSWORD = PASSWORD(‘new password’);”（2）. 在忘记root密码的时候，以windows为例： 1. 关闭正在运行的MySQL服务。 2. 打开DOS窗口，转到mysql\bin目录3. 输入mysqld --skip-grant-tables 回车--skip-grant-tables 的意思是启动MySQL服务的时候...

centos7下mysql5.7的安装【代码】

1.通过yum repository安装，地址https://dev.mysql.com/downloads/repo/yum/ 2.下载rpm文件wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm3.可以参考https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/安装mysql5.7 4.Adding the MySQL Yum Repositoryrpm -Uvh mysql80-community-release-el7-3.noarch.rpm[root@iZbp1gg50ddqbgxf1jpqwwZ home]# rpm -Uvh mysql80-community-release-el7-3.n...

CentOS7 yum方式安装MySQL5.7 + 远程连接【代码】【图】

1 下载并安装MySQL官方的 Yum Repository[root@localhost ~]# wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm 使用上面的命令就直接下载了安装用的Yum Repository，大概25KB的样子，然后就可以直接yum安装了。[root@localhost ~]# yum -y install mysql57-community-release-el7-10.noarch.rpm 之后就开始安装MySQL服务器。[root@localhost ~]# yum -y install mysql-community-server 这步...

MySQL5.7 count()函数【代码】

我们都用过count()函数，最常用的就是全表统计行数。select count(*) from tableName;count(*) 这里是计算全表的行数。我们看官网的解释是：COUNT(*) counts the number of rows。我们建表测试一下：CREATE TABLE `tb_testFn_count` ( `id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, `title` VARCHAR(10) DEFAULT NULL, `description` VARCHAR(10) DEFAULT NULL, PRIMARY KEY (id) )ENGINE=InnoDB AUTO_INCREMENT=6...

YUM CentOS 7 64位下mysql5.7安装配置【代码】【图】

配置YUM源在MySQL官网中下载YUM源rpm安装包：http://dev.mysql.com/downloads/repo/yum/#下载mysql源安装包# wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm# 安装mysql源# yum localinstall mysql57-community-release-el7-8.noarch.rpm 检查mysql源是否安装成功# yum repolist enabled | grep "mysql.*-community.*"看到下图表示安装成功安装MySQL# yum install mysql-community-server 启动MySQ...

MYSQL5.7二进制包的安装

mysql5.7 二进制包安装1. 下载包 wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.12-linux-glibc2.5-x86_64.tar.gz2. 解压 tar xxvf mysql-5.7.12-linux-glibc2.5-x86_64.tar.gzmv mysql-5.7.12-linux-glibc2.5-x86_64 /usr/local/mysql3. 初始化useradd -M -s /sbin/nologin mysql mkdir -p /data/mysqlchown mysql /data/mysqlcd /usr/local/mysql./bin/mysqld --initialize --user=mysql --datadir=/data/mysq...

安装mysql5.7【代码】

环境： CentOS7 mysql源选择本地源：[root@master ~]# ll win-share/mysql/57/ 总用量 207346 -rwxrwxrwx. 1 root root 26468960 2月 28 22:17 mysql-community-client-5.7.33-1.el7.x86_64.rpm -rwxrwxrwx. 1 root root 315280 12月 11 13:20 mysql-community-common-5.7.33-1.el7.x86_64.rpm -rwxrwxrwx. 1 root root 2458780 12月 11 13:21 mysql-community-libs-5.7.33-1.el7.x86_64.rpm -rwxrwxrwx. 1 root root 126...

docker安装mysql5.7【代码】

docker pull mysql:5.7 mkdir -p /mydata/mysql/conf cat > /mydata/mysql/conf/my.cnf << EOF [client] default-character-set=utf8[mysql] default-character-set=utf8[mysqld] init_connect=‘SET collation_connection=utf_unicode_ci‘ init_connect=‘SET NAMES uft8‘ character-set-server=utf8 collation-server=utf8_unicode_ci skip-character-set-client-handshake # 解决客户端连接慢，跳过域名解析 skip-name-resolv...

MySQL5.7脚本自动安装

脚本里面没有把同步时间写进去，这个写在最前面yum install -y ntp ntpdatecp -f /usr/share/zoneinfo/Asia/Shanghai /etc/localtime执行下列语句之前，请详细了解ntp和ntpdate的区别，由于我这里是测试环境，所以ntpdate并无问题，正式环境请慎用ntpdate（ntp是逐渐校正时间，ntpdate是跳跃式的直接修改时间，可能会对应用造成不良影响）（另外，在虚拟机上测试时，ntpd不是太明显）service ntpdate start /sbin/chkconfig --add ...

mysql5.7新增加用户和授权【代码】

迁移mysql数据库，运行项目的时候发现nginx和uWSGI都配置正确，可就是网站打不开，看了log文件，发现错误：django.db.utils.OperationalError: (1044, "Access denied for user ‘lcp‘@‘%‘ to database ‘work_blog‘")看到这意识到mysql数据库现在只有root账户，并没lcp这个。所以需要增加这个用户，并设置密码和相应权限，下面是一个通用命令：mysql -u root -p CREATE USER ‘myuser‘@‘localhost‘ IDENTIFIED BY ‘mypass...

centos7.3 使用yum快速安装mysql5.7【代码】

配置mysql yum源1.下载yum源 shell> wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm 2.安装yum源包 shell>yum localinstall mysql57-community-release-el7-8.noarch.rpm 3.检查mysql源是否安装成功 shell> yum repolist enabled | grep "mysql.*-community.*" 4.安装mysql shell> yum install mysql-community-server 5.启动MySQL服务 shell> systemctl start mysqld 6.查看MySQL的启动状态 shell> s...

首页 / MYSQL / MySQL5.7.10多元复制功能搭建

MySQL5.7.10多元复制功能搭建

内容导读

内容图文

内容总结

内容备注

内容手机端

【MySQL5.7.10多元复制功能搭建】教程文章相关的互联网学习教程文章

功能 - 相关标签

MYSQL - 技术教程分类

MYSQL - 最新教程

MYSQL - 最热教程