容器部署MySQL数据迁移

1、用MySQL镜像启动一个MySQL容器

[root@lb docker]# docker pull mysql
...
[root@lb docker]# docker images
REPOSITORY          TAG                 IMAGE ID            CREATED             SIZE
mysql               latest              0d64f46acfd1        7 days ago          544MB
[root@lb ~]# mkdir /data1
[root@lb ~]# docker run -d -p 3306:3306 -v /data1:/var/lib/mysql --name mysql1 -e MYSQL_ROOT_PASSWORD=123 mysql
d694e8735af3d7481555013bd84f0a8fcd367d98dd36ce4d6b7d0e2fd10ad04a

PS:/var/lib/mysql 是默认得数据存放目录

2、进入容器中创建库表等一些数据

[root@lb /]# docker exec -it mysql1 /bin/bash
root@d694e8735af3:/# mysql -uroot -p123
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 8
Server version: 8.0.21 MySQL Community Server - GPL

Copyright (c) 2000, 2020, 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> create database test;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| test               |
+--------------------+
5 rows in set (0.01 sec)

mysql> create table t1 ( id int, name varchar(20), gender char(20));
Query OK, 0 rows affected (0.01 sec)

mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| t1             |
+----------------+
1 row in set (0.00 sec)

mysql> desc t1;
+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| id     | int         | YES  |     | NULL    |       |
| name   | varchar(20) | YES  |     | NULL    |       |
| gender | char(20)    | YES  |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> insert into t1 values(1,'tom','m');
Query OK, 1 row affected (0.01 sec)

mysql> select * from t1;
+------+------+--------+
| id   | name | gender |
+------+------+--------+
|    1 | tom  | m      |
+------+------+--------+
1 row in set (0.00 sec)

mysql> exit
Bye
root@d694e8735af3:/# exit
exit

3、复制目录至另一节点

[root@lb ~]# scp -rp /data1/ 192.168.53.8:/root/

为了节省镜像下载时间，将镜像打包发送过去

[root@lb docker]# docker save mysql>mysql.tar
[root@lb docker]# scp ./mysql.tar 192.168.53.8:/root/


53.8
[root@web2 ~]# docker load </root/mysql.tar

4、在53.8节点上用容器启动MySQL验证

[root@web2 ~]# docker run -d -p 3306:3306 --name mysql2 -v /root/data1/:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123 mysql
b189fbacc5363e9d53d7fa6a8b0d476041e2a6fcedfabfedf337111a8c22463d
[root@web2 ~]# docker exec -it mysql2 /bin/bash
root@b189fbacc536:/# mysql -uroot -p123
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 8
Server version: 8.0.21 MySQL Community Server - GPL

Copyright (c) 2000, 2020, 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> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| test               |
+--------------------+
5 rows in set (0.05 sec)

mysql> select * from test.t1;
+------+------+--------+
| id   | name | gender |
+------+------+--------+
|    1 | tom  | m      |
+------+------+--------+
1 row in set (0.10 sec)

mysql> 

验证完毕，数据已完成迁移