Blog

Tungsten Cluster: How Does Failover Work? Part 1 of 3

Did you ever wonder just what the Tungsten Manager is thinking when it does an automatic failover or a manual switch in a cluster? What factors are taken into account by the Manager when it picks a replica to fail over to? This blog post will detail the steps the Manager takes to perform a switch or failover. We will cover both the process and some possible reasons why that process might not complete, along with best practices and ways to monitor the cluster for each situation.

Eric M. Stone

Jan 25, 2023

Tungsten University, Cluster Management, Database Administration

How can I tell which Tungsten Connector mode I am using: Bridge, Proxy/Direct or Proxy/SmartScale?

Part of the power of Tungsten Clustering for MySQL / MariaDB is its intelligent MySQL Proxy, known as the Tungsten Connector. Tungsten Connector has three main modes, and depending on the type of operations you are performing (such as if you need read-write splitting), we help you choose which mode is best. Hence the question, "How can I tell which Tungsten Connector mode I am using: Bridge, Proxy/Direct or Proxy/SmartScale?"

Eric M. Stone

Jan 20, 2023

Tungsten University, Intelligent Proxy

Recently a Continuent Customer Asked: Part 3

In this blog, part 3 of a series of “Recently a Customer Asked” posts for Tungsten University, we explore the question: "Why does the tprovision command fail with error “Can’t connect to local MySQL server through socket” when using the xtrabackup method?

Eric M. Stone

Jan 19, 2023

Tungsten University, Cluster Management, Database Administration

Global WordPress High Availability Using Tungsten Clustering, Part 1

Running highly-available WordPress is especially challenging, because WordPress is not by nature Active/Active-aware, and will refuse to run in an environment where database writes are active-active. In this blog post Part 1, we will explore the design considerations for making WordPress highly-available at the database layer. We also cover some other WordPress HA architecture needs, like the need for a shared filesystem.

Eric M. Stone

Jan 17, 2023

MySQL High Availability (HA) & Disaster Recovery (DR), Cluster Management, Database Administration

Tungsten Cluster: Command Line Superpowers Using cctrl

The purpose of the cctrl command is to provide easy access to the Tungsten Manager layer, which in turn controls the entire cluster. In this post we will explore the cctrl> service command and the power it provides to the admin.

Eric M. Stone

Jan 13, 2023

Tungsten University, Cluster Management, Database Administration, Zero Downtime Maintenance

Recently a Continuent Customer Asked: Part 2

In this post we discussed the tprovision command and why it is always best to use a Replica node, not the Primary node, as the source for provisioning another Replica node.

Eric M. Stone

Jan 10, 2023

Tungsten University, Cluster Management, Database Administration

New Command for Tungsten: tungsten_get_ports

Tungsten Clustering contains many tools to monitor your cluster, and today we will look at a new one - the `tungsten_get_ports` command, included with Tungsten versions 6.1.20+ and 7.0.2+. This tool was created to help provide a clear view of running Tungsten processes and the associated listener ports.

Eric M. Stone

Dec 29, 2022

Tungsten University, Cluster Management, Database Administration, Monitoring and Observability

Recently a Continuent Customer Asked: Part 1

This is a short blog answering the question: "I have a cron job running as a non-tungsten user, and that job needs access to the tungsten-owned files under /opt/continuent, but cannot access the files it needs - how do I give access to those files to my cron job?"

Eric M. Stone

Dec 27, 2022

Tungsten University, Cluster Management, Database Administration, Security

Tungsten Clustering: Plugging the Holes - Risk Mitigation Through Best Practices, Part 2

Tungsten Clustering depends on a number of prerequisites and best practices to function optimally. In this blog post, we explore a critical, yet easily-overlooked step when installing a Tungsten Cluster node - configuring the available number of open files when using `systemd` control.

Eric M. Stone

Dec 21, 2022

Tungsten University, Cluster Management, Database Administration

Tungsten Clustering: Plugging the Holes - Risk Mitigation Through Best Practices

Tungsten Clustering depends on a number of prerequisites and best practices to function optimally. In this blog post, we explore a critical, yet easily-overlooked step when installing a Tungsten Cluster node - setting up start at boot, ideally under `systemd` control.

Eric M. Stone

Dec 07, 2022

MySQL High Availability (HA) & Disaster Recovery (DR), Cluster Management, Database Administration, Monitoring and Observability

Now Available: Tungsten Dashboard v1.0.11 Release

We are pleased to announce that Tungsten Dashboard v1.0.11 is now available. Tungsten Dashboard is a web-based UI for monitoring and managing Tungsten Clustering deployments of MySQL databases, freely included for Tungsten Clustering customers. We provide Tungsten Dashboard in addition to our command-line user interfaces for easy visual monitoring and management of Tungsten Clusters. Users are able to view, monitor and maintain all of their database clusters in one place.

Eric M. Stone

Nov 08, 2022

Continuent News, Cluster Management, Database Administration, Monitoring and Observability

New Command for Tungsten: tungsten_get_status

Tungsten Clustering contains many tools to monitor your cluster, and today we will look at a new one - the `tungsten_get_status` command, included with Tungsten versions 6.1.19+ and 7.0.2+. This tool was created in response to a customer request for a simple script that could display the status of all nodes cluster-wide for any topology from a single place. The status includes the datasource and replicator layers along with the policy for each cluster.

Eric M. Stone

Oct 11, 2022

Tungsten University, Cluster Management, Database Administration, Monitoring and Observability

Categories

Series

Tungsten Cluster: How Does Failover Work? Part 1 of 3

How can I tell which Tungsten Connector mode I am using: Bridge, Proxy/Direct or Proxy/SmartScale?

Recently a Continuent Customer Asked: Part 3

Global WordPress High Availability Using Tungsten Clustering, Part 1

Tungsten Cluster: Command Line Superpowers Using cctrl

Recently a Continuent Customer Asked: Part 2

New Command for Tungsten: tungsten_get_ports

Recently a Continuent Customer Asked: Part 1

Tungsten Clustering: Plugging the Holes - Risk Mitigation Through Best Practices, Part 2

Tungsten Clustering: Plugging the Holes - Risk Mitigation Through Best Practices

Now Available: Tungsten Dashboard v1.0.11 Release

New Command for Tungsten: tungsten_get_status

Blog

Categories

Series

Tungsten Cluster: How Does Failover Work? Part 1 of 3

How can I tell which Tungsten Connector mode I am using: Bridge, Proxy/Direct or Proxy/SmartScale?

Recently a Continuent Customer Asked: Part 3

Global WordPress High Availability Using Tungsten Clustering, Part 1

Tungsten Cluster: Command Line Superpowers Using cctrl

Recently a Continuent Customer Asked: Part 2

New Command for Tungsten: tungsten_get_ports

Recently a Continuent Customer Asked: Part 1

Tungsten Clustering: Plugging the Holes - Risk Mitigation Through Best Practices, Part 2

Tungsten Clustering: Plugging the Holes - Risk Mitigation Through Best Practices

Now Available: Tungsten Dashboard v1.0.11 Release

New Command for Tungsten: tungsten_get_status

Pages