Stack Overflow
Stack Overflow

Questions tagged [mysqlbinlog]

mysqlbinlog is a MySQL Utility for Processing Binary Log Files

mysqlbinlog is a MySQL Utility for Processing Binary Log Files

The server's binary log consists of files containing “events” that describe modifications to database contents. The server writes these files in binary format. To display their contents in text format, use the mysqlbinlog utility

Docs: https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog.html

MariaDB Docs: https://mariadb.com/kb/en/library/using-mysqlbinlog/

134 questions
0
votes
1 answer

Is it possible to have a millisecond precision for the Timestamp in a BinLog?

We are working with a MariaDb 10.4.14 and we stream the binlog with the Debezium suite. We encounter an issue because the Timestamp in the binlog streamer is a uint32 which does not provide a millisecond precision. Do you know if it is possible to…
kiki
  • 563
  • 4
  • 17
0
votes
0 answers

Show Binlog retention on MySQL prior to version 5.6

How can I see the current Binlog retention setting for MySQL 5.5.53? I know that version 5.6 has the command: CALL mysql.rds_show_configuration; Is there an equivalent for versions prior to 5.6? I ran this command but I am not sure if this is…
Night Rider
  • 155
  • 8
0
votes
1 answer

binlog not recording DML statement in mysqlcluster

I have created a MySQL NDB Cluster consisting of 2 data node, 1 mgm node and 1 mysqld for testing. Also i have created a slave for NDB to INNODB replication. My binlog are not recording DML statement because of which i am not able to do Point in…
nooruddin dalvi
  • 1
0
votes
1 answer

MySQL data directory stays default with -v flag in docker image

I am trying to start MySQL using docker image, I wanted to have a look at the binlog files, however I couldn't find them in /var/lib/mysql. From a few stackoverflow and Google reads, potential reason could be that mysql doesn't have permissions to…
Raj Malhotra
  • 89
  • 1
  • 11
0
votes
1 answer

MySQL bin log breaking in chunks

I am trying to delete records from a table like DELETE * FROM table WHERE x=1 LIMIT 200000; When I am checking my bin logs it is showing breaking of this delete statement into further smaller chunks like: sql(0): 336 records sql(1): 336…
Daljeet Singh
  • 704
  • 3
  • 7
  • 17
0
votes
2 answers

Unable to connect to the binlog client in NiFi

I'm building a NiFi dadaflow, and I need to get the data changes from a MySql database, so I want to use the CaptureChangeMySQL processor to do that. I get the following error when I run the CaptureChangeMySQL processor and I don't see what's…
asmoth
  • 98
  • 2
  • 9
0
votes
1 answer

MySQL recovery, include binlog position MASTER_LOG_POS

I run a MySQL DB dump like this: mysqldump mydatabase -u root -p --single-transaction --events --routines --quick --master-data=2 --flush-logs --flush-privileges > mydump.sql This creates a dump file, which contains the following line: CHANGE…
user984003
  • 28,050
  • 64
  • 189
  • 285
0
votes
1 answer

lsyncd canot update mysql-bin.00001

I use lsyncd and lsyncd to send file to other server,.sql file is ok,but mysql-bin.00001 canot update. lsyncd.conf settings { logfile = "/var/log/lsyncd/lsyncd.log", statusFile = "/var/log/lsyncd/lsyncd.status", inotifyMode =…
VenbillYu
  • 1
  • 1
0
votes
1 answer

MySQL RDS read replica service is not purging binlogs

We have a replica read database for MySQL (5.6.41) on AWS RDS service, which worked OK for the last 2 years, but it suddenly started to behave very differently during last 3 weeks: it uses space and is not normally returning it back. So I had to buy…
0x49D1
  • 8,505
  • 11
  • 76
  • 127
0
votes
1 answer

Can't open CloudSQL binlog: "No such file or directory"

I am trying to view the MySQL binlog files to trace down the source of a particular query. I used the SHOW BINARY LOGS query to get the names of the existing log files, but when trying to access using the mysqlbinlog command, I keep getting an…
watermelon
  • 118
  • 6
0
votes
1 answer

Kafka messy code - Chinese words become messy code in debezium

I got messy code with debezium: "doulist_name": "2013 豆瓣电影ã€�å�£ç¢‘榜】" There are Chinese words in mysql database, i use debezium to send the data to kafka. I found the Chinese words become messy code when consume the message, how…
feng
  • 17
  • 3
0
votes
1 answer

Set binlog for Mysql 5.6 & Ubuntu16.4

in /etc/mysql/my.cnf: [mysqld] log_bin=mysql-bin binlog_format=ROW server-id=11 then on mysql client: mysql> show variables like '%binlog%'; +-----------------------------------------+----------------------+ | Variable_name …
Jack Ma
  • 153
  • 1
  • 11
0
votes
0 answers

How to just record the special user's action in Mysql's binlog

I want to execute the specific user's modification to the mysql to a mirror database, after research on the search engine, I know I can open turn on the general log config, and select the IDs that produced by the specific user, and map them to…
Chijiaodaxie
  • 15
  • 4
0
votes
1 answer

StreamSets JDBC Producer CDC - Change Log Format Error edit

The idea behind my pipeline is to reflect changes from a MySQL to a PostgreSQL DB. In the future I'll also have a Oracle to PostgreSQL replication. So, from this forum and SDC documentation, I saw that the right way to do it is to use a CDC origin.…
Eilliar
  • 11
  • 4
0
votes
2 answers

How to Resync the Slave database automatically from Master database using a Windows Service?

I am writing a Windows Service program to sync a local Slave database from the Master database continuously. I have a master database called nsbm_syncdb. If I want to Sync the slave database, I have to write the following query. CHANGE MASTER…
Abdullah Mansoor
  • 67
  • 1
  • 11
1 2 3
…
8 9