Stack Overflow
Stack Overflow

Questions tagged [proxysql]

The ProxySQL Mailing List is very active and is a good place to help with complex issues and potential bugs.

References:

More:

72 questions
0
votes
1 answer

Connecting to Proxysql from PHP what credentials and port to be use

I am creating an application which connects to the proxysql. All the clusters are configured through the proxysql but what credentials and port should I use in my application to connect to the proxysql?
Rahul Tokase
  • 1,048
  • 9
  • 25
0
votes
1 answer

How to preserve the configurations of ProxySQL after restarting the EC2 instance?

I've followed the tutorial here and set up a ProxySQL v2.0.2 service on an Ubuntu AWS EC2 instance. One thing that troubles me is that the configurations of ProxySQL are gone after the EC2 instance restarts. For example, before the EC2 instance…
Brian
  • 12,145
  • 20
  • 90
  • 153
0
votes
1 answer

Docker Basic Proxysql with mysql that logs all queries

I am looking to setup proxysql and mysql locally with Docker so I can stream all outgoing logs (including any failed logs) with something like docker logs -f proxysql This is so I can debug queries etc. I have made good progress. My docker…
Robbo_UK
  • 11,351
  • 25
  • 81
  • 117
0
votes
1 answer

Procedure call not working via ProxySql, error MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'mysql.proc' doesn't exist

I have two RDS instances for mysql, 1 master node and 1 replication slave node. I have setup a ProxySql EC2 instance listening on 6033 port which routes all the write requests to master node and all the read requests to slave node. In my .NET code…
Nitin Agarwal
  • 563
  • 1
  • 6
  • 19
0
votes
1 answer

ProxySql Master node not serve the traffic untill slave gets shunned

I need to create a hostgroup with a master and n slaves. Can I configure it in a way that all the requests will be served by the slaves DB only(not by the master), until and unless the slaves get shunned?
Vyom Srivastava
  • 33
  • 5
0
votes
2 answers

Cache all SELECTs with ProxySQL

I spent a couple of hours setting up ProxySQL to cache all selects, but there is no hit on the query rule. Rule is set up this way: rule_id = 1 active = 1 match_pattern = ^SELECT(.*)$ cache_ttl = 3600000 apply = 1 destination_hostgroup = 36 All…
LordMagik
  • 43
  • 10
0
votes
1 answer

auto_increment_increment value for MySQL Group Replication on Single-Primary Mode

We are setting up this servers stack: 1x ProxySQL Server 2x MySQL Servers We are using MySQL Group Replication between the 2 MySQL servers on "Single-Primary" Mode. The default value for auto_increment_increment with this config is 7. It's safe to…
Nacho
  • 199
  • 4
0
votes
1 answer

Query cache with Proxy SQL

I'm trying to put in cache two huge queries. With SELECT count_star,sum_time,hostgroup,digest,digest_text FROM stats_mysql_query_digest ORDER BY sum_time DESC; i'm able to see the digest for these two queries. So I did: INSERT INTO…
Gandalf Corvotempesta
  • 5
  • 6
0
votes
0 answers

How to divide CRUD operations between multiple MySQL servers?

Say, I had created a product (a mobile application) which serves a lot of clients. Initially, I did not think about data compliance issues and stored all their data on one server. Now, these clients want data compliance in such a way that their data…
MontyPython
  • 2,906
  • 11
  • 37
  • 58
0
votes
2 answers

How to connect to ProxySQL with default config on Docker

I installed docker, got the most popular box with proxySQL. docker run -d -p 6032:6032 --name proxysql prima/proxysql:latest then I tried to connect to it from my local mysql like so: mysql -u admin -padmin -h 127.0.0.1 -P6032 and I'm getting this…
Yevgeniy Afanasyev
  • 37,872
  • 26
  • 173
  • 191
-1
votes
0 answers

Proxysql: How to configure a user to read from a specific host?

I have a Proxysql setup with two servers, one that can handle reads and writes (acm-db-main-1) and one that's set up as read-only (acm-db-main-2). I'd like to configure some users that are heavy read-only users to ONLY connect to acm-db-main-2. …
Geoff Maddock
  • 1,700
  • 3
  • 26
  • 47
-1
votes
1 answer

ProxySQL insert get duplicate entry on PHP 7.4.23 (Silverstripe)

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…
Andrean Novan
  • 1
  • 1
1 2 3 4
5