> >> Always use a DBMS, and MySQL is no (proper) DBMS without a > >> transactional backend. There are InnoDB, which is not completely free (needs > >> a proprietary backup tool); BDB, which is deprecated until further notices; > >> and SolidDB, which is still β. > > > > Ok, so your solution is to use something else? > > Well, this is a MySQL list… you can use MySQL with InnoDB, if you are > willing to either have a proprietary backup solution or to use a β backend. > > > > Is there a better open source database out there for that amount of data? > > Several. MySQL’s own MaxDB, PostgreSQL, Firebird if you are into > Borland stuff, Ingres if you need XA distributed transactions.
Firebird isn't Borland :-) > I usually recommend PostgreSQL, or Ingres if two-phase commits are > needed. Firebird has two-phase commits. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
