mysql-events icon indicating copy to clipboard operation
mysql-events copied to clipboard

why binary logs are required?

Open marcodali opened this issue 3 years ago • 2 comments

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.

marcodali avatar Mar 11 '22 23:03 marcodali

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.

😔

rodrigogs avatar Mar 12 '22 01:03 rodrigogs

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?

McLotos avatar Feb 01 '23 11:02 McLotos