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

Feature: Document how mysql system variables should be set #35

Open
nickchomey opened this issue Jul 26, 2024 · 4 comments
Open

Feature: Document how mysql system variables should be set #35

nickchomey opened this issue Jul 26, 2024 · 4 comments
Assignees
Labels
documentation Improvements or additions to documentation

Comments

@nickchomey
Copy link

Feature description

There was some miscommunication and confusion in another issue which ultimately arose from me using mariadb, and having different system variables.

It might be worth documenting which primary variables need to be set (or at least considered) in order to be maximally compatible with this connector.

MariaDB Binlog/replication Variables

Mysql binlog variables

@lovromazgon
Copy link
Contributor

Note to the implementer - the requirements are similar (a subset) of the ones listed here.

@nickchomey
Copy link
Author

nickchomey commented Jul 27, 2024

At the very least, according to the mysql package used here, it looks like we need to use

binlog_format=ROW         #default is "mixed" in mariadb, "row" in mysql
binlog_row_image=FULL     #default in both mariadb and mysql

@alarbada
Copy link
Collaborator

yup @nickchomey, the binlog format we use is row. We probably won't support any other, at least for the foreseeable future, as the library we use right now doesn't support any other format

@nickchomey
Copy link
Author

Yes, row seems to be the most functional and compatible for both mariadb and mysql.

But I assume there's some other variables that might be needed to be documented.

@alarbada alarbada mentioned this issue Aug 29, 2024
2 tasks
@alarbada alarbada added documentation Improvements or additions to documentation triage Needs to be triaged labels Oct 28, 2024
@alarbada alarbada moved this to Triage in Conduit Main Oct 28, 2024
@lovromazgon lovromazgon removed the triage Needs to be triaged label Oct 29, 2024
@lovromazgon lovromazgon moved this from Triage to Todo in Conduit Main Oct 29, 2024
@alarbada alarbada self-assigned this Oct 29, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
documentation Improvements or additions to documentation
Projects
None yet
Development

No branches or pull requests

3 participants