Zero-Downtime Cluster Maintenance: Comparing the Procedures for Upgrades versus DB/OS Maintenance
Zero-Downtime Cluster Maintenance: Comparing the Procedures for Upgrades versus DB/OS Maintenance
Zero-Downtime Cluster Maintenance: Comparing the Procedures for Upgrades versus DB/OS Maintenance
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).
How to move the Relay role to another node in a Composite Tungsten Cluster
https://github.com/continuent/continuent-puppet-tungsten As user root: vi /root/install.pp
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
$clusterData = { "myServiceNameHere" => { "topology" => "master-slave", "master" => "myDBHostName1", "slaves" => "myDBHostName2", }, } class { 'tungsten' : installSSHKeys => true, installMysql => true, clusterData => $clusterData, replicatorRepo => "stable", installReplicatorSoftware => true, } |
yum install puppet mkdir -p /etc/puppet/modules puppet module install continuent/tungsten puppet apply /root/install.pp