Replication and indices?

[sasha@xxxxxxxxx]

>Hello, 
>
>I did not find a clue, on wheter mysql does recalculate indices on a 
>replication slave or not. So I do hope, there is anyone here, to help 
>me? 
>We are using some rather slow machines, on which the indexed 
>databased should be replicated. Currently, we are doing this by 
>simply replacing files. But this does not seem to be very a good 
>solution. 
>If replication-indices were replicated, this would make things a lot 
>easier!
>
>Bye 

Replication just replays all the queries from the master on the slave, so if you create the index on the master, it will be created on the slave.

>
>
-- 
Sasha Pachev

+------------------------------------------------------------------+
|      ____  __     _____   _____  ___     http://www.mysql.com    |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sasha Pachev            |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     sasha@xxxxxxxxx         |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Provo, Utah, USA        |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                         |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                        |
|             /*/             \*\ Developers Team                  |
+------------------------------------------------------------------+


-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php"; before
posting. To request this thread, e-mail mysql-thread60327@xxxxxxxxxxxxxxx

To unsubscribe, send a message to:
    <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php