[Maria-discuss] eviction in information_schema?
How can i detect eviction of node from the cluster from "information_schema" other than decreasing of WSREP_CLUSTER_SIZE? Thanks,
http://galeracluster.com/documentation-webpages/mysqlwsrepoptions.html#wsrep... This script will be executed on all nodes so you'll definitely detect it. On 29/09/16 04:04, l vic wrote:
How can i detect eviction of node from the cluster from "information_schema" other than decreasing of WSREP_CLUSTER_SIZE? Thanks,
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Does it mean "either/or", e.g. does it mean GLOBAL_STATUS table wouldn't be updated if i use --wsrep-notify-cmd option? For example, would WSREP_CLUSTER_SIZE be still updated after new node join if I use --wsrep-notify-cmd option? Thank you again, On Wed, Sep 28, 2016 at 6:39 PM, Daniel Black <daniel.black@au1.ibm.com> wrote:
http://galeracluster.com/documentation-webpages/ mysqlwsrepoptions.html#wsrep-notify-cmd
This script will be executed on all nodes so you'll definitely detect it.
On 29/09/16 04:04, l vic wrote:
How can i detect eviction of node from the cluster from "information_schema" other than decreasing of WSREP_CLUSTER_SIZE? Thanks,
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
On Fri, Sep 30, 2016 at 11:00 AM, l vic <lvic4594@gmail.com> wrote:
Does it mean "either/or", e.g. does it mean GLOBAL_STATUS table wouldn't be updated if i use --wsrep-notify-cmd option? For example, would WSREP_CLUSTER_SIZE be still updated after new node join if I use --wsrep-notify-cmd option?
Yes, wsrep_cluster_size gets updated in either case. - Nirbhay
Thank you again,
On Wed, Sep 28, 2016 at 6:39 PM, Daniel Black <daniel.black@au1.ibm.com> wrote:
http://galeracluster.com/documentation-webpages/mysqlwsrepop tions.html#wsrep-notify-cmd
This script will be executed on all nodes so you'll definitely detect it.
On 29/09/16 04:04, l vic wrote:
How can i detect eviction of node from the cluster from "information_schema" other than decreasing of WSREP_CLUSTER_SIZE? Thanks,
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (3)
-
Daniel Black -
l vic -
Nirbhay Choubey