MySQL Community Advent Calendar 2022: How to deploy WordPress on OCI with MySQL Database Service and spread the read load to multiple Read Replicas

Oracle recently released Read Replica for MySQL Database Service (also known as MySQL HeatWave, with or without the use of HeatWave accelerator for OLTP and OLAP).

Read Replicas are read-only copies of the MySQL DB system in the same region. When you add Read Replicas, they are automatically distributed accross Availability Domains and/or Fault Domains.

Each MySQL DB instance can have up to 18 read replicas.

Read Replicas use MySQL Asynchronous Replication with parallel workers. And when you create the first Read Replica, a Read Replica Load Balancer is created, which distributes read traffic among the read replicas.

Not all shapes are compatible with Read Replicas, the …

I’ve said it before and I’ll say it again; I can only hope you enjoy reading the OpenLampTech developer newsletter as much as I do. Once again this week we have a fantastic newsletter for you (and me). Enjoy and please share the publication to help spread the word that OpenLampTech is the media coverage for MySQL, PHP, and the LAMP stack landscapes!

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

In OpenLampTech issue #56, we have curated and original content covering:

• A fantastic developer Interview
• 7 …

MySQL Community Advent Calendar 2022 - How to generate MySQL slow query log in OCI for MySQL HeatWave Database Service using Fn infrastructure - part 2

MySQL HeatWave Best Practices Series: Schema Design

MySQL Community Advent Calendar 2022 - How to generate MySQL slow query log in OCI for MySQL HeatWave Database Service using Fn infrastructure

MySQL Community Advent Calendar 2022 - How can you analyze queries in MySQL Database Service in OCI using Performance_Schema

In the previous part, we created our application and our 2 functions. Now we need to create an API Gateway to be able to call these functions from outside OCI. Using a third party scheduler, our laptop, etc… Before creating the gateway, we need to create some policy to allow the API Gateway to call […]

In my previous post, I explained how to deal with Performance_Schema and Sys to identify the candidates for Query Optimization but also to understand the workload on the database. In this article, we will see how we can create an OCI Fn Application that will generate a slow query log from our MySQL Database Service […]

​ In a previous post, I talked about using MySQL Shell to import JSON data into a MySQL Document Store. But what if you have JSON data that you need to import into a column into an existing table? Fear not; the importJSON() utility can handle this as well. This post assumes you have access to a MySQL […]