> 데이터 베이스 > MySQL 튜토리얼 > Docker를 사용하여 MySQL 데이터베이스를 배포하는 방법

Docker를 사용하여 MySQL 데이터베이스를 배포하는 방법

WBOY
풀어 주다: 2023-05-27 10:24:58
앞으로
1763명이 탐색했습니다.

    1. 시스템 버전 확인

    [root@node ~]# cat /etc/os-release 
    NAME="CentOS Linux"
    VERSION="7 (Core)"
    ID="centos"
    ID_LIKE="rhel fedora"
    VERSION_ID="7"
    PRETTY_NAME="CentOS Linux 7 (Core)"
    ANSI_COLOR="0;31"
    CPE_NAME="cpe:/o:centos:centos:7"
    HOME_URL="https://www.centos.org/"
    BUG_REPORT_URL="https://bugs.centos.org/"
    
    CENTOS_MANTISBT_PROJECT="CentOS-7"
    CENTOS_MANTISBT_PROJECT_VERSION="7"
    REDHAT_SUPPORT_PRODUCT="centos"
    REDHAT_SUPPORT_PRODUCT_VERSION="7"
    로그인 후 복사

    2. 도커 상태 확인

    1. 도커 버전 확인

    [root@node ~]# 
    [root@node ~]# docker version
    Client: Docker Engine - Community
     Version:           20.10.17
     API version:       1.41
     Go version:        go1.17.11
     Git commit:        100c701
     Built:             Mon Jun  6 23:05:12 2022
     OS/Arch:           linux/amd64
     Context:           default
     Experimental:      true
    
    Server: Docker Engine - Community
     Engine:
      Version:          20.10.17
      API version:      1.41 (minimum version 1.12)
      Go version:       go1.17.11
      Git commit:       a89b842
      Built:            Mon Jun  6 23:03:33 2022
      OS/Arch:          linux/amd64
      Experimental:     false
     containerd:
      Version:          1.6.6
      GitCommit:        10c12954828e7c7c9b6e0ea9b0c02b01407d3ae1
     runc:
      Version:          1.1.2
      GitCommit:        v1.1.2-0-ga916309
     docker-init:
      Version:          0.19.0
      GitCommit:        de40ad0
    로그인 후 복사

    2. 도커 상태 확인

    [root@node ~]# systemctl status docker
    ● docker.service - Docker Application Container Engine
       Loaded: loaded (/usr/lib/systemd/system/docker.service; enabled; vendor preset: disabled)
       Active: active (running) since Mon 2022-10-31 03:28:51 CST; 3 days ago
         Docs: https://docs.docker.com
     Main PID: 11884 (dockerd)
        Tasks: 32
       Memory: 3.4G
       CGroup: /system.slice/docker.service
               ├─11884 /usr/bin/dockerd -H fd:// --containerd=/run/containerd/containerd.sock
               ├─89868 /usr/bin/docker-proxy -proto tcp -host-ip 0.0.0.0 -host-port 8100 -container-ip 172.17.0.2 -container-port 8100
               └─89875 /usr/bin/docker-proxy -proto tcp -host-ip :: -host-port 8100 -container-ip 172.17.0.2 -container-port 8100
    
    Nov 03 01:23:55 node dockerd[11884]: time="2022-11-03T01:23:55.090581806+08:00" level=info msg="ignoring event" container=d9f4cabef3539e...kDelete"
    Nov 03 01:25:19 node dockerd[11884]: time="2022-11-03T01:25:19.911516515+08:00" level=info msg="ignoring event" container=e7556e1f3cd741...kDelete"
    Nov 03 01:25:20 node dockerd[11884]: time="2022-11-03T01:25:20.514390808+08:00" level=info msg="ignoring event" container=cb68026ad986be...kDelete"
    Nov 03 01:25:20 node dockerd[11884]: time="2022-11-03T01:25:20.907601037+08:00" level=info msg="ignoring event" container=3fccd6f474f242...kDelete"
    Nov 03 01:28:08 node dockerd[11884]: time="2022-11-03T01:28:08.318850188+08:00" level=info msg="ignoring event" container=c40d1656d49185...kDelete"
    Nov 03 01:29:44 node dockerd[11884]: time="2022-11-03T01:29:44.687790759+08:00" level=info msg="ignoring event" container=aaa5856375e071...kDelete"
    Nov 03 01:29:49 node dockerd[11884]: time="2022-11-03T01:29:49.913701227+08:00" level=info msg="ignoring event" container=4df40876d4fdc5...kDelete"
    Nov 03 01:29:50 node dockerd[11884]: time="2022-11-03T01:29:50.273656357+08:00" level=info msg="Layer sha256:7c05c40a224c88646a3c06ee539...aned up"
    Nov 03 01:29:50 node dockerd[11884]: time="2022-11-03T01:29:50.341692050+08:00" level=info msg="Layer sha256:7c05c40a224c88646a3c06ee539...aned up"
    Nov 03 01:29:50 node dockerd[11884]: time="2022-11-03T01:29:50.411279167+08:00" level=info msg="Layer sha256:7c05c40a224c88646a3c06ee539...aned up"
    Hint: Some lines were ellipsized, use -l to show in full.
    로그인 후 복사

    3. docker 허브에서 mysql 검색

    [root@node ~]# docker search mysql
    NAME                            DESCRIPTION                                     STARS     OFFICIAL   AUTOMATED
    mysql                           MySQL is a widely used, open-source relation…   13426     [OK]       
    mariadb                         MariaDB Server is a high performing open sou…   5119      [OK]       
    phpmyadmin                      phpMyAdmin - A web interface for MySQL and M…   674       [OK]       
    percona                         Percona Server is a fork of the MySQL relati…   592       [OK]       
    bitnami/mysql                   Bitnami MySQL Docker Image                      78                   [OK]
    databack/mysql-backup           Back up mysql databases to... anywhere!         74                   
    linuxserver/mysql-workbench                                                     45                   
    ubuntu/mysql                    MySQL open source fast, stable, multi-thread…   38                   
    linuxserver/mysql               A Mysql container, brought to you by LinuxSe…   37                   
    circleci/mysql                  MySQL is a widely used, open-source relation…   28                   
    google/mysql                    MySQL server for Google Compute Engine          21                   [OK]
    rapidfort/mysql                 RapidFort optimized, hardened image for MySQL   13                   
    bitnami/mysqld-exporter                                                         4                    
    ibmcom/mysql-s390x              Docker image for mysql-s390x                    2                    
    newrelic/mysql-plugin           New Relic Plugin for monitoring MySQL databa…   1                    [OK]
    vitess/mysqlctld                vitess/mysqlctld                                1                    [OK]
    hashicorp/mysql-portworx-demo                                                   0                    
    docksal/mysql                   MySQL service images for Docksal - https://d…   0                    
    rapidfort/mysql8-ib             RapidFort optimized, hardened image for MySQ…   0                    
    mirantis/mysql                                                                  0                    
    cimg/mysql                                                                      0                    
    drud/mysql                                                                      0                    
    silintl/mysql-backup-restore    Simple docker image to perform mysql backups…   0                    [OK]
    corpusops/mysql                 https://github.com/corpusops/docker-images/     0                    
    drud/mysql-local-57             ddev mysql local container                      0
    로그인 후 복사

    4. mysql 미러 다운로드

    [root@node ~]# docker pull mysql:5.7
    5.7: Pulling from library/mysql
    Digest: sha256:f2ad209efe9c67104167fc609cca6973c8422939491c9345270175a300419f94
    Status: Image is up to date for mysql:5.7
    docker.io/library/mysql:5.7
    로그인 후 복사

    5. mysql 컨테이너 만들기

    1. 데이터 디렉터리 만들기

    [root@node ~]# mkdir -p /data/mysql
    [root@node ~]# cd /data/mysql/
    [root@node mysql]# ls
    로그인 후 복사

    2. mysql 컨테이너 실행

    [root@node mysql]# docker run -d --name mysql_01 --restart always -v /data/mysql/db:/var/lib/mysql -p 3541:3306 -e MYSQL_ROOT_PASSWORD=admin -e MYSQL_DATABASE=data mysql:5.7
    aa36de70b1ae62ed3e123c504e6a6ad28aae1c399ca94fd5c507d3ed5c1a51f4
    로그인 후 복사

    3. mysql 컨테이너 상태 보기

    [root@node mysql]# docker ps
    CONTAINER ID   IMAGE               COMMAND                  CREATED         STATUS         PORTS                                                  NAMES
    aa36de70b1ae   mysql:5.7           "docker-entrypoint.s…"   2 seconds ago   Up 2 seconds   33060/tcp, 0.0.0.0:3541->3306/tcp, :::3541->3306/tcp   mysql_01
    로그인 후 복사

    4. mysql 보기 컨테이너 실행 로그

    [root@node mysql]# docker logs mysql_01 
    2022-11-03 03:31:49+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.36-1debian10 started.
    2022-11-03 03:31:49+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
    2022-11-03 03:31:49+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.36-1debian10 started.
    2022-11-03 03:31:49+00:00 [Note] [Entrypoint]: Initializing database files
    2022-11-03T03:31:49.635196Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2022-11-03T03:31:49.898761Z 0 [Warning] InnoDB: New log files created, LSN=45790
    2022-11-03T03:31:49.931888Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
    2022-11-03T03:31:50.006756Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 0d679e67-5b28-11ed-a3e5-0242ac110003.
    2022-11-03T03:31:50.007982Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
    2022-11-03T03:31:50.887041Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
    2022-11-03T03:31:50.887076Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
    2022-11-03T03:31:50.887861Z 0 [Warning] CA certificate ca.pem is self signed.
    2022-11-03T03:31:51.230064Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
    2022-11-03 03:31:53+00:00 [Note] [Entrypoint]: Database files initialized
    2022-11-03 03:31:53+00:00 [Note] [Entrypoint]: Starting temporary server
    2022-11-03 03:31:53+00:00 [Note] [Entrypoint]: Waiting for server startup
    2022-11-03T03:31:54.067334Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2022-11-03T03:31:54.070294Z 0 [Note] mysqld (mysqld 5.7.36) starting as process 76 ...
    2022-11-03T03:31:54.073329Z 0 [Note] InnoDB: PUNCH HOLE support available
    2022-11-03T03:31:54.073358Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2022-11-03T03:31:54.073361Z 0 [Note] InnoDB: Uses event mutexes
    2022-11-03T03:31:54.073363Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
    2022-11-03T03:31:54.073365Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2022-11-03T03:31:54.073369Z 0 [Note] InnoDB: Using Linux native AIO
    2022-11-03T03:31:54.073598Z 0 [Note] InnoDB: Number of pools: 1
    2022-11-03T03:31:54.073680Z 0 [Note] InnoDB: Using CPU crc32 instructions
    2022-11-03T03:31:54.076833Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
    2022-11-03T03:31:54.086060Z 0 [Note] InnoDB: Completed initialization of buffer pool
    2022-11-03T03:31:54.088952Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
    2022-11-03T03:31:54.101612Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
    2022-11-03T03:31:54.108731Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2022-11-03T03:31:54.108809Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2022-11-03T03:31:54.133108Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
    2022-11-03T03:31:54.133793Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
    2022-11-03T03:31:54.133813Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
    2022-11-03T03:31:54.134160Z 0 [Note] InnoDB: Waiting for purge to start
    2022-11-03T03:31:54.184549Z 0 [Note] InnoDB: 5.7.36 started; log sequence number 2749723
    2022-11-03T03:31:54.184906Z 0 [Note] Plugin 'FEDERATED' is disabled.
    2022-11-03T03:31:54.186366Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
    2022-11-03T03:31:54.188246Z 0 [Note] InnoDB: Buffer pool(s) load completed at 221103  3:31:54
    2022-11-03T03:31:54.191804Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
    2022-11-03T03:31:54.191834Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
    2022-11-03T03:31:54.191837Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
    2022-11-03T03:31:54.191840Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
    2022-11-03T03:31:54.192296Z 0 [Warning] CA certificate ca.pem is self signed.
    2022-11-03T03:31:54.192354Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
    2022-11-03T03:31:54.193128Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
    2022-11-03T03:31:54.199094Z 0 [Note] Event Scheduler: Loaded 0 events
    2022-11-03T03:31:54.199272Z 0 [Note] mysqld: ready for connections.
    Version: '5.7.36'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server (GPL)
    2022-11-03 03:31:54+00:00 [Note] [Entrypoint]: Temporary server started.
    Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
    Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
    Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
    Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
    2022-11-03 03:31:56+00:00 [Note] [Entrypoint]: Creating database data
    
    2022-11-03 03:31:56+00:00 [Note] [Entrypoint]: Stopping temporary server
    2022-11-03T03:31:56.656015Z 0 [Note] Giving 0 client threads a chance to die gracefully
    2022-11-03T03:31:56.656041Z 0 [Note] Shutting down slave threads
    2022-11-03T03:31:56.656046Z 0 [Note] Forcefully disconnecting 0 remaining clients
    2022-11-03T03:31:56.656050Z 0 [Note] Event Scheduler: Purging the queue. 0 events
    2022-11-03T03:31:56.656102Z 0 [Note] Binlog end
    2022-11-03T03:31:56.656573Z 0 [Note] Shutting down plugin 'ngram'
    2022-11-03T03:31:56.656591Z 0 [Note] Shutting down plugin 'partition'
    2022-11-03T03:31:56.656593Z 0 [Note] Shutting down plugin 'BLACKHOLE'
    2022-11-03T03:31:56.656596Z 0 [Note] Shutting down plugin 'ARCHIVE'
    2022-11-03T03:31:56.656598Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2022-11-03T03:31:56.656627Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
    2022-11-03T03:31:56.656631Z 0 [Note] Shutting down plugin 'MyISAM'
    2022-11-03T03:31:56.656639Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
    2022-11-03T03:31:56.656654Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2022-11-03T03:31:56.656658Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2022-11-03T03:31:56.656662Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2022-11-03T03:31:56.656665Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2022-11-03T03:31:56.656667Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2022-11-03T03:31:56.656669Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2022-11-03T03:31:56.656670Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2022-11-03T03:31:56.656672Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2022-11-03T03:31:56.656674Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2022-11-03T03:31:56.656676Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2022-11-03T03:31:56.656677Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2022-11-03T03:31:56.656679Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2022-11-03T03:31:56.656680Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2022-11-03T03:31:56.656681Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2022-11-03T03:31:56.656682Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
    2022-11-03T03:31:56.656683Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
    2022-11-03T03:31:56.656685Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
    2022-11-03T03:31:56.656686Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    2022-11-03T03:31:56.656687Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2022-11-03T03:31:56.656688Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2022-11-03T03:31:56.656690Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
    2022-11-03T03:31:56.656691Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2022-11-03T03:31:56.656692Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2022-11-03T03:31:56.656693Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2022-11-03T03:31:56.656695Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2022-11-03T03:31:56.656696Z 0 [Note] Shutting down plugin 'INNODB_CMP'
    2022-11-03T03:31:56.656697Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2022-11-03T03:31:56.656699Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
    2022-11-03T03:31:56.656701Z 0 [Note] Shutting down plugin 'INNODB_TRX'
    2022-11-03T03:31:56.656702Z 0 [Note] Shutting down plugin 'InnoDB'
    2022-11-03T03:31:56.656806Z 0 [Note] InnoDB: FTS optimize thread exiting.
    2022-11-03T03:31:56.656919Z 0 [Note] InnoDB: Starting shutdown...
    2022-11-03T03:31:56.757522Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
    2022-11-03T03:31:56.757787Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 221103  3:31:56
    2022-11-03T03:31:57.970526Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12659645
    2022-11-03T03:31:57.972238Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
    2022-11-03T03:31:57.972276Z 0 [Note] Shutting down plugin 'MEMORY'
    2022-11-03T03:31:57.972287Z 0 [Note] Shutting down plugin 'CSV'
    2022-11-03T03:31:57.972292Z 0 [Note] Shutting down plugin 'sha256_password'
    2022-11-03T03:31:57.972294Z 0 [Note] Shutting down plugin 'mysql_native_password'
    2022-11-03T03:31:57.972417Z 0 [Note] Shutting down plugin 'binlog'
    2022-11-03T03:31:57.972905Z 0 [Note] mysqld: Shutdown complete
    
    2022-11-03 03:31:58+00:00 [Note] [Entrypoint]: Temporary server stopped
    
    2022-11-03 03:31:58+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
    
    2022-11-03T03:31:58.915733Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2022-11-03T03:31:58.917521Z 0 [Note] mysqld (mysqld 5.7.36) starting as process 1 ...
    2022-11-03T03:31:58.920218Z 0 [Note] InnoDB: PUNCH HOLE support available
    2022-11-03T03:31:58.920244Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2022-11-03T03:31:58.920247Z 0 [Note] InnoDB: Uses event mutexes
    2022-11-03T03:31:58.920249Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
    2022-11-03T03:31:58.920251Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2022-11-03T03:31:58.920254Z 0 [Note] InnoDB: Using Linux native AIO
    2022-11-03T03:31:58.920601Z 0 [Note] InnoDB: Number of pools: 1
    2022-11-03T03:31:58.920689Z 0 [Note] InnoDB: Using CPU crc32 instructions
    2022-11-03T03:31:58.921871Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
    2022-11-03T03:31:58.927295Z 0 [Note] InnoDB: Completed initialization of buffer pool
    2022-11-03T03:31:58.928789Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
    2022-11-03T03:31:58.940579Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
    2022-11-03T03:31:58.945797Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2022-11-03T03:31:58.945895Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2022-11-03T03:31:58.963248Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
    2022-11-03T03:31:58.963976Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
    2022-11-03T03:31:58.963996Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
    2022-11-03T03:31:58.964510Z 0 [Note] InnoDB: Waiting for purge to start
    2022-11-03T03:31:59.015352Z 0 [Note] InnoDB: 5.7.36 started; log sequence number 12659645
    2022-11-03T03:31:59.015611Z 0 [Note] Plugin 'FEDERATED' is disabled.
    2022-11-03T03:31:59.015717Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
    2022-11-03T03:31:59.018506Z 0 [Note] InnoDB: Buffer pool(s) load completed at 221103  3:31:59
    2022-11-03T03:31:59.019449Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
    2022-11-03T03:31:59.019472Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
    2022-11-03T03:31:59.019476Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
    2022-11-03T03:31:59.019478Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
    2022-11-03T03:31:59.019855Z 0 [Warning] CA certificate ca.pem is self signed.
    2022-11-03T03:31:59.019905Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
    2022-11-03T03:31:59.020329Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
    2022-11-03T03:31:59.020457Z 0 [Note] IPv6 is available.
    2022-11-03T03:31:59.020506Z 0 [Note]   - '::' resolves to '::';
    2022-11-03T03:31:59.020528Z 0 [Note] Server socket created on IP: '::'.
    2022-11-03T03:31:59.021431Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
    2022-11-03T03:31:59.027266Z 0 [Note] Event Scheduler: Loaded 0 events
    2022-11-03T03:31:59.027407Z 0 [Note] mysqld: ready for connections.
    로그인 후 복사

    6. mysql 컨테이너

    를 입력합니다. 1. mysql 컨테이너

    [root@node mysql]# docker exec -it mysql_01 /bin/bash
    root@aa36de70b1ae:/# pwd
    /
    로그인 후 복사

    2를 입력합니다. 7. mysql 컨테이너

    1에 원격으로 연결합니다.

    2. mariadb 서비스를 시작하세요

    root@aa36de70b1ae:/# mysql -h 127.0.0.1 -P3306 -uroot -padmin
    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 4
    Server version: 5.7.36 MySQL Community Server (GPL)
    
    Copyright (c) 2000, 2021, Oracle and/or its affiliates.
    
    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 |
    | data               |
    | mysql              |
    | performance_schema |
    | sys                |
    +--------------------+
    5 rows in set (0.00 sec)
    
    mysql>
    로그인 후 복사

    3. 원격으로 mysql 컨테이너에 연결하세요

    yum -y install mariadb
    로그인 후 복사
    .

    위 내용은 Docker를 사용하여 MySQL 데이터베이스를 배포하는 방법의 상세 내용입니다. 자세한 내용은 PHP 중국어 웹사이트의 기타 관련 기사를 참조하세요!

    관련 라벨:
    원천:yisu.com
    본 웹사이트의 성명
    본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.
    인기 튜토리얼
    더>
    최신 다운로드
    더>
    웹 효과
    웹사이트 소스 코드
    웹사이트 자료
    프론트엔드 템플릿