MySQL 5.1.73 and xenforo 1.4.3

[william1872]

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

 

[.Rolex]

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

 

[william1872]

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.

 

[.Rolex]

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

what OS are you using? you just need to add the repo

 

[william1872]

CENT OS

What's the main benefit using Percona MySQL?

Sorry I'm not a DB guy

 

[.Rolex]

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

 

[william1872]

Seem to get a load of transaction error when trying the install part:

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

 

[.Rolex]

Seem to get a load of transaction error when trying the install part:

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?

 

[william1872]

Did you remove/uninstall your old MySQL first?

Oh no haven't done that

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?

 

[MattW]

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

Yes, it doesn't actually remove the databases from the server, just the MySQL software. Installing Percona should then perform an upgrade task as part of the installation against the existing databases.

 

[william1872]

Yes, it doesn't actually remove the databases from the server, just the MySQL software. Installing Percona should then perform an upgrade task as part of the installation against the existing databases.

Thanks Matt : )