Skip to main content

Menu

Webinar

Built for the Agentic Era: Introducing MariaDB Enterprise Platform 2027

Register now

Product

MariaDB Community Server 12.3 LTS: How It Scales AI Workloads and Delivers 4x Write Performance

By Ralf Gebhardt

8 min read
Share

Key takeaways

  • Long-term stability until 2029: MariaDB 12.3 arrives as a production-ready, Long Term Support (LTS) release that guarantees three years of continuous security updates and maintenance for ultimate peace of mind.
  • A massive 4x performance boost: A complete overhaul of how data is written gives you four times the processing speed on heavy workloads, helping you squeeze more power out of your existing hardware and delay costly infrastructure upgrades.
  • Built-in support for AI applications: By optimizing vector searches directly alongside your regular data, this release makes it faster and simpler to scale modern AI tools like smart chatbots and recommendation engines without needing a separate database.
  • Frictionless migration from Oracle and MySQL: Enhanced compatibility features remove the typical technical roadblocks, making it much cheaper and less risky to move your legacy systems over to a flexible, open-source platform.

MariaDB Community Server 12.3 is the latest Long Term Maintenance (LTS) release of MariaDB's open-source relational database. It consolidates all innovations from the 12.x rolling release series (12.0–12.2) into a single, production-ready version that will be maintained with bug fixes and security updates through June 2029. The release is significant because it combines AI workload readiness, a major write-performance improvement, and broader SQL compatibility — making it suitable for both new projects and legacy migration efforts.

MariaDB 12.3 delivers a 4x performance boost for write-heavy workloads through a fundamental re-engineering of the binary log. The core improvement is architectural: binlog components have been migrated directly into the InnoDB engine, removing redundant synchronization points that previously created bottlenecks. This benefits any workload with high write throughput — such as e-commerce transaction processing or real-time IoT data ingestion — and can be enabled in production with a simple configuration change.

Yes. MariaDB 12.3 introduces optimized distance calculations specifically designed for high-dimensional vectors and matryoshka embeddings — the kind produced by modern AI models such as those from OpenAI and Gemini. New extrapolation techniques make vector search significantly faster, meaning MariaDB can serve as both the relational database and the vector store within a single deployment. This is particularly relevant for RAG (Retrieval-Augmented Generation) applications that need to retrieve semantically similar content at low latency.

MariaDB 12.3 includes expanded compatibility for both Oracle and MySQL. On the Oracle side, it adds support for (+) join syntax, TO_DATE, associative arrays, and SYS_REFCURSOR. For MySQL, it adds native support for caching_sha2_password, which is the default authentication plugin in modern MySQL deployments. Together, these features reduce the technical friction of migrating applications from either Oracle or MySQL to MariaDB's open-source platform.

MariaDB Community Server 12.3 LTS will receive continuous bug fixes, security updates, and stability improvements until June 2029 — a three-year maintenance window.

A rolling release (such as 12.0, 12.1, or 12.2) delivers new features on a quarterly basis, does not receive patches and is suited for teams that want the latest capabilities as they ship. An LTS (Long Term Maintenance) release, like 12.3, is a consolidated snapshot of a full release cycle that prioritizes stability — receiving only bug fixes, security patches, and critical stability improvements for its maintenance lifetime.

MariaDB 12.3 introduces new optimizer hints, including JOIN_FIXED_ORDER and MAX_EXECUTION_TIME, which allow database administrators to manually direct the query optimizer for predictable performance outcomes. These additions give DBAs fine-grained control in situations where the optimizer's automatic choices are suboptimal — useful in complex analytical queries or latency-sensitive production workloads.

MariaDB Enterprise Server 12.3 Beta is coming soon, the GA release will be available as part of the next MariaDB Enterprise Platform release later this year. It will bring the performance and compatibility improvements of the Community 12.3 LTS release to the commercial Enterprise Platform, along with additional stability and reliability enhancements suited for mission-critical deployments. Enterprise customers benefit from advanced clustering, hardened security features, and 24/7 commercial support — capabilities not included in the Community edition. The enterprise version includes five years of standard support, with the option to extend coverage for an additional three years. 

Yes. MariaDB Server 12.3 LTS is explicitly designed for production use. The LTS designation means the codebase is stable and won't change in breaking ways during its support window. It includes a production-ready binary log re-engineering for write performance, expanded observability tools via Performance Schema and Galera audit logging, and seamless upgrade paths from both 11.4 LTS and 12.2 Rolling — making it appropriate for teams starting a new project or consolidating from a previous version.