1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL 5.1.73 and xenforo 1.4.3

Discussion in 'Server Configuration and Hosting' started by william1872, Nov 26, 2014.

  1. william1872

    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
     
  2. .Rolex

    .Rolex New Member

    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 likes this.
  3. william1872

    william1872 Member

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

    .Rolex New Member

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

    william1872 Member

    CENT OS

    What's the main benefit using Percona MySQL?

    Sorry I'm not a DB guy
     
  6. .Rolex

    .Rolex New Member

    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 and maszd like this.
  7. william1872

    william1872 Member

    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
     
  8. .Rolex

    .Rolex New Member

    Did you remove/uninstall your old MySQL first?
     
    william1872 likes this.
  9. william1872

    william1872 Member

    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?
     
  10. MattW

    MattW Well-Known Member

    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 and .Rolex like this.
  11. william1872

    william1872 Member

    Thanks Matt : )
     

Share This Page