/ Register

Want more timely Centmin Mod News Updates?
Become a Member

MariaDB mariadb-Galera installation on current server

Discussion in 'MariaDB & General MySQL news & discussions' started by ehsan, Sep 24, 2014.

Tags:
Previous Thread Next Thread
Loading...
  1. Sep 24, 2014 #1
    ehsan

    ehsan New Member

    9
    2
    3
    Sep 22, 2014
    Ratings:
    +2
    Local Time:
    5:24 AM
    1.9.4
    10.0.21-MariaDB
    Hi,
    I have prepared a new server to help mariadb load of my xenforo forum. (so I have 2 servers now)
    Right now I am using one for web and one for mysql (both centminmod) and I was thinking of using both server for mysql so wanted to install mariadb-galera on both.
    I think I should replace mariadb-server with mariadb-galera-server. Am I right?
    And also do you think setting up cluster with haproxy will result in more mysql power?
     
  2. Sep 24, 2014 #2
    eva2000

    eva2000 Administrator Staff Member

    53,488
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,672
    Local Time:
    11:54 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    I haven't touched MariaDB Galera or clustered MySQL setup for Xenforo so I wouldn't know if there's any issues yet, I'd stick with MariaDB Server non-Galera for now.

    How loaded is your MariaDB MySQL work load ? You can use addon for mysqlmymonlite.sh to gather stats see mysqlmymonlite.sh Addon | Centmin Mod Community

    However, I don't provide any free optimisation advice/support, so tuning your server and MariaDB MySQL is left up to you. Properly tuned MariaDB MySQL for your specific work loads should handle load quite while provided it's paired up with right server hardware.
     
  3. Sep 24, 2014 #3
    ehsan

    ehsan New Member

    9
    2
    3
    Sep 22, 2014
    Ratings:
    +2
    Local Time:
    5:24 AM
    1.9.4
    10.0.21-MariaDB
    Thanks for your advice.
     
  4. Sep 24, 2014 #4
    eva2000

    eva2000 Administrator Staff Member

    53,488
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,672
    Local Time:
    11:54 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  5. Sep 25, 2014 #5
    ehsan

    ehsan New Member

    9
    2
    3
    Sep 22, 2014
    Ratings:
    +2
    Local Time:
    5:24 AM
    1.9.4
    10.0.21-MariaDB
    I am already on innodb, but right know I am enjoying your mysqlmon script and I am trying to use the most of my servers.
     
    Last edited: Sep 25, 2014
Previous Thread Next Thread
Loading...

.