Blog

The Tungsten Connector proxy within a Tungsten Cluster is a very powerful tool, able to route traffic many different ways. The Quality Of Service (QoS) determines where the Connector proxy will send client request packets, either to the Primary for writes or to a Replica for reads. This short blog post will show you how to use the command line to control the Quality Of Service when creating a new connection to the MySQL Server database.

In this blog post, we cover the correct method for doing Tungsten software upgrades. When doing systems and database administration, there are often multiple ways to get the job done. While each of those ways may work, there is often one way that is called the “best practice”, meaning that it is the agreed-upon best workflow to accomplish that specific goal. With Tungsten Clustering software, the same holds true.

In this blog, part 5 of a series of “Recently a Customer Asked” posts for Tungsten University, we explore the values of the STATE output field in cctrl> ls which tells us about the health of the datasource. Specifically, we focus on the SHUNNED state, the different cctrl> ls outputs you may see when SHUNNED, and possible recovery steps.

One of the great powers of the Tungsten Cluster is that the writable Primary role can be moved to another node or cluster at will. When dealing with composite clusters and moving the Primary to another site entirely, there are different actions to take depending on the topology. In this blog post we will compare the procedures for moving the Primary role from one Composite cluster to another peer Composite cluster.

In this blog, part 4 of a series of “Recently a Customer Asked” posts for Tungsten University, we explore the purpose of the STATUS field in the cctrl> ls output and how it compares to the previous output.

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.

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?

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.

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.

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.

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?"

Need to do maintenance on a host? Learn how to suspend it gracefully.