3-node cluster config. Attempted to load a large amount of data in one of the databases. Process was disconnected by what appears to be an OS error. Having trouble disconnecting/shutting down the offending node. I will attached the relevant error.log section.
It is stuck at the same spot. These are new nodes. Outside of re-installing the Cluster software on the node, can I reset /deletethe /var/lib/mysql files to simulate a new instance and add it to the cluster? Basically simulate a brand new node.
Each time you start a new node, PXC must sync the data set with the other nodes. If you have 100GB of data, that will take about 1hr-2hrs over gigabit eth. Are you watching the logs? The logs will tell you that an SST is in progress.
I understand how it works but it does not appear to be doing anything as this is the result of a tail -f of the /var/log/mysql/error.log This has been the last lines in the log for the past hour…
I really just want to trash this node and re-add it to the cluster.
=================================================
2021-12-08T19:16:06.989369Z 1 [Note] [MY-000000] [Galera] Non-primary view
2021-12-08T19:16:06.989621Z 1 [Note] [MY-000000] [WSREP] Server status change disconnected → connected
2021-12-08T19:16:06.989864Z 1 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification.
2021-12-08T19:16:06.990120Z 1 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification.
2021-12-08T19:16:07.485951Z 0 [Warning] [MY-000000] [Galera] last inactive check more than PT1.5S (3*evs.inactive_check_period) ago (PT3.50233S), skipping check