Will XenForo 1.2 be compatible with MySQL 5.6 and PHP 5.5?

[IcEWoLF]

I am surprised a lot of you are using MySQL.
MariabDB+XtraDB = better.

 

[Biker]

I am surprised a lot of you are using MySQL.
MariabDB+XtraDB = better.

When our hosting companies start pushing MariaDB out on production servers when we get 'em, we'll use it. But most of us aren't going to settle for the downtime to switch. And for those on shared hosting, I doubt their neighbors would appreciate the downtime, either.

 

[Gladius]

MariaDB is a drop-in replacement for MySQL, so whatever works on MySQL should work on MariaDB as well. There's practically no downtime involved in the switch if done properly. We've been using MariaDB for about 4 months now along with a number of other optimizations and things are running very smoothly.

 

[Deebs]

Personally I prefer Percona and run production on Percona 5.5 and I am testing Percona 5.6-10 alpha 2.

 

[IcEWoLF]

Looks like MariaDB might be officially supported by WHM/cPanel soon: http://blog.cpanel.net/mysql-mariadb/ Official blog post.

 

[Gladius]

It's about time, the requests for it have been put in years ago and cPanel seem to have been twiddling their thumbs all this time.

 

[agison]

I will wait for Percona 5.6 then upgrade.

 

[Claudio]

FWIW, I've just had a quick play with 1.1.4 on PHP 5.5 and haven't experienced any issues. We don't use preg_replace with the e modifier, which is one of the deprecated changes, and we've never used any of the other things that are now deprecated. (Plus 1.1.4 will not show strict/deprecation errors unless you're in debug mode, to reduce showing potential minor warnings to end users.)

I'm very very happy to see you again Mike

 

[MattW]

Looks like MariaDB might be officially supported by WHM/cPanel soon: http://blog.cpanel.net/mysql-mariadb/ Official blog post.

Not really, that is just a blog post on how to stop WHM from managing MySQL, and replacing it with MariaDB. They have also got one for Percona (which is a BAD copy/paste/edit from the MariaDB one : http://blog.cpanel.net/replacing-mysql-with-percona-in-11-36/ )

 

[IcEWoLF]

Not really, that is just a blog post on how to stop WHM from managing MySQL, and replacing it with MariaDB. They have also got one for Percona (which is a BAD copy/paste/edit from the MariaDB one : http://blog.cpanel.net/replacing-mysql-with-percona-in-11-36/ )

More than "just" a blog post: http://features.cpanel.net/response...an-accomodate-both-innodb-and-noninnodb-users

 

[MattW]

More than "just" a blog post: http://features.cpanel.net/response...an-accomodate-both-innodb-and-noninnodb-users

and that is just a feature request. I swapped out MySQL for Percona last April on my Cpanel VPS. I wouldn't personally switch back to MySQL now.

 

[IcEWoLF]

Check out this post, very good read:
http://www.webhostingtalk.com/showpost.php?p=8550624&postcount=6

 

[MattW]

Check out this post, very good read:
http://www.webhostingtalk.com/showpost.php?p=8550624&postcount=6

I've read that post before. I use his Centminmod script on my second VPS (Nginx & MariaDB)

 

[Biker]

It's about time, the requests for it have been put in years ago and cPanel seem to have been twiddling their thumbs all this time.

cPanel has never known to be "bleeding edge" when it comes to updates and trying new things. They prefer stable and I do, too.

 

[hellreturn]

Which is more good? Percona or MariaDB? Curious.

 

[Gladius]

cPanel has never known to be "bleeding edge" when it comes to updates and trying new things. They prefer stable and I do, too.

There's nothing unstable about MariaDB, it's been running on thousands of cPanel servers for years without any problems and cPanel are well aware of that fact.

 

[Slavik]

Which is more good? Percona or MariaDB? Curious.

For XenForo, Percona + ExtraDB.

 

[hellreturn]

For XenForo, Percona + ExtraDB.

Is their any tutorial here on how to migrate from MySQL to Percona + ExtraDB for Debian?

 

[Slavik]

Is their any tutorial here on how to migrate from MySQL to Percona + ExtraDB for Debian?

Stop mysql, remove mysql server, install percona, restart mysql.

 

[hellreturn]

Stop mysql, remove mysql server, install percona, restart mysql.

That's it? No percona specific changes in my.cnf? Also does it auto install ExtraDB?