Thanks a lot, Adrian. That's a great post. The following paragraph
was pretty helpful:
"Finally, if you intend to prevent any writes on slaves but still
allow users to create temporary tables on slaves (quite helpful for
reporting and the like), you need to be careful about the interaction
between temporary table privileges and regular table privileges. Read
more about privileges in the MySQL manual. My simple advice is this:
create a separate database that only exists on the slave and only
grant temporary table privileges in that database. Creating the
database only on the slave ensures nobody uses it on the master (if it
even exists on the master, you already have potential problems).
Revoking temporary table privileges except in that database keeps
replicated tables safe from modifications."
That's essentially what I'm doing, but it looks like doing it in a
separate database would be the best method... I just need to change my
reporting table updates to work with selecting from one database and
inserting in another.
_______________________________________________
New York PHP Community MySQL SIG
http://lists.nyphp.org/mailman/listinfo/mysql
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
