I am pretty new on the Oracle Cloud Infrastructure technology, so maybe I am talking about something you already know. But anyway I prefer to share this case: it can help if you encounter the same problem as me. Let’s take the risk to have too much information rather than nothing!

The problem

I was doing some tests on the new MySQL Database Service and during the setup I decided to generate my ssh keys via the OCI console:

When I tried to connect via PuTTY or MobaXterm to my compute instance using the opc account and my private key (generated previously), I got the …

In this article, we will see the steps to create a snapshot of the existing RDS MySql Instance. Then we will see the steps to restore the snapshot which creates a new RDS Instance. At last, we will clean up the instances and snapshots.

  This is yet another reminder that MySQL 5.6 reaches End of Life status in February 2021.  I have been sending out such reminders since February of 2020. But in my presentations this year when I bring up the 5.6 EOL, there are a lot of users out there that are shocked to hear the news. In one of my November presentations (virtual) I had a very upset audience member who wondered why I was not making more of a big deal out of the EOL date.

    Wikipedia says ""End-of-life" ("EOL") is a term used with respect to a product supplied to customers, indicating that the product is in the end of its useful life (from the vendor's point of view), and a vendor stops marketing, selling, or rework sustaining it. (The vendor may simply intend to limit or end support for the product.)" 

What does this mean those of you running MySQL 5.6 will not be getting bug fixes, will find it much harder to get support, and …

 Want to learn more about new features in MySQL 8.0? The folks at the Utah Oracle Users Group are opening their December 03, 2020 meeting to all.  It will run from 6:30 PM - 8:00 PM Mountain Time. 

Please RSVP https://us02web.zoom.us/j/89659298608?pwd=QVhIRDcvV0EwNnF

All opinions expressed in this blog are those of Dave Stokes who is actually amazed to find anyone else agreeing with him

How scheduler and script stand in supporting failover (Percona and Marco example) 

In part one of this series,  I had illustrated how simple scenarios may fail or have problems when using Galera native support inside ProxySQL. In this post, I will repeat the same tests but using the scheduler option and the external script.

The Scheduler

First a brief explanation about the scheduler.

The scheduler inside ProxySQL was created to allow administrators to extend ProxySQL capabilities. The scheduler gives the option to add any kind of script or application and run it at the specified interval of time. The scheduler was also the initial first way we had to deal with Galera/Percona XtraDB Cluster (PXC) node management in case of issues. 

…

How native ProxySQL stands in failover support (both v2.0.15 and v2.1.0)

In recent times I have been designing several solutions focused on High Availability and Disaster Recovery. Some of them using Percona Server for MySQL with group replication, some using Percona XtraDB Cluster (PXC). What many of them had in common was the use of ProxySQL for the connection layer. This is because I consider the use of a layer 7 Proxy preferable, given the possible advantages provided in ReadWrite split and SQL filtering. 

The other positive aspect provided by ProxySQL, at least for Group Replication, is the native support which allows us to have a very quick resolution of possible node failures.

ProxySQL has Galera …

We are pleased to announce that you can find MySQL session (in Italian) on RIOS OpenSource Week during Dec 1-4, 2020. See details below:

• Event Name: RIOS OpenSource Week
• Event Date: Dec 1-4, 2020
• URL
• MySQL Session (under Finance Track): "MySQL nel fintech: una storia enterprise" (in Italian)
• Speaker: Vittorio Cioe, the MySQL Sales Consultant for Eastern Europe, CIS, Israel and Turkey
• Session date & time: Dec 3, 2020 @ 11:20 CET

MySQL talk is visible for registered people only, so please feel free to register! 

We are happy to invite you to Open Source Week and our MySQL talk!

We are pleased to announce that you can find MySQL session (in Italian) on RIOS OpenSource Week during Dec 1-4, 2020. See details below: Event Name: RIOS OpenSource Week Event Date: Dec 1-4, 2020 URL MySQL Session (under Finance Track): "MySQL nel fintech: una storia enterprise" (in Italian) Speaker...

On a previous blog post, we saw how to create an account on the Oracle OCI using the Oracle Cloud Free Tier offer and then how to instal MySQL Server on the Compute instance.
Some weeks later, the new MySQL Database Service (MDS) was out and I can show you now how to install and configure it.

We are talking about the MySQL 8.0 Enterprise Edition on the on Oracle Generation 2 Cloud Infrastructure. For the moment it’s only available on some of the data regions (Frankfurt and London for the EMEA zone), but normally others will be activated …

On a previous blog post, we saw how to create an account on the Oracle OCI using the Oracle Cloud Free Tier offer and then how to instal MySQL Server on the Compute instance.
Some weeks later, the new MySQL Database Service (MDS) was out and I can show you now how to install and configure it.

We are talking about the MySQL 8.0 Enterprise Edition on the on Oracle Generation 2 Cloud Infrastructure. For the moment it’s only available on some of the data regions (Frankfurt and London for the EMEA zone), but normally others will be …