Join the community today
Register Now

MariaDB MariaDB10

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

  1. Matt

    Matt Moderator Staff Member

    689
    319
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +442
    Local Time:
    12:08 PM
    1.7.1
    MariaDB 10
    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.
     
    • Like Like x 2
  2. eva2000

    eva2000 Administrator Staff Member

    29,702
    6,707
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,009
    Local Time:
    9:08 PM
    Nginx 1.13.x
    MariaDB 5.5
    Excellent.. MariaDB 10.0.13 or there abouts is when I am looking to have Centmin Mod default to MariaDB 10.
     
    • Like Like x 2
  3. RoldanLT

    RoldanLT Well-Known Member

    3,868
    945
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,284
    Local Time:
    7:08 PM
    1.11
    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

    689
    319
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +442
    Local Time:
    12:08 PM
    1.7.1
    MariaDB 10
    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.
     
    • Like Like x 1
  5. RoldanLT

    RoldanLT Well-Known Member

    3,868
    945
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,284
    Local Time:
    7:08 PM
    1.11
    10.2
    Oh and thinking I might upgrade mine too :)
     
  6. Matt

    Matt Moderator Staff Member

    689
    319
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +442
    Local Time:
    12:08 PM
    1.7.1
    MariaDB 10
    Do it!!
     
  7. RoldanLT

    RoldanLT Well-Known Member

    3,868
    945
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,284
    Local Time:
    7:08 PM
    1.11
    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

    689
    319
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +442
    Local Time:
    12:08 PM
    1.7.1
    MariaDB 10
    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.
     
    • Like Like x 1
  9. eva2000

    eva2000 Administrator Staff Member

    29,702
    6,707
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,009
    Local Time:
    9:08 PM
    Nginx 1.13.x
    MariaDB 5.5
    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
     
    • Like Like x 1
  10. RoldanLT

    RoldanLT Well-Known Member

    3,868
    945
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,284
    Local Time:
    7:08 PM
    1.11
    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

    689
    319
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +442
    Local Time:
    12:08 PM
    1.7.1
    MariaDB 10
    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

    689
    319
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +442
    Local Time:
    12:08 PM
    1.7.1
    MariaDB 10
    I want your user base!
     
    • Like Like x 1
  13. BamaStangGuy

    BamaStangGuy Active Member

    470
    137
    43
    May 25, 2014
    Ratings:
    +180
    Local Time:
    6:08 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

    29,702
    6,707
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,009
    Local Time:
    9:08 PM
    Nginx 1.13.x
    MariaDB 5.5
    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
     
    • Like Like x 2
  15. Matt

    Matt Moderator Staff Member

    689
    319
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +442
    Local Time:
    12:08 PM
    1.7.1
    MariaDB 10
    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
    
     
    • Like Like x 1
  16. RoldanLT

    RoldanLT Well-Known Member

    3,868
    945
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,284
    Local Time:
    7:08 PM
    1.11
    10.2
    Lucky you :meh:
     
  17. BamaStangGuy

    BamaStangGuy Active Member

    470
    137
    43
    May 25, 2014
    Ratings:
    +180
    Local Time:
    6:08 AM
    What things do we need to watch out for in my.cnf after doing the upgrade?
     
  18. RoldanLT

    RoldanLT Well-Known Member

    3,868
    945
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,284
    Local Time:
    7:08 PM
    1.11
    10.2
    CentMinMod latest beta does it automatically.
     
  19. eva2000

    eva2000 Administrator Staff Member

    29,702
    6,707
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,009
    Local Time:
    9:08 PM
    Nginx 1.13.x
    MariaDB 5.5
    Yeah .07 automatically adjusts all MariaDB 5.5 settings which will conflict with MariaDB 10 :D
     
  20. RoldanLT

    RoldanLT Well-Known Member

    3,868
    945
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,284
    Local Time:
    7:08 PM
    1.11
    10.2
    Is this one: #innodb_additional_mem_pool_size = 32M
    Having conflict?