Learn how we can use MySQL Shell to connect to a remote server over SSH.

Advent Calendar 2022 - This article describes how to define the backup policy when deploying MySQL Database Service in OCI with Terraform

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

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

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

Creating aliases for MySQL Shell in PowerShell.

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

Advent Calendar 2022 - How to always use MySQL Shell even if we are used to the old mysql command line client.

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

If, in Percona Server, you are observing tail latencies on queries that should be fast, this might be a side effect of Percona's improved InnoDB Empty Free List Algorithm.  When using this algorithm (the default in 5.6 and 5.7 and optional configuration in 8.0), a query needing a free page while none are available waits until the LRU Manager Thread refills the free list.  Because this