Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
MySQL HeatWave Replication Filters and Sources Without GTIDs
The Inbound Replication capabilities of MySQL HeatWave Database Service have been improved with filtering and handling of sources without GTIDs. Users now have more flexibility to configure replication Channels for hybrid deployments or straightforward live migrations from on-premises or other cloud vendors. Using the templates under the Target DB system filter options, you can easily […]
Announcing MySQL HeatWave Read Replicas with Load Balancer
The MySQL HeatWave Database Service added new capabilities that enable applications to scale database read operations to millions of queries per second. Users can add and remove read replicas and load balancers to DB Systems with just a few clicks, and the service takes care of deployment, configuration, monitoring, and maintenance. Applications can connect directly […]
OCI MySQL Database Service – Using a backup as source for a new instance
Let’s continue our journey of deploying the MySQL Database System on OCI with Terraform. This time we will see how we can use a backup (see [1] and [2]) as a source (initial data) for a new instance. Within the oci_mysql_mysql_db_system it’s possible to define a source detailing how to provision the initial data of […]
Creating Aliases in MySQL Shell
MySQL Shell is a powerful way to connect to and manage MySQL instances. Connections can even be made to servers that are behind an SSH connection. In this post, we will discuss how to extend and customize MySQL Shell so that it is easier to initiate those connections. The Problem If you are like me, you use aliases […]
Web-Konseil Unlocks Data Possibilities for their Clients with MySQL HeatWave
Web-Konseil, is a web and digital agency based in Lyon, France. The agency supports companies in the development of websites and e-commerce applications. Its business keeps growing with constant innovation and introduction of new services. Thanks to a partnership with Oracle, Web-Konseil already offers a hosting service for its customers on Oracle Cloud Infrastructure (OCI). […]
OCI MySQL Database Service – Backup Policy and Tags
Recently, for the 3rd day of the MySQL Community Advent Calendar 2022, I wrote an article on how to define a backup policy for MySQL Database Service in OCI using Terraform. We saw that it was possible to define tags (defined_tags and freeform_tags) in the backup_policy section of a oci_mysql_mysql_db_system resource. However, it seems that […]
Connecting MySQL Shell Over SSH
As I mentioned in my last post, I am a big fan of MySQL Shell. Until recently, I have only used MySQL Shell to connect to a local instance of MySQL running on my development machine. I recently needed to connect to a MySQL database running on a remote server. I wanted to use MySQL Shell but […]
Define the Backup Policy when deploying MySQL Database Service in OCI
For this new MySQL Advent Calendar 2022, today’s post is related on how to define a Backup Policy and a Maintenance Window when deploying a MySQL Database Service instance in OCI using Terraform. Backup Policy In the oci_mysql_mysql_db_system resource, we will add a new section called backup_policy like this: backup_policy { is_enabled = "true" retention_in_days […]
MySQL Shell Alias For PowerShell
Yesterday, my colleague, Fred (AKA LeFred), shared a blog post that discusses setting up aliases that allow us to run MySQL Shell when we enter mysql at a command prompt. Since I also use Windows regularly, I wanted to share how you can set up those same aliases in Windows PowerShell. We need to update our profile script to create permanent aliases in […]
Always use MySQL Shell
You know how much I praise and like MySQL Shell but if like me, for you too, old habits die hard, I advise you to create these different aliases in your ~/.bashrc (or ~/.bash_aliases) file to force yourself to use MySQL Shell even for a small statement check: alias mysql="mysqlsh --sql mysql://localhost" alias mysqlx="mysqlsh --js […]