Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
MySQL Basics: Join the Party—Bringing Tables Together with JOINs
Discover how to combine information from multiple tables using JOINs in MySQL! This beginner-friendly guide explains INNER JOINs (and friends) with fun library metaphors, approachable SQL examples, and practical tips to help you unlock the true power of your relational database.
Say Hello to OIDC in PostgreSQL 18!
If you’ve ever wondered how to set up OpenID Connect (OIDC) authentication in PostgreSQL, the wait is almost over. We’ve spent some time exploring what it would take to make OIDC easier and more reliable to use with PostgreSQL. And now, we’re happy to share the first results of that work.
Why OIDC, and why now?We’ve spoken to some of our customers and noticed a trend of moving away from LDAP to OIDC. Our MongoDB product is already providing OIDC integration and the team working on PostgreSQL products saw an opportunity coming with PostgreSQL 18. As some of you may have noticed…
Simplify Real-Time Analytics with MySQL HeatWave Auto-Refresh Materialized Views
MySQL HeatWave is a fully managed cloud database service that integrates with MySQL, combining transactions, analytics, machine learning, and generative AI capabilities. It features an in-memory query accelerator for real-time analytics, eliminating the need for ETL processes to separate databases. Available on Oracle Cloud Infrastructure (OCI), AWS, and Azure, HeatWave automates tasks like backups and […]
Accelerate Similarity Search with Automatic HeatWave Vector Index
MySQL HeatWave is the only fully managed MySQL database service that combines transactions, analytics, machine learning, and GenAI services, without ETL. It also includes the capabilities to query data in object store and provides the best price performance in the industry. MySQL HeatWave is available on Oracle OCI, Amazon AWS, and Microsoft Azure. When building […]
Enhance Your Data Processing with HeatWave Temporary Tables
MySQL HeatWave is the only fully managed MySQL database service that combines transactions, analytics, machine learning, and GenAI services, without ETL. It also includes the capabilities to query data in object store and provides the best price performance in the industry. MySQL HeatWave is available on Oracle OCI, Amazon AWS, and Microsoft Azure. Temporary tables […]