Let’s plan it – Scheduling in Apache NiFi
Janis Ax
Data Management
One key feature of Apache NiFi is scheduling. NiFi dataflows should cover streaming and batch use cases. But how can we connect both worlds together, and what settings are available? In this blog, we want to check the scheduling possibilities and show how to use them correctly. General scheduling options  The dataflow engineer has in total two...
Weiterlesen
A little less please: MySQL „partial revokes“
Matthias Jung
Data Management
Granting permissions on databases can be a tedious job. Especially assigning restrictive permissions à la "you may read all tables except for the information in database XYZ" was laborious. For such a task, the SELECT rights had to be defined for all databases that the user should be able to read. The unwanted database was simply given no rights. O...
Weiterlesen
Better be safe than sorry or how to "cluster" clusters. MySQL InnoDB ClusterSets
Matthias Jung
MySQL
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...
Weiterlesen
MySQL HeatWave - Speed up your OLAP tasks
Raphael Salguero
Oracle
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...
Weiterlesen
Just take it easy. InnoDB automatic configuration
Matthias Jung
MySQL - English Articles
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...
Weiterlesen
Less is more. MySQL Binlog Transaction Compression
Matthias Jung
MySQL - English Articles
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...
Weiterlesen