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.
…
[Read more]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]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:
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 …
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.
OCI CLI is a powerful tool that does it all for OCI administration: from creating a compute instance to configuring a Virtual Cloud Network (VCN), from setting up Identity Management Service (IAM) to managing all the different storage flavours. Consult the OCI CLI command reference.
MySQL Database Service (MDS) is not an exception, everything related to the new MySQL Server service running over OCI can be easily managed with a set of commands using OCI CLI, check it here. Starting new DB Systems, creating and managing backups, dealing with …
[Read more]Top n Window Function queries over a specific subset of data are common in analysis and reporting requirements. Luckily, in MySQL, there are Window functions we can use for this type of query. To be quite honest, you don’t necessarily need Window Functions. You can retrieve those top 3 (or whatever) types of results with a regular SQL query. But, since we have those powerful Window Functions, why not use them? My thoughts exactly! Besides, no one wants a spaghetti code mess of SQL to try and understand. Not to mention, Window functions are often better optimized for querying larger data sets. Continue reading and see example queries for more understanding…
[Read more]
