07 Docker安装mysql


[root@localhost test]# podman search mariadb
INDEX       NAME                            DESCRIPTION                                       STARS   OFFICIAL   AUTOMATED
docker.io   docker.io/library/mariadb       MariaDB is a community-developed fork of MyS...   3651    [OK]       
docker.io   docker.io/bitnami/mariadb       Bitnami MariaDB Docker Image                      124                [OK]
docker.io   docker.io/linuxserver/mariadb   A Mariadb container, brought to you by Linux...   162                
docker.io   docker.io/webhippie/mariadb     Docker images for MariaDB                         21                 [OK]
docker.io   docker.io/circleci/mariadb      CircleCI images for MariaDB                       3                  [OK]

[root@localhost test]# podman pull mariadb
Trying to pull docker.io/library/mariadb...
Getting image source signatures
Copying blob ba34deb445c3 done
Copying blob e6ca3592b144 done
Copying blob 47b4f6570cf0 done
Copying blob 534a5505201d done
Copying blob 990916bd23bb done
Copying blob c62d6bd206a2 done
Copying blob 69df87d9330c done
Copying blob 6ab34d00af2f done
Copying blob 0222c6c4a452 done
Copying blob d9f0e67eb23f done
Copying blob 28b039c5139e done
Copying blob bb48a5d6fdc6 done
Copying config cbbff8572f done
Writing manifest to image destination
Storing signatures
[root@localhost test]# podman images
REPOSITORY                                       TAG           IMAGE ID       CREATED        SIZE
localhost/simon_tomcat9                          latest        c379423344cf   26 hours ago   624 MB
docker.io/library/mariadb                        latest        cbbff8572fa8   3 days ago     413 MB
docker.io/library/centos                         latest        0d120b6ccaa8   5 weeks ago    222 MB


[root@localhost test]# mkdir -p /simon_data/mariadb/{conf,logs,data}
[root@localhost test]# podman run -p 23306:3306 --name mariadb \
-v /simon_data/mariadb/conf:/etc/mysql/conf \
-v /simon_data/mariadb/logs:/logs \
-v /simon_data/mariadb/data:/var/lib/mysql \
-d mariadb

[root@localhost test]# podman ps
CONTAINER ID  IMAGE                                                       COMMAND         CREATED         STATUS             PORTS                    NAMES
b2030de64008  docker.io/library/mariadb:latest                            mysqld          57 seconds ago  Up 56 seconds ago>3306/tcp  mariadb


[root@localhost conf]# podman exec -it b2030de64008 /bin/bash
root@b2030de64008:/# mysql -uroot -p'wwwwww'
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 11
Server version: 10.5.5-MariaDB-1:10.5.5+maria~focal mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> 
MariaDB [(none)]>
MariaDB [(none)]> create database db01 default charset utf8;
Query OK, 1 row affected (0.001 sec)
MariaDB [(none)]> use db01;
Database changed
MariaDB [db01]> create table t_01 (id int(4) not null primary key,`name` varchar(32) default null);
Query OK, 0 rows affected (0.017 sec)
MariaDB [db01]> insert into t_01 values(1,'simon');
Query OK, 1 row affected (0.004 sec)

MariaDB [db01]> insert into t_01 values(2,'hukey');
Query OK, 1 row affected (0.003 sec)
MariaDB [db01]> 
MariaDB [db01]> select * from t_01;
| id | name  |
|  1 | simon |
|  2 | hukey |
2 rows in set (0.001 sec)

# 备份
[root@localhost conf]# podman exec -it b2030de64008 /bin/bash -c ' exec mysqldump --all-databases -uroot -p'wwwwww'' > /simon_data/mariadb/data/all-database.sql
[root@localhost conf]# 
[root@localhost conf]# ll !$
ll /simon_data/mariadb/data/all-database.sql
-rw-r--r-- 1 root root 4062659 Sep 20 09:50 /simon_data/mariadb/data/all-database.sql

posted @ 2022-11-24 20:44  oldSimon  阅读(25)  评论(0编辑  收藏  举报