List:General Discussion« Previous MessageNext Message »
From:David Griffiths Date:August 21 2003 4:32am
Subject:Re: Oracle DBA here looking for advice on MySQL ....
View as plain text  
That's not entirely correct. InnoDB currently supports a single tablespace
(comprised of multiple datafiles).

Heikki Tuuri (the developer and maintainer of InnoDB) also mentioned that
multiple-tablespace support might be in InnoDB this fall (September 2003
according to the TODO list at InnoDB: http://www.innodb.com/todo.html).

As an Oracle DBA (I'm one myself), InnoDB will give you "close to Oracle"
features.

As an FYI, we also spent alot of time looking @ Postres and SAPDB. Postgres
is a great database engine, and would be very adequate if it didn't have one
significant missing feature - there is no replication or standby support
unless you buy an expensive licence (which brings the cost close to that of
Oracle); we need the high-availability of clusters and replication. Both
Postgres and MySQL have great support via their mailing lists, but once in a
while, the people on the Postgres mailing list decide to kick MySQL around a
bit; I think they have an inferiority complex.

SAPDB is a mess right now and the documentation is atrocious; hopefully the
MySQL developers can clean it up. It also doesn't have replication (though
it has utilities and features that imply replication via their name; the
latest version renamed them, with a comment that it wasn't really
replication).

MySQL, with InnoDB and replication, is better than either for what we need.

David.

----- Original Message -----
From: "Michael S. Fischer" <michael@stripped>
To: "'Martin Gainty'" <mgainty@stripped>; "'MySQL Users'"
<mysql@stripped>
Sent: Wednesday, August 20, 2003 5:24 PM
Subject: RE: Oracle DBA here looking for advice on MySQL ....


> In a word, no.  The way MySQL organizes its datafiles is trivial by
> comparison: one directory per database, two files per table (table.MYI
> and table.MYD), one is the datafile, the other is the index file.  MySQL
> also does not preallocate space for its tables like Oracle does.
>
> --Michael
>
> > -----Original Message-----
> > From: Martin Gainty [mailto:mgainty@stripped]
> > Sent: Wednesday, August 20, 2003 2:20 PM
> > To: 'MySQL Users'
> > Subject: Re: Oracle DBA here looking for advice on MySQL ....
> >
> >
> > As a Oracle followup question
> > Oracle supports Tablespaces
> > That is
> > 2 or more logically separate entities for System Data and User Data
> >
> > Does MySQL have Tablespace support?
> >
> > Many Thanks,
> > Martin
> > ----- Original Message -----
> > From: "Adam Nelson" <adam@stripped>
> > To: "'Johnson, Michael '" <Michael.Johnson@stripped>;
> > "'MySQL Users'" <mysql@stripped>
> > Sent: Wednesday, August 20, 2003 7:49 AM
> > Subject: RE: Oracle DBA here looking for advice on MySQL ....
> >
> >
> > > I'd say MySQL 2nd edition by Paul Dubois.  It has the first
> > 200 pages
> > > with stuff you already know, but the next 800 pages are mysql
> > > specific. Very good reference book and best practices guide.
> > >
> > > The only thing it's missing is what I think should be in every book
> > > (and is in virtually none).  5 pages devoted to the initial
> > setup of
> > > the program on each major OS.  It's such a simple thing, but often
> > > there are very competent individuals who just want to read the best
> > > practices setup in concise form.  Then, when more time is
> > available,
> > > go back and tweak, etc..
> > >
> > >
> > >
> > > > -----Original Message-----
> > > > From: Johnson, Michael [mailto:Michael.Johnson@stripped]
> > > > Sent: Monday, August 18, 2003 6:43 PM
> > > > To: MySQL Users
> > > > Subject: Oracle DBA here looking for advice on MySQL ....
> > > >
> > > >
> > > > What is the best book on MySQL with regard
> > > > to its Architecture and how it starts up, shutdowns, processes
> > > > queries, rolls back data, etc etc. ?
> > > >
> > > > I am not looking for a SQL book here.
> > > >
> > > > What is the best My SQL book you have read ?
> > > >
> > > > Thank you in advance.
> > > >
> > > > Mike
> > > >
> > >
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:
> > http://lists.mysql.com/mysql?> unsub=mgainty@stripped
> > >
> > >
> >
> >
> > --
> > MySQL General Mailing
> > List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?> unsub=michael@stripped
> >
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
Thread
Oracle DBA here looking for advice on MySQL ....Michael  Johnson19 Aug
  • Re: Oracle DBA here looking for advice on MySQL ....Rajesh Kumar19 Aug
  • Re: Oracle DBA here looking for advice on MySQL ....Andy Jackman19 Aug
    • RE: Oracle DBA here looking for advice on MySQL ....Brian Austin20 Aug
  • RE: Oracle DBA here looking for advice on MySQL ....Adam Nelson20 Aug
    • Re: Oracle DBA here looking for advice on MySQL ....Martin Gainty21 Aug
      • RE: Oracle DBA here looking for advice on MySQL ....Michael S. Fischer21 Aug
        • RE: Oracle DBA here looking for advice on MySQL ....Paul DuBois21 Aug
        • Re: Oracle DBA here looking for advice on MySQL ....Dan Nelson21 Aug
          • Re: Oracle DBA here looking for advice on MySQL ....Jeremy Zawodny21 Aug
        • Re: Oracle DBA here looking for advice on MySQL ....David Griffiths21 Aug
RE: Oracle DBA here looking for advice on MySQL ....Michael  Johnson19 Aug
  • RE: Oracle DBA here looking for advice on MySQL ....Wendell Dingus19 Aug
  • RE: Oracle DBA here looking for advice on MySQL ....Michael S. Fischer19 Aug