/ Register

Join the community today
Become a Member

MariaDB MariaDB10

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

Tags:
Previous Thread Next Thread
Loading...
Page 1 of 2
  1. May 26, 2014 #1
    Matt

    Matt Well-Known Member

    925
    414
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +669
    Local Time:
    3:54 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. May 26, 2014 #2
    eva2000

    eva2000 Administrator Staff Member

    53,488
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,672
    Local Time:
    12:54 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Excellent.. MariaDB 10.0.13 or there abouts is when I am looking to have Centmin Mod default to MariaDB 10.
     
  3. May 27, 2014 #3
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    10:54 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. May 27, 2014 #4
    Matt

    Matt Well-Known Member

    925
    414
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +669
    Local Time:
    3:54 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. May 27, 2014 #5
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    10:54 AM
    Mainline
    10.2
    Oh and thinking I might upgrade mine too :)
     
  6. May 27, 2014 #6
    Matt

    Matt Well-Known Member

    925
    414
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +669
    Local Time:
    3:54 AM
    1.5.15
    MariaDB 10.2
    Do it!!
     
  7. May 27, 2014 #7
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    10:54 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. May 27, 2014 #8
    Matt

    Matt Well-Known Member

    925
    414
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +669
    Local Time:
    3:54 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. May 27, 2014 #9
    eva2000

    eva2000 Administrator Staff Member

    53,488
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,672
    Local Time:
    12:54 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. May 27, 2014 #10
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    10:54 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. May 27, 2014 #11
    Matt

    Matt Well-Known Member

    925
    414
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +669
    Local Time:
    3:54 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. May 27, 2014 #12
    Matt

    Matt Well-Known Member

    925
    414
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +669
    Local Time:
    3:54 AM
    1.5.15
    MariaDB 10.2
    I want your user base!
     
  13. May 28, 2014 #13
    BamaStangGuy

    BamaStangGuy Active Member

    668
    192
    43
    May 25, 2014
    Ratings:
    +272
    Local Time:
    9:54 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. May 28, 2014 #14
    eva2000

    eva2000 Administrator Staff Member

    53,488
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,672
    Local Time:
    12:54 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. May 30, 2014 #15
    Matt

    Matt Well-Known Member

    925
    414
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +669
    Local Time:
    3:54 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. May 31, 2014 #16
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    10:54 AM
    Mainline
    10.2
    Lucky you :meh:
     
  17. Jun 2, 2014 #17
    BamaStangGuy

    BamaStangGuy Active Member

    668
    192
    43
    May 25, 2014
    Ratings:
    +272
    Local Time:
    9:54 PM
    What things do we need to watch out for in my.cnf after doing the upgrade?
     
  18. Jun 2, 2014 #18
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    10:54 AM
    Mainline
    10.2
    CentMinMod latest beta does it automatically.
     
  19. Jun 3, 2014 #19
    eva2000

    eva2000 Administrator Staff Member

    53,488
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,672
    Local Time:
    12:54 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Yeah .07 automatically adjusts all MariaDB 5.5 settings which will conflict with MariaDB 10 :D
     
  20. Jun 3, 2014 #20
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    10:54 AM
    Mainline
    10.2
    Is this one: #innodb_additional_mem_pool_size = 32M
    Having conflict?
     
Previous Thread Next Thread
Loading...
Page 1 of 2

.