Mysql Lists wrote:
I'm hoping they get replication setup by "diffs", only sending the diffs
that are tracked from the master.. replicated to the slave.. That would
be sweet :)
On 9/27/05, *Jigal van Hemert* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>
wrote:
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).
Please reply to the list and not to me personally, so others can join
the thread :-)
Using "diffs" (I assume that you mean a set of records that were changed
since the previous moment of synchronisation) is not the way MySQL
replication works. The master 'simply' keeps a log of the modifying
queries it performed and the slave reads that log from time to time.
It's the simplest and safest way to replicate IMHO...
Regards, Jigal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
