Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [binlog]

The tag has no usage guidance.

0
votes
0answers
9 views

Binary log CLOUD SQL

Good day , my colleague was trying to get a backup from cloud sql using binary log, is there a chance to get the binary log with a specific date and time?
1
vote
1answer
28 views

MySQL store current binary log in different folder from past binary logs`

Is there any way to do this? Specify a different directory for currently active binary log. (It would nice if possible, because then we could store past binary logs in a compressed file system ...
0
votes
1answer
49 views

mysql - 35GB binlog files are cached in OS cache

I have a mysql database with 5.6. Binary logs are enabled and it has 5 slaves. GTID mode enabled. Maximum binlog file size is 1GB. sync_binlog = 0 When I check the free -gh total ...
0
votes
1answer
349 views

enabling BINARY LOG on AWS RDS MySQL

Context I am trying to enable BINARY LOGs on a MySQL RDS instance. Issue I used CALL mysql.rds_set_configuration('binlog retention hours', 24) without encountering an error. And using CALL mysql....
0
votes
1answer
39 views

How does MySQL rotate binary log files when number extension reaches its maximum?

Assume the bin-log file format is: something-bin-log.000122. With each file has a maximum of 1GB size before rotating, and with cap on the number of old binary log files - say 14 days. What will be ...
0
votes
1answer
29 views

Mysql Slave - Stop applying changes from a particular user

I have a mysql master and 3 slave. In the master im running Archive commands to delete old records everyday. But I don't want to Purge the records on the Slave 3. Im using this as a Archive DB. So,...
0
votes
0answers
136 views

mysql-binlog-connector-java - find first log file name in binary log index file ERROR

I am doing a POC on this library, and I am having some difficulties setting it up. I have an extremly simple MySQL setup: a single VM (no master-slaves) centos 7 MySQL version 5.7 Here is the code ...
1
vote
1answer
75 views

pt-query-digest --type binlog (percona-toolkit) gives empty output with MariaDB/Galera 10.1

My installed versions of MariaDB and Percona Toolkit on MacBook: brew info percona-toolkit percona-toolkit: stable 3.0.10 (bottled), HEAD Percona Toolkit for MySQL https://www.percona.com/software/...
0
votes
0answers
73 views

Cannot reset mysql-bin file to 01

I have server running centos 6.9 with mysql 5.5.5 , the Mysql-bin file wont reset back to mysql-bin.000001 Here is the output for the master status command mysql> SHOW MASTER STATUS ; +-----------...
2
votes
3answers
2k views

Maximum overall size of MariaDB binary logs

I am looking for a way to prevent MariaDB binary logs from taking a huge size when they grow faster than usual. variable max_binlog_size set the maximum size of ONE binary logfile. variable ...
0
votes
2answers
289 views

Purging Binary Logs from Master in a Replication Environment

Replication Set up 6 Masters and their respective Slave. All 6 slaves writing to a Master - which has its own Slave. Now, I want to purge binary logs on the 6 original masters and set expiry to 15 ...
0
votes
1answer
309 views

Disable Binary Logging During MySQL Dump

I do apologize if this has been asked before but my search skills were not able to turn up a definitive answer. SITUATION: I have two Windows Server 2012 R2 servers running WAMP 3.06 (which contains ...
1
vote
1answer
79 views

Error - enabling bin log in mysql

I have a mysql server with 5.5. I tried to enable the binlog using the below config file. # BINARY LOGGING # server_id = 1 log_bin = /mysql/binlog/...
0
votes
1answer
175 views

Can Select but not Insert from SQL Server to MySQL

I'm having a problem with inserting data from SQL Server to MySQL. I saw this syntax that helped others: EXEC master.dbo.sp_addlinkedserver @server='MYSQL', @srvproduct='MySQL', @provider='MSDASQL', @...
0
votes
0answers
42 views

Master binlog has stopped

Couple of days ago all of my slaves weren't able to sync data from the master. After searching deeply, Here is my findings: 1- Seconds_Behind_Master= NULL. All the slaves. 2- The error was 'binlog ...
0
votes
1answer
818 views

Unable to start mysqld service after enabling log_bin

Hi I am unable to start mysqld service after I make changes in my.cnf to enable log-bin. After making changes the file looks like below: # For advice on how to change settings please see # http://dev....
0
votes
0answers
549 views

MySQL Replication - Mixed Mode Error 1032

Im using MySQL replication with binlog_format=mixed on both master and slave, but still Im getting error 1032. [ERROR] Slave SQL: Could not execute Update_rows event on table mydb.mytable; Can't ...
2
votes
1answer
2k views

What is the significance of sync_binlog?

What is the significance of sync_binlog? What exactly happens If I set sync_binlog=1? How does it affect the replication between master and slave?
0
votes
1answer
853 views

Target log not found in binlog index, from purge binary logs mysqld-relay-bin

I am trying to run the following. mysql > purge binary logs to 'mysqld-relay-bin.000075'; ERROR 1373 (HY000): Target log not found in binlog index # cat ./mysqld-relay-bin.index /srv/mysql/logs/...
0
votes
0answers
265 views

Can add a new database to binlog-do-db without restart MySQL?

My MySQL version is 5.6.24,running on CentOS 7.0. My my.cnf on the master has: binlog-do-db = aaa123 binlog-do-db = bbb123 binlog-do-db = ccc123 binlog-do-db = ddd123 binlog-do-db = eee123 binlog-do-...
1
vote
2answers
240 views

Is it safe to copy the binlogs from a running mysql server

I want to backup a tokudb database. I want to be able to restore it to the most recent state. Which I am writing to a file at backup. My guess would be to run something like this mysql -e "SHOW ...
1
vote
1answer
224 views

sync_binlog different for master and slave

Is it fine if sync_binlog is different for master and slave? For my system I can see master has sync_binlog=1 and slave has sync_binlog=0.
0
votes
0answers
56 views

Copy un-replicated Bin logs from Master to Slave , if Master goes down MySQL 5.7 Enterprise

I have async-Classic file based replication with 2 Nodes as Active - Active. R/W is happening on Primary Node (PN) only and Secondary Node (SN) has been setup as HA only. SN has been configured as ...
2
votes
1answer
2k views

MySQL - Binary Log File size growing more than the maximum limit

I have a MySQL 5.7 running on a Centos 6. I enabled Binary Logging and didn't provide any custom value for the maximum size of Binary Log in my configuration file. By default, the parameter ...
1
vote
2answers
759 views

PURGE BINARY LOGS taking time

We are observing high latency for some queries, digging further we found that every 5 minutes the queries take long time by examining the slow query logs. We observed that PURGE BINARY LOGS TO '...
0
votes
1answer
26 views

How could I use binary log as relay log?

I has a full backup of MySQL, and binary logs from the time of starting full backup.Can I restore the data in another instance use replication like only start slave sql_thread; rather than mysql < ...
0
votes
1answer
154 views

Purge old binlogs in mysql 4

I need to purge binary logs from mysql version 4. I have checked the manual found that the syntax is like an advanced versions: PURGE MASTER LOGS TO mysql-bin.xxx However, when i use this command, i ...
0
votes
1answer
66 views

recovery with binlogs?

I would like to know if there is a way that I can restore my databases, I don't have a replication and I would like to migrate my databases without downtime or losing data. So with binlogs could I do ...
2
votes
2answers
202 views

Race condition in mysql / percona innodb binlog for master -> slave

I'm having a really hard time diagnosing and working around a race condition that is causing problems on my slave and knocking it offline due to a foreign key relationship. We're using MIXED format ...
0
votes
2answers
493 views

Is it safe to disable sync_binlogs, innodb_flush_log_at_trx_commit and innodb_doublewrite on a site-redundant galera cluster?

On a site-redundant galera cluster, a commit should only return after a quorum of database nodes have accepted the transaction. If one database node goes down, all commits will be preserved by the ...
0
votes
2answers
363 views

Mysql binlog filename keeps changing, preventing replication

First off, some versions: Centos 6, mysql 5.1 are what I'm stuck with using for now. So - The problem is that when I replicate using either of these methods: A: From the manual, unavailable via ...
0
votes
2answers
405 views

Replication error from Mariadb 10.1 to Mysql 5.1/5.0/5/5 when master's logging format is set to row based

While replicating from Mariadb 10.1 to MySQL (5.0, 5.1, 5.5) or Mariadb (5.2, 5.5) lower versions, if master's binlog_format is set to row, the replication failure occurs with the following message ...
2
votes
2answers
629 views

MySQL replication slave hangs after encountering SET @@SESSION.GTID_NEXT= 'ANONYMOUS';

I recently installed two identical default installations of MySQL 5.7 under Ubuntu Server 16.04, and configured them to do a binary log replication. Until now this has been working fine, but suddenly ...
4
votes
1answer
317 views

MySQL replication: purge_logs giving error

On a MySQL replication instance I have this error message: [ERROR] MYSQL_BIN_LOG :: purge_logs Was called Expired with file / db-space-no-connected-cpa / DBMS / dxnc6sla / arch / not listed in the ...
2
votes
1answer
470 views

Add query executed user information to Mysql binlog

We are using MYSQL as our production database and we have setup another salve for read requests. Time to time various database users can execute insert/update queries on master database. If we want ...
1
vote
1answer
7k views

replicate-ignore-table setup and usage for excluding table from binlog backup

I need to make an everyday backup of a mysql database that is very big on a remote server and I only want to get the difference since the last backup. I also need to exclude some tables from being ...
2
votes
1answer
407 views

How can you close or flush a binlog file on a remote server

I am replicating my binlog files to a secondary server using the mysqlbinlog --stop-never --read-from-remote-server flags. If the primary database server is compromised I want to replay the binlogs ...
3
votes
3answers
836 views

In MySQL, how exactly does data flows from query to disk?

I would like to have clarity on how exactly data flows from the the time of firing a query till it goes to disk. (I have rough idea it will go to buffers, then to redo logs then disk files) but then ...
1
vote
1answer
47 views

Contradictory reports from MySQL that a binlog file exists

Our replication recently stopped working. I submitted a question but was unsuccessful in fixing the problem (Error 1236 - "Could not find first log file name in binary log index file"). ...
1
vote
2answers
310 views

Partial mysqlbinlog on latest binlog file

I'm trying to do a partial mysqlbinlog on the latest binary log file at a certain position therein (trying to extract just one query). mysqlbinlog --start-position=1234 --stop-position=1234 /var/lib/...
1
vote
1answer
202 views

Changing tx_isolation and binlog format on master server - do i also need to adjust slave?

We are running a Drupal Commerce site with MariaDB 10.0 and master/slave replication. Because of the way our application works, we end up running in to a ton of deadlocks under heavy load. Apparently ...
1
vote
2answers
5k views

Mysql FLUSH LOGS in live server with replication

I need to run the slow query and unindexed query logging for some time on a live production db with replication. Changing GLOBAL const value sounds like a good solution. This article also provides ...
0
votes
1answer
210 views

Mysql datadir and binlogs: same partition or not?

On a MySQL cluster, does it make sense to store MySQL database files and binlogs in different partitions? (This is about partitions on the same physical disk. If they were on different physical disks,...
0
votes
1answer
718 views

mixing binlog formats between master and slave

I have a pretty much straightforward Master --> Slave replication setup in MySQL 5.6 / Innodb. Both my Master and Slave are setup in MIXED binlog format. Now I need my slave to act as a master to ...
2
votes
1answer
226 views

MySQL binlog does not show SQL statements

While checking the binlogs, it struck me that I cannot see any SQL statement. Here's an example: $> sudo mysqlbinlog --database=securities --start-datetime='2015-11-26 13:00:00' --...
0
votes
1answer
185 views

Suddenly a massive amount of binlog files

I've seen a sudden increase of binlog files, very large in number and size, in all three nodes of a Percona XtraDB cluster: -rw-rw---- 1 mysql mysql 1,1G 19 oct. 16:11 binlog-32.000001 -rw-rw---- ...
0
votes
0answers
627 views

Mysql server does not start if binary logging is disabled

I have been trying to disable binary logging on a slave server, since I do not use it as a master for another one, I have no use for the logs and I am trying to reduce lag so cut out everything that ...
0
votes
1answer
371 views

mysqlbinlog: unknown variable ssl_key or ssl_cert or ssl_ca

I am trying to recover binlog from a remote server using mysqlbinlog client program, however it appears that mysqlbinlog doesn't recognize the SSL options that's required to establish SSL connect to ...
1
vote
1answer
741 views

mysql max_binlog_size is not working

I have a weird problem. I am currently using mysql and have defined 100M of max_binlog_size. However, I have hundreds of files created every day and each file is of no more then 2MB or 3MB each and ...
1
vote
2answers
5k views

How can I parse mysql bin log file for statements (Row/Mixed Format)

I have a mysql database running with binary log enabled. Unfortunately, a statement was executed by the client, which turned out erroneous. Since a number of records have been "affected", I want to ...