# docker-mysql-proxy

**Repository Path**: opensouce_fx/docker-mysql-proxy

## Basic Information

- **Project Name**: docker-mysql-proxy
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2025-03-09
- **Last Updated**: 2025-03-09

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# mysql-proxy-docker
mysql proxysql docker compose


## 文件路径
 tree -L 3
.
├── README.md
├── docker-compose.yml
├── parameters.env
├── scripts
│   └── mysql_set_users_and_repls.sh
└── volumes
    ├── mysql_node0
    │   ├── conf
    │   ├── lib
    │   ├── mysql-files
    │   └── run
    ├── mysql_node1
    │   ├── conf
    │   ├── lib
    │   ├── mysql-files
    │   └── run
    ├── mysql_node2
    │   ├── conf
    │   ├── lib
    │   ├── mysql-files
    │   └── run
    ├── proxysql
    │   └── conf
    └── share
        └── scripts

1. 目录适应mysql8.0
	需要创建 run，mysql-files 等目录，同时在 docker-compose.yaml添加映射
	```cmd
	mkdir -p volumes/mysql_node0/run/mysqld
	mkdir -p volumes/mysql_node1/run/mysqld
	mkdir -p volumes/mysql_node2/run/mysqld
	```
2. 步骤详解：
	参考 https://blog.breezelin.cn/practice-mysql-proxysql-docker-compose.html
	

## Usage

1. download
```cmd
$ cd /tmp
$ git clone https://github.com/breeze2/mysql-proxy-docker.git
$ cd mysql-proxy-docker

```

2. run containers
```cmd
$ docker-compose up -d

```

3. set mysql replication
```cmd
$ sh ./scripts/mysql_set_users_and_repls.sh 

```

4. login proxysql admin interface
```cmd
$ mysql -u admin2 -padmin2 -h 127.0.0.1 -P16032
```

5. login proxysql database interface
```cmd
$ mysql -u root -p123123 -h 127.0.0.1 -P16033
```