How to get MySQL Primary Keys in one minute
Kedar
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…
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.