mysqlrouter VS ansible-role-linux-mysql

mysqlrouter will connect WP to MySQL

mysqlrouter - modified version of mysqlrouter official image with some improvements

git clone https://github.com/garutilorenzo/ansible-role-linux-mysql.git cd ansible-role-linux-mysql/ vagrant up Bringing machine 'my-ubuntu-0' up with 'virtualbox' provider... Bringing machine 'my-ubuntu-1' up with 'virtualbox' provider... Bringing machine 'my-ubuntu-2' up with 'virtualbox' provider... Bringing machine 'my-ubuntu-3' up with 'virtualbox' provider... Bringing machine 'my-ubuntu-4' up with 'virtualbox' provider... [...] [...] my-ubuntu-4: Inserting generated public key within guest... ==> my-ubuntu-4: Machine booted and ready! ==> my-ubuntu-4: Checking for guest additions in VM... my-ubuntu-4: The guest additions on this VM do not match the installed version of my-ubuntu-4: VirtualBox! In most cases this is fine, but in rare cases it can my-ubuntu-4: prevent things such as shared folders from working properly. If you see my-ubuntu-4: shared folder errors, please make sure the guest additions within the my-ubuntu-4: virtual machine match the version of VirtualBox you have installed on my-ubuntu-4: your host and reload your VM. my-ubuntu-4: my-ubuntu-4: Guest Additions Version: 6.0.0 r127566 my-ubuntu-4: VirtualBox Version: 6.1 ==> my-ubuntu-4: Setting hostname... ==> my-ubuntu-4: Configuring and enabling network interfaces... ==> my-ubuntu-4: Mounting shared folders... my-ubuntu-4: /vagrant => C:/Users/Lorenzo Garuti/workspaces/simple-ubuntu ==> my-ubuntu-4: Running provisioner: shell... my-ubuntu-4: Running: inline script ==> my-ubuntu-4: Running provisioner: shell... my-ubuntu-4: Running: inline script my-ubuntu-4: hello from node 5

This ansible role will install and configure MySQL in HA mode using MySQL InnoDB Cluster or GTID replication