Author:
erics, January 21st, 2020
|
|
echo `mysql -uyourUser -pyourPassword -B --disable-column-names -e "SELECT CONCAT('DROP DATABASE ', SCHEMA_NAME, ';') FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME LIKE 'yourPrefix%';"` | mysql -uyourUser -pyourPassword -B |
Categories: How-To's, Technology Tags: Concat, Database, DB, drop, DROP DATABASE, drop database like, howto, INFORMATION_SCHEMA, INFORMATION_SCHEMA.SCHEMATA, LIKE, Match, mysql, SCHEMA_NAME, SCHEMATA, tips
| 
No comments
Author:
erics, September 26th, 2019
Make It Faster: Improving MySQL Write Performance for Tungsten Cluster Slaves
Categories: Architecture, cctrl, Composite, Mastering Tungsten Clustering, Question Tags: HA, mysql, Performance, Performance Tuning, QA, Shell, Tungsten
| Comments Off on Make It Faster: Improving MySQL Write Performance for Tungsten Cluster Slaves
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
