Episode #54 of MySQL Shorts is now available!
In this blog post, we will discuss how to validate at the operating system level the effects of changing the innodb_flush_method to variations other than the default (particularly for O_DIRECT which is most commonly used) and the use of innodb_use_fdatasync.IntroductionFirst, let’s define what the innodb_flush_method parameter does. It dictates how InnoDB manages the flushing of data […]
The momentum around Galera Manager development has been amazing. You report bugs or feature requests, and we fix them!
The major reason to release this was to ensure that Galera Manager would accept the new signing keys of Galera Cluster (key ID: 8DA84635).
One will now also note that gm-installer reports a new version: gm-installer version 1.12.0 (linux/amd64). And when you install it, Galera Manager itself is now at version 1.8.3. One of the major fixes is that Ubuntu 22.04 support for self-provided hosts is now exposed in the UI. This fixes …
[Read more]Migrating data from MySQL to Oracle can be a wearisome task with a significant amount of manual effort. It can be streamlined with the assistance of two Devart products: dbForge Studio for Oracle and the ODBC driver for MySQL.
The post How to Migrate from MySQL to Oracle: A Comprehensive Guide appeared first on Devart Blog.
This post introduces Generated Invisible Primary Keys (GIPKs) and how to enable them with MySQL HeatWave.
Oracle recently released MySQL 8.0.36 and MySQL 8.3, and this is a perusal of the release notes to determine what is new, what is in the seventy-three bugs fixed, and what has changed in the three months since the last releases. Comments in italics are my own and do not reflect the view of anyone […]
Maintaining a production dataset at a manageable size can present a considerable challenge during the administration of a MySQL InnoDB Cluster.
Old Days
Back in the day when we only had one main copy of our data (the
source), and one read copy (the replica) that we used to look at
current and old data from our main system, we used a special
trick to remove data without affecting the replica. The trick was
to turn off writes to the binary log for our removal commands in
the main system. External tools like pt-archiver were also able to use that trick. To
stop bypass writing into the binary log, we used the command:
SET SQL_LOG_BIN=0
.
This mean that on the main production server (replication source), we were purging the data without writing the delete operation into the binary logs:
Current Days
These …
[Read more]MySQL January 2024 GA Releases Now Available
Understanding how to merge or join strings together in SQL is crucial for handling data effectively. This is especially handy when you’re creating SQL queries, helping you combine info from different columns, make meaningful labels, and get data ready for analysis. In this guide, we’ll tell you how to write an SQL query to concatenate […]
The post Concatenate Strings in an SQL Query With Examples appeared first on TechBeamers.
Recently I noted a strange MySQL replication error in a Percona XtraDB Cluster (PXC) node replicating from a standard MySQL instance. “Node has dropped from cluster”. This is a quick blog…
The post Node has dropped from cluster error in Galera Cluster first appeared on Change Is Inevitable.