Skip to content
Book a free 30-minute call with an engineer

MySQL development

Relational database for PHP and web apps

MySQL 8MariaDBAmazon AuroraProxySQLPercona ToolkitEloquentPrismaphpMyAdmin

Data

Building with MySQL

MySQL sits under a huge number of websites, especially Laravel and WordPress ones. We work with MySQL and MariaDB on new builds and, more often, on existing systems that have grown and slowed down.

Our work covers schema design, query and index fixes, replication, backups and moves to managed services like Amazon RDS, Aurora, Cloud SQL or Azure Database for MySQL. For new projects that need vector search or geospatial queries, we'd normally choose PostgreSQL.

top_products.sqlSQL
1SELECT p.sku,​
2 p.name,​
3 SUM(oi.quantity) AS units,​
4 SUM(oi.quantity * oi.price) AS revenue​
5FROM order_items oi​
6JOIN products p ON p.id = oi.product_id​
7JOIN orders o ON o.id = oi.order_id​
8WHERE o.status = 'paid'​
9 AND o.created_at >= CURDATE() - INTERVAL 30 DAY​
10GROUP BY p.sku, p.name​
11ORDER BY revenue DESC​
12LIMIT 20;​

The kind of MySQL code our team writes every week.

What we build with MySQL

  1. 01

    Database design

    Schemas with proper keys, constraints and indexes from the first migration.

  2. 02

    Query optimisation

    Finding slow queries with the slow log and EXPLAIN, then fixing them with indexes and rewrites.

  3. 03

    Cloud migration

    Moving self-hosted MySQL to RDS, Aurora or Cloud SQL with a few minutes of downtime at most.

  4. 04

    Replication & HA

    Read replicas, failover and backup plans that have actually been restored once.

  5. 05

    Version upgrades

    Upgrading to MySQL 8 or later, with compatibility tests before the switch.

  6. 06

    Data migrations

    Moving data between MySQL, PostgreSQL and other systems with row counts and checks.

Why teams pick MySQL

01

Decades of production use

Most failure modes are well known and well documented.

02

Supported everywhere

Every framework, host and cloud supports it.

03

Quick reads

Performs well for the read-heavy traffic most websites have.

04

Easy to staff

Lots of developers know it, which helps with long-term maintenance.

Good fits

  • Laravel and PHP applications
  • E-commerce stores
  • Large WordPress sites
  • SaaS platforms
  • Reporting databases

MySQL questions

Is MySQL still a good choice for new projects?

Yes. MySQL 8 is fast and supports window functions, CTEs and JSON columns. It's a solid pick for read-heavy web apps and PHP stacks. If you need vector search or PostGIS-style geospatial queries, we'd point you to PostgreSQL.

Our MySQL database is slowing down. What can you do?

We turn on the slow query log, read the execution plans, add or fix indexes, rewrite the worst queries and tune the server config. We also check the app for N+1 queries and missing caches. That usually brings a big speed-up without new hardware.

Can you migrate MySQL to the cloud without downtime?

Close to it. We set up the cloud database as a replica of your current server, keep it in sync, then promote it during a short planned cutover. Downtime is usually a few minutes, and there's a rollback plan if something looks wrong.

Do you support MariaDB?

Yes. MariaDB is mostly compatible with MySQL and we work with both. Where they differ in ways that affect your app, such as JSON handling, we'll flag it before any upgrade or migration.

Pairs well with