I’m just trying out the v8.4 Read-Write configuration for MySQL Router, that comes default in the community edition and, as they say, TL;DR “it’s default upon bootstrap”.
What does this mean and how can I go about it?
The overview is simple:
- Either install or upgrade your existing MySQL Router to v8.4 at least.
- Bootstrap the Router.
- Use the port 3310 or change it to fit your needs.
Let’s get to it:
Stop your running router:
systemctl stop mysqlrouterCopy the old config, just in case:
cp /etc/mysqlrouter/mysqlrouter.conf /etc/mysqlrouter/mysqlrouter_v80.conf
I normally keep my mysql linux repository disabled so no “yum update” takes over version control and gives me a nasty surprise afterwards. As so, I uncomment the “mysql” entry:
vi /etc/yum.conf …