拉取網易蜂巢的mysql-server：5.6
|
1
|
docker pull hub.c.163.com/nce2/mysql:5.6 |
創(chuàng)建mysql5.6容器 1master+3個slave
|
1
2
3
4
|
docker run --name mysql-master -d -P hub.c.163.com/nce2/mysql:5.6docker run --name mysql-slave1 -d -P hub.c.163.com/nce2/mysql:5.6docker run --name mysql-slave2 -d -P hub.c.163.com/nce2/mysql:5.6docker run --name mysql-slave3 -d -P hub.c.163.com/nce2/mysql:5.6 |
驗證容器狀態(tài)
|
1
2
3
4
5
6
|
[root@bogon ~]# docker psCONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES907bbbf25d25 hub.c.163.com/nce2/mysql:5.6 "/run.sh" 5 minutes ago Up 5 minutes 3306/tcp mysql-slave3a81df6c86808 hub.c.163.com/nce2/mysql:5.6 "/run.sh" 5 minutes ago Up 5 minutes 3306/tcp mysql-slave2375eabd4c598 hub.c.163.com/nce2/mysql:5.6 "/run.sh" 5 minutes ago Up 5 minutes 3306/tcp mysql-slave11651d1cab219 hub.c.163.com/nce2/mysql:5.6 "/run.sh" 14 minutes ago Up 14 minutes 3306/tcp mysql-master |
通過主機命令行進入master容器
|
1
2
3
|
docker exec -it mysql-master bash[root@bogon ~]# docker exec -it mysql-master bashroot@1651d1cab219:/# |
在master中創(chuàng)建一個數(shù)據(jù)庫test_docker
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
root@1651d1cab219:/# mysql -uroot -pEnter password:Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 4Server version: 5.6.19-v1-log MySQL Community Server (GPL)Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || #bak_database || mysql || performance_schema || test |+--------------------+5 rows in set (0.02 sec)mysql> create database test_docker;Query OK, 1 row affected (0.06 sec)mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || #bak_database || mysql || performance_schema || test || test_docker |+--------------------+6 rows in set (0.00 sec) |
在slave1中創(chuàng)建一個數(shù)據(jù)庫test_docker
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
[root@bogon ~]# docker exec -it mysql-slave bashError response from daemon: No such container: mysql-slave[root@bogon ~]# docker exec -it mysql-slave1 bashroot@375eabd4c598:/# mysql -uroot -pEnter password:Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 4Server version: 5.6.19-v1-log MySQL Community Server (GPL)Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || #bak_database || mysql || performance_schema || test |+--------------------+5 rows in set (0.00 sec) |
通過以上的信息說明master與slave是數(shù)據(jù)隔離的，所以我們可以通過docker創(chuàng)建N個mysql容器， 然后就能以很小的代價就能學習《高可用MySQL》中的數(shù)據(jù)模型 再也不用發(fā)愁機器不夠用。
后續(xù)操作
登錄到master容器
|
1
2
|
[root@bogon ~]# docker exec -it mysql-master bashroot@1651d1cab219:/# |
怎么查看容器的操作系統(tǒng)環(huán)境
一般就是
|
1
2
3
|
uname -a cat /etc/pro cat /etc/lsb-release |
很幸運我們的容器是ubuntu14.04
|
1
2
3
4
5
|
root@1651d1cab219:/# cat /etc/lsb-releaseDISTRIB_ID=UbuntuDISTRIB_RELEASE=14.04DISTRIB_CODENAME=trustyDISTRIB_DESCRIPTION="Ubuntu 14.04.3 LTS" |
但是執(zhí)行 apt-get install時候卻什么也裝不了
需要更改
cd /etc/apt/
沒有 vi vim ee 編輯器 只好追加內容到 sources.list
|
1
2
3
4
5
6
7
8
9
10
|
echo deb http://mirrors.163.com/ubuntu/ trusty main restricted universe multiverse >> sources.listecho deb http://mirrors.163.com/ubuntu/ trusty-security main restricted universe multiverse >> sources.listecho deb http://mirrors.163.com/ubuntu/ trusty-updates main restricted universe multiverse >> sources.listecho deb http://mirrors.163.com/ubuntu/ trusty-proposed main restricted universe multiverse >> sources.listecho deb http://mirrors.163.com/ubuntu/ trusty-backports main restricted universe multiverse >> sources.listecho deb-src http://mirrors.163.com/ubuntu/ trusty main restricted universe multiverse >> sources.listecho deb-src http://mirrors.163.com/ubuntu/ trusty-security main restricted universe multiverse >> sources.listecho deb-src http://mirrors.163.com/ubuntu/ trusty-updates main restricted universe multiverse >> sources.listecho deb-src http://mirrors.163.com/ubuntu/ trusty-proposed main restricted universe multiverse >> sources.listecho deb-src http://mirrors.163.com/ubuntu/ trusty-backports main restricted universe multiverse >> sources.list |
然后 更新源
|
1
2
|
apt-get updateapt-get install vim |
然后通過vim把sources.list文件的前兩行刪除掉 再重新update一下。
apt-get update
安裝一個網絡工具獲取ip
|
1
|
apt-get install net-tools |
獲取到master的ip地址
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
root@1651d1cab219:/# ifconfigeth0 Link encap:Ethernet HWaddr 02:42:ac:11:00:02 inet addr:172.17.0.2 Bcast:0.0.0.0 Mask:255.255.0.0 inet6 addr: fe80::42:acff:fe11:2/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:15119 errors:0 dropped:0 overruns:0 frame:0 TX packets:12633 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:34197557 (34.1 MB) TX bytes:897732 (897.7 KB)lo Link encap:Local Loopback inet addr:127.0.0.1 Mask:255.0.0.0 inet6 addr: ::1/128 Scope:Host UP LOOPBACK RUNNING MTU:65536 Metric:1 RX packets:22 errors:0 dropped:0 overruns:0 frame:0 TX packets:22 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:2212 (2.2 KB) TX bytes:2212 (2.2 KB) |
slave也需要這么做
還有一種方法
可以創(chuàng)建Dockerfile依賴mysql鏡像創(chuàng)建一個新的鏡像。
上訴命令通過RUN來執(zhí)行創(chuàng)建的新容器會有安裝的軟件。
最后通過slave的docker連接到master的容器mysql服務器上
master的服務器mysql賬號root賦值權限
|
1
2
3
4
5
|
mysql> grant all privileges on *.* to root@'%' identified by '';Query OK, 0 rows affected (0.02 sec)mysql> flush privileges;Query OK, 0 rows affected (0.02 sec) |
slave服務器執(zhí)行如下命令
|
1
2
3
4
5
6
7
8
9
10
11
|
[root@bogon ~]# mysql -uroot -p -h 172.17.0.2Enter password:Welcome to the MariaDB monitor. Commands end with ; or \g.Your MySQL connection id is 6Server version: 5.6.19-v1-log MySQL Community Server (GPL)Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MySQL [(none)]> |
在master上將test_docker數(shù)據(jù)庫刪除，看slave的終端是否也不顯示已刪除的庫
master操作
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || #bak_database || mysql || performance_schema || test || test_docker |+--------------------+6 rows in set (0.00 sec)mysql> drop database test_docker;Query OK, 0 rows affected (0.06 sec)mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || #bak_database || mysql || performance_schema || test |+--------------------+5 rows in set (0.00 sec) |
slave操作
|
1
2
3
4
5
6
7
8
9
10
11
12
13
|
MySQL [(none)]> show databases;+--------------------+| Database |+--------------------+| information_schema || #bak_database || mysql || performance_schema || test |+--------------------+5 rows in set (0.00 sec)MySQL [(none)]> |
以上就是本文的全部內容，希望對大家的學習有所幫助，也希望大家多多支持服務器之家。
原文鏈接：http://www.cnblogs.com/baolong/p/5763412.html
