In this blog, I’ll discuss the use case for replication. We want to improve our ability to replicate your data and limit replication to row-based events securely, wherein we do not have control over the source(s). The replica doesn’t have checking capabilities when processing replicated transactions as of MySQL 8.0.18. It does this to carry […]
Continue Reading
This article is the second of the new series dedicated on how a DBA can find the info he needs with MySQL Database Service in Oracle Cloud Infrastructure. The first article was dedicated on Backups, this one is about Disk Space Utilization. This time we have two options to retrieve useful information related to disk […]
Continue ReadingNew series of articles about how to find useful information when using MySQL Database Service
Continue ReadingRunning MySQL InnoDB Cluster / Group Replication, there is a transaction size limit (https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_transaction_size_limit) The default value of “group_replication_transaction_size_limit” is about 143 MB (150000000 bytes) How can we determine the size of a batch job (single transaction) in MySQL? Setting a small value with variable group_replication_transaction_size_limit and running the transaction produces the error message in […]
Continue Reading
With a special focus on Percona Operator for MySQL Overview HAProxy, ProxySQL, MySQL Router (AKA MySQL Proxy); in the last few years, I had to answer multiple times on what proxy to use and in what scenario. When designing an architecture, many components need to be considered before deciding on the best solution. When deciding […]
Continue ReadingA friend’s application started failing with MySQL causing error about timestamp columns and it needs urgent fixing from the database side. A timestamp column was not accepting the null values and they were sort of down. In this blog we will learn how MySQL is telling you, to follow what you say. When you define […]
Continue Reading
In this new series of articles we will explore the different sources of information available when using MySQL Database Service on OCI to effectively perform your daily DBA job. Of course there is way less things to take care of, like backups, upgrades, operating system and hardware maintenance, … But as a serious DBA, you […]
Continue Reading
I’ve been enjoying OpenLampTech for 70 weeks now. Wow! That’s a lot of publishing. But, more importantly, a lot of learning. And forming relationships with the readers. I am so grateful you are reading OpenLampTech. Thanks! The Newsletter for PHP and MySQL Developers Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely […]
Continue ReadingNew series of articles about how to find useful information when using MySQL Database Service
Continue ReadingMySQL book review: SQL Antipatterns, volume 1
Continue Reading