-1

please help

i currently working to setup ProxySQL with 1 master and 2 slave. I have setup mysql_query_rules like this here the image but i tested on mysql client working as expected, insert goes to master and select goes to slave. but when i connect my PHP project to ProxySQL i got error when insert anything.

Error insert

My OS : Centos 7 PHP : 7.4.23 (Silverstripe 3) maybe there someone who have experience trouble like this, and have solved.

Andrean Novan
  • 1
  • 1
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. – Community Aug 31 '21 at 17:29

1 Answers1

0

Finaly solved, this error happen because bug on silverstripe when insert actually insert first to get ID and then update it to fill the field. but when try to update it check the ID first this make the problem because when insert proxysql goes to master, but when select for check ID goes to slave that not yet update by the insert from master because delay. so i use match_digest to query for check the ID and arranged to master hostgroup.

Andrean Novan
  • 1
  • 1