Stack Overflow
Stack Overflow

Questions tagged [binlog]

60 questions
1
vote
1 answer

sync_binlog parameter

I was going through the documentation for sync_binlog parameter and found a discrepancy in sync_binlog parameter documentation. The documentation here http://dev.mysql.com/doc/refman/5.6/en/replication-options-binary-log.html#sysvar_sync_binlog…
Ashu
  • 163
  • 4
  • 13
1
vote
1 answer

MySQL statement based replication: Does binlog contain exact queries executed on master?

We had to debug our web application for an event that occurred some days ago, and all we have are the MySQL replication binlogs (statement replication). Can we depend on those as being exactly the same SQL queries as our web application was…
Michał Bielecki
  • 66
  • 4
1
vote
1 answer

SQL Server differential backup to SQL statements

Is there any way to convert differential backup to SQL statements which will produce identical results when applied? Or any other solution similar to binary log in MySQL?
noonex
  • 1,975
  • 1
  • 16
  • 18
1
vote
0 answers

mysql binlog output file is ambiguous?

I use mysqlbinlog -f -v --base64-output=DECODE-ROWS mysql-bin.00001 > res.000001 my table has a column is varbinary. So res.000001 like this ### UPDATE db.tbl ### WHERE ### @1=967540772 ### @2='\x10\x00c\x01\x00%...' ### SET ### …
MoreFreeze
  • 2,856
  • 3
  • 24
  • 34
1
vote
0 answers

How to exact the data without duplication from mysql logs?

After I took a full backup of DB using mysqldump -u user -p database > backup.sql. After this I used mysql> show master status; +------------------+----------+--------------+------------------+ | File | Position | Binlog_Do_DB |…
Kotesh Malempati
  • 103
  • 2
  • 2
  • 9
0
votes
0 answers

How to notify row changes of rds mysql version 5.6.4?

I need to monitor row changes of 5 tables of an ancient MySQL instance - version 5.6.4. I know that aurora has lambda_call function, so I could combine this function with triggers and get what I need. But, is there a similar solution for this old…
gmilleo
  • 159
  • 8
0
votes
1 answer

cannot enable bin-logs for mysql

I have an old 5.7 mysql database that crashed last week. But i was able to start it again. Now we have an issue where certain settings are disabled but were or are still enabled in my.cnf. The setting are log-bin and errors logs. No logs were logged…
MarvinD
  • 1
  • 1
0
votes
1 answer

Does Kafka support CDC from a source of MariaDB by binlog?

We have a production system running MariaDB, and hope to build an extract-transformation-load (ETL) module with near real-time changed data capture through the database's binary log (binlog) functionality. For the feasibility, we see an online…
James
  • 1,373
  • 3
  • 13
  • 27
0
votes
1 answer

expire_log_days parameter value not updated?

I have one MySQL RDS and i am trying to change the expire_log_days parameter value, but i'm unable to change because it's unmodified parameter. But while i am checking inside database it shows 0, Please find the below screenshot for your…
Krishnakumar
  • 53
  • 5
0
votes
0 answers

why mysql not sync system variables from master to slave

I just tried to execute "set global log_queries_not_using_indexes=ON;" on master, but slave not sync the same system variables. So i'm confused that what does mysql master sync to slave by binlog? include information_schema?
Bowie
  • 1
  • 1
0
votes
0 answers

Debezium MySQL Connector - Primary Server Configuration for binlog_row_image setting

We have a primary MySQL server and a secondary/replica server. Debezium connector is configured to read from the replica server. Per the Debezium documentation, we configured the below settings on the replica server only. Also did a replica server…
Krishnamurthy Hegde
  • 43
  • 6
0
votes
1 answer

Mariadb binlog query event q_flag

I have a program which can read MySQL binlog. Recently I use the program to parse a binlog generated by MariaDb 10.3. I found that there are Q_FLAGS in the QUERY_EVENT which was not specified in the MySQL binlog specification. The Q_FLAG number…
Gerald Me
  • 107
  • 1
  • 2
  • 8
0
votes
0 answers

What does generated by server on drop tables mean

Hi i create a new table using phpmyadmin create table not query and suddenly all my tables are recreated by itself and lost all data i tried to check last binlog and i found some strange lines like this : SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/; #…
Aref Makke
  • 1
  • 3
0
votes
2 answers

MySql Binlog Update Statement Where Clause Has All Table Columns, Even If Client Uses Just Primary Key In Where Clause When Running Query

On Examination of BinLog Found Following Statement : It has All table columns in where clause. The query I passed to mysql had only 1 Column- Primary Key Column, then why the log wrote all columns in BinLog? I have a particular problem with BinLog…
user1070759
  • 23
  • 7
0
votes
0 answers

Whether table names and db names are case sensitive in mysql binlog file

I create a table as follow: create table INTERFACE_INFO_PK_SIMPLE ( API_ID VARCHAR(128) not null primary key, API_METHOD VARCHAR(24), API_PATH VARCHAR(1024), API_STATUS VARCHAR(8), API_COMMENT VARCHAR(510), API_TYPE…
Kami Wan
  • 724
  • 2
  • 9
  • 23
1 2
3
4