[Kamailio-Users] Redundancy and fault-tolerance

[Henning Westerholt]

On Tuesday 03 March 2009, Iñaki Baz Castillo wrote:
> > what do you mean by not optimized? If the slave is not active (not
> > running) and one use DRDB just for synchronizing the data, how this could
> > be dangerous?
>
> Simpler than that. Forget DB replication stuff. I just mean that if
> you have a MySQL 1 with a large MyISAM table and you copy it to other
> server using "scp/rsync", you will get a non optimized or corrupted
> table (even if both servers have same CPU, architecture and file
> system).
>
> I've experimented it by copying with "rsync" a 2 GB long MyISAM table.
> After restarting the MySQL-2 and run a SQL command to check tables
> [1], you probably will get a "NOT OPTIMIZED TABLE" and you must to
> repair it. This is the best case.
>
> PD: This is based on my experience with MySQL. However I'have no too
> much knowledge on it.

Hi Iñaki,

ok, thanks for the clarification. This sounds strange. I mean, how is this 
different to a normal backup/ restore cycle when some machine crash? I'd 
expect that it simply continue to use the restored data.

Cheers,

Henning