没有合适的资源?快使用搜索试试~ 我知道了~
docker容器mysql数据库无状态主从配置
需积分: 9 2 下载量 22 浏览量
2016-10-18
13:02:07
上传
评论
收藏 6KB TXT 举报
温馨提示
试读
6页
docker容器mysql数据库无状态主从配置,从节点重启自动增量同步。
资源推荐
资源详情
资源评论
1、docker search mysql
2、docker pull mysql
3、docker images
4、创建/soft/conf,/soft/master,/soft/slave,修改配置文件(参考附件)
5、docker run --name mysql-master -v /soft/conf/my-m.cnf:/etc/mysql/my.cnf -p 3307:3306 -e MYSQL_ROOT_PASSWORD=1234 -e MYSQL_USER=sbin -e MYSQL_PASSWORD=1234 -e MYSQL_DATABASE=sbin -v /soft/master:/var/lib/mysql -d mysql
6、docker run --name mysql-slave -v /soft/conf/my-s.cnf:/etc/mysql/my.cnf -p 3308:3306 -e MYSQL_ROOT_PASSWORD=1234 -e MYSQL_USER=sbin -e MYSQL_PASSWORD=1234 -e MYSQL_DATABASE=sbin -v /soft/slave:/var/lib/mysql -d mysql
7、mysql -h 0.0.0.0 -P 3307 -u root -p
8、mysql -h 0.0.0.0 -P 3308 -u root -p
9、连接主库,并运行以下命令,创建一个用户用来同步数据
GRANT REPLICATION SLAVE ON *.* to 'backup'@'%' identified by '123456';
10、查看主库状态
$ show master status;
记住File、Position的值,如果没查到数据,请检查第一、第二步,配置问题。
我查出来的是mysql-bin.000004、312;
11、连接到从库,运行以下命令,设置主库链接
change master to master_host='121.32.32.54',master_user='backup',master_password='123456',master_log_file='mysql-bin.000004',master_log_pos=312,master_port=3307;
12、启动同步
$ start slave;
13、查看同步状态
$ show slave status
如果看到Waiting for master send event.. 什么的就成功了,你现在在主库上的修改,都会同步到从库上
附件:
1、首先创建两个文件my-m.cnf(主库配置) 、my-s.cnf(从库配置)
my-m.cnf 内容如下
# Copyright (c) 2014, Oracle and/or its affiliates. All rights reserved.
#
# This program is free software; you can redistribute it and/or modify
2、docker pull mysql
3、docker images
4、创建/soft/conf,/soft/master,/soft/slave,修改配置文件(参考附件)
5、docker run --name mysql-master -v /soft/conf/my-m.cnf:/etc/mysql/my.cnf -p 3307:3306 -e MYSQL_ROOT_PASSWORD=1234 -e MYSQL_USER=sbin -e MYSQL_PASSWORD=1234 -e MYSQL_DATABASE=sbin -v /soft/master:/var/lib/mysql -d mysql
6、docker run --name mysql-slave -v /soft/conf/my-s.cnf:/etc/mysql/my.cnf -p 3308:3306 -e MYSQL_ROOT_PASSWORD=1234 -e MYSQL_USER=sbin -e MYSQL_PASSWORD=1234 -e MYSQL_DATABASE=sbin -v /soft/slave:/var/lib/mysql -d mysql
7、mysql -h 0.0.0.0 -P 3307 -u root -p
8、mysql -h 0.0.0.0 -P 3308 -u root -p
9、连接主库,并运行以下命令,创建一个用户用来同步数据
GRANT REPLICATION SLAVE ON *.* to 'backup'@'%' identified by '123456';
10、查看主库状态
$ show master status;
记住File、Position的值,如果没查到数据,请检查第一、第二步,配置问题。
我查出来的是mysql-bin.000004、312;
11、连接到从库,运行以下命令,设置主库链接
change master to master_host='121.32.32.54',master_user='backup',master_password='123456',master_log_file='mysql-bin.000004',master_log_pos=312,master_port=3307;
12、启动同步
$ start slave;
13、查看同步状态
$ show slave status
如果看到Waiting for master send event.. 什么的就成功了,你现在在主库上的修改,都会同步到从库上
附件:
1、首先创建两个文件my-m.cnf(主库配置) 、my-s.cnf(从库配置)
my-m.cnf 内容如下
# Copyright (c) 2014, Oracle and/or its affiliates. All rights reserved.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; version 2 of the License.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
#
# The MySQL Community Server configuration file.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
# the Free Software Foundation; version 2 of the License.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
#
# The MySQL Community Server configuration file.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
剩余5页未读,继续阅读
资源评论
bnlovebn
- 粉丝: 1
- 资源: 6
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功