I assume you have read Setting up MySQL Router before reading this.
So we start our First example with the config file used in Setting up MySQL Router sample-router.ini
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
[logger] level = INFO [routing:read_only] bind_address = localhost bind_port = 7001 destinations = localhost:13002,localhost:13003,localhost:13004 mode = read-only [routing:read_write] bind_address = localhost bind_port = 7002 destinations = localhost:13005,localhost:13006 mode = read-write |
About different mode options :
[routing:read_only] :
If you connect a client to read-only routing service i.e.…