# docker-compose-servers

**Repository Path**: sharewodrow/docker-compose-servers

## Basic Information

- **Project Name**: docker-compose-servers
- **Description**: docker自启动服务集搭建
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-02-01
- **Last Updated**: 2024-02-03

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 用docker-compose快速搭建一些环境

## mysql8-slaver

### 主库

```
skip-name-resolve
innodb_log_file_size = 32M
log-bin=mysql-bin
server-id=1
binlog-do-db=?db
binlog-ignore-db=?db
binlog-ignore-db=information_schema
binlog-ignore-db=performance_schema
binlog-ignore-db=mysql
binlog-ignore-db=sys

flush tables with read lock;
show master status;

mysqldump -uuser -ppass --routines --single_transaction --master-data=2 --add-drop-database --databases db1 db2 > name.sql
mysqldump --host='domain' --user='user' --password='password' --routines --single_transaction --master-data=2 --add-drop-database --databases db1 db2 > name.sql
mysqldump -uuser -ppass database_name >database_name.sql
```

### 从库

```
unlock tables;

relay_log=mysqld-relay-bin #记录中继日志
log-slave-updates=YES #从服务器同步后记录日志
slave-skip-errors=all
replicate_do_db=?db
replicate-do-table=?db.?tb
replicate-ignore-db=?db
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema
replicate-ignore-db=mysql
replicate-ignore-db=sys
replicate-ignore-table=?db.?tb
replicate_wild_do_table=?db.%

source database_name.sql;

show slave status;
STOP SLAVE;
CHANGE MASTER TO MASTER_HOST='',MASTER_PORT=3306,MASTER_USER='',MASTER_PASSWORD='',MASTER_LOG_FILE='mysql-bin.0000',MASTER_LOG_POS=;
START SLAVE;
show slave status;
```

## baota
```
默认用户：btpanel
默认密码：btpaneldocker
容器默认SSH密码：btpaneldocker
```