Percona cluster for mysql and proxysql

1

Hi All,
Im new here, looking for help about my setup.
Set up as below:
3 mysql servers with Ubuntu, each act as master and full sync between them.
2 backend servers, Ubuntu, each have proxysql installed, these are the backend servers for my application.
There is a Pmm with grafana for monitoring all servers.
The above setup is done by someone and he did not teach me how to use it or how to check the performance.

When i connect and test each mysql server separately with sysbench its working fine.
When i test the same using proxysql on the backend servers then the test will fail.

Im not sure where is the issue.
This is the manual can mmand im using to test connection:-

mysql -h 127.0.0.1 -P 6032 -u root -p

From backend servers:-
netstat -tuln | grep 6032 tcp 0 0 0.0.0.0:6032 0.0.0.0:* LISTEN

Anyone can help me please with correct way to connect the proxysql and test it with sysbench?

Regards,
Mo

2

Hi Mo,

The Port 6032 is the administrative port. If everything is configured correctly in ProxySQL, the correct port is 6033.

mysql -h 127.0.0.1 -P 6033 -u root -p

If it does not work, please share ProxySQL logs and the error from the connect attempt.

3

Indeed, its working with port 6033, Thanks.
Now im able to run the script to test, but i got so many errors, since i canot upload the file, so below you will see the sysbech script and its output:

Sysbench script as below:

cat sysbench-proxysql.sh
#!/bin/bash

Variables

SQL1_DB_HOST=“127.0.0.1” # Changed to localhost
SQL1_DB_PORT=“6033” # Port for ProxySQL
SQL1_DB_USER=“USER”
SQL1_DB_PASS=“PASSWORD”
SQL1_DB_NAME=“test”

Test the connection to the SQL1 MySQL database via ProxySQL

echo “Testing connection to SQL1 DB via ProxySQL…”
mysql -h $SQL1_DB_HOST -P $SQL1_DB_PORT -u $SQL1_DB_USER -p$SQL1_DB_PASS -e “SHOW DATABASES;” &> /dev/null

if [ $? -eq 0 ]; then
echo “Connection successful!”

# Preparing the SQL1 database for sysbench
echo "Preparing SQL1 DB for sysbench..."
sysbench oltp_read_write --db-driver=mysql --mysql-host=$SQL1_DB_HOST --mysql-port=$SQL1_DB_PORT --mysql-user=$SQL1_DB_USER --mysql-password=$SQL1_DB_PASS --mysql-db=$SQL1_DB_NAME prepare

# Running the test
echo "Running sysbench on SQL1 DB via ProxySQL..."
sysbench oltp_read_write --db-driver=mysql --mysql-host=$SQL1_DB_HOST --mysql-port=$SQL1_DB_PORT --mysql-user=$SQL1_DB_USER --mysql-password=$SQL1_DB_PASS --mysql-db=$SQL1_DB_NAME --threads=50 --time=60 run > Proxysql_results.txt

# Cleaning up after test
echo "Cleaning up SQL1 DB after sysbench test..."
sysbench oltp_read_write --db-driver=mysql --mysql-host=$SQL1_DB_HOST --mysql-port=$SQL1_DB_PORT --mysql-user=$SQL1_DB_USER --mysql-password=$SQL1_DB_PASS --mysql-db=$SQL1_DB_NAME cleanup

# Display results
echo "SQL1 DB Sysbench Test Results via ProxySQL:"
cat SQL1_results.txt

else
echo “Connection failed! Please check your database credentials, ProxySQL settings, and network settings.”
fi

Below are the errors:

./sysbench-proxysql.sh

Testing connection to SQL1 DB via ProxySQL…
Connection successful!
Preparing SQL1 DB for sysbench…
sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)

Creating table ‘sbtest1’…
Inserting 10000 records into ‘sbtest1’
Creating a secondary index on ‘sbtest1’…
Running sysbench on SQL1 DB via ProxySQL…
Cleaning up SQL1 DB after sysbench test…
sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)

Dropping table ‘sbtest1’…
SQL1 DB Sysbench Test Results via ProxySQL:
sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)

Running the test with following options:
Number of threads: 600
Initializing random number generator from current time

Initializing worker threads…

Threads started!

