Document wsrep_replicate_myisam

[byte]

We have this experimental feature, it is in Percona XtraDB Cluster (PXC) and MariaDB Server documentation, but it is somehow missing from our documentation

Via Seppo:
"It is still an experimental feature, as there is no extensive testing with it, and we don't know about problems which could result if it is widely used. Originally we developed this parameter to help some users who wanted to use DML for MyISAM tables in mysql database, (e.g. to CREATE and DROP users) and get these sessions to replicate.

But what would result if user has real application data in MyISAM tables and runs high intensity application load on these tables, this was never tested and was not the design target with this parameter."

[kirjaamo]

See also Issue 254. Should I mention in documentatio that thisis an experimental feature? Is also replicate_aria experimental?

[byte]

Yes please. Also, I like to remind you that we have had wsrep_replicate_myisam for sometime, but the documentation was somehow deleted. Can you just check the git history and find it? Propose what was there and let me see if we need to change anything

[kirjaamo]

I'll check the git log.

[kirjaamo]

I cannot find it in the log entries.

[byte]

Then feel free to rewrite the text based on the fact that said feature exists in all servers and it is documented too

On Fri, 12 Mar 2021 at 3:52 PM, Kirjaamo Information < ***@***.***> wrote: I cannot find it in the log entries. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#256 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAAO5C243BV3AXKAJXHZSYTTDHB5FANCNFSM4YY5BOXA> .

-- Colin Charles, http://www.bytebot.net/ "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

[kirjaamo]

@byte We don't have a Percona options page yet. What other options than wsrep_replicate_myisam should we include? wsrep_replicate_aria?

[byte]

wsrep_replicate_myisam is a feature that is present in Codership Galera Cluster. It is just not documented for some reason.

See:

• MariaDB - https://mariadb.com/kb/en/galera-cluster-system-variables/#wsrep_replicate_myisam
• Percona - https://www.percona.com/doc/percona-xtradb-cluster/LATEST/wsrep-system-index.html

As for Percona options page, that is maybe another issue you can create, but Percona also does a good job of documenting it, and they add pxc_ prefix to options -- https://www.percona.com/doc/percona-xtradb-cluster/LATEST/wsrep-system-index.html