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

Author: erics, August 26th, 2019

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

How To Sort Text as a Number in MySQL

Author: erics, July 11th, 2013

select theField from theTable order by theField+0; ~OR~ select theField from theTable order by CAST(theField AS UNSIGNED);

Author: erics, May 11th, 2011

To pad a number with leading zeros, up to a max of 5 places:

sprintf("%05d",$value);

1	sprintf("%05d",$value);