How to setup multiple master-slave? #2202
Description
As Laravel is supporting define configuration about read-write servers for MySQL.
I want to ask how can we do it with our package. I read the docs but you just say config many hosts but not primary.
Let's say I have 1 master and 2 slaves:
- The master is being used for write data only, if this master dies, one slave will become master for write data.
- Another slave will allow read data only.
Can we do it on configuration? If not then anyone has the solutions for this problem?