Skip to content
Agencei

Expertise

MySQL and MariaDB expertise: fast, reliable databases for your sites and applications

MySQL is the most widely used relational database on the web, and MariaDB is its compatible fork. With the InnoDB engine, they offer transactions, foreign keys, replication and a very broad hosting ecosystem. MySQL 8 brought window functions, CTEs, invisible indexes and a transactional data dictionary.

Agencei works on MySQL and MariaDB mainly behind WordPress, WooCommerce, PrestaShop and existing PHP or Java applications: slowness diagnosis, indexing, InnoDB tuning, replication, backups and migrations to a recent version or a managed service.

This expertise is for companies whose site or shop slows down as the catalogue and orders grow, or who need to make a database reliable when it has been hosted without real monitoring.

Talk about your projectRequest a quote

Use cases

Optimising a WordPress or WooCommerce database

Cleaning up options and metadata tables, indexing plugin queries and tuning the application-side query cache.

PrestaShop shop performance

Analysing catalogue, faceted filter and cart queries, missing indexes and purging connection and statistics tables.

Version upgrade

Moving from MySQL 5.7 to 8, or from MariaDB to a supported version, checking query compatibility and SQL modes.

Replication and backups

Read replica for reporting, scheduled logical and physical backups, restore drills and point-in-time recovery.

Migration to a managed service

Transfer to RDS or Aurora MySQL with replication to limit downtime, then a controlled application cutover.

Project types

  • MySQL performance audit
  • WordPress or PrestaShop database optimisation
  • MySQL 5.7 to 8 upgrade
  • Migration to RDS or Aurora MySQL
  • Replication and high availability
  • MySQL to PostgreSQL migration
  • Backup strategy

Integration with the rest of the stack

  • MySQL + WordPress and WooCommerce

    The CMS database, with a Redis object cache to reduce repeated reads and InnoDB tuning suited to table sizes.

  • MySQL + PrestaShop 8

    The shop database, with an optional read replica for exports and an index plan tailored to catalogue queries.

  • MySQL + AWS (RDS, Aurora)

    Managed instance with automatic backups, replicas, encryption and slow query monitoring through Performance Insights.

  • MySQL + Docker

    Versioned MySQL or MariaDB container for local development, with an anonymised dataset and the same configuration as production.

Examples of problems solved

Huge wp_options or wp_postmeta table

Removing expired transients and data from uninstalled plugins, adding indexes on metadata keys and scheduling regular cleanup.

Slow queries showing in the slow query log

Analysis with EXPLAIN, creation of composite indexes, rewriting queries with no usable index and cutting unnecessary joins.

"Too many connections" error

Tuning max_connections, application-side pooling, fixing unclosed connections and capping PHP-FPM workers.

InnoDB locks and wait timeouts

Identifying long transactions, reducing update batch sizes and tuning innodb_lock_wait_timeout.

Unable to restore after an incident

Setting up verified backups, keeping binary logs for point-in-time recovery and running regular restore drills.

Frequently asked questions

MySQL or MariaDB?

They remain close but are gradually diverging. MariaDB is often installed by default on Linux distributions and by hosts; MySQL 8 brings features MariaDB does not fully have. We choose based on your hosting and application.

Why does my MySQL database slow down over time?

Usually because tables grow without suitable indexes, data is never purged (logs, sessions, statistics) and the InnoDB configuration is left at defaults. An audit targets the fixes.

Should we migrate from MySQL to PostgreSQL?

Not necessarily. For WordPress or PrestaShop, MySQL is the native choice. Migrating to PostgreSQL makes sense for a custom application that needs advanced types, extensions or better behaviour under heavy concurrency.

How large a database can MySQL handle?

Databases of several hundred gigabytes are common. The limit comes from table design, indexes and the memory allocated to InnoDB rather than from the engine itself.

How do you secure a MySQL database?

Dedicated users with limited rights, restricted network access, encrypted connections, strong passwords, security updates and encrypted backups stored off the server.

Related services

Database services

Design, optimization, administration and backups for your PostgreSQL, MySQL, MongoDB and Redis databases.

See this service

Data migration

Migration between databases, engines, versions or systems, with ETL, validation and zero-downtime cutover.

See this service

WordPress Agency

Custom themes and plugins, headless WordPress, performance and security for a site built to last.

See this service

PrestaShop Agency

Custom PrestaShop modules and themes, takeover of 1.6, 1.7 and 8 stores, performance and integrations.

See this service

Performance Optimization

Profiling-based diagnosis and targeted fixes: Core Web Vitals, SQL queries, caching, CDN.

See this service

WordPress Troubleshooting

White screen, 500 error, hack, broken after an update: fast diagnosis and recovery.

See this service

Related expertise

PostgreSQL DatabaseWordPress SitesPrestaShop Shops

Tell us about your project

Describe your need in a few lines: we come back to you with a first analysis and the next steps.

Talk about your projectRequest a quote