Questions tagged [binary-log]
The binary-log tag has no summary.
7 questions
1 vote
1 answer
90 views
SQL statements containing $ character are sucessfully passed through MariaDB
I have been figuring out mysqlbinlog restore issue for some days and I have found that it is caused by some uncomplete SQL statements which are containing $ character. Following SQL statements are ...
- 11
2 votes
2 answers
4k views
Correct way to have a mysql/mariadb incremental backup
I've read for a few hours on this topic but don't have a complete grasp. I'm going to be using borg backup to a network share. Looking to have pretty frequent backups of the binlog....every 5 ...
- 150
3 votes
0 answers
775 views
combine two mysql replication log files
So I use a master-master replication of a mysql database and load balance traffic between the two. This results in server A with a binlog of all it's transactions and Server B with a binlog of only ...
- 31
6 votes
1 answer
8k views
MySQL - Unable to enable binary logging
I'm trying to enable binary logging so that I can set up master-slave replication between two servers. I'm working with an existing server with lots of data and I'm trying to dump the data with the ...
- 161
1 vote
1 answer
2k views
MySQL Binary Logging Format - Disk Filling Up
I have a MySQL server instance configured with binary logging enabled. I don't do any replication, but the binary logs are part of our recovery plan - to be able to replay all the transactions since ...
- 13
2 votes
2 answers
8k views
--log-slave-updates is OFF but some updates are still logged to the slave binary log?
MySQL version 5.5.14 According to the document, by the default, slave does not log to its binary log any updates that are received from a master server. Here are my config. on the slave: # egrep '...
- 52.6k
1 vote
2 answers
1k views
MySQL Multiple Binary Log Destinations
I know in Oracle it is possible to specify up to 10 archive log destinations. Does anyone know if it is possible to specify multiple, concurrent locations for the MySQL Binary Log? (And no, I'm not ...
- 2,597