[SAC] [OSGeo] #2049: Upgrade MySQL tables from MyISAM to InnoDB

#2049: Upgrade MySQL tables from MyISAM to InnoDB
---------------------------+-------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Website rebranding 2017
Component: Systems Admin | Keywords:
---------------------------+-------------------------------------
the staging.www.osgeo.org wordpress was installed using MyISAM which has a
number of issues

e.g transaction safety, not supporting multiple cores, not ANSI SQL
compliant in enforcing things.

MySQL and Maria planning to get rid of it in some future version.

That said I'd like to convert all the tables to InnoDB and plan to do that
this weekend.

I spoke to GetInteractive and they said there was no specific reason they
went with MyISAM. Just happened to be the default.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2049&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2049: Upgrade MySQL tables from MyISAM to InnoDB
---------------------------+--------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone: Website rebranding 2017
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+--------------------------------------
Changes (by robe):

* status: new => closed
* resolution: => fixed

Comment:

Done and documented in
https://wiki.osgeo.org/wiki/SAC:betawebsite#Convert_MySQL_Tables_to_InnoDb

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2049#comment:1&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.