slider

Tag: proxysql

MySQL Users Management Using ProxySQL Tools

Recently, we have implemented a set of new commands in ProxySQL Tools to manage MySQL users. You can create, delete, and modify users from the command line. Following commands are available: proxysql-tools galera user list proxysql-tools galera user create username [—-options] proxysql-tools galera user delete username proxysql-tools galera user modify username [—-options] proxysql-tools galera user […]

Read More

Setup High Availability For ProxySQL via KeepAlived In AWS

Usually application don’t connect directly to Percona XtraDB Cluster, but go through a proxy – ProxySQL, for instance. However, if only one proxy node is used it becomes a single point of failure. Not long ago Marco Tusa wrote about how to configure two ProxySQL nodes in front of XtraDB cluster. If deployed on EC2 instances, it […]

Read More