Welcome to Centmin Mod Community
Become a Member

MariaDB MariaDB 10.1.x Galera Cluster

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by pamamolf, Mar 2, 2016.

  1. pamamolf

    pamamolf Premium Member Premium Member

    4,101
    428
    83
    May 31, 2014
    Ratings:
    +837
    Local Time:
    9:07 PM
    Nginx-1.26.x
    MariaDB 10.6.x
    Hi


    As we have as default MariaDB 10.1.x on latest centminmod beta if i am not wrong the galera cluster is included and ready to work.

    As i can see the mycnf file also has entries for it...

    Code:
    ## wsrep specific
    # wsrep_on=OFF
    # wsrep_provider
    # wsrep_cluster_address
    # binlog_format=ROW
    # default_storage_engine=InnoDB
    # innodb_autoinc_lock_mode=2
    # innodb_doublewrite=1
    # query_cache_size=0
    So if i stop mysql and enable the above settings is it ready to work or i must disable or adjust any other setting to get this work?

    Thanks
     
  2. eva2000

    eva2000 Administrator Staff Member

    55,189
    12,251
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,829
    Local Time:
    4:07 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Centmin Mod is provide as is, so short of scripted related bugs or issues, any further optimisation to the web stack components - nginx, php-fpm, mariadb mysql, csf firewall etc or web app specific configurations are left to the Centmin Mod user to deal with. So I do not provide any free support for such.

    MariaDB 10.1 does include Galera cluster native support but enabling, configuring and using it is up to you. Best to read the documentation MariaDB Galera Cluster - MariaDB Knowledge Base and What is MariaDB 10.1? - MariaDB Knowledge Base

    However, Centmin Mod users are free to help each other out and ask questions or give answers on this community forum. My hopes are that this community forum evolves so that more veteran long time Centmin Mod users help new Centmin Mod users out :)