Multiple masters ?

[jbw]

Hi

I've been reading up on proxysql over the last few hours and can't find a simple yes or no answer to this. I understand host groups and their function in specifying what host is the master and which are read slaves however for my application I have 3 mysql instances in a multi-master setup. I simply want to use proxysql so my application can connect locally to it and proxysql will route the queries to a working master. So my question is, is it possible to specify multiple master server entries ? If so, will proxysql also obect weights here? i.e. I'd ideally like to have one "primary master" which is the highest weighted.. if that goes down then another less weighted master can take the queries instead.

Is the above possible using proxysql? 

Thanks in advance

Regards

Jerald

[Michael Romero]

I have the same need. Bumping.