Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
Machine learning with recommender system models in MySQL Heatwave AutoML
Recommender Systems are commonly used in e-commerce to recommend new products to users based on their prior history and preferences. The concept behind recommendation systems is finding patterns in consumer behavior to predict users’ preferences, even before they have interacted with the product, making recommender system an effective tool to navigate efficiently through a large […]
How to deploy WordPress and MySQL on OKE using MySQL Operator for Kubernetes
Let’s see how to deploy WordPress and MySQL on a Kubernetes Cluster. The Kubernets cluster we are using is OKE (Oracle Kubernetes Engine) in OCI (Oracle Cloud Infrastructure): OKE Cluster We start by creating a Kubernetes Cluster on OCI using the Console: We select the Quick create mode: We need to name our cluster and […]
Introducing Data Import from Amazon S3 in MySQL HeatWave on AWS
Overview MySQL HeatWave on AWS is a fully managed database service, powered by the integrated HeatWave in-memory query accelerator. It’s the only cloud database service that combines transactions, analytics, and machine learning services across data stored in MySQL and data lake, delivering real-time, secure analytics without the complexity, latency, and cost of extract, transform, and […]
MySQL Connector/J 2FA and FIDO (WebAuthn)
Support for MySQL FIDO authentication in Java was introduced in MySQL Connector/J 8.0.28 with the implementation of the client-side authentication plugin authentication_fido_client. This implementation is FIDO compliant but we quickly realized we were also interested in supporting some newer FIDO2 features as well. Unfortunately, the original implementation couldn’t be extended and we needed to come […]
Introducing the ISV Catalog for MySQL HeatWave
We are excited to launch the Independent Software Vendor (ISV) Catalog for MySQL HeatWave. This catalog will enable both customers and partners to easily find 3rd party ISV products and services for MySQL HeatWave. MySQL HeatWave is a fully managed database service for transactions, real- time analytics across data warehouses and data lakes, […]
Running MySQL Tests With GitHub Actions
Recently, I have been talking about how to write and run tests for Node.js code that interacts with a MySQL database. These posts have included details on how to use third-party libraries such as Testcontainers to run the tests in a clean database and Knex to manage database changes. Today, I will discuss how to automate running these tests using GitHub Actions when […]
Where can you find MySQL team in October 2023
As previously announced on Aug 15, 2023, you can find the MySQL team at following conferences in October 2023: Please mark your calendars and we look forward to speaking with you!
Building ML models using data in object storage with HeatWave AutoML
MySQL HeatWave Lakehouse enables users to query up to half a petabyte of data in object storage in a variety of file formats, such as CSV, Parquet, Avro, and export files from other databases (e.g., Amazon Aurora, Redshift, MySQL, etc…). Customers can query data in various formats in object storage, transactional data in MySQL databases, […]
MySQL HeatWave Lakehouse on AWS
MySQL HeatWave Lakehouse is now available on AWS. MySQL HeatWave is the only cloud database offering that provides an online transactional processing (OLTP) database, a real-time in-memory data warehouse, and in-database automated machine learning capabilities in a single MySQL database service—without the complexity, latency, risks, and cost of ETL duplication. With the addition of the […]
How to copy a MySQL instance ?
To copy a MySQL server to another server or to the cloud, there are several ways. We can distinguish between two different types of copy: The physical copy is often the fastest. However, it requires some tools to ensure that you have a consistent online backup. For example, you can use MySQL Enterprise Backup (MEB). […]