MySQL 5.1.73 and xenforo 1.4.3

william1872

Member
Hey guys,

Just had a quick question.

We're currently running Xenforo 1.2 and preparing to upgrade to 1.4.3 today. Just noticed our MySQL version is currently 5.1.73, is the latest release of xenforo compatible with this version of MySQL?

I plan on upgrading MySQL after we jump to xenforo 1.4.3, latest release of MySQL is 5.6, I'm assuming xenforo 1.4.3 supports that version?

Thanks
 
yes that version is compatible, xenforo server requirements states a minimum of MySQL 5.0

with that said, I would recommend you switch to Percona MySQL server
 
yes that version is compatible, xenforo server requirements states a minimum of MySQL 5.0

with that said, I would recommend you switch to Percona MySQL server

Thanks, I don't seem to have the option to use 'Percona MySQL server' with my VPS environment.
 
CENT OS

What's the main benefit using Percona MySQL?

Sorry I'm not a DB guy

its superior in perfomance and scalability

http://www.percona.com/software/percona-server/benchmarks
http://www.percona.com/software/percona-server/feature-comparison

it's a direct replacement and installing it is cake

yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm

yum install Percona-Server-client-56 Percona-Server-server-56
 
Seem to get a load of transaction error when trying the install part:


Code:
Running rpm_check_debug
Running Transaction Test


Transaction Check Error:
  file /usr/bin/mysql from install of Percona-Server-client-56-5.6.21-rel70.1.el6.x86_64 conflicts with file from package MySQL56-client-5.6.21-1.cp1142.x86_64
  file /usr/bin/msql2mysql from install of Percona-Server-client-56-5.6.21-rel70.1.el6.x86_64 conflicts with file from package MySQL56-client-5.6.21-1.cp1142.x86_64
  file /usr/bin/mysql_config_editor from install of Percona-Server-client-56-5.6.21-rel70.1.el6.x86_64 conflicts with file from package MySQL56-client-5.6.21-1.cp1142.x86_64
  file /usr/bin/mysql_find_rows from install of Percona-Server-client-56-5.6.21-rel70.1.el6.x86_64 conflicts with file from package MySQL56-client-5.6.21-1.cp1142.x86_64
 
Seem to get a load of transaction error when trying the install part:


Code:
Running rpm_check_debug
Running Transaction Test


Transaction Check Error:
  file /usr/bin/mysql from install of Percona-Server-client-56-5.6.21-rel70.1.el6.x86_64 conflicts with file from package MySQL56-client-5.6.21-1.cp1142.x86_64
  file /usr/bin/msql2mysql from install of Percona-Server-client-56-5.6.21-rel70.1.el6.x86_64 conflicts with file from package MySQL56-client-5.6.21-1.cp1142.x86_64
  file /usr/bin/mysql_config_editor from install of Percona-Server-client-56-5.6.21-rel70.1.el6.x86_64 conflicts with file from package MySQL56-client-5.6.21-1.cp1142.x86_64
  file /usr/bin/mysql_find_rows from install of Percona-Server-client-56-5.6.21-rel70.1.el6.x86_64 conflicts with file from package MySQL56-client-5.6.21-1.cp1142.x86_64

Did you remove/uninstall your old MySQL first?
 
Did you remove/uninstall your old MySQL first?

Oh no haven't done that :D

I think this will be a task for the developer, since our existing customer base is all in MySQL DB's on the site and we have quite a bit of custom coding done, knowing my luck I'd break something.

Is it just the case of removing MySQL and installing Percona MySQL?
 
Top Bottom