Need to be able to set binlog_format in config parameters
Bug #963600 reported by
Clint Byrum
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql (Juju Charms Collection) |
Fix Released
|
High
|
Clint Byrum |
Bug Description
the default of 'STATEMENT' will cause some actions to break because some things are not "safe" for STATEMENT mode due to ordering issues. So we need to be able to set this to 'MIXED'. (for an example of this, the moodle install program will error out with this:
Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'
Related branches
lp:~clint-fewbar/charms/precise/mysql/add-binlog-format
- Marco Ceppi (community): Approve
-
Diff: 174 lines (+71/-42)6 files modifiedconfig.yaml (+4/-0)
hooks/common.py (+13/-9)
hooks/config-changed (+51/-18)
hooks/db-relation-joined (+2/-0)
hooks/install (+0/-14)
revision (+1/-1)
Changed in mysql (Juju Charms Collection): | |
status: | In Progress → Fix Committed |
Changed in mysql (Juju Charms Collection): | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
This also affects the Hive charm recently added. It requires InnoDB and the binlog format of 'ROW'.