Stack Overflow
Stack Overflow

Questions tagged [binlog]

60 questions
0
votes
1 answer

MySql:If i set binlog format to row,dose change buffer still valid？

When i use "satement" binlog and non-unique index,mysql will use "change buffer" avoid reading from disk. But if set binlog format to "row", binlog need the all columns in the row , so mysql must read from disk.So in this case , dose "change buffer"…
wenbin
  • 3
  • 1
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
2 answers

Bin Log (Tail Log) in Google Cloud Spanner

Can we get bin log of DML statements execution in Google Cloud Spanner. Tried enabling "Data Access Write" Logs, but it does not give the same bin log as mysql or other relational…
Chandan Bhattad
  • 351
  • 1
  • 5
  • 21
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
1 answer

Where can I find a variable about max bin log files in Maria DB ( I aint mean to say max_binlog_size)

Too many binary log files are in the disk. the number of log files keep 14~16 as below. (normally 14) mysql-bin-changelog.028255 134223043 mysql-bin-changelog.028256 134228506 mysql-bin-changelog.028257 134220246 mysql-bin-changelog.028258 …
eyeronman
  • 57
  • 6
0
votes
0 answers

What happens when mysql binlog reaches mysql-bin.999999

Lets say my mysql replication is enabled for long time, and the server has been quite busy, so new bin log files get created every few seconds. So in a few months, it is possible for latest bin log file to have name "mysql-bin.999999". Does the next…
Ouroboros
  • 1,432
  • 1
  • 19
  • 41
0
votes
1 answer

MySQL Slave replication failure: How to identify SQL which is causing it to fail

I am running MySQL on AWS RDS.. Slave replication is getting stuck because of following error. It says that it is not able to find a record in table of slave server... Is there a way to know which record ? Or the SQL which is failing ! Read Replica…
Deepak Singhal
  • 10,568
  • 11
  • 59
  • 98
0
votes
0 answers

Sphinx Searchd long to restart

we've been using Sphinx (2.0.4) for about 4 years, but recently (like a month ago), searches started having downtimes once an hour. We have a big update of all the data during the night, which doesn't cause any problem. We then have an indexation…
Antoine Bouchard
  • 55
  • 1
  • 2
  • 9
0
votes
1 answer

got "ClassNotFoundException" when reading binlog data from Kafka using Spark Streaming

I want to read the binlog data from kafka using Spark Streaming, the binlog data is collected using canal(which uses protobuf-2.4.1)，I have to use the protobuf-2.5.0 in the Spark Streaming environment. Now i got the following Exception 16/07/11…
klion26
  • 71
  • 1
  • 5
0
votes
1 answer

Can MariaDB's Maxscale(BinLog Server) be used as a collector of binlogs from different mysql clusters?

I have read that Maxscale(BinLog Server) of MariaDB can be used for relaying the bin logs from a MySQL Cluster to a single BinLog Server, however i wanted to know if its possible to collect all the bin logs from different MySQL Cluster and persist…
Sushil Ks
  • 403
  • 2
  • 10
  • 18
0
votes
1 answer

Does the MySql binlog contain transaction boundaries?

If I'm reading a MySql binlog, can I get an indication of which statements occur in the same transaction?
Mark Harrison
  • 297,451
  • 125
  • 333
  • 465
0
votes
1 answer

mysql inside a transaction does the binlog guarantee the update oder of table

start transaction; update a set b=1 where a=1; update b set c=1 where a=1; commit; The binary log will record a, b update in order, but when would the b's update flush to log before than a? how to recurrent?
stackedit io
  • 1
0
votes
0 answers

binlog_do_db groups for mysql replication?

Is it possible to split the binlog_do_db to slave-groups? I have a mysql master server with the databases "frontend, backend, events, lists". Now I want to replicate the databses "events and lists" to slave 1 and slave 2. For a live backup I want to…
user3285277
  • 1
0
votes
1 answer

Need advice on binary logs?

We have set up master slave configuration and we are storing bin logs of 30 days. It is taking up more space on server and we need find some better way to handle it. We are thinking to store logs of 7 days only. Is it OK.
Manojkumar
  • 1,351
  • 5
  • 35
  • 63
-1
votes
0 answers

Cluster Replication Failure: Duplicate entries for key in log

I am trying to add an instance to a cluster set with the mysqlsh command: dba.get_cluster().add_instance("cluster@10.0.0.90:3306", {"ipAllowlist": "10.0.0.0/24"}) Then see the error WARNING: Error in applier for group_replication_recovery: Worker 1…
Bob R
  • 605
  • 1
  • 13
  • 25
1 2 3
4