Balazs Rauznitz wrote:
I have replication set up. Is it OK to alter one of the slaves and add several indexes ? It did seem to work, but I'd like to be sure.
Replication does nothing more or less than copying the queries that alter the tables (inserts, updates, alter table, delete, etc.) to the slave in the same order as they were executed on the master (it may be technically a different story, but this illustrates the concept).
So, you can change the data or the database structure as much as you want, but errors may occur if the queries fail somehow. Adding indexes is okay as long as you don't add indexes that will cause duplicate key errors (e.g. a UNIQUE index on a field that will not contain unique values). Also, indexes may slow down the queries (more or less) because of the extra execution time needed to update the indexes.
Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