FATAL: mysql_stmt_execute() returned error 1317 (Query execution was interrupted) for query ‘UPDATE sbtest1 SET c=? WHERE id=?’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:469: SQL error, errno = 1317, state = '70100': Query execution was interrupted FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'BEGIN' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = ‘HY000’: Lost connection to MySQL server during query
FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query ‘BEGIN’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'BEGIN' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = ‘HY000’: Lost connection to MySQL server during query
FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query ‘BEGIN’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query FATAL: mysql_stmt_execute() returned error 1180 (Got error 149 - 'Lock deadlock; Retry transaction' during COMMIT) for query 'INSERT INTO sbtest1 (id, k, c, pad) VALUES (?, ?, ?, ?)' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:488: SQL error, errno = 1180, state = ‘HY000’: Got error 149 - ‘Lock deadlock; Retry transaction’ during COMMIT
FATAL: mysql_stmt_execute() returned error 1317 (Query execution was interrupted) for query ‘UPDATE sbtest1 SET c=? WHERE id=?’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:469: SQL error, errno = 1317, state = '70100': Query execution was interrupted FATAL: mysql_stmt_execute() returned error 1180 (Got error 149 - 'Lock deadlock; Retry transaction' during COMMIT) for query 'INSERT INTO sbtest1 (id, k, c, pad) VALUES (?, ?, ?, ?)' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:488: SQL error, errno = 1180, state = ‘HY000’: Got error 149 - ‘Lock deadlock; Retry transaction’ during COMMIT
FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query ‘BEGIN’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query FATAL: mysql_stmt_execute() returned error 1062 (Duplicate entry '5038' for key 'sbtest1.PRIMARY') for query 'INSERT INTO sbtest1 (id, k, c, pad) VALUES (?, ?, ?, ?)' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:488: SQL error, errno = 1062, state = ‘23000’: Duplicate entry ‘5038’ for key ‘sbtest1.PRIMARY’
FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query ‘BEGIN’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'BEGIN' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = ‘HY000’: Lost connection to MySQL server during query
FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query ‘BEGIN’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'BEGIN' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = ‘HY000’: Lost connection to MySQL server during query
FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query ‘BEGIN’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'BEGIN' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = ‘HY000’: Lost connection to MySQL server during query
FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query ‘BEGIN’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'BEGIN' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = ‘HY000’: Lost connection to MySQL server during query
FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query ‘BEGIN’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'BEGIN' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = ‘HY000’: Lost connection to MySQL server during query
FATAL: mysql_stmt_execute() returned error 1180 (Got error 149 - ‘Lock deadlock; Retry transaction’ during COMMIT) for query ‘INSERT INTO sbtest1 (id, k, c, pad) VALUES (?, ?, ?, ?)’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:488: SQL error, errno = 1180, state = 'HY000': Got error 149 - 'Lock deadlock; Retry transaction' during COMMIT FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'BEGIN' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = ‘HY000’: Lost connection to MySQL server during query
FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query ‘BEGIN’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query FATAL: mysql_stmt_execute() returned error 1317 (Query execution was interrupted) for query 'INSERT INTO sbtest1 (id, k, c, pad) VALUES (?, ?, ?, ?)' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:488: SQL error, errno = 1317, state = ‘70100’: Query execution was interrupted
FATAL: mysql_stmt_execute() returned error 1062 (Duplicate entry ‘5046’ for key ‘sbtest1.PRIMARY’) for query ‘INSERT INTO sbtest1 (id, k, c, pad) VALUES (?, ?, ?, ?)’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:488: SQL error, errno = 1062, state = '23000': Duplicate entry '5046' for key 'sbtest1.PRIMARY' FATAL: mysql_stmt_execute() returned error 1062 (Duplicate entry '5007' for key 'sbtest1.PRIMARY') for query 'INSERT INTO sbtest1 (id, k, c, pad) VALUES (?, ?, ?, ?)' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:488: SQL error, errno = 1062, state = ‘23000’: Duplicate entry ‘5007’ for key ‘sbtest1.PRIMARY’
FATAL: mysql_stmt_execute() returned error 1180 (Got error 149 - ‘Lock deadlock; Retry transaction’ during COMMIT) for query ‘UPDATE sbtest1 SET k=k+1 WHERE id=?’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:458: SQL error, errno = 1180, state = 'HY000': Got error 149 - 'Lock deadlock; Retry transaction' during COMMIT FATAL: mysql_stmt_execute() returned error 1180 (Got error 149 - 'Lock deadlock; Retry transaction' during COMMIT) for query 'INSERT INTO sbtest1 (id, k, c, pad) VALUES (?, ?, ?, ?)' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:488: SQL error, errno = 1180, state = ‘HY000’: Got error 149 - ‘Lock deadlock; Retry transaction’ during COMMIT
FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query ‘BEGIN’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'BEGIN' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = ‘HY000’: Lost connection to MySQL server during query
FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query ‘BEGIN’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'BEGIN' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = ‘HY000’: Lost connection to MySQL server during query
FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query ‘BEGIN’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'BEGIN' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = ‘HY000’: Lost connection to MySQL server during query
FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query ‘BEGIN’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'BEGIN' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = ‘HY000’: Lost connection to MySQL server during query
FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query ‘BEGIN’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'BEGIN' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = ‘HY000’: Lost connection to MySQL server during query
FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query ‘BEGIN’
FATAL: thread_run' function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'BEGIN' FATAL: thread_run’ function failed: /usr/share/sysbench/oltp_common.lua:405: SQL error, errno = 2013, state = ‘HY000’: Lost connection to MySQL server during query

