Indexing on replicated databases

2003-07-10 Thread Jeff McKeon 
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?

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).

Thanks,

Jeff McKeon
IT Manager
Telaurus Communications LLC
[EMAIL PROTECTED]
(973) 889-8990 ex 209 

***The information contained in this communication is confidential. It
is intended only for the sole use of the recipient named above and may
be legally privileged. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution
or copying of this communication, or any of its contents or attachments,
is expressly prohibited. If you have received this communication in
error, please re-send it to the sender and delete the original message,
and any copy of it, from your computer system. Thank You.***


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Indexing on replicated databases

2003-07-10 Thread Keith C. Ivey 
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]