How To Control Output Formatting Via The MySQL Shell CLI

Author: , May 26th, 2021

https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-output-formats.html Multiple Formats Available: Table Format – use –result-format=table, alias –table Tab Separated Format – use –result-format=tabbed, alias –tabbed Vertical Format – use –result-format=vertical, alias –vertical JSON Format Output – use –result-format=VALUE, alias –json[=pretty|raw|off] VALUE may be one of: json or json/pretty – These options both produce pretty-printed JSON. ndjson or json/raw – These options […]

How To Determine Where MySQL Looks For my.cnf

Author: , March 22nd, 2021

Ah, the power of grep!

How To Install MySQL 8.0 on AWS Linux 2

Author: , November 18th, 2020

How To Install MySQL on MacOS Using Brew

Author: , April 5th, 2020

As a non-root user:

Make sure your PATH contains /usr/local/bin

How To DROP DATABASE LIKE In MySQL

Author: , January 21st, 2020

Make It Faster: Improving MySQL Write Performance for Tungsten Cluster Slaves

Author: , September 26th, 2019

Make It Faster: Improving MySQL Write Performance for Tungsten Cluster Slaves

10 Reasons Why Tungsten Clustering Beats the DIY Approach for Geo-Distributed MySQL Deployments

Author: , 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.

Zero-Downtime Cluster Maintenance: Comparing the Procedures for Upgrades versus DB/OS Maintenance

Author: , August 26th, 2019

Zero-Downtime Cluster Maintenance: Comparing the Procedures for Upgrades versus DB/OS Maintenance

How to use Round-Robin Load Balancing with the Tungsten Connector

Author: , 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).

Enabling Autorecovery for the Tungsten Replicator

Author: , 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.