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.
Dec
01
2020
Dec
01
2020
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 …
[Read more]
Nov
30
2020
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
Nov
30
2020
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.
…
[Read more]
Nov
30
2020
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 …
[Read more]
Nov
30
2020
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!
Nov
30
2020
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...
Nov
30
2020
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 …
Nov
30
2020
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 …
Nov
30
2020
Django is a popular framework for Python application developers. It includes packages which make tasks like authorization and content administration easier. Django supports a number of databases including MySQL which makes it possible to run a Django application over Vitess without having to change the application code. Let’s take a look at how to combine the strengths of these two open source frameworks. We built this example using Vitess operator. You can see the details of the implementation in the blog post Vitess Operator for Kubernetes.