We have already reported several times about the MySQL InnoDB Cluster and the associated components such as the MySQL Shell and the MySQL Router (e.g., https://blog.ordix.de/mysql-shell-cluster-your-application-in-40-minutes). With version 8.0.28 there is another innovation in this "triumvirate". The InnoDB ClusterSets. This allows the DBA to comfo...
A few months ago, Oracle published the new MySQL HeatWave feature for the Oracle Cloud Infrastructure (OCI), which promised to speed up analysis and transactional queries on your MySQL database without big effort. By using so called "HeatWave-Engines" (or "RAPID-Engines") in addition to the original MySQL instance, customers will be able to us...
Repeatedly customers ask us how to set the most important parameters of the InnoDB storage engine. But the answer can be amazingly simple for MySQL Version 8.0: innodb_dedicated_server = ON Don't think twice it is alright? With MySQL 8.0 the InnoDB engine is the de facto standard for operating MySQL databases. A wise configuration of the most impor...
The MySQL binary log is of particular importance for the operation of critical databases. It is the central point for DR and/or backup concepts. We have already talked about the mechanism and benefits of this "log file" in many places in this blog. With version 8.0.20, it is now possible to use compression. We will report on this topic in the follo...
There was already an article in ORDIX News 3/2012 that dealt with the provision of test environments (sandboxes). Of course, the MySQL Shell didn't exist back then. This tool (unfortunately still often unknown to DBAs) is very suitable for quickly creating test environments of various colors as sandboxes. Sandbox toys: What is a sandbox and what ca...
Keeping track of the state of a database server is certainly one of the most important tasks of every DBA. As with most database products, this control is carried out via an error log. This is an ASCII log file that is located in a certain path (depending on the operating system or configuration) in the file system off the server. With version 8.0....