# Percona cluster for mysql and proxysql **URL:** \ **Category:** Uncategorized\ **Created:** [August 28, 2023, 10:29pm UTC](https://forums.percona.com/t/percona-cluster-for-mysql-and-proxysql/24761 "2023-08-28T22:29:09Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Mkdccie](https://avatars.discourse-cdn.com/v4/letter/m/a183cd/32.png) [@Mkdccie](https://forums.percona.com/u/Mkdccie)\ **Post date:** [August 28, 2023, 10:29pm UTC](https://forums.percona.com/t/percona-cluster-for-mysql-and-proxysql/24761/1 "2023-08-28T22:29:09Z")
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 ---
**Author:** ![vinicius.grippa](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vinicius.grippa/32/1246_2.png) [@vinicius.grippa](https://forums.percona.com/u/vinicius.grippa)\ **Post date:** [August 28, 2023, 11:12pm UTC](https://forums.percona.com/t/percona-cluster-for-mysql-and-proxysql/24761/2 "2023-08-28T23:12:13Z")
Hi Mo, The Port 6032 is the administrative port. If everything is configured correctly in ProxySQL, the correct port is 6033. ```auto 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. ---
**Author:** ![Mkdccie](https://avatars.discourse-cdn.com/v4/letter/m/a183cd/32.png) [@Mkdccie](https://forums.percona.com/u/Mkdccie)\ **Post date:** [August 29, 2023, 8:11am UTC](https://forums.percona.com/t/percona-cluster-for-mysql-and-proxysql/24761/3 "2023-08-29T08:11:38Z")
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 ---
**Author:** ![Mkdccie](https://avatars.discourse-cdn.com/v4/letter/m/a183cd/32.png) [@Mkdccie](https://forums.percona.com/u/Mkdccie)\ **Post date:** [August 29, 2023, 8:14am UTC](https://forums.percona.com/t/percona-cluster-for-mysql-and-proxysql/24761/4 "2023-08-29T08:14:35Z")
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 ---
**Author:** ![Mkdccie](https://avatars.discourse-cdn.com/v4/letter/m/a183cd/32.png) [@Mkdccie](https://forums.percona.com/u/Mkdccie)\ **Post date:** [August 29, 2023, 8:39am UTC](https://forums.percona.com/t/percona-cluster-for-mysql-and-proxysql/24761/5 "2023-08-29T08:39:21Z")
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\> ---
**Author:** ![Mkdccie](https://avatars.discourse-cdn.com/v4/letter/m/a183cd/32.png) [@Mkdccie](https://forums.percona.com/u/Mkdccie)\ **Post date:** [August 29, 2023, 8:42am UTC](https://forums.percona.com/t/percona-cluster-for-mysql-and-proxysql/24761/6 "2023-08-29T08:42:34Z")
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) ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [August 30, 2023, 4:16pm UTC](https://forums.percona.com/t/percona-cluster-for-mysql-and-proxysql/24761/7 "2023-08-30T16:16:44Z")
Show contents of runtime\_mysql\_servers and runtime\_mysql\_galera\_hostgroups please. ---
**Author:** ![Mkdccie](https://avatars.discourse-cdn.com/v4/letter/m/a183cd/32.png) [@Mkdccie](https://forums.percona.com/u/Mkdccie)\ **Post date:** [August 30, 2023, 4:24pm UTC](https://forums.percona.com/t/percona-cluster-for-mysql-and-proxysql/24761/8 "2023-08-30T16:24:08Z")
Can you send me the commands please? ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [August 30, 2023, 4:57pm UTC](https://forums.percona.com/t/percona-cluster-for-mysql-and-proxysql/24761/9 "2023-08-30T16:57:37Z")
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. ---
**Author:** ![Mkdccie](https://avatars.discourse-cdn.com/v4/letter/m/a183cd/32.png) [@Mkdccie](https://forums.percona.com/u/Mkdccie)\ **Post date:** [August 31, 2023, 11:27am UTC](https://forums.percona.com/t/percona-cluster-for-mysql-and-proxysql/24761/10 "2023-08-31T11:27:40Z")
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? ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [August 31, 2023, 12:38pm UTC](https://forums.percona.com/t/percona-cluster-for-mysql-and-proxysql/24761/11 "2023-08-31T12:38:50Z")
Hello @Mkdccie, If you need direct help and hands-on assistance, contact us [Sales & General Inquiries - Percona](https://percona.com/contact)