Want to subscribe to topics you're interested in?
Become a Member

MariaDB mariadb-Galera installation on current server

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

  1. ehsan

    ehsan New Member

    9
    2
    3
    Sep 22, 2014
    Ratings:
    +2
    Local Time:
    9:37 PM
    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. eva2000

    eva2000 Administrator Staff Member

    30,165
    6,784
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,135
    Local Time:
    4:07 AM
    Nginx 1.13.x
    MariaDB 5.5
    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.
     
    • Like Like x 1
  3. ehsan

    ehsan New Member

    9
    2
    3
    Sep 22, 2014
    Ratings:
    +2
    Local Time:
    9:37 PM
    1.9.4
    10.0.21-MariaDB
    Thanks for your advice.
     
  4. eva2000

    eva2000 Administrator Staff Member

    30,165
    6,784
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,135
    Local Time:
    4:07 AM
    Nginx 1.13.x
    MariaDB 5.5
  5. ehsan

    ehsan New Member

    9
    2
    3
    Sep 22, 2014
    Ratings:
    +2
    Local Time:
    9:37 PM
    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
    • Like Like x 1