Do the tables on the slave machine have to be *exactly* the same as the tables on the master? Is it possible to have different indexes on the slave? I want to use my master as my transaction server and my slave as my reporting server. In that respect, I'd like to use very few indexes on my master and heavily index the slave. Can this be done and, more importantly, are there any problems associated with doing it? I'm not anticipating any "CREATE INDEX" or "DROP INDEX" commands on the master.
Thanks, --jeff sql,query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
