Initializing the MySQL Database
Initialize the MySQL database by following instructions in the Running MySQL section of the MySQL Installation Guide.
To verify the read/write splitting function of MySQL Router, you need to initialize the database and set up the primary/secondary architecture. For details about MySQL primary-secondary replication, see Semisynchronous Replication and Parallel Replication in the MySQL Primary-Secondary Replication Deployment Guide.
Parameter |
Description |
master (Primary Database) |
slave1 (Secondary Database) |
slave2 (Secondary Database) |
master1 (Primary Database 1) |
master2 (Primary Database 2) |
|---|---|---|---|---|---|---|
port |
Port |
3306 |
3307 |
3308 |
3309 |
3310 |
server_id |
Server ID |
1 |
2 |
3 |
4 |
5 |
report_host |
Host information |
rp_master |
rp_slave |
rp_slave_2 |
rp_master_1 |
rp_master_2 |
datadir |
Data path |
/data/mysql/datam |
/data/mysql/datas |
/data/mysql/datas2 |
/data/mysql/datam1 |
/data/mysql/datam2 |
log-error |
Log path |
/data/mysql/log/mysqlm.log |
/data/mysql/log/mysqls.log |
/data/mysql/log/mysqls.2log |
/data/mysql/log/mysqlm1.log |
/data/mysql/log/mysqlm2.log |
pid-file |
PID file path |
/data/mysql/run/mysqldm.pid |
/data/mysql/run/mysqlds.pid |
/data/mysql/run/mysqlds2.pid |
/data/mysql/run/mysqldm1.pid |
/data/mysql/run/mysqldm1.pid |
socket |
Socket path |
/data/mysql/run/mysqlm.sock |
/data/mysql/run/mysqls.sock |
/data/mysql/run/mysqls2.sock |
/data/mysql/run/mysqlm1.sock |
/data/mysql/run/mysqlm2.sock |