On Fri, Mar 29, 2002 at 01:13:50PM -0800, Jeff Kilbride wrote: > Do the tables on the slave machine have to be *exactly* the same as > the tables on the master?
No. > Is it possible to have different indexes on the slave? Yes. > 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. It should work pretty well. Just add the indexes on the slave(s) only. Of course any index-related changes on the master will end up on the slaves, but that's unlikely to be a problem for you. You wouldn't manipulate an index (on the master) that doesn't exist in the first place. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 50 days, processed 1,428,300,544 queries (328/sec. avg) --------------------------------------------------------------------- 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
