Author Topic: quick question  (Read 918 times)

0 Members and 1 Guest are viewing this topic.

Offline Patrick

  • 620
  • 17
  • Active Participant
  • *****
  • HBF Volunteer
quick question
« on: 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
Patrick - Forum Rules
Insanity: doing the same thing over and over again and expecting different results. - Albert Einstein

Offline Lawrence

  • 573
  • 22
  • Community Manager
  • Active Participant
  • *****
    • Lawrence Wright
Re: quick question
« Reply #1 on: 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.
Skype: sociallarry | AIM: larry.aim@aim.com | Forum Rules & Information

These forums are hosted by me with no intentions to ever monetize them. These forums are here solely for the benfit of the HostBill community.

Offline Paul

  • 82
  • 8
  • Active Participant
  • ***
Re: quick question
« Reply #2 on: 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.

Offline tallship

  • 614
  • 19
  • Active Participant
  • *****
  • Manager Network Services
    • Skype - tallship
    • Business Internet and Telephony since 1985.
Re: quick question
« Reply #3 on: 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.
Bradley D. Thornton - Manager Network Services, NorthTech Computer   TEL: +1.310.388.9469 (US) | +44.203.318.2755 (UK) | +61.390.088.072 (AU) | +41.43.508.05.10 (CH)
Registered Linux User #190795 - "Ask Bill why the string in [MS-DOS] function 9 is terminated by a dollar sign. Ask him, because he can't answer. Only I know that." - Dr. Gary Kildall.

Offline nibb

  • 308
  • -49
  • Active Participant
  • *****
Re: quick question
« Reply #4 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.

Offline Patrick

  • 620
  • 17
  • Active Participant
  • *****
  • HBF Volunteer
Re: quick question
« Reply #5 on: September 28, 2013, 11:19:05 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. 
Patrick - Forum Rules
Insanity: doing the same thing over and over again and expecting different results. - Albert Einstein

Offline tallship

  • 614
  • 19
  • Active Participant
  • *****
  • Manager Network Services
    • Skype - tallship
    • Business Internet and Telephony since 1985.
Re: quick question
« Reply #6 on: September 29, 2013, 09:36:56 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.
Bradley D. Thornton - Manager Network Services, NorthTech Computer   TEL: +1.310.388.9469 (US) | +44.203.318.2755 (UK) | +61.390.088.072 (AU) | +41.43.508.05.10 (CH)
Registered Linux User #190795 - "Ask Bill why the string in [MS-DOS] function 9 is terminated by a dollar sign. Ask him, because he can't answer. Only I know that." - Dr. Gary Kildall.