Join the community today
Register Now

MariaDB MariaDB10

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

  1. Matt

    Matt Well-Known Member

    890
    402
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +643
    Local Time:
    12:29 AM
    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

    49,039
    11,235
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,487
    Local Time:
    9:29 AM
    Nginx 1.21.x
    MariaDB 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 Premium Member Premium Member

    5,301
    1,328
    113
    May 25, 2014
    Ratings:
    +2,052
    Local Time:
    7:29 AM
    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 Well-Known Member

    890
    402
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +643
    Local Time:
    12:29 AM
    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 Premium Member Premium Member

    5,301
    1,328
    113
    May 25, 2014
    Ratings:
    +2,052
    Local Time:
    7:29 AM
    Mainline
    10.2
    Oh and thinking I might upgrade mine too :)
     
  6. Matt

    Matt Well-Known Member

    890
    402
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +643
    Local Time:
    12:29 AM
    1.5.15
    MariaDB 10.2
    Do it!!
     
  7. rdan

    rdan Premium Member Premium Member

    5,301
    1,328
    113
    May 25, 2014
    Ratings:
    +2,052
    Local Time:
    7:29 AM
    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 Well-Known Member

    890
    402
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +643
    Local Time:
    12:29 AM
    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

    49,039
    11,235
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,487
    Local Time:
    9:29 AM
    Nginx 1.21.x
    MariaDB 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 Premium Member Premium Member

    5,301
    1,328
    113
    May 25, 2014
    Ratings:
    +2,052
    Local Time:
    7:29 AM
    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 Well-Known Member

    890
    402
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +643
    Local Time:
    12:29 AM
    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 Well-Known Member

    890
    402
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +643
    Local Time:
    12:29 AM
    1.5.15
    MariaDB 10.2
    I want your user base!
     
  13. BamaStangGuy

    BamaStangGuy Active Member

    663
    189
    43
    May 25, 2014
    Ratings:
    +268
    Local Time:
    6:29 PM
    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

    49,039
    11,235
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,487
    Local Time:
    9:29 AM
    Nginx 1.21.x
    MariaDB 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 Well-Known Member

    890
    402
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +643
    Local Time:
    12:29 AM
    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 Premium Member Premium Member

    5,301
    1,328
    113
    May 25, 2014
    Ratings:
    +2,052
    Local Time:
    7:29 AM
    Mainline
    10.2
    Lucky you :meh:
     
  17. BamaStangGuy

    BamaStangGuy Active Member

    663
    189
    43
    May 25, 2014
    Ratings:
    +268
    Local Time:
    6:29 PM
    What things do we need to watch out for in my.cnf after doing the upgrade?
     
  18. rdan

    rdan Premium Member Premium Member

    5,301
    1,328
    113
    May 25, 2014
    Ratings:
    +2,052
    Local Time:
    7:29 AM
    Mainline
    10.2
    CentMinMod latest beta does it automatically.
     
  19. eva2000

    eva2000 Administrator Staff Member

    49,039
    11,235
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,487
    Local Time:
    9:29 AM
    Nginx 1.21.x
    MariaDB 10.x
    Yeah .07 automatically adjusts all MariaDB 5.5 settings which will conflict with MariaDB 10 :D
     
  20. rdan

    rdan Premium Member Premium Member

    5,301
    1,328
    113
    May 25, 2014
    Ratings:
    +2,052
    Local Time:
    7:29 AM
    Mainline
    10.2
    Is this one: #innodb_additional_mem_pool_size = 32M
    Having conflict?