What is MySQL?
MySQL is a widely used open-source relational database. It stores data in tables with rows and columns and is queried with SQL, making it a reliable backend for content management systems, e-commerce platforms, and custom web applications.
It is used by many common applications including WordPress, Magento, Shopware, and Drupal.
On TurboStack
TurboStack runs Percona Server for MySQL, a drop-in, performance-focused build of MySQL, as a host-level service. You enable it on a host and pick the major version (for example 8.4).
When you create an application, TurboStack automatically provisions a dedicated database and database user for it, so each site has its own isolated credentials. The InnoDB buffer pool is the memory MySQL uses to cache data and indexes. It is auto-tuned to the server's resources, so you rarely need to adjust it manually.
Warning
Major-version upgrades are supported, but downgrades are not. Plan and test a version change before applying it in production, and take a backup first.
Best practices
- Stay on a current, supported major version and plan upgrades deliberately - you cannot downgrade.
- Leave the InnoDB buffer pool auto-tuned unless you have measured evidence that a different size helps.
- Use the per-application database and user that TurboStack creates rather than sharing one database across sites.
- Keep the database bound to localhost; only expose it to other hosts when you genuinely need remote access, and restrict access when you do.
- Take regular backups and verify you can restore them, especially before version changes.
- Add indexes for your common query patterns and review slow queries periodically.