Portal Home > Knowledgebase > Articles Database > mysql 5.5 ? 5.6 ?
mysql 5.5 ? 5.6 ?
| Posted by ttgt, 06-23-2014, 12:05 PM |
| do you upgrade your mysql to 5.5 or 5.6 on your cpanel server ?
which one is better ?
thanx
|
| Posted by Ed-Freethought, 06-23-2014, 12:10 PM |
| You'll have to upgrade to at least MySQL 5.5 if you want to keep receiving cPanel updates - 11.44 won't install without first upgrading to MySQL 5.5.
|
| Posted by ttgt, 06-23-2014, 12:19 PM |
| but 5.5 is fine ? or 5.6 is better ?
|
| Posted by Ed-Freethought, 06-23-2014, 12:27 PM |
| Of course MySQL 5.6 is better than 5.5. That doesn't mean that 5.5 doesn't work or won't do the job.
MySQL 5.6 has some new feature as well as the usual performance enhancements. Take a look at the MySQL release notes for details, or the summary on the MySQL upgrade page in WHM.
MySQL 5.6 is classed as General Availability (production stable) by MySQL and has been out for per a year. Of course, you may have your own policies about how often to upgrade and you should perform appropriate testing to make sure that everything in your specific environment is compatible with MySQL 5.6 before blindly upgrading.
|
| Posted by my247webhosting, 06-23-2014, 02:33 PM |
| 5.6 would the version as it would have all latest patches as well as optimized code to help mysql run smoothly
|
| Posted by sKunKbad, 08-02-2014, 10:16 PM |
| I'm having a hard time finding shared hosting from a reputable company that includes MySQL 5.6. From a hosts point of view, is there something wrong with 5.6? If it's now been out for 1yr+, it would seem that it would be widely available, but that's not the case, as far as I can tell.
|
| Posted by mixmox, 08-03-2014, 03:54 AM |
| http://www.mysqlperformanceblog.com/...han-mysql-5-5/
|
| Posted by sKunKbad, 08-03-2014, 10:09 AM |
| I don't think you understood what I was asking. I know about there are differences. One of those differences, which is quite substantial, is that 5.6 allows for a datetime field to have a default of CURRENT_TIMESTAMP. Finding shared hosting with 5.6 (and a few other requirements) has been very hard. MDD hosting is now offering 5.6, but they offer very low data storage, so that won't work for my client, who has roughly 90 GB of data. At this point, why isn't it easy to find a bunch of hosts that offer 5.6?
|
| Posted by Atlanical-Mike, 08-03-2014, 10:37 AM |
| Well put it this way from experience, I wouldn't use 5.6 again, I had a hosting brand, and when we upgraded to 5.6 we had issues and that lead to use closing down that brand. MySQL kept crashing innoDB tables corrupting and it was only when we upgraded to 5.6.
|
| Posted by Visiba, 08-03-2014, 10:44 AM |
| We're running MySQL 5.6 and were previously on 5.5. The upgrade via WHM went pretty smooth and we didn't have such issues. We're only seeing a higher memory usage by MySQL since we upgraded.
|
| Posted by Atlanical-Mike, 08-03-2014, 10:50 AM |
| When did you upgrade mate? I upgraded in Feb.
|
| Posted by Visiba, 08-03-2014, 10:52 AM |
| First set of servers were upgraded beginning of March.
|
| Posted by Atlanical-Mike, 08-03-2014, 10:55 AM |
| Must have just been us then haha. I believe cPanel had it under experimental.
|
| Posted by EthernetServers, 08-03-2014, 11:01 AM |
| Been running 5.6 for a few months on multiple servers and had no problems. Error logs are clean, no unexpected restarts or anything like that.
|
| Posted by martijnatlico, 08-03-2014, 04:46 PM |
| Well I don't have any experience with cPanel and where that gets MySQL from, but up until recently many popular server-oriented Linux distributions (Ubuntu LTS, CentOS) were still on older MySQL versions (CentOS 6 is still and will always be on MySQL 5.1). Those versions are supported by the distribution vendor so that's the easiest one to use from the hosts perspective. If you look at anything but the bottom end of the market it should be easy to find someone offering MySQL 5.6.
|
| Posted by sKunKbad, 08-03-2014, 05:51 PM |
| If you wouldn't mind sharing a good choice, I'd appreciate it. I have spent a lot of time searching. Maybe I just look in the wrong places.
|
| Posted by RRWH, 08-03-2014, 06:42 PM |
| So you are expecting a shared host to work ok with a 90Gb + database? No wonder you are having trouble finding someone.
I say if that is your data, then heck, even a VPS might not cut it and you should be looking for a realistic solution for your client - and that being a dedi server with a decent MySQL configuration for the data. With a dataset like that, you really should be looking towards a dedicated DB server.
The MySQL config is going to be WAY different for a 90G dataset v's the "typical" shared hosting Mysql requirements.
|
| Posted by sKunKbad, 08-03-2014, 11:57 PM |
| This is for a client. They have a shared hosting account at jaguar PC which gives them 100gb, but the MySQL version in 5.5.
|
Add to Favourites 
Print this Article
Also Read