Regards,
Mo

4

Below if i run the same script to one of the mysql servers directly:
./sysbench-sql1-db.sh
Testing connection to SQL1 DB…
Connection successful!
Preparing SQL1 DB for sysbench…
sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)

Creating table ‘sbtest1’…
Inserting 10000 records into ‘sbtest1’
Creating a secondary index on ‘sbtest1’…
Running sysbench on SQL1 DB…
Cleaning up SQL1 DB after sysbench test…
sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)

Dropping table ‘sbtest1’…
SQL1 DB Sysbench Test Results:
sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)

Running the test with following options:
Number of threads: 600
Initializing random number generator from current time

Initializing worker threads…

Threads started!

SQL statistics:
queries performed:
read: 226394
write: 54367
other: 36791
total: 317552
transactions: 14425 (233.44 per sec.)
queries: 317552 (5138.95 per sec.)
ignored errors: 1746 (28.26 per sec.)
reconnects: 0 (0.00 per sec.)

General statistics:
total time: 61.7916s
total number of events: 14425

Latency (ms):
min: 19.44
avg: 2530.10
max: 13211.78
95th percentile: 5217.92
sum: 36496724.73

Threads fairness:
events (avg/stddev): 24.0417/2.28
execution time (avg/stddev): 60.8279/0.51

5

Below is the output from proxysql admin (From backend server)

mysql -u admin -p -h 127.0.0.1 -P 6032 --prompt='Admin> ’
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 153931
Server version: 5.5.30 (ProxySQL Admin Module)

Copyright (c) 2009-2023 Percona LLC and/or its affiliates
Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

Admin> SELECT * FROM stats_mysql_connection_pool;
±----------±---------------±---------±--------±---------±---------±-------±--------±------------±--------±------------------±----------------±----------------±-----------+
| hostgroup | srv_host | srv_port | status | ConnUsed | ConnFree | ConnOK | ConnERR | MaxConnUsed | Queries | Queries_GTID_sync | Bytes_data_sent | Bytes_data_recv | Latency_us |
±----------±---------------±---------±--------±---------±---------±-------±--------±------------±--------±------------------±----------------±----------------±-----------+
| 100 | 161.97.110.106 | 3306 | ONLINE | 0 | 100 | 177 | 0 | 177 | 7740 | 0 | 2236075 | 3865830 | 633 |
| 100 | 161.97.110.110 | 3306 | ONLINE | 0 | 100 | 171 | 0 | 171 | 12392 | 0 | 2403938 | 8301922 | 947 |
| 100 | 161.97.112.232 | 3306 | ONLINE | 0 | 100 | 252 | 0 | 252 | 20652 | 0 | 775939 | 15540332 | 759 |
| 101 | 161.97.110.106 | 3306 | SHUNNED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 633 |
| 101 | 161.97.110.110 | 3306 | SHUNNED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 947 |
| 101 | 161.97.112.232 | 3306 | SHUNNED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 759 |
| 8100 | 161.97.110.106 | 3306 | SHUNNED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 633 |
| 8100 | 161.97.110.110 | 3306 | SHUNNED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 947 |
| 8100 | 161.97.112.232 | 3306 | SHUNNED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 759 |
| 8101 | 161.97.110.106 | 3306 | SHUNNED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 633 |
| 8101 | 161.97.110.110 | 3306 | SHUNNED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 947 |
| 8101 | 161.97.112.232 | 3306 | SHUNNED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 759 |
±----------±---------------±---------±--------±---------±---------±-------±--------±------------±--------±------------------±----------------±----------------±-----------+
12 rows in set (0.01 sec)

