Welcome to Centmin Mod Community
Become a Member

MariaDB MariaDB10

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by Matt, May 26, 2014.

  1. Matt

    Matt Moderator Staff Member

    862
    387
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +606
    Local Time:
    2:51 PM
    1.5.15
    MariaDB 10.2
    Bit the bullet and upgraded the live server to MariaDB10 using the latest 0.7 beta

    Code:
    Server version: 10.0.11-MariaDB MariaDB Server
    Upgrade worked perfectly.
     
  2. eva2000

    eva2000 Administrator Staff Member

    44,750
    10,205
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,816
    Local Time:
    11:51 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Excellent.. MariaDB 10.0.13 or there abouts is when I am looking to have Centmin Mod default to MariaDB 10.
     
  3. rdan

    rdan Well-Known Member

    4,962
    1,183
    113
    May 25, 2014
    Ratings:
    +1,797
    Local Time:
    9:51 PM
    Mainline
    10.2
    Ow, you did it already Matt :D
    I'm still on MariaDB 5.5.37 on my Live Forum :D
     
  4. Matt

    Matt Moderator Staff Member

    862
    387
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +606
    Local Time:
    2:51 PM
    1.5.15
    MariaDB 10.2
    Yeah, I'd done a couple of test upgrades with various databases installed on there, and they all worked fine, so went for the latest beta, and did the upgrade.
     
  5. rdan

    rdan Well-Known Member

    4,962
    1,183
    113
    May 25, 2014
    Ratings:
    +1,797
    Local Time:
    9:51 PM
    Mainline
    10.2
    Oh and thinking I might upgrade mine too :)
     
  6. Matt

    Matt Moderator Staff Member

    862
    387
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +606
    Local Time:
    2:51 PM
    1.5.15
    MariaDB 10.2
    Do it!!
     
  7. rdan

    rdan Well-Known Member

    4,962
    1,183
    113
    May 25, 2014
    Ratings:
    +1,797
    Local Time:
    9:51 PM
    Mainline
    10.2
    haha but still I got plenty of visitors. :D
    I'm worried to display some db error's to them :/
     
  8. Matt

    Matt Moderator Staff Member

    862
    387
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +606
    Local Time:
    2:51 PM
    1.5.15
    MariaDB 10.2
    Yeah, I did mine last night while at work, and no one was online. Only downtime I had was when I ran the PHP/NGINX/Siege update on the new menu, and forgot to enable ipv6 in the config, so nginx wouldn't restart.
     
  9. eva2000

    eva2000 Administrator Staff Member

    44,750
    10,205
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,816
    Local Time:
    11:51 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Ah I might want to add a check to see if folks are using Nginx with ipv6 and override the non-ipv6 configuration option on upgrades. Sounds handy to have :D
     
  10. rdan

    rdan Well-Known Member

    4,962
    1,183
    113
    May 25, 2014
    Ratings:
    +1,797
    Local Time:
    9:51 PM
    Mainline
    10.2
    As of this current post, it's 1:07 AM here.
    Already dawn still have plenty of them :(
    Maybe later 4AM.
     
  11. Matt

    Matt Moderator Staff Member

    862
    387
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +606
    Local Time:
    2:51 PM
    1.5.15
    MariaDB 10.2
    Oh yeah, that would have been good to have. Couldn't figure why it was failing with the IPv6 addresses, then I remembered the setting to change.
     
  12. Matt

    Matt Moderator Staff Member

    862
    387
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +606
    Local Time:
    2:51 PM
    1.5.15
    MariaDB 10.2
    I want your user base!
     
  13. BamaStangGuy

    BamaStangGuy Premium Member Premium Member

    650
    188
    43
    May 25, 2014
    Ratings:
    +263
    Local Time:
    8:51 AM
    How do I go about enabling the MariaDB option in the latest Beta? When I hit it it just says its a placeholder.
     
  14. eva2000

    eva2000 Administrator Staff Member

    44,750
    10,205
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,816
    Local Time:
    11:51 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    originally from https://plus.google.com/b/104831941868856035845/104831941868856035845/posts/RTBx3oYWqz3

    so yes test on a test server first and in light of @RoldanLT encountered issues at http://community.centminmod.com/thr...db-10-on-my-live-server-got-an-error-help.72/ make sure you disabled CentALT repo first
     
  15. Matt

    Matt Moderator Staff Member

    862
    387
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +606
    Local Time:
    2:51 PM
    1.5.15
    MariaDB 10.2
    Just completed another MariaDB10 upgrade on a live server using 07_submenu_290514 (y)

    Code:
    [root@host centmin-v1.2.3mod]# mysql -u root -p
    Enter password:
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 12
    Server version: 10.0.11-MariaDB MariaDB Server
    
     
  16. rdan

    rdan Well-Known Member

    4,962
    1,183
    113
    May 25, 2014
    Ratings:
    +1,797
    Local Time:
    9:51 PM
    Mainline
    10.2
    Lucky you :meh:
     
  17. BamaStangGuy

    BamaStangGuy Premium Member Premium Member

    650
    188
    43
    May 25, 2014
    Ratings:
    +263
    Local Time:
    8:51 AM
    What things do we need to watch out for in my.cnf after doing the upgrade?
     
  18. rdan

    rdan Well-Known Member

    4,962
    1,183
    113
    May 25, 2014
    Ratings:
    +1,797
    Local Time:
    9:51 PM
    Mainline
    10.2
    CentMinMod latest beta does it automatically.
     
  19. eva2000

    eva2000 Administrator Staff Member

    44,750
    10,205
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,816
    Local Time:
    11:51 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Yeah .07 automatically adjusts all MariaDB 5.5 settings which will conflict with MariaDB 10 :D
     
  20. rdan

    rdan Well-Known Member

    4,962
    1,183
    113
    May 25, 2014
    Ratings:
    +1,797
    Local Time:
    9:51 PM
    Mainline
    10.2
    Is this one: #innodb_additional_mem_pool_size = 32M
    Having conflict?