目錄
- docker-compose 安裝掛載本地文件啟動mariadb
- 創建本地文件夾與配置文件
- 執行啟動
- 總結
docker-compose 安裝掛載本地文件啟動mariadb
docker pull mariadb:xxx
創建本地文件夾與配置文件
注：記得使用chown授權避免權限不足無法寫入的錯誤
[mariadbd] skip-host-cache skip-name-resolve [mysqld] datadir=/var/lib/mysql log-error=/var/log/mysql/mysqld.log pid-file=/var/run/mysqld/mysqld.pid log_bin=/var/log/mysql/mysql-bin binlog_format=row max-binlog-size=512m expire_logs_days=180 log_bin_index=/var/log/mysql/mysql-bin.index slow_query_log_file=/var/log/mysql/mariadb-slow.log long_query_time = 0.5 server-id=1 skip-external-locking max_connections = 1000 connect_timeout = 5 wait_timeout = 600 max_allowed_packet = 16M thread_cache_size = 128 sort_buffer_size = 4M bulk_insert_buffer_size = 16M tmp_table_size = 32M max_heap_table_size = 32M default_storage_engine = InnoDB # you can't just change log file size, requires special procedure #innodb_log_file_size = 50M #innodb_buffer_pool_size = 256M innodb_log_buffer_size = 8M innodb_file_per_table = 1 innodb_open_files = 400 innodb_io_capacity = 400 innodb_flush_method = O_DIRECT #tunning memory innodb_buffer_pool_size = 512m innodb_buffer_pool_instances=10 sort_buffer_size=12M read_buffer_size=8M read_rnd_buffer_size=50M join_buffer_size=8M query_cache_size=256M thread_concurrency=4 #CPU核數 * 2 !include /etc/mysql/mariadb.cnf !includedir /etc/mysql/conf.d/
創建compose文件，version版本參考：
https://docs.docker.com/compose/compose-file/compose-versio
docker-compose安裝參考：
mariadb集群搭建—Galera Cluster+ProxySQL
version: '3.7'
services:
mariadb:
image: mariadb:10.6.5
container_name: "mariadb_alone"
restart: always
environment:
MYSQL_USER: "root"
MYSQL_ROOT_PASSWORD: "199651Ch@"
TZ: "Asia/Shanghai"
ports:
- "3306:3306"
user: "0"
volumes:
# 容器與宿主機時間同步
- /etc/localtime:/etc/localtime
- ./data:/var/lib/mysql
- ./log:/var/log/mysql
- ./run:/var/run/mysqld
- ./conf/mariadb.cnf:/etc/mariadb.cnf
執行啟動
docker-compose up -d 后臺啟動
總結
以上為個人經驗，希望能給大家一個參考，也希望大家多多支持。
