Move sql to a more stable distro

[adehnert]

Fedora gets desupported frequently, and we mostly don't care about recent software on sql.mit.edu. We should switch to a distro with longer support cycles.

I'd be a fan of Debian or Ubuntu LTS, though RHEL, Oracle Linux, or CentOS are other options.

[adehnert]

See also -c scripts -i sql on 29 July 2012.

[achernya]

sql currently has mysql 5.1.48; Debian Squeeze has 5.1.63 and the RHEL family (as of 6.3) has 5.1.61.

I would favor moving to RHEL since we have a license for it from MIT, over CentOS and probably Oracle Linux. Additionally, upgrades throughout the 6.x family are fully supported, meaning we may end up getting security updates longer than if we went with Debian.

I feel like moving to Debian may be a bit disruptive, although it would be consistent with running Debian on metal throughout the rest of the project.

[adehnert]

Replying to achernya:

sql currently has mysql 5.1.48; Debian Squeeze has 5.1.63 and the RHEL family (as of 6.3) has 5.1.61.

Incidentally, this appears to not quite be true: AFAICT, kitchen-sink has 5.1.51 and sliced-bread has 5.1.48.

Ubuntu Precise, for reference, has 5.5.24.

[achernya]

Due to maintenance today, both sql servers now have 5.1.56. However, (thankfully) this does not change the upgrade path mentioned earlier.

[adehnert]

Consensus (per -c scripts -i trac-#310 c. 2012-10-30) appears to be Debian.

[achernya]

primary-key is now installed with Debian Squeeze, and acting as a slave to sliced-bread.

[achernya]

foreign-key is also now installed, but does not yet have any data. Once foreign-key is added to the cluster and the remctl pony is written, switchover to the new sql servers can be done.