MySQL Master – Slave Replication on CentOS Introduction MySQL master-slave replication is quite simple and direct way to scale-out reads optimally. Retaining multiple copies of master across slaves also guarantee reliability and maximum availability, Replication […]
Introduction MySQL master-slave replication is quite simple and direct way to scale-out reads optimally. Retaining multiple copies of master across slaves also guarantee reliability and maximum availability, Replication is never an substitute or alternative for […]
I have used data from BUREAU OF TRANSPORTATION STATISTICS https://www.transtats.bts.gov for benchmarking ClickHouse (https://clickhouse.yandex) From their website, here is what the OnTime data covers: Airline on-time data are reported each month to the U.S. Department […]
We almost daily do MySQL Performance Audit, Health Check, Diagnostics and Forensics for some customer, We are pioneers in architecting and build optimal and scalable MySQL infrastructure operations. To know more about MinervaDB MySQL high performance […]
Recently one of the customers wanted me to evaluate and recommend a Columnar Database System of Data Analytics. I have chosen ClickHouse, Vertica, Greenplum and MariaDB ColumnStore for this exercise. I have to admit all […]
Sometimes we may have to kill several MySQL connections / processes, How can we do that effortlessly ? We have to first list down the connections you want to kill with ” SHOW FULL PROCESSLIST […]
SHOW ENGINE INNODB STATUS is a very direct and simple SHOW ENGINE statement to display InnoDB Monitor output. The output of this query is quite detailed and exhaustive, It has wealth of information to troubleshoot […]
InnoDB is a open source and default general purpose MySQL storage engine built for high performance and reliability , Antelope is the original InnoDB file format which supports both COMPACT and REDUNDANT row formats for […]
As a full-time MySQL DBA consultant one of the biggest pain I face in my day-to-day operations is performing DDL in an high traffic / transaction intensive MySQL infrastructure without impacting business continuity, reliability and […]
Can we run InnoDB from read only media like DVD/CD ? Yes, it’s possible from MySQL-5.6.7 release candidate. This makes users to explicitly setup the instance on read-only mode, It makes entire server instance as […]
MySQL, InnoDB and Oracle are registered trademarks of Oracle Corp. MariaDB is a trademark of Monty Program AB. All other trademarks are property of their respective owners. Other product or company names mentioned may be trademarks or trade names of their respective owner. Copyrights © 2010-2022 All Rights Reserved by MinervaDB®.