quick question

Patrick · July 23, 2013, 12:46:29 AM

Anyone using mysql 5.5? If so any known compatibility issues with common forums, sites? Last upgrade i regretted doing it. Think it's time though seeing as 5.1 is EOL

Lawrence · July 23, 2013, 04:59:15 AM

These forums run on 5.5, as do all my servers with absolutely no problems.

Note, I was on 5.1 previously. I got lazy and decided to kill two birds with one stone. Launched new servers and just migrated the old databases to the new servers, which synced up rather nicely. Upgrading always poses room for disaster if you're not careful. Again, I was lazy in my scenario.

If you have a spare server, just wipe it and install cPanel, migrate accounts, test it, then format that old one and repeat. In my case, it was to upgrade to new hardware. The MySQL update was just an added bonus.

Paul · July 23, 2013, 05:05:57 AM

i use 5.5 for just about everything. a lot of speed enhancements and innodb optimization options that make it pretty important over 5.1 for large heavy-use stuff.

tallship · July 23, 2013, 06:49:52 PM

I abandoned MySQL not quite two years ago. I found myself throwing up everytime I saw mention of, or the logo for, the evil EllisonCo.

Right now most of my machines are running MaridaDB 10, and I' playing with Galera which should start moving again shortly, as soon as some lib issues are taken care of.

nibb · September 28, 2013, 11:17:07 PM

MariaDB and Galera are nice.

5.5 should be pretty much stable these days and there should be no problem running. At least not for software which is updated, olders stuff could have problems but then they are probably outdated.

Patrick · September 28, 2013, 11:19:05 PM

Quote from: nibb on September 28, 2013, 11:17:07 PM
MariaDB and Galera are nice.

5.5 should be pretty much stable these days and there should be no problem running. At least not for software which is updated, olders stuff could have problems but then they are probably outdated.

Good to see you back Nibb.

tallship · September 29, 2013, 09:36:56 PM

Quote from: Patrick on September 28, 2013, 11:19:05 PM
Good to see you back Nibb.

Yes indeed! Good to see you back Nibb

Patrick. For you I would recommend replacing MySQL 5.x w/MariaDB 5.6 - that's the stable branch. I run MariaDB 10 but I've got complete confidence in Monty and his products. That's just me. The reasonable recommendation is MariaDB 5.6.x at this time - and *ALL* of the distros either already have, or are currently in the process of changing over to MariaDB having dumped (no pun intended) the Evil EllisonCo's MySQL.