Tag: high availability

Occasionally, clients reach out to us with authentication issues when a node is down. While this scenario shouldn’t happen in a high availability database management system (DBMS), it can if you miss a couple of very relevant lines in the…

This is the sixth in a series of blog posts, that covers the details to deploy the Oracle Management Servers for a high available set up of Oracle Enterprise Manager 13.5 using Oracle Cloud Infrastructure‘s resources.   Recap This is…

This is the fourth in a series of blog posts that covers the details to deploy a high available set up of Oracle Enterprise Manager 13.5 using Oracle Cloud Infrastructure’s resources.   Recap This is the fourth of a six-part…

Oracle MySQL Community Edition comes with a native, virtually synchronous, clustering solution called InnoDB Cluster. This clustering solution uses a technology under the hood called Group Replication. This technology is very similar to Galera Cluster, although where Galera relies on…

The 2020 edition of Black Friday and Cyber Monday is now behind us. But smart organizations are still studying it closely. That’s because, for better or worse, Black Friday and Cyber Monday have a lot to say about how well…

Database unavailability or outright failure is no joke. Not only do such incidents often cause massive internal stress (along with the inevitable blame game between IT staff), but they can also negatively impact business outcomes and lead to dissatisfied or…

This blog post will show how to dynamically add logic at the beginning of jobs in Availability Groups in order to avoid job execution errors in the replica or replicas. Problem In SQL Availability Groups the SQL jobs have to…

On October 3rd ProxySQL will have it’s very first technology day. They have chosen the lovely city of Ghent, Belgium, my home town, as the place to be. For those attending Percona Live Europe in Amsterdam, this is a great…

ProxySQL is a great tool. It’s one of the most recommended technologies in our Open Source Database practice. Many of our clients are running it or are migrating towards it, but we’ve seen that it is pretty CPU-intensive. We’ve also…

In one of the projects I have been working on, one requirement was the ability to stop traffic from reaching a MySQL host which has been lagging behind its master for longer than a specific amount of time and then…