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

If you are using MyDumper as your Logical Backup solution and you store your backups on S3, you need to take a local backup and then upload it to S3. But what if there is not enough space to hold the backup on the server where we are taking the backup? Even if we have enough disk space, we will need to wait until the end to start to upload the files, making the whole process longer.

MyDumper implemented stream backup in v0.11.3 and we have been polishing the code since then. We also implemented two ways of executing external commands:

−−exec-per-thread: The worker that is getting the data from the database will write and redirect to the STDIN of the external command. It will be similar to execute cat FILE | command per every written and closed file.

−−exec: In this case, the worker writes in the local storage and when the file is closed, the filename is enqueued. The exec …

MySQL stores data in the form of one or many tables and sometimes these tables become useless but take up some space, to free up the space and get rid of these tables, we can delete them by simply dropping them from the MySQL database. Drop a table means deleting the table permanently from the …

NodeJS MySQL Drop Table Read More »

MySQL is a relational database management system that stores data in one or more tables of rows and columns and uses structured query languages to perform different operations on them. MySQL can be used in NodeJS to store large amounts of data, and we can retrieve data quickly due to its simple structure using SQL …

NodeJS MySQL Select Record Read More »