Skip to main content
5 votes

How to easily bring 80 MySQL users into ProxySQL?

Since you're using ProxySQL with Percona, there's a nifty tool made by the good people at Percona that does exactly what you're looking for (sync's mysql users to proxysql). If you install ProxySQL ...
utdream's user avatar
  • 151
4 votes

How to avoid replication lag in case all writes on master and reads on replica?

Replication always has lag, if only a very small amount, because your data changes are not even written to the binary log until you commit a transaction. Then the replica has to download those events ...
Bill Karwin's user avatar
  • 15.1k
4 votes

How to easily bring 80 MySQL users into ProxySQL?

Here is the official doc that explains password storing (and hashing) within ProxySQL: Password management Now the task is to export all usernames and SHA1-hashed passwords from mysql into the ...
IcarusNM's user avatar
  • 581
3 votes
Accepted

How to avoid replication lag in case all writes on master and reads on replica?

Some SELECTs exist to support the Inserts/Updates/Deletes that you are about to do. You must not send them to the Replica; they must be done in the Primary, usually inside the same transaction with ...
Rick James's user avatar
  • 78.6k
3 votes
Accepted

Mysql: Is it possible to handle 1000 concurrent while having low cpu?

Here's how to identify which 'bad' query to fix that will give you the most bang for the buck: The slowlog plus pt-query-digest. More details here: http://mysql.rjweb.org/doc.php/mysql_analysis#...
Rick James's user avatar
  • 78.6k
3 votes

How to easily bring 80 MySQL users into ProxySQL?

I've improved a bit based on the answer from IcarusNM. This script expects two files with credentials in the current directory. proxyadmin.cnf backend.cnf It simply loads a list of user accounts ...
Herman van Rink's user avatar
2 votes
Accepted

Is good idea to implement ProxySQL in production with Docker?

HA implies that something will break. But if all the pieces are in the same server, it seems like the most likely thing to break is the server -- taking down everything. For HA to be really ...
Rick James's user avatar
  • 78.6k
2 votes
Accepted

ProxySQL equivalent of MaxScale schemarouter

You can find the answer here: Can proxysql have multiple listener? (Google Groups). In short: ProxySQL's query rules support routing by schemaname. For simplicity, let's assume you have 3 distinct ...
René Cannaò's user avatar
1 vote

How to set the 'source address' ProxySQL uses to connect to MariaDB?

The ProxySQL connection uses just the username usaddr. The MariaDB grant of the hostname grants access to the IP, so 'usarr'@'192.168.9.%' gives access to the connections from 192.168.9.0/24. What you ...
danblack's user avatar
  • 7,809
1 vote

MySQL replication and ProxySQL

Yes, you will need an existing replication environment since ProxySQL is a proxy service. It can work with Percona XtraDB Cluster, MariaDB Galera cluster or MySQL InnoDB Cluster as well.
jerichorivera's user avatar
1 vote

Mysql: Is it possible to handle 1000 concurrent while having low cpu?

The queries are bad Then they need fixing. You could add extra hardware but you will get linear improvements at best, fixing the queries could potentially give several orders of magnitude of ...
David Spillett's user avatar
1 vote

PROXYSQL configuration over mysql galera replication

I have upvoted the other answer, and normally I would not send a different one, but I would like to complement with extra information: Yes, you can do that and it is even a very typical setup, for ...
jynus's user avatar
  • 14.9k
1 vote

PROXYSQL configuration over mysql galera replication

Yes, I would think so. In the ProxySQL blog post here there is a reference infrastructure which has multiple ProxySQL instances connected to the same set of database nodes. It also says: We usually ...
dbdemon's user avatar
  • 6,381
1 vote

ProxySQL in PXC and failing all nodes

No, installing ProxySQL is not mandatory Do you mean all three nodes close down suddenly rather than close down gracefully? What version of Percona XtraDB Cluster are you using? If it is a version 5....
greenweeds's user avatar
1 vote
Accepted

ProxySQL user not connecting - XtraDB

Turns out i had created the admin user in the mysql users table manually in ProxySQL and that was not allowed. Removing the proxysql database file /var/lib/proxysql/proxysql.db and restarting the ...
Jdeboer's user avatar
  • 41

Only top scored, non community-wiki answers of a minimum length are eligible