Percona XtraDB cluster with ProxySQL

A tool for testing XtraDB cluster with ProxySQL in front.

Requirements

• JDK 17+

• Docker

How it works

It is a simple Quarkus command-line application which creates and configures containers with Testcontainers.

Testcontainers provides an easy-to-use API to manager containers and cleans everything up automatically when the JVM process stops.

Building and running uber-jar

./mvnw
java -jar target/pxc-with-proxysql-runner.jar

Building and installing uber-jar and startup-script in PATH

By default, the app is installed in ${HOME}/bin. Otherwise, set the destDir system property.

./mvnw -DputInPath -DdestDir="${HOME}/bin"

And then from any directory:

pxc-with-proxysql

Output looks like:

15:58:41.672 INFO  [app.Application] (main) ⏳ Creating Percona server certificates...
15:58:43.879 INFO  [app.Application] (main) ⚡ Percona server certificates created in 00:00:02.175
15:58:43.881 INFO  [app.Application] (main) ⏳ Starting Percona node1...
15:59:05.349 INFO  [app.Application] (main) ⚡ Percona node1 started in 00:00:21.468
15:59:05.350 INFO  [app.Application] (main) ⏳ Starting Percona node2...
15:59:29.197 INFO  [app.Application] (main) ⚡ Percona node2 started in 00:00:23.847
15:59:29.197 INFO  [app.Application] (main) ⏳ Starting Percona node3...
15:59:52.939 INFO  [app.Application] (main) ⚡ Percona node3 started in 00:00:23.741
15:59:52.939 INFO  [app.Application] (main) ⏳ Creating backend users...
15:59:53.367 INFO  [app.Application] (main) ⚡ Backend users created in 00:00:00.427
15:59:53.367 INFO  [app.Application] (main) ⏳ Starting ProxySQL...
16:00:00.092 INFO  [app.Application] (main) ⚡ ProxySQL started in 00:00:06.724
16:00:00.092 INFO  [app.Application] (main) ⏳ Configuring ProxySQL...
16:00:00.699 INFO  [app.Application] (main) ⚡ ProxySQL configured in 00:00:00.606
16:00:00.699 INFO  [app.Application] (main) ⚡ Ready to receive connections on port 49181 in 00:01:19.027