Not the answer you need?
Register and ask your own question!

pc.recovery=true in 5.7 not shown in wsrep_provider_options.

doets001doets001 EntrantCurrent User Role Novice
For xtradb cluster 5.6 and 5.7 I see in the documentation that the wsrep_provider_option pc.recovery is by default true. In the 5.6 I can query (show variables like 'wsrep_provider_options) it and see that it is set to true. But in 5.7 I can't see it anymore.
Is that ok? or did I configured something wrong? Or is it just not shown anymore in 5.7?

- percona-xtradb-cluster-server-5.7 5.7.25-31.35-1

show variables like 'wsrep_provider_options' \G
*************************** 1. row ***************************
Variable_name: wsrep_provider_options
Value: base_dir = /var/lib/mysql/; base_host = x.x.x.x; base_port = xxxx; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.causal_keepalive_period = PT1S; evs.debug_log_mask = 0x1; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.info_log_mask = 0; evs.install_timeout = PT7.5S; evs.join_retrans_period = PT1S; evs.keepalive_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 10; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.use_aggregate = true; evs.user_send_window = 4; evs.version = 0; evs.view_forget_timeout = P1D; gcache.dir = /var/lib/mysql/; gcache.freeze_purge_at_seqno = -1; gcache.keep_pages_count = 0; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 512M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 100; gcs.fc_master_slave = no;
1 row in set (0.01 sec)
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.