How to install Percona ProxySQL alongside PXC 8.4 client?

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

Hi there,

We run the latest PXC cluster 8.4 (not PRO) on three nodes, no issues there.

But on a client node, what exactly are the steps to install ProxySQL with the latest PXC client tools?

The ProxSQL documentation tells me to install Percona-XtraDB-Cluster-client-80 (on Redhat).

So I can’t install ProxySQL alongside Percona-XtraDB-Cluster-client 8.4?

Using percona-release I can setup proxysql OR pxc-84-lts, but not both at the same time…

Cheers
Till

2

Hi @bitone,
You can install the 8.4 client. You just need any MySQL client to be able to connect to the admin interface of ProxySQL. With percona-release use the enable subcommand rather than setup.

3

Hi @matthewb
Thanks for your reply.

I have to admit that the command set of percona-release always was a bit of a mystery to me…

So, what you mean is that I can enable both, proxysql and pxc-84-lts with it?
Ok I have to try that.

4

Hi @matthewb

Nice, that worked!

In this context I have another question: I wrote some mysql client (in C) using libmysql.
RHEL 9 offers me mariadb-connector-c-devel, but there seems to be some issue with this library connecting to ProxySQL when using prepared statements with RO cursors…

What Percona repository and package can I install to get libmysql and the developer files?

Cheers,
Till

5

You can get percona-server-devel package which has the libmysqlclient library, and other developer files.

I’d also advise against prepare statements unless you are executing the same SELECT query many thousands of times with just a parameter change. Using prepared statements for every SELECT is huge overhead. If you have many select-and-done queries, just send the query.

1 Like
6

Thanks for the hint!
Actually I’m using some pooling library (libzdb) and don’t call mysql_xxx directly from my code..