In this blog post, discover how to deploy WordPress on OCI using MySQL HeatWave Dabase Service with multiple replicas to spread the read traffic without having to change anything in WordPress and using MySQL Router 8.2.0's transparent R/W splitting feature.
Dec
13
2023
Dec
13
2023
Some time ago, we saw how we could deploy WordPress on OCI using MySQL HeatWave Database Service with Read Replicas. We had to modify WordPress to use a specific plugin that configures the Read/Write Splitting on the application (WordPress): LudicrousDB.
Today, we will not modify WordPress to split the Read and Write operations, but we will use MySQL Router 8.2.0 (see [1], [2], [3]).
Architecture
The …
[Read more]
Dec
12
2023
MySQL in Dec-Feb24
Dec
12
2023
What is MySQL Shell Utility: MySQL Shell’s instance dump utility, schema dump utility, and table dump utility provide Oracle Cloud Infrastructure Object Storage streaming, MySQL HeatWave Service compatibility checks and modifications, parallel dumping with multiple threads, and file compression, which are not provided by mysqldump. Progress information is displayed during the dump. You can carry out […]
Dec
12
2023
MySQL HeatWave is a fully managed database service, powered by the HeatWave in-memory query accelerator. It’s the only cloud service that combines transactions, real-time analytics across data warehouses and data lakes, and machine learning in one MySQL Database—without the complexity, latency, risks, and cost of ETL duplication.
In this Blog provides an overview, how to migrate from GCP Cloud SQL for MySQL into OCI MySQL Heatwave using MySQL Shell.
Dec
12
2023
Some time ago, we saw how we could deploy WordPress on OCI using MySQL HeatWave Database Service with Read Replicas. We had to modify WordPress to use a specific plugin that configures the Read/Write Splitting on the application (WordPress): LudicrousDB. Today, we will not modify WordPress to split the Read and Write operations, but we […]
Dec
12
2023
In Percona Managed Services, we manage Percona for MySQL, Community MySQL, and MariaDB. Sometimes, the replica server might have replication errors, and the replica might be out of sync with the primary. In this case, we can use Percona Toolkit’s pt-table-checksum and pt-table-sync to check the data drift between primary and replica servers and make […]
Dec
12
2023
To mitigate SQL injection attacks, queries that use user-provided input should be parameterized. In this post, we will discuss how to use named and unnamed parameters in a Node application. Finally, we show how to use the SQL Template Tag module to create unnamed placeholders and the related values in a single statement.
Dec
11
2023
In a recent podcast on Mastering EOL Migrations: Lessons learned from MySQL 5.7 to 8.0 I discuss with my colleague Adam North not only the technical issues that become a major migration but also key business and management requirements with having a well-articulated strategy that covers:
- Planning
- Testing
- Be Prepared
- Proactiveness
Having a plan is key to any significant task including data migrations. You should heed the warnings and the deprecations and consider all potential downstream product impacts such as connector upgrades. The plan includes a timeline but also needs to define all the stakeholders both technical and business, the definition of a successful migration, and most importantly the decision tree for a non-successful migration that would …
[Read more]
Dec
11
2023
In a recent podcast on Mastering EOL Migrations: Lessons learned from MySQL 5.7 to 8.0 I discuss with my colleague Adam North not only the technical issues that become a major migration but also key business and management requirements with having a well-articulated strategy that covers: