Showing entries 131 to 140 of 43508
« 10 Newer Entries | 10 Older Entries »
WordPress in OCI with MySQL HeatWave Read Replicas and MySQL Router R/W Splitting

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.

WordPress in OCI with MySQL HeatWave Read Replicas and MySQL Router R/W Splitting

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]
Where can you find MySQL during December - February 2024 - Update No.2

MySQL in Dec-Feb24

Migrate from GCP Cloud SQL for MySQL to MySQL HeatWave on Oracle Cloud Infrastructure (OCI) using MySQL Shell

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.

How to Use Percona Toolkit’s pt-table-sync for Replica Tables With Triggers in MySQL

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 […]

Parameterizing MySQL Queries in Node

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.

Mastering MySQL 5.7 EOL migrations

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]
Maximizing Performance of AWS RDS for MySQL with Dedicated Log Volumes

A quick configuration change may do the trick in improving the performance of your AWS RDS for MySQL instance. Here, we will discuss a notable new feature in Amazon RDS, the Dedicated Log Volume (DLV), that has been introduced to boost database performance. While this discussion primarily targets MySQL instances, the principles are also relevant to […]

What do you need to debug MySQL issues – a checklist

Welcome to the ultimate guide for MySQL issues debugging — your comprehensive MySQL checklist for tackling MySQL database environment challenges. This checklist for MySQL debugging is as useful to a…

The post What do you need to debug MySQL issues – a checklist first appeared on Change Is Inevitable.

MySQL Shorts - Episode #48 Released

Announcement of the new MySQL Shorts Episode

Showing entries 131 to 140 of 43508
« 10 Newer Entries | 10 Older Entries »