Re: Problem with perl script

[Mikael Ronström]

Geert Kerkhofs wrote:
> I'm doing a research on database clusters for a
> company and I've created a perl script that
> inserts 10.000 records into a MySQL database
> cluster. But when i execute the script and one of
> the storage nodes crashes (simulated) while
> executing then the perl script stops executing and
> deliveres an error.
> can somebody explain me why it doesn't continue
> executing on the other storage node? What can i do
> to solve this ??
>

When a data node fails all transactions currently ongoing will be aborted
and temporary error will be reported to the application. This temporary
error must be handled by your Perl application to redo the transaction.

When the transaction is redone it should use the surviving nodes in the cluster.

Rgrds Mikael

> Does somebody have some familliar failures?