MySQL

What is MySQL?

MySQL is the most widely used open-source relational database in the world. MySQL stores data in structured tables with rows and columns, connected via relationships. Since its acquisition by Oracle, MySQL remains the backbone of millions of websites and applications — from WordPress to Facebook.

Why MySQL is useful

For structured data, a relational database is indispensable. MySQL offers reliability and speed:

• Proven technology: 25+ years in production at the world's largest companies
• ACID-compliant: Full transaction support for data integrity
• Broad ecosystem: Compatible with virtually every programming language and framework
• Excellent performance: Optimised for read-intensive workloads

Time savings with MySQL

MySQL is the standard behind WordPress, Drupal and countless frameworks. The broad support means less configuration and faster integration.

Hidden features that often go unused

MySQL is often deployed as a simple database, but its advanced features are impressive:

• JSON Document Store: Store JSON documents and query them with SQL — the best of both worlds.
• Window Functions: Complex analytical queries without subqueries or temporary tables.
• Common Table Expressions: Recursive queries for hierarchical data such as categories.
• Generated Columns: Automatically calculated columns that you can index.
• Invisible Indexes: Test the effect of removing an index without actually dropping it.
• Clone Plugin: Copy a complete database instance in seconds for replication.

Integrations with other tools

MySQL integrates with many other tools and services:

• WordPress & Drupal: MySQL is the standard database for the most popular CMS platforms.
• PHP & Python: Native drivers and ORM support in all major frameworks.
• Exact Online & Yuki: Much accounting software runs on MySQL-based architecture.