Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
Using Oracle Analytics Cloud with MySQL Database Service and HeatWave
Get better business insight faster by combining the data visualization and AI capabilities of Oracle Analytics Cloud with the fastest MySQL cloud service. This on-demand webinar offers a quick introduction to the MySQL Database Service and to the Oracle Analytics Cloud Service. Watch the webinar (including demo): Speakers: Mandy Pang, Oracle Labs, Principal Product Manager […]
How to use the Oracle MySQL Database Service with applications that run in AWS
From RDS to MDS When an application reaches the maximum capabilities offered by Amazon Web Services (AWS) RDS, it is often recommended to migrate to the AWS Aurora service. However, Aurora is based on an older version of MySQL. Aurora still does not support MySQL 8.0, which was released in April 2018. Therefore, it […]
MySQL HeatWave: 1100x Faster than Aurora, 400x than RDS, 18x than Redshift at 1/3 the cost
HeatWave is designed to enable customers to run analytics on data which is stored in MySQL databases without the need for ETL. This service is built on an innovative, in-memory analytics engine which is architected for scalability and performance and is optimized for Oracle Cloud Infrastructure (OCI) Gen 2 hardware. This results in a very […]
MySQL Database Service with High Availability
MySQL Database Service is now easier to use and has flexible deployment options, including High Availability. While creating a new DB System using the web console, users can choose between Standalone, Highly Availability, and HeatWave deployments. The service will pre-populate the necessary fields with the recommended settings. You only need to provide the MySQL user […]
What’s New in MySQL 8.0.24
MySQL 8.0.24 introduces several new improvements and updates, many of which deserve their own blog post for a deep dive into the new features. The new version includes new features and bug fixes for Optimizer, GIS, InnoDB, Performance schema, Replication, Group Replication, Router, MTR Testsuite, and more. Read the overview and dedicated blogs to learn […]
Migrate from Amazon Aurora to MySQL Database Service and Start Saving
You’ve been using Amazon Aurora to manage your data but recently found out that you could manage the same data on Oracle cloud for a ⅓ of the cost on Amazon. You also learned that you could run your MySQL queries on Oracle Cloud 1100x faster than on Amazon Aurora, including Analytics queries. Now […]
The BBC ensures world-class broadcasting services with MySQL Enterprise Edition
The BBC delivers resilience of broadcasting services across TV, radio, and digital platforms using MySQL InnoDB Cluster. Kim Cassells, Senior Database Systems Engineer, BBC said, “MySQL InnoDB Cluster provides us with the high availability, fault tolerance, and scalability that are critical for delivering modern broadcasting services. We also get advice directly from the MySQL engineers […]
MDS, PHP and authentication
Recently I blogged about how to easily deploy a LAMP application to MDS. Using the Terraform module (OCI Resource Manager’s Stack) you also have the possibility to choose the PHP version to install: But as you should already know, not all versions support the latest default authentication method in MySQL 8.0: caching_sha2_password [1], [2], [3]. Most […]
Migrate Ownership of your stored routines, views and triggers for MySQL in 2021
Yesterday my friend and ex-colleague Sveta published a blog post on how to migrate ownership of stored routines, views and triggers in MySQL. I usually agree a lot with her and even if I agree with what she wrote, there is one single point I would like to comment: use MySQL Shell ! In the […]
MySQL: Character Sets, Unicode, and UCA compliant collations
With MySQL 8.0, the version of MySQL Database Service aka MDS, the default character set has changed from latin1 to ut8mb4. The default collation is utf8mb4_0900_ai_ci but what does that mean ? and why are the utf8mb4_0900_* the recommended ones ? Collations like utf8mb4_unicode_520_ci and utf8mb4_0900_ai_ci are based on Unicode Collation Algorithm (UCA). The number […]