[Bug 619330] New: InnoDB as default table type

["sysadmin" (bugzilla.gnome.org) <bugzilla gnome org>]

https://bugzilla.gnome.org/show_bug.cgi?id=619330
  sysadmin | Other | unspecified

           Summary: InnoDB as default table type
    Classification: Infrastructure
           Product: sysadmin
           Version: unspecified
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: Normal
         Component: Other
        AssignedTo: sysadmin-maint gnome bugs
        ReportedBy: otaylor redhat com
         QAContact: sysadmin-maint gnome bugs
      GNOME target: ---
     GNOME version: ---


We should consider changing the server configuration on drawable.gnome.org so
that tables default to InnoDB. InnoDB is really just a better backend than
MyISAM in almost every way - the obvious way being that it supports
transactions. And it's pretty clearly the future direction for storage engines
for MySQL.

The only real downside I know is that we have to dump InnoDB tables for backup
rather than using mysqlhotcopy, but our DB backup scripts already handle this,
and dump backups actually tend to perform pretty well compared to  mysqlhotcopy
(much smaller data size for a gzip'ed dump in most cases.)

Application affects:

 - It won't affect existing applications tables
 - Applications that really care (bugzilla wants some giant non-transactional
tables to be MyISAM) will take care of themselves
 - Applications that don't care get a better database

-- 
Configure bugmail: https://bugzilla.gnome.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching the QA contact of the bug.
You are watching the assignee of the bug.