Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
Functional Indexes in MySQL
Database indexes are used to help query performance. Database indexes typically contain information about data in a specific column of the database table. With the introduction of functional indexes in MySQL 8.0.13, we can now create indexes based on the result of an expression or function. The Setup Before talking about functional indexes, let’s get some data set up. […]
MySQL Connection Control
As a MySQL database administrator, have you ever faced a brute force attack on your database server or been the target of a DDOS-like connection flow on port 3306? If so, you will quickly understand why this plugin distributed with MySQL can be very useful in such situations. Indeed, the connection-control plugin allows the administrator […]
Indexing JSON Data in MySQL
Storing JSON in a relational database is something developers have done for quite some time. There are a variety of reasons why you would want to store JSON in a database table – user preferences and configuration data are two good examples. The JSON Data Type was introduced to MySQL in version 5.7.8. This data type allows […]
How to import data from Microsoft SQL Server to MySQL HeatWave Database Service
After having see how we can import data from PostgreSQL and Amazon Redshift, this time we will see how we can export data from Microsoft SQL Server and import it into MySQL HeatWave Database Service in OCI. This time we will use something extra (for fun but also because it’s practical): OCI Object Storage ! […]
MySQL InnoDB Redo Log Archiving
When performing physical backup on system that are heavily used, it can happen that the backup speed cannot keep up with the redo log generation. This can happen when the backup storage is slower than the redo log storage media and this can lead in inconsistency in the generated backup. MySQL Enterprise Backup (aka MEB) […]
Live Migration from Azure Database for MySQL to MySQL HeatWave Database Service on OCI
In this article we will see how to perform a live migration from Azure/MySQL to OCI/MySQL HeatWave. As Azure allows public connections directly to the database, this is what I will use to migrate and replicate the data between both clouds. Also, since this content is focused on data migration, I won’t explore all the […]
Using MySQL Shell to generate table’s create statement from CSV file
Recently, I wrote several articles on how to load data from CSV files to migrate from different databases to MySQL Database Service: We saw that the most complicate is to write the CREATE TABLE statement that matches the data. I also received some questions about how to generate the table’s definition when only the CSV […]
Import data from Amazon Aurora PostgreSQL to MySQL HeatWave Database Service in OCI
In previous posts we already saw how to export data from PostgreSQL and AWS RedShift, and import it on MySQL Database Service in OCI using MySQL Shell importTable utility: Today, we will see how we can export some tables from AWS RDS Aurora PostgreSQL and import them on MySQL HeatWave Database Service. For this exercise, […]
How to import data from Amazon Redshift to MySQL HeatWave Database Service
We saw in this previous post how to import data from PostgreSQL to MySQL HeatWave Database Service. Using almost the same technique, we will now import data from Amazon Redshift and import it to a MySQL HeatWave instance in OCI. With Redshift we have two options to export the data to CSV files that can […]
How to import data from PostgreSQL to MySQL HeatWave Database Service
MySQL HeatWave Database Service is very popular and many users wants to benefit from the managed MySQL service and from MySQL HeatWave fast engine. We see many users migrating their data from MySQL on-premise or from another cloud vendor to OCI MySQL HeatWave… but we also see people migrating from other data-stores like PostgreSQL. In […]