I have a table that has been sharded between two machines, and the same table on each machine holds different data (not replicated).

With ProxySQL, how can I create a mysql_query_rule that allows a client to perform a SELECT on the appropriate shard?

Or if I perform the query as:

select * from table_name where id=5

Then how would ProxySQL know which shard (machine) has the record with id=5?

  • (I made two substantive changes to the wording; please verify that I did not mess up the intent.) – Rick James Mar 13 '19 at 2:50
  • The intent has not changed. Thanks – giogio Mar 13 '19 at 3:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.