[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: MySQL transactional support?

From: Glenn A. Thompson <gthompson_at_cdr.net>
Date: 2002-07-08 02:00:45 CEST

Hey:

Justin Erenkrantz wrote:

> On Sun, Jul 07, 2002 at 10:29:02AM -0400, Mark C. Chu-Carroll wrote:
> > It's a bit funny to me watching this discussion this weekend. Stellation
> > was released open-source last thursday. By thursday afternoon, we had
> > our first request/volunteer for adding MySQL support. So we've been having
>
> I know in my conversations with Dave Shields, he mentioned that
> MySQL didn't support transactions properly. Therefore, MySQL can
> not be used by anyone looking for a consistent DB. Or, have recent
> MySQL databases improved their robustness?

Not True. I have tested InnoDB and all seems good so far. I tested across
tables. All tables need to be InnoDB though. So unless someone can show me how
I'm wrong. It's all merely DB preference to me.

>
>
> Regardless of the licensing debates, if that is still the case,
> that alone should make Subversion not use MySQL.

Which DB do you suggest? I'll put it on my list to look at.

> Subversion is
> going to require solid transactional support on the backend. If
> MySQL is going to open the door for inconsistencies, then we must
> not support it.

I'm not concerned.

>
>
> In point of opinion, I believe MySQL is nightmare to work with and
> its (write) performance is awful. If we are going to support any SQL
> DB, IMHO, MySQL should not be our preference. -- justin
>

Well, I'm trying to design my stuff so that with a little work other databases
can be swapped in.
DB opinions are are like assholes... or something like that:-)

I so hate engaging in these "which is better" discussions. So much so that I
intend to support quite a few DBs before all is said and done.
Postgres comes to mind. Only, As far as I can tell, It doesn't support
tablespaces. This can be a problem when you are storing large files. Sure you
can use external references. But I'm not a advocate of that approach. Personal
taste I guess.
My repos will most likely start at about 50GB.

As for MySQL being a nightmare. Never had a problem installing, running, or
maintaining it.

Anyway, let me go back under the rock from which I came. When I have something
I will glading play review tenis:-)

Cheers,
gat

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org
Received on Mon Jul 8 01:59:21 2002

This is an archived mail posted to the Subversion Dev mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.