MySQL – determine transaction size

Running 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

Comparisons of Proxies for MySQL

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 Reading

OpenLampTech issue #70 – Substack Repost

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 Reading