Sharing user credentials between MySQL Servers with MySQL Cluster
Andrew Morgan has a great post up about a new feature in MySQL Cluster 7.2 that alleviates a pain point I've encountered in the past. Andrew explains,
The Developer Release for MySQL Cluster 7.2 includes a new feature that allows the system data required for checking user access to be shared amongst all of your MySQL Servers. By default all of the tables holding these credentials are stored in MyISAM and so are local to that MySQL Server.This can become painful to manage – every time you want to create a new user or change their permissions you need to repeat it on every server, miss one out and the user won’t be able to access that server (or will still be able to access it after you withdraw their privileges).
Head over and check it out, and subscribe to my MySQL Cluster bundle on Google Reader!