The binlog tag has no wiki summary.
3
votes
1answer
116 views
Switch MySQL lag slave to new master and keep lagging (5.1)
We have the following scenario:
Set of slaves replicate from the master, separate standby master (a.k.a slave with binlogs) replicates from the same master; lag slave, powered by pt-slave-delay, ...
2
votes
2answers
87 views
How to see what was executed in the database via binlogs for specific date?
I am trying figure out how to "query" binlogs to see what was exectued in the database for a specific date. For example, if I execute mysqlbinlog binlog then the thing just runs forever and it is had ...
1
vote
1answer
120 views
Master updates Slave but not Master itself
I have a setup master/slave in which applications are pointed only to master. Yesterday Master had got crashed due to "multi bit error on dimm detected" in Front indication panel in orange color.
...
1
vote
1answer
122 views
MySQL binary logs - skip a table
Is there a way to skip a specific table in the binary logs?
I've got binary logs configured as my incremental backup strategy between nightly backups. But we have one huge reference table that we're ...
1
vote
2answers
983 views
Error reading MySQL 5.5 binary log using mysqlbinlog
I'm having some trouble with a replication setup I'm using. It has been working fine for months, and then over the weekend, the slave stopped reading updates from the masters binlog with an error Got ...
1
vote
1answer
262 views
How soon after updating expire_logs_days param and restarting sql will old binlogs get deleted?
MySQL 5.1.x | InnoDB | Windows
My mysql data directory is starting to fill up with bin logs.
I currently have the following settings configured in my windows mysql server:
[mysqld]
log-bin
...
1
vote
0answers
100 views
How to restore deleted rows from a binary log?
Background
I am trying to recover a few thousand rows that were accidentally deleted from a MySQL database. Luckily replication is enabled, so in the binary logs I have a record of each INSERT, ...
1
vote
1answer
410 views
Binlog has bad magic number
I keep getting this error whenever I start MySQL.
121028 1:38:55 [Note] Plugin 'FEDERATED' is disabled.
121028 1:38:55 InnoDB: The InnoDB memory heap is disabled
121028 1:38:55 InnoDB: Mutexes and ...
0
votes
2answers
284 views
How can you monitor if MySQL binlog files get corrupted?
I was wondering if there was any nice way to continuously monitor mysql master binlog files and detect if get corrupted.
0
votes
1answer
37 views
Strange characters in mysqlbinlog output
Has anyone experienced this? Data replicates fine but when output in mysqlbinlog there are hidden characters that break the input?
mysqlbinlog Ver 3.3 for Linux at x86_64
mysql 5.5.28 server
...
0
votes
2answers
110 views
Replication master binlog rotation when network is unavailable
I recently experienced an issue where the binlog file in master rotated because network connectivity between the slave and master was unavailable.
After solving the network issue, the slave was not ...
