May
20
2024
--

Can We Set up a Replicate Filter Within the Percona XtraDB Cluster?

Set up a Replicate Filter Within the Percona XtraDB ClusterIf you were to ask me the question, “Would it be possible to set up a replicate filter within the Percona XtraDB Cluster?” my immediate response would be to question you right back. Why would you even want the cluster nodes to have different data when you’re using a synchronous replication cluster? That’s because, instinctively, […]

May
13
2024
--

Seamless Table Modifications: Leveraging pt-online-schema-change for Online Alterations

Seamless Table Modifications in MySQL pt-online-schema-changeTable modifications are a routine task for database administrators. The blog post Using Percona Toolkit to Alter Database Tables Online: A Controlled Approach provides insights into the process of altering tables online in a controlled manner, ensuring uninterrupted access for application users and preventing application downtime. We will focus here on utilizing the powerful “pt-online-schema-change” […]

May
01
2024
--

MySQL 8.4 First Peek

MySQL 8.4 First PeekMySQL 8.4 has now been officially released, and this is a quick review of what is in the release notes. This is momentous as it is designated a Long-Term Support (LTS) release. Various 8.0 releases introduced material changes that impacted speed and stability, causing hair-pulling and swearing among those affected. Please note this is a […]

Feb
06
2024
--

MySQL 8.2.0 Community vs. Enterprise; Is There a Winner?

MySQL 8.2.0 Community vs. EnterpriseTo be honest, the comparison between the two MySQL distributions is not something that excited me a lot. Mainly because from my MySQL memories, I knew that there is not a real difference between the two distributions when talking about the code base.To my knowledge the differences in the enterprise version are in the additional […]

Feb
06
2024
--

Are Your MySQL Users Using ‘password’ or ‘thebossisajerk’ as Passwords?

MySQL password securityAre your MySQL users using ‘password’, ‘s3cr3t’, or ‘thebossisajerk’ as their passwords? Easy-to-guess passwords can be disastrous to the security of your data, but there is a way to exclude inappropriate words or phrases from being used. The first step is to compile a list of words and phrases you want to exclude, and that […]

Feb
01
2024
--

In Search of Transparency at FOSDEM

FOSDEM – In Search of TransparencyFOSDEM is for sure one of the most respected free and open source software-focused conferences in Europe, which is loved by many, myself included. It is from the point of love I am raising concerns about transparency, which seems to be lacking in regard to some processes at FOSDEM.For many years, as long as I […]

Jan
31
2024
--

MySQL Table Size Is Way Bigger After Adding a Simple Index; Why?

MySQL Table Size Is Way Bigger After Adding a Simple IndexIt is a known good practice to keep only necessary indexes to reduce the write performance and disk space overhead. This simple rule is mentioned briefly in the official MySQL Documentation:https://dev.mysql.com/doc/refman/8.0/en/optimization-indexes.htmlHowever, in some cases, the overhead from adding a new index can be way above the expectations! Recently, I’ve been analyzing a customer case like […]

Jan
18
2024
--

Syscalls Analysis in MySQL When Using innodb_flush_method and innodb_use_fdatasync

MySQL When Using innodb_flush_method and innodb_use_fdatasyncIn 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 […]

Jan
17
2024
--

Quick Peek: MySQL 8.0.36 and 8.3

Quick Peek MySQL 8.0.36 and 8.3Oracle 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 […]

Jan
12
2024
--

Can’t We Assign a Default Value to the BLOB, TEXT, GEOMETRY, and JSON Data Types?

Default Value to the BLOB, TEXT, GEOMETRY, and JSONOne of our customers wants to create a table having a column of data type TEXT with the default value, but they encountered an error: [crayon-65a58ffb54a4c454230324-i/]. It seems reasonable at first glimpse, as we know that each BLOB, TEXT, GEOMETRY, or JSON value is represented internally by a separately allocated object. This is in contrast […]

Powered by WordPress | Theme: Aeros 2.0 by TheBuckmaker.com