Questions tagged [binary-log]
7 questions
5
votes
1 answer
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 following command:
mysqldump -u root -p…
Justin
- 151
- 1
- 6
3
votes
0 answers
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 it's transactions. Each server also has a…
Joel
- 31
- 1
2
votes
2 answers
--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 'bin|slave'…
quanta
- 50,327
- 19
- 152
- 213
1
vote
2 answers
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 minutes or so..
here are my takes so far:
start mariadb…
BostonMacOSX
- 141
- 5
1
vote
1 answer
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 the last full backup.
Not too long ago, it was…
Douglas Rapp
- 13
- 3
1
vote
2 answers
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 implying that MySQL would have this since they are…
Corey S.
- 2,379
- 1
- 18
- 23
1
vote
1 answer
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 logged into the general log and also appear in the…
sch0b
- 11
- 2