[Info-vax] Anyone interested in another public access system

[Arne Vajhøj]

Richard Maher wrote:
> "Arne Vajhøj" <arne at vajhoej.dk> wrote in message
> news:49c6d333$0$90276$14726298 at news.sunsite.dk...
>> Jan-Erik Söderholm wrote:
>>> Neil Rieck wrote:
>>>> 3) when my boss said no, we started to experiment with MySQL for
>>>> OpenVMS
>>> Compared with Rdb, MySQL is more of a joke then anything else... :-)
>> Not exactly geared towards the same requirements.
>>
>> But if MySQL on VMS works as well as on other platforms, then it
>> is a good solution for many purposes.
> 
> Just how "well" does it work on other platforms?

Pretty good.

>                                                   The (admittedly oldish)
> version I was using on Linux didn't offer any transactional integrity with
> ISAM. (You had to have something like InnoDB) I was sticking the
> transactional semantics in my Perl but they weren't doing a hell of a lot.
> How "well" can you roll-forward and AIJ on other platforms?
> 
> Referencial integrity was just peachy also! Took my Trigger and Constraint
> definition syntax with no problem; and then just proceeded to completely
> ignore them :-(

Both transactions and foreign keys require InnoDB tables.

But if you want that then use those.

BTW, Oracle bought InnoDB company some time ago.

> I have to say MySQL was better than I thought it'd be but my expectations
> weren't set very high. But it's great for those sites that store your
> credit-card details in the clear, havn't even heard of referential
> integrity, or transactional atomicity, and will make you prove that they
> over/double-charged you for something (even if you managed to evade to
> Bangalore call centre)
> 
> 2PC with Oracle or SQL Server? XA? WS-AT? What planet are on? As if anyone
> gives a shit about that stuff these days?

If you use InnoDB you get 2PC and XA.

You pick the table type you need:

transactions => InnoDB
write the stuff to disk as fast as possible => MyISAM
don't even bother writing them to disk => MEMORY

Arne