[Info-vax] "Optional" extras (Re: Anyone interested in another public access system)

[Richard Maher]

Hi Arne,

"Arne Vajhøj" <arne at vajhoej.dk> wrote in message
news:49c842b8$0$90271$14726298 at news.sunsite.dk...
> 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

Transactions? Referential Integrity? I mean how esoteric can you get! Must
be a throw-back to some Legacy, Mainframe days.

Cheers Richard Maher

PS. If Oracle bought InnoDB then I'm guessing they sell something; is InnoDB
not a free RDMS?