wsrep specific recommendations

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

 

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

 

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....