With mysql client

# Connect as root user
mysql -h <VM_IP> -P 30306 -u root -p

# Connect as application user
mysql -h <VM_IP> -P 30306 -u <USERNAME> -p <DATABASE>

‍

Connection string for applications

mysql://<USER>:<PASSWORD>@<VM_IP>:30306/<DATABASE>

‍

Examples by language

# Python (pymysql)
import pymysql
conn = pymysql.connect( 
host="<VM_IP>", port=30306, 
user="<USER>", password="<PASSWORD>", db="<DATABASE>"
)

// Node.js (mysql2)
const connection = mysql.createConnection({ 
host: "<VM_IP>", port: 30306, 
user: "<USER>", password: "<PASSWORD>", database: "<DATABASE>"
});

# View the Percona pod
`kubectl get pods -A | grep percona`

# View the installation log
`tail -f /var/log/cuemby/bootstrap.log`

# Verify that the port is listening
`ss -tlnp | grep 30306`

‍

Expected output

NAME                       READY   STATUS    RESTARTS
percona-xxxxxxxxx-xxxxx    1/1     Running   0        ← Running ✓

‍

ℹ️ For everyday use, use the application user (PERCONA_USER), not root. The application user already has full permissions on PERCONA_DATABASE.

-- List databases
SHOW DATABASES;

- Use the application database
USE app;

- Create a table
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
email VARCHAR(150) UNIQUE NOT NULL,
created_in TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

- Insert a record
INSERT INTO users (name, email) VALUES ('Martin', 'martin@cuemby.com');

- Query
SELECT * FROM users;

‍

Check Percona improvements

-- View Percona XtraDB Engine Status
SHOW ENGINE INNODB STATUS\G

-- Query specific Percona variables
SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
SHOW VARIABLES LIKE 'query_response_time%';

‍

💡 Tip: Percona includes the Percona Toolkit (pt-query-digest, pt-online-schema-change, etc.) for slow query analysis and zero-downtime schema migrations. These tools are available within the pod.