Replication Problem

2004-08-20 Thread Smitesh . Damdoo
Hi, All Is replication of database in MySQL is possible. Actually i want to replicate the changes to the database to different servers located at different locations. Please tell me if any suggestions, or available resources for this Replication Topic. From: Smitesh S. Damdoo (Mob. No.) 922

Necessity of recreation of Index

2004-08-14 Thread Smitesh . Damdoo
Hi, Everybody. It's simple question. But i am in confusion. I have table with huge number of records but only 3 columns (suppose col1, col2, col3). col1 is primary key and I have created the Index on the column (i.e. col2) which is not a primary key. Problem 1) is that