Versions Compared

Version Old Version 2 New Version Current
Changes made by

mhodges

mhodges

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

2)  Open source database services are maturing, and we should move gradually to adopt them, but we should not make them foundational to our strategy at this time.

 

Experimental

  • MariaDB

Strategic (3-5 Years)

  • Oracle

  • Microsoft SQL Server

Tactical (1-2 Years)

  • Oracle 11g, 12c

  • SQL Server 2012

Containment

  • MySQL 5.5

Retirement

  • Oracle 8i - Premier Support ended Dec 2004, Extended Support ended Dec 2006

  • Oracle 9i - Premier Support ended Jul 2007, Extended Support ended Jul 2010

  • Oracle 10g - Premier Support ended Jul 2010, Extended Support ended Jul 2013

 

Notes

  • Oracle is used with most of our administrative applications, including out student, financial, and HR applications.  It is very unlikely we will be able to migrate these enterprise apps to another RDBMS

  • SQL Server is used with eThority and Hawaii DXP.  It is unlikely either vendor will support another RDBMS.

  • Percona Server, using the XtraDB storage engine, supports the Zabbix monitoring tool used by the ITS TI System Administration group. It is a open source MySQL fork.

  • ITS also uses Percona’s XtraBackup, an open source hot backup solution, to back up our MySQL and Percona Server databases.

  • ITS gets Enterprise MySQL support from Oracle.

...