Zero-Downtime Cluster Maintenance: Comparing the Procedures for Upgrades versus DB/OS Maintenance
Part of the power of Tungsten Clustering for MySQL / MariaDB is the ability to perform true zero-downtime maintenance, allowing client applications full access to the database layer, while taking out individual nodes for maintenance and upgrades. In this blog post we cover various types of maintenance scenarios, the best practices associated with each type of action, and the key steps to ensure the highest availability.
Aug 26, 2019
Cluster Management, Database Administration, Zero Downtime Maintenance
In a proxy-ed world, where do connections come from?
Database Proxies provide a single entry point into MySQL for the calling client applications. Proxies are wonderful tools to handle various situations like a master role switch to another node for maintenance, or for transparency with read and write connections. However, when the time comes to perform the switch action, all of the calling clients have been funneled through the proxy, so identification of the calling host from the database itself becomes difficult.
Jul 29, 2019
Intelligent Proxy
How to move the Relay role to another node in a Composite Tungsten Cluster
How to move the Relay role to another node in a Composite Tungsten Cluster
Jul 25, 2019
24/7/365 Support, Database Administration, Cluster Management, Zero Downtime Maintenance
Slick Command-Line Tricks for a Tungsten MySQL / MariaDB Database Cluster
Tungsten Clustering provides high availability, disaster recovery, and a host of other benefits for MySQL / MariaDB / Percona Server databases. In this blog post we will explore some of the shell aliases I use every day to administer various Tungsten Clusters.
Jul 16, 2019
Database Administration, Cluster Management, Native