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 [mysqlbinlog]

mysqlbinlog : Utility for Processing Binary Log and Relay Logs

-1
votes
0answers
21 views

mysql aborts during restore

Windows 10 Pro mysql 5.7.23 Win64 (all servers) Python 3.6.6 Aim: Kind of master-slave replication system using python script. Only master is enabled to create binlog file. Slave part is managed ...
-1
votes
0answers
9 views

Data for only 2 tables not getting replicate on slave

I have set up of Master slave in MIXED binlog format. All servers are 5.6.22 version. On master data is getting inserted but on slave for two tables data is not getting replicate. For other tables and ...
0
votes
0answers
24 views

MySQL binary log uncontrolled growing

This problem starts after connect a new slave to my master replication server. All servers have Centos 7 MySQL 5.7.22 16 GB Ram available 12 GB RAM for innodb_buffer_pull_size my.cnf (only ...
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
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
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 ...
0
votes
1answer
35 views

Point In Time recovery on Mysql

Can someone please advise best methods to do a mysql PITR from binary logs that are saved in MIXED format. I am finding it difficult to identify the wrong queries that executed to avoid from restore ...
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/...
3
votes
2answers
55 views

MySQL binlog missing queries

In direct reference to the accepted answer in this question MySQL doesn't log to the binary log file when you use direct database.table syntax in your update queries (eg. UPDATE Foo.Bar SET ...). ...
1
vote
0answers
114 views

My node js server stops listening on mysql db

I implemented a listener on a table in a MySQL database with a MySQL event that is based on listening on binlog. However, the problem is that after a while my node.js server stops listening on the ...
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 ; +-----------...
0
votes
1answer
66 views

How to maintain production database with less data and report database with all data [closed]

We have a large database. We want to remove previous months data from Prod DB and keep only 3 months data. We also want a Report DB with all data. For Example: we have restored complete Prod DB ...
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
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
1answer
52 views

(memery table)MySQL master/slave replication on the same server, after restart MySQL err: 1381 (HY000): You are not using binary logging

It's used for replicating a memory table, before restart, there is no err info and replication works fine. I have tried modifying my.cnf and restarted MySQL for many times, but it doesn't work show ...
0
votes
1answer
83 views

why binlog doesn't log the DML statement?

two method compared 1. use test; create table t (a int); 2. create table test.t1(a int); my result is the first one can log the binlog but the second one can't not use test;create table t(a int); ...
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 ...
0
votes
1answer
57 views

How to restore several databases with binlogs?

I need to restore 3 databases but I don't have the backups of the, I investigate that it can be done with the binlog files, but how does that work when you have several databases that need to be ...
1
vote
0answers
86 views

Cannot read sql statement into mysqlbinlog

Mysql 5.7 on Windows: show global variables like 'binlog_format'; using me the STATEMENT show master status; gives me log-bin.000053 Now I execute this: DELETE FROM test.emp WHERE EMPNO=109; ...
0
votes
0answers
307 views

MySQL Row Based Replication, how to find failed entry in binary log?

I'm looking at moving my production systems from Statement Based Replication to Row Based Replication, but in my testing I am finding it very difficult to locate problems in the binary logs. For ...
1
vote
1answer
387 views

Mysql database offline-online synchronization

I need to synchronize database on server with database of local server upon active internet connection. For its implementation I execute mysqlbinlog utility to read transaction logs and write the ...
2
votes
0answers
31 views

what is the efficient way of read mysqlbin log to keep informed about every event in sqldb?

I want to keep updated about tranformation happening in mysql db and based on each event i want to do some processing and send data to some rest api on other server. My plan is : Read mysqlbinlog ...
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 ...
2
votes
0answers
45 views

Find the correct entry in myqlbinlog (using Row Based Replication)

I've just started testing Row Based Replication on my MySQL 5.5. databases. I have now got the following error: Could not execute Update_rows event on table dbname.tablename; Can't find record in '...
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 ...
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/...
0
votes
1answer
57 views

Mysql master slave communication

I was just working on mysql master-slave setup for incremental data backup from master to slave. For that I have to enable "bin log" in the master machine. So my doubt is how does master and slave ...
1
vote
2answers
535 views

Can I remove binary log files not listed in mysql-bin.index?

We've had some problems with one of our more elderly MySQL servers (version 5.045). The database is back up and running OK but there were over twenty thousand binary log files in the mysql folder. I ...
3
votes
1answer
82 views

MySQL binary log reporting execution time as UINT_MAX

Looking through the MySQL Binlogs, I see some data that just does not make sense. There are queries that say they have been running for 4294967295 seconds (which also happens to be UINT_MAX on this ...
0
votes
1answer
509 views

How to restore truncated MySQL table from binary logs?

I have a mysql server and while working on it I accidentlly truncated the wrong table. I do have a mysql dump wich I immediately used to restore my database structure, but I still miss some entries in ...
0
votes
1answer
410 views

MySQL Error wth Relay logs - Could not open relay logs file for logging

We are receiving the following error. 2016-03-08 15:32:09 1184 [ERROR] MYSQL_BIN_LOG::move_crash_safe_index_file_to_index_file failed to move crash_safe_index_file to index file. 2016-03-08 15:32:09 ...
0
votes
1answer
235 views

Is it safe to sync MySQL binlogs?

I am working on a strategy to replicate my MySQL binlogs to Amazon s3. I have looked into mysqlbinlog --remote-server but it seems like adding a file watcher on /var/log/mysql which triggers an aws ...
3
votes
1answer
330 views

why my MySQL binary log file size is so small?

I have a lot of small binary log files , each of them just only 126 Bytes -rw-rw----. 1 mysql mysql 126 Jan 6 16:13 mysql-bin.000001 -rw-rw----. 1 mysql mysql 126 Jan 6 16:16 mysql-bin.000002 -rw-...
0
votes
1answer
1k views

Size of Binary log file in Mysql Replication

I have a master - server replication setup in Linux servers. Master Configuration details : MySQL version is 5.1 and replication mode is MIXED type. Slave Configuration details : MySQL version ...
1
vote
1answer
78 views

Binary log backups in MySQL

I'm running a master-master replication with read-only second master. Now since my binary logs are not getting replicated in my passive master. Should I need to enable --log-slave-updates? If I ...
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
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 ...
3
votes
1answer
5k views

How do I get the MySQL binary log coordinates from the binary files?

I'm attempting to set up replication for a large (120 GB) MySQL database and I messed up. I shut down the master, copied the data files, and restarted the master. Now I've set up the slave & ...
1
vote
1answer
638 views

MySQL binlog limitations

I have a MySQL instance running on AWS, with around 5000 inserts per second. Any idea what the performance impact will be if I use binlog (row) and a binlog tailer? Check this link From my ...
5
votes
3answers
6k views

Show sql statements from mysql binlog (GTID)

I have mysql binlogs for replication through GTID. I'm trying to show executed update/insert statements like this: mysqlbinlog --base64-output=DECODE-ROWS mysql-bin.000024 But all I see is ...
1
vote
2answers
742 views

Why is restoration from binary logs so slow?

We have a MySQL 5.5 server with binary logging enabled and a backup script that collects the binary logs and, once a day, generates a complete database dump with mysqldump. In testing database ...
0
votes
2answers
3k views

Shell script for backup binlog files for every 8 hours in MySQL

I'm writing a shell script for point in time recovery for MySQL Instance. Our requirement is backing up Binlog for every 8 Hours (Daily 3 times) using mysqlbinlog and it should backup binlog starting ...
2
votes
1answer
4k views

Hi disk I/O and crash when turning on sync_binlog in MySQL

I have a MySQL master server (MariaDB 10.0.17) that have a very odd behavior. It has one slave fetching data from it. When I set global sync_binlog = 1, the server I/O goes very high and after some ...
0
votes
1answer
367 views

what will happen to the binary log if it reaches its maximum value ? Does it reset to mysql-bin.00001 again?

what will happen to the binary log if it reaches its maximum value ? Does it reset to mysql-bin.00001 again ? I know the below points exist means, there won't be any reset happen in binlogs. I would ...
4
votes
1answer
3k views

Is it possible to gain the precise position of a live mysql database when performing full backup

I have a production database that I usually run fullbackups on once every week. I have bin logs turned on for incremental backups. The production server is on the west coast while business hours are ...
1
vote
1answer
3k views

How to track only DDL statements executed in MySQL

Can we track only executed DDL statements in MySQL but not DML statements. I dont want to use either binlog/general log to enable. I just wanted to track only DDL statements. I had gone through the ...
0
votes
1answer
1k views

mysqlbinlog recovery table wise

I am going to restore my MySQL database table using log files. My database name is "decsys" . I have already created sql using log files C:\wamp\bin\mysql\mysql5.5.8\bin>mysqlbinlog -d decsys C:\...
3
votes
1answer
247 views

Is there any drawback of MIXED replication mode?

So, recent mysql server allows three types of replication mode: STATEMENT, ROW, MIXED. They all have pros/cons, and I pick the mode according to site characteristics. When I get a replication error I ...
1
vote
1answer
885 views

Myloader command: Table doesn't exist

I took the backup of mysql database using mydumper command: mydumper -B mydb -o /backup/oct3 -s 500000 -c -m -S /tmp/mysql.sock -u root -p password@123 -v 3 Now, I am restoring mysql database ...