- Committer: james.page at ubuntu
- Date: 2014-09-12 10:24:33 UTC
- mfrom: (124.1.5 lp-1353135)
- Revision ID: james.page@ubuntu.com-20140912102433-dfsfxi04rhp5nq3l
[gnuoy,r=james-page,t=james-page] Set allowed_hosts data on shared-db relations
Set a list of allowed_units which the client units can query to see if their permissions have been setup yet. The reason for this is to allow the client to work around a race condition which occurs when a service has multiple units:
1) A service consisting of multiple units joins mysql and triggers mysql to run shared-db-changed for each unit in turn. But as soon as shared-db-changed has been run for the *first* time mysql runs relation set publishing the password.
2) All units in the client service then run their shared-db-changed hook in response to the relation set that mysql issued when it did the *first* run of shared-db-changed. At this point permissions have only been granted to one unit and the rest will fail if they try and access the db.
This is the same behaviour as the postgres charm which was added in response to Bug #1187508
Set a list of allowed_units which the client units can query to see if their permissions have been setup yet. The reason for this is to allow the client to work around a race condition which occurs when a service has multiple units:
1) A service consisting of multiple units joins mysql and triggers mysql to run shared-db-changed for each unit in turn. But as soon as shared-db-changed has been run for the *first* time mysql runs relation set publishing the password.
2) All units in the client service then run their shared-db-changed hook in response to the relation set that mysql issued when it did the *first* run of shared-db-changed. At this point permissions have only been granted to one unit and the rest will fail if they try and access the db.
This is the same behaviour as the postgres charm which was added in response to Bug #1187508
| Filename | Latest Rev | Last Changed | Committer | Comment | Size | ||
|---|---|---|---|---|---|---|---|
 .. |
|||||||
hooks
|
1 | 13 years ago | kapil.thangavelu at canonical | wordpress and mysql formulas with tongue in cheek |
|
||
|
keys
|
81.1.3 | 11 years ago | Clint Byrum | adding percona key to charm |
|
||
|
lib
|
114.1.1 | 10 years ago | Marco Ceppi | Remove dependency on charm-helpers-sh |
|
||
|
scripts
|
91.5.1 | 11 years ago | Chad Smith | add_to_cluster and remove_from_cluster scripts |
|
||
charm-helpers.yaml |
113.2.5 | 10 years ago | Edward Hope-Morley | [dosaboy] added support for 'source' and 'key' con | 89 bytes |
|
|
|
config.yaml |
120.5.2 | 10 years ago | Jacek Nykis | Added support for nrpe-external-master relation. A | 4.9 KB |
|
|
|
copyright |
85 | 11 years ago | Clint Byrum | Removing unneeded augeas bits | 756 bytes |
|
|
icon.svg |
96 | 11 years ago | Marco Ceppi | Added icon.svg | 18 KB |
|
|
|
Makefile |
113.2.9 | 10 years ago | Edward Hope-Morley | [dosaboy] added support for 'source' and 'key' con | 379 bytes |
|
|
|
metadata.yaml |
120.5.2 | 10 years ago | Jacek Nykis | Added support for nrpe-external-master relation. A | 996 bytes |
|
|
|
monitors.yaml |
74.1.4 | 11 years ago | Clint Byrum | adding generic monitors | 271 bytes |
|
|
|
README.md |
122 | 9 years ago | Marco Ceppi | Sync from precise | 4.7 KB |
|
|
|
revision |
120.2.6 | 9 years ago | Darryl Weaver | Fix for mysql on trusty master-relation-changed ho | 4 bytes |
|
|