thijsferyn / proxysql-orchestrator-sync Goto Github PK

Hey Feryn,

this is script is amazing and it's working like a charm. It's not really an issue but for testing purpose, I used the simple read-write split between HG from the Proxysql.

https://github.com/sysown/proxysql/wiki/ProxySQL-Read-Write-Split-(HOWTO)#basic-readwrite-split-using-regex

I am facing a problem when you have only 1 master and 1 slave. The Script will remove the
slave form the HG 1. Now when reads/writes a split between HG0 and HG1 you will face read block, since there is no one left in the HG01.

Since the script not automatically adds the Master to HG1. I made a small script adjustment here:

$proxySqlServer->query("INSERT INTO mysql_servers (hostgroup_id,hostname,port) VALUES ('0','".$master."','3306'), ('1','".$master."','3306')");

Now every time the script does the insert, the master will be automatically also added to the HG1. Which becomes a reader as well.
Which makes reads available again. Otherwise, it's blocked because it's only looking into HG1. Now we should have the possibility to weight the master when a slave comes back online so reads get primarily distributed to the slave first, but that's another story.

Again it's not a issue but needs to be considered when there is no slave left in HG1.

Best,
Eddi