Author:
erics, August 29th, 2019
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.
Categories: Connector, Geo-Distributed, Maintenance, Multimaster, Multimaster MySQL, Multisite Tags: AWS, Clustering, Disaster REcovery, High Availability, mysql, proxy, Replicator
| Comments Off on 10 Reasons Why Tungsten Clustering Beats the DIY Approach for Geo-Distributed MySQL Deployments
Author:
erics, August 26th, 2019
Zero-Downtime Cluster Maintenance: Comparing the Procedures for Upgrades versus DB/OS Maintenance
Categories: Architecture, cctrl, Composite, Datasource, Downtime, Maintenance, Mastering Tungsten Clustering, Question, Shun, Zero-Downtime Tags: Command, HA, Master, mysql, QA, recover, Shell, Slave, Switch, Tungsten, welcome, Zero
| Comments Off on Zero-Downtime Cluster Maintenance: Comparing the Procedures for Upgrades versus DB/OS Maintenance
Author:
erics, August 8th, 2019
The power of Tungsten Clustering for MySQL / MariaDB is its built-in intelligent MySQL proxy, known as the Tungsten Connector. The Connector has built-in read-write splitting capabilities, and it is also possible to configure different algorithms which select the appropriate slave (i.e. Round-Robin or Lowest-Latency).
Categories: Balance, Bottleneck, Connector, Heavy I/O Load, Load Balancing, Mastering Tungsten Clustering, Overloaded, Read-only, Read-write, Splitting Tags: Clustering, mysql, proxy, Slave, Tungsten
| Comments Off on How to use Round-Robin Load Balancing with the Tungsten Connector
Author:
erics, August 7th, 2019
The replicator is a critical piece of the Tungsten Clustering solution for MySQL / MariaDB, as well as its own stand-alone data replication product. Automatic recovery enables the replicator to go back online in the event of a transient failure. In this blog, we discuss how to enable Autorecovery.
Categories: Auto Recover, Auto recovery, Mastering Tungsten Clustering, Mastering Tungsten Replicator, Offline, Tune Tags: Configuration, mysql, Network, Online, Recovery, Replicator, Tungsten, tuning
| Comments Off on Enabling Autorecovery for the Tungsten Replicator
Author:
erics, August 1st, 2019
Every time I use awk, my respect for it grows! Like grep, find and rsync, it is one of the powerhouse command-line tools in my arsenal. Recently, I needed to list all MySQL binary log files from a starting file forwards in sequence. AWK to the rescue! For example, I knew the starting file was […]
Categories: How-To's, Technology Tags: AWK, binary log file, howto, Index, Log, log file, Match, mysql, tips
| No comments
Author:
erics, July 31st, 2019
Continuent is pleased to announce Tungsten Clustering 5.4.0 and Tungsten Replicator 5.4.0 for MySQL / MariaDB. It’s significant in that it introduces MySQL 8 support, along with many new features, stability improvements and bug fixes.
Categories: Continuent Tungsten, MySQL 8, News, Tungsten Clustering, Tungsten Replicator Tags: Clustering, mysql, release, Replicator
| Comments Off on Tungsten Clustering 5.4.0 and Tungsten Replicator 5.4.0 Released
Author:
erics, July 31st, 2019
Continuent is pleased to announce Tungsten Clustering 6.1.0 and Tungsten Replicator 6.1.0 for MySQL / MariaDB. It’s significant in that it has MySQL 8 support, along with many new features, stability improvements and bug fixes. This release also features a new manager, and it also has the ability to do active/active Composite Multimaster geo-clustering.
Categories: Continuent Tungsten, MySQL 8, News, Tungsten Clustering, Tungsten Replicator Tags: Clustering, mysql, release, Replicator
| Comments Off on Tungsten Clustering 6.1.0 and Tungsten Replicator 6.1.0 Released
Author:
erics, July 25th, 2019
How to move the Relay role to another node in a Composite Tungsten Cluster
Categories: Architecture, cctrl, cls, Composite, Datasource, failover, Maintenance, Mastering Tungsten Clustering, Question Tags: Automatic, Command, HA, High Availability, Master, Move, mysql, QA, Relay, Replicator, Shell, Slave, Switch, Tungsten
| Comments Off on How to move the Relay role to another node in a Composite Tungsten Cluster
Author:
erics, July 19th, 2019
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?”
Categories: Bridge, Cluster, Connector, Direct, Mastering Tungsten Clustering, SmartScale Tags: Clustering, mysql, proxy, Tungsten
| Comments Off on How can I tell which Tungsten Connector mode I am using: Bridge, Proxy/Direct or Proxy/SmartScale?
Author:
erics, July 16th, 2019
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.
Categories: Mastering Tungsten Clustering, Monitor Tags: Aliases, bash, cli, Command, Command line, HA, High Availability, monitoring, mysql, Tungsten
| Comments Off on Slick Command-Line Tricks for a Tungsten MySQL / MariaDB Database Cluster