Question : On a site-redundant galera cluster, a commit should only return after a quorum of database nodes have accepted […]
Tag: binlog
Why do the MySQL bin log files still exist after a purge or flush?
Question : I’ve used PURGE BINARY LOGS as well as FLUSH LOGS, but the mysql directory still contains these files: […]
Purge mysql log bins older than two weeks automatically
Question : I have to manually write purge binary logs bin to “mysql-bin.somenumbers” ; Once in a while, I need […]
what happens If I remove mysql-bin.index file?
Question : Because of the file storage full, we are removing mysql bin log files. Accidentally, we removed mysql-bin.index file. […]
How do I make binlog-format=ROW the start up default in the /etc/my.cnf file?
Question : I can run the query SET GLOBAL binlog_format = ‘ROW’ and it works for that session. How do […]
MariaDB replication failure: Fatal error 1236 – binlog shows ‘Event truncated’
Question : Disclaimer: I am not a certified DBA I have configured MariaDB Master – Slave replication and everything was […]
Risks of sync_binlog = 0 for mysql
Question : I’m trying to understand the risks of sync_binlog=0 for MySQL. We do not have a slave database, and, […]
MySQL Exec_Master_Log_Pos value greater than Read_Master_Log_Pos
Question : I am trying to repair one MySQL replication setup. One of the database’s table at slave side is […]
recovery with binlogs?
Question : I would like to know if there is a way that I can restore my databases, I don’t […]
Purging Binary Logs from Master in a Replication Environment
Question : Replication Set up 6 Masters and their respective Slave. All 6 slaves writing to a Master – which […]