Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

why binary logs are required? #42

Open
marcodali opened this issue Mar 11, 2022 · 2 comments
Open

why binary logs are required? #42

marcodali opened this issue Mar 11, 2022 · 2 comments

Comments

@marcodali
Copy link

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
Copy link
Owner

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
Copy link

McLotos commented Feb 1, 2023

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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants