On 10 Jul 2003 at 9:39, Jeff McKeon wrote: > I've got the following replication situation... > > A --> B --> C > > All data changes, updates and adds go into DB-A. I work with DB-C and > pull all my queries for reporting from that. Would there be any > problem with adding new indexes or different indexes to DB-C than > exist in DB-A or B?
If you added a unique index, then inserts or updates that succeeded on A and B could fail on C. Other than that, it seems like it should work, but it would complicate recovering from replication problems. But what would be the benefit of doing it rather than adding the indexes to all copies of the tables? > Is there a command/query I can issue to show me the indexed columns > for tables in DB-C (I inherited these DB's so there's still a lot I > don't know about their structure). SHOW CREATE TABLE table_name; SHOW INDEX FROM table_name; -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]