search

canonical / mysql-operator

Machine charm for MySQL following the operator framework
https://charmhub.io/mysql
Apache License 2.0
7 stars 10 forks source link

Avoid logging FLUSH LOG statements to the binlog #336

Closed shayancanonical closed 11 months ago

shayancanonical commented 11 months ago

Issue

By default, FLUSH LOG statements are logged to the binlog. When a member is not part of a group (self-healing scenarios), these log statements result in GTID conflicts which prevents the member from self-healing.

Solution

Disable logging FLUSH LOG statements to the bin log.

codecov[bot] commented 11 months ago

Codecov Report

Merging #336 (323ee3f) into main (2e9e55e) will not change coverage. The diff coverage is 100.00%.

@@           Coverage Diff           @@
##             main     #336   +/-   ##
=======================================
  Coverage   64.01%   64.01%           
=======================================
  Files          16       16           
  Lines        2993     2993           
  Branches      389      389           
=======================================
  Hits         1916     1916           
  Misses        955      955           
  Partials      122      122
Files Coverage Δ
lib/charms/mysql/v0/mysql.py 72.74% <100.00%> (ø)