[MDEV-5701] "flush privileges" statement not replicated Created: 2014-02-18 Updated: 2014-06-21 Resolved: 2014-06-21 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 5.5.35-galera |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Giuseppe Iannello | Assignee: | Nirbhay Choubey (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Scenario: increasing username size limit to 80 chars (https://mariadb.com/kb/en/create-user/) Connect to node01 (out of 3 nodes), execute the ALTER TABLE/FLUSH PRIVILEGES. Expected result: the user is created on all the nodes.
Solution: execute FLUSH PRIVILEGES on all the nodes of the cluster after ALTER TABLE. I'm not sure that replicating FLUSH PRIVILEGES across the cluster is correct, but in that case the documentation should be updated. |
| Comments |
| Comment by Nirbhay Choubey (Inactive) [ 2014-06-21 ] |
|
Hi giannello, You got it right! FLUSH PRIVILEGES is not replicated, so one has to run the command |
| Comment by Nirbhay Choubey (Inactive) [ 2014-06-21 ] |
|
Added under limitations : https://mariadb.com/kb/en/mariadb-galera-cluster-known-limitations/ |