Next steps¶

You have the basics. To go further with Percona Server for MySQL, consider:

Data types — Choose the right types (integers, strings, dates, booleans) for your data.
Indexes — Create and use indexes to improve query performance.
Joins and subqueries — Combine data from multiple tables.
Functions, procedures, triggers, views — Encapsulate logic and automate tasks.
Transactions and isolation levels — Ensure data integrity with concurrent operations.
Backup and restore — Protect your data from loss or corruption.
Security — Use users, roles, privileges, and encryption.
Debugging and testing — Use logs, error messages, and assertions to find and fix issues.

For full details, see the Percona Server for MySQL documentation.

Other database servers you might try¶

Percona offers quickstart guides for MongoDB and PostgreSQL if you want to try another database server.

For backups and restores¶

Percona XtraBackup performs online, non-blocking full backups for Percona Server for MySQL and MySQL®.

Percona XtraBackup Quickstart overview

For monitoring and management¶

Percona Monitoring and Management (PMM) monitors MySQL variants and provides metrics, dashboards, and actionable performance data.

Install PMM and connect your MySQL instances to it .

For high availability¶

Percona XtraDB Cluster (PXC) is an open source, highly available clustering solution for MySQL based on Galera.

Percona XtraDB Cluster Quickstart overview

Advanced command-line tools¶

Percona Toolkit is a collection of command-line tools for MySQL and MongoDB tasks that are complex or tedious to do manually.

Percona Toolkit documentation

Operators¶

Percona Operator for MySQL and Percona Operator for MySQL based on Percona XtraDB Cluster simplify deploying and managing MySQL and PXC in Kubernetes, with automated failover, self-healing, and scaling.

Percona Operator for MySQL Documentation

Percona Operator for MySQL - Quickstart overview

Percona Operator for MySQL based on Percona XtraDB Cluster - Quickstart overview