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 , 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 , April 15th, 2014
https://github.com/continuent/continuent-puppet-tungsten As user root: vi /root/install.pp
$ 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
Categories: How-To's , Technology Tags: AWS , CentOS , Continuent , howto , Install , key , Master , Puppet , Replicator , Slave , ssh , tips , Tungsten
| No comments
Author:
erics , September 25th, 2013
If you are inserting to the same table at the same time at two or more different sites, and using bi-directional or multi-master replication, then the auto-increment keys need to be offset so they do not conflict or the application needs to be be able to generate it’s own unique keys. Use the auto-increment-increment and […]
Categories: How-To's , Technology Tags: Auto , Auto-Increment , Avoid , Collision , Increment , Master , Master-Master , mysql , Offset , Replication
| No comments