MySQL at TaranovoConf, Bulgaria

MySQL Shell is a powerful utility for managing MySQL Instances. One feature is the ability to perform multithreaded data dumps and loads. In this post we will discuss hows to dump data to, and read data from, a Storage Bucket in Oracle Cloud Infrastructure.

MySQL HeatWave on AWS is now available in AWS Asia Pacific (Mumbai) region Last month, we announced the availability of MySQL HeatWave on AWS in AWS Japan (Tokyo) region. We have now extended the availability to AWS India (Mumbai) region. The new region enables customers with applications deployed in AWS Asia Pacific (Mumbai) region to: […]

MySQL HeatWave on AWS is now available in AWS Asia Pacific (Mumbai) region

In a previous post, we discussed how you could use MySQL Shell to dump and load data using a multithreaded process. At the end of the post, I mentioned it was possible to dump data to and load data from cloud services such as Oracle Cloud Infrastructure (OCI). In this post, I will show you how to perform these data […]

Preface This blog begins by introducing an alternative and optional thread handling mechanism called MySQL Thread Pool, available in the MySQL Enterprise Edition. It then delves into the “Max Transaction Limit” feature that was added to MySQL Thread Pool in MySQL 8.0. The blog shows the recommended MySQL Thread pool configuration and proceeds to compare […]

The "Max Transaction Limit" feature added MySQL Thread Pool in MySQL 8.0 Enterprise Edition helps to prevent performance drops as load increases.

We are sure you’ve probably already heard that MySQL 5.7 is going to reach End of Life (EOL) by October 2023. We are here to tell you that the migration from MySQL 5.7 need not be scary — MySQL 8.0 has been Generally Available for five years, and the Galera Cluster product for it, has been hardened for over three years, so it is truly time to get ready to migrate.

In our first session of the series, we are going to cover:
* the new features of Galera Cluster with MySQL 8 that you might benefit from, including what is available in Galera Cluster Enterprise Edition (EE)
* how to plan a migration from MySQL 5.7 or older to 8.0
* things to test for, before migrating
* common pitfalls of said migration
* how to ensure your Galera Cluster keeps humming along with no downtime

We also offer migration support to help you before and during your migration, after-which our regular support plan will cover …

I am trying something new with the OpenLampTech developer newsletter here on the blog. I will start re-sharing last week’s newsletter on the following Wednesday instead of Monday. If you want it earlier than that, you should subscribe. This won’t be permanent but does help me with some content creation as I am too thin with original content at the moment for the weekly blog. Thanks for reading!

Custom WooCommerce and Shopify Solutions

Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!

Learn More

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

…

Last time we tried to connect to a MySQL DB instance in OCI with Cloud Shell, we needed to use the bastion service. See here.

Now, we also have the possibility to bypass the bastion host as Cloud Shell offers the possibility to change network.

As you know, in Oracle Cloud Infrastructure, a MySQL DB instance is not exposed in the public subnet and doesn’t have the possibility to get a public IP.

In the Private Subnet, we often have a security list allowing all internal IPs (from public and private subnet of the VCN) to connect to the MySQL port(s).

If the security list is present, we can click on the Cloud Shell icon and once loaded, change the network:

We need to create a new Private Network Definition:

In case you don’t have the ports open for MySQL in the …