why binary logs are required?

rodrigogs / mysql-events

A node package that watches a MySQL database and runs callbacks on matched events.

BSD 3-Clause "New" or "Revised" License

136 stars 52 forks source link

why binary logs are required? #42

Open marcodali opened 2 years ago

marcodali commented 2 years ago

I tested this library with success in my mysql local installation and worked out of the box. But when I deploy to server prod, it raises and error about: code: ‘ER_NO_BINARY_LOGGING’, errno: 1381, sqlMessage: ‘You are not using binary logging’, sqlState: ‘HY000’, index: 0, sql: ‘SHOW BINARY LOGS’

we do not want to activate binary logging at server because it compromises performance.

rodrigogs commented 2 years ago

This lib reads the binary log in order to generate the events. If you don't have binary logs enabled, there's no other way to know that something happened on your database.

😔

McLotos commented 1 year ago

This lib reads the binary log in order to generate the events. If you don't have binary logs enabled, there's no other way to know that something happened on your database.

pensive @rodrigogs in console I get events like
IntVar {
timestamp: 1675251151000,
nextPosition: 878377422,
size: 9,
type: 2,
value: 9451924,
binlogName: 'mysql-bin.011001'
}
what is mean?