Case Study: MySQL High Availability, Zero Downtime Maintenance and Disaster Recovery for SaaS
This is the second post in a series of MySQL case study blogs. It discusses a SaaS provider dealing with sensitive medical data and their need to be able to quickly deploy clusters in AWS and recover from multi-zone AWS outages.
Dec 17, 2019
Zero Downtime Maintenance
10 Reasons Why Tungsten Clustering Beats the DIY Approach for Geo-Distributed MySQL Deployments
Why does the DIY approach fail to deliver vs. the Tungsten Clustering solution for geo-distributed MySQL multimaster deployments? Before we dive into the 10 reasons, note why commercially-supported enterprise software is less risky and in fact less costly.
Aug 29, 2019
Total Cost of Ownership, Native
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
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
Transparent Proxy Maintenance for MySQL, MariaDB & Percona Server
When it comes to zero downtime, proxies are the first line components of a cluster. In order to achieve High Availability (HA) for MySQL, MariaDB and Percona Server, a commonly deployed setup consists of configuring load balancers (hardware or software) on top of those proxies.
Jun 11, 2019
Intelligent Proxy
Worldwide Multimaster MySQL Cluster Administration Using Tungsten Dashboard
Tungsten Clustering offers a graphical administration tool called the Tungsten Dashboard™ to help with your management burden. The GUI makes the deployment much easier to visualize and administer.
Sep 25, 2018
Cluster Management, Geographic Distribution and Geo-Scale
MySQL / MariaDB Clustering: Seamless Master Switch with Tungsten Clustering
One nice thing about Tungsten Clustering is that you need just a single command to move the master role to another host in your cluster.
Sep 18, 2018
Database Administration, Cluster Management, Intelligent Proxy
MySQL / MariaDB Clustering with Tungsten: Failover Focus
In this blog post, we discuss failover concepts and administration.
Sep 14, 2018
Intelligent Proxy
Mastering Tungsten Replicator Series: Migration from an Old Database to a New Cluster
The Tungsten Replicator is an extraordinarily powerful and flexible tool capable of moving vast volumes of data from source to target.
Sep 05, 2018
Advanced Replication, Cluster Management, Native, Zero Downtime Maintenance
Mastering Tungsten Replicator Series: Filtering the Data Fantastic
The Tungsten Replicator is an extraordinarily powerful and flexible tool capable of moving vast volumes of data from source to target.
In this blog post we will discuss the basics of how to implement and use filters in the Tungsten Replicator.
Aug 27, 2018
Advanced Replication, Database Administration, Cluster Management
How To Monitor Your Database Clusters Using Tungsten Dashboard
Managing a single cluster takes time and attention, and handling multiple clusters spread out over many sites is even more demanding. Tungsten Clustering offers a graphical administration tool called the Tungsten Dashboard™ to help with your management burden. You are able to view, monitor and maintain all of your clusters all in one place.
Aug 24, 2018
Tungsten University, Cluster Management, Database Administration, Monitoring and Observability
How To Architect MySQL to be Available No Matter What
Think about it - your global, cloud-based application needs to be online and available for the business to run. Downtime is to be avoided like the plague. Perhaps you even have multiple cloud providers to span.
How do we create a database service layer that handles all kinds of failures?
Aug 20, 2018
MySQL High Availability (HA) & Disaster Recovery (DR), Zero Downtime Maintenance