Admin>

6

below are the admin error logs

Admin> SELECT * FROM stats_mysql_errors;
±----------±---------------±-----±---------±---------------±-----------±------±-----------±-----------±-----------±---------------------------------------------------------------------+
| hostgroup | hostname | port | username | client_address | schemaname | errno | count_star | first_seen | last_seen | last_error |
±----------±---------------±-----±---------±---------------±-----------±------±-----------±-----------±-----------±---------------------------------------------------------------------+
| 100 | 161.97.110.110 | 3306 | root | 127.0.0.1 | test | 1180 | 2 | 1693296151 | 1693296284 | Got error 149 - ‘Lock deadlock; Retry transaction’ during COMMIT |
| 100 | 161.97.110.110 | 3306 | root | 127.0.0.1 | test | 1062 | 1 | 1693296150 | 1693296150 | Duplicate entry ‘5038’ for key ‘sbtest1.PRIMARY’ |
| 100 | 161.97.110.110 | 3306 | root | 127.0.0.1 | test | 1317 | 1 | 1693296149 | 1693296149 | Query execution was interrupted |
| 100 | 161.97.112.232 | 3306 | root | 127.0.0.1 | test | 1180 | 4 | 1693296149 | 1693296150 | Got error 149 - ‘Lock deadlock; Retry transaction’ during COMMIT |
| 100 | 161.97.112.232 | 3306 | root | 127.0.0.1 | test | 1062 | 2 | 1693296150 | 1693296150 | Duplicate entry ‘5007’ for key ‘sbtest1.PRIMARY’ |
| 100 | 161.97.110.106 | 3306 | root | 127.0.0.1 | test | 1317 | 1 | 1693296149 | 1693296149 | Query execution was interrupted |
| 100 | 161.97.110.110 | 3306 | root | 127.0.0.1 | test | 1213 | 369 | 1693296149 | 1693296284 | Deadlock found when trying to get lock; try restarting transaction |
| 100 | 161.97.110.106 | 3306 | root | 127.0.0.1 | test | 1213 | 71 | 1693296149 | 1693296284 | Deadlock found when trying to get lock; try restarting transaction |
| 100 | 161.97.112.232 | 3306 | root | 127.0.0.1 | test | 1213 | 686 | 1693296149 | 1693296284 | Deadlock found when trying to get lock; try restarting transaction |
| 100 | 161.97.110.110 | 3306 | root | 127.0.0.1 | test | 1295 | 182 | 1693296147 | 1693296284 | This command is not supported in the prepared statement protocol yet |
| 100 | 161.97.112.232 | 3306 | root | 127.0.0.1 | test | 1295 | 229 | 1693296146 | 1693296284 | This command is not supported in the prepared statement protocol yet |
| 100 | 161.97.112.232 | 3306 | root | 127.0.0.1 | test | 1317 | 2 | 1693296150 | 1693296284 | Query execution was interrupted |
| 100 | 161.97.110.106 | 3306 | root | 127.0.0.1 | test | 1295 | 239 | 1693296146 | 1693296284 | This command is not supported in the prepared statement protocol yet |
±----------±---------------±-----±---------±---------------±-----------±------±-----------±-----------±-----------±---------------------------------------------------------------------+
13 rows in set (0.01 sec)

7

Show contents of runtime_mysql_servers and runtime_mysql_galera_hostgroups please.

8

Can you send me the commands please?

9

runtime_mysql_servers and runtime_mysql_galera_hostgroups are tables in proxysql admin. Looking at your posts above, you are familar with accessing the admin side. Just SELECT from those tables.

10

Hi,
For some reason the cluster stop working, and i had to reinstall the servers again.
So now im looking for someone to do full new installation for Percona cluster.
Anyone here can help?

11

Hello @Mkdccie,
If you need direct help and hands-on assistance, contact us Sales & General Inquiries - Percona