Learn about Centmin Mod LEMP Stack today
Become a Member

wsrep specific recommendations

Discussion in 'Feature Requests & Suggestions' started by pamamolf, Oct 13, 2017.

  1. pamamolf

    pamamolf Well-Known Member

    4,003
    420
    83
    May 31, 2014
    Ratings:
    +812
    Local Time:
    11:26 PM
    Nginx-1.17.x
    MariaDB 10.3.x
    Hello :)

    I want to recommend for wsrep specific configuration sample to change:

    to
    as it seems it is a recommended value and better set it to OFF (some mention that we may end with corrupted data but MariaDB recommend to set it OFF?) - (another one mention that this variable was removed at version 10.0):

    Tips on Converting to Galera

    • innodb_doublewrite - ON: When an IST occurs, want there to be no torn pages? (With FusionIO or other drives that guarantee atomicity, OFF is better.)

    and as it seems now is not enough to have only this:

    to add also:

    So after that edits a user can remove # from all related configuration lines and start working with it.....

    Thank you :)

     
    Last edited: Oct 13, 2017
  2. pamamolf

    pamamolf Well-Known Member

    4,003
    420
    83
    May 31, 2014
    Ratings:
    +812
    Local Time:
    11:26 PM
    Nginx-1.17.x
    MariaDB 10.3.x
    After reading a bit more i think the recommendation for innodb_doublewrite is wrong !

    So we can keep it as it is and we will need to add only the query_cache_type=0 as it is needed now to properly disable the cache :)

    Thank you
     
  3. eva2000

    eva2000 Administrator Staff Member

    49,869
    11,482
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,834
    Local Time:
    7:26 AM
    Nginx 1.21.x
    MariaDB 10.x
    using using MariaDB Galera Cluster ? or stand MariaDB server ?
     
  4. pamamolf

    pamamolf Well-Known Member

    4,003
    420
    83
    May 31, 2014
    Ratings:
    +812
    Local Time:
    11:26 PM
    Nginx-1.17.x
    MariaDB 10.3.x
    For MariaDB server as we have on another post to properly disable cache we need both lines:

    So i thought if i want to test the included cluster functionality by enabling the wsrep configuration values, both above lines will be needed also to properly disable it....

    That's why i recommend that....