How MySQL Binary Log Gets Its Number
Kedar
In this blog I share how MySQL binary logs get their unique numbers after noting my observations with MySQL binary logs sequencing. Recently I noted an odd binary log sequencing…
Browsing Category
MariaDB
28 posts
Articles related to MariaDB
What do you need to debug MySQL issues – a checklist
Welcome to the ultimate guide for MySQL issues debugging — your comprehensive MySQL checklist for tackling MySQL database environment challenges. This checklist for MySQL debugging is as useful to a…
How to get MySQL Primary Keys in one minute
This blog post talks about one of the important MySQL configuration, sql_generate_invisible_primary_key, available in MySQL 8.0.30. This will save you from performance bottlenecks due to tables without Primary Key. If…
Quick Look – MySQL Data Directory Files
Do you know what lies inside your MySQL Data Directory? This article is a quick guide about the files stored inside MySQL data directory. Data managed by the MySQL server…
How to fix MySQL federated table error
This blog is about a very odd case of a Federated table error causing unable reach the remote MySQL server and causing to error. I’ll share the approach I tool…
How to replicate without binary logs in MySQL
“How can we replicate without using binary logs” just a thought popped up in my brain during a casual discussion. This blog post is a brain dump of the possible…
4 responses to “How to replicate without binary logs in MySQL”
Another way is to leverage storage replication which just offloads everything from database and can achieve data consistency.
Hi Rama. That’s right, I intended to convey the same when I covered “System-level” section noting “snapshot / drbd like”.
Thanks for suggesting.
Hi Kedar , it was nice blog.if you can share my.cnf files configuration for both MySQL servers .so that we will understand what parameters you were using in this blog .Thank you
There is no specific config for this experiment.