john test
- Total activity 51
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 16
Comments
Recent activity by john test Sort by recent activity-
Hi Ashraf, Actually I rebuilt the cluster so didn't save the logs, but here is my.cnf if you see something that can be added/optimized would be much appreciated.You will also see that this is a geo...
-
Thank you Ashraf. Much appreciated.
-
Thanks Alex. I was in a hurry so I ended up rebuilding but this is good info as it has happened to me a few times already so I will try next time. Thank you!
-
Hi Alex Actually I see they got set when I ran the command I posted above # mysql -uroot -pXXXXX -e 'SHOW VARIABLES LIKE "wsrep_provider_options"'Warning: Using a password on the command line int...
-
hi Alex I don't see any errors or warnings but better to do it properlyCan I set all of them in my.cnf ?This is where the rest of wsrep variables areOk to set them like this?wsrep_provider_option...
-
I set them inside mysql client as such mysql> SET GLOBAL wsrep_provider_options="evs.keepalive_period = PT3S; evs.suspect_timeout = PT30S; evs.inactive_timeout = PT1M; evs.install_timeout = PT1M";
-
Thank you. I added them to all nodes my.cnf and restarted mysql one after the other. Appreciate your help.
-
Thank you. In fact, the connectivity is not very good between the 2 sites. This is the reason we were initially considering 2 separate galera clusters with mysql multi-master replication between th...
-
Thanks Ashraf. So is it preferable to have garbd node in 3rd site or is it fine if we have it in site A or B in case of 2-site solution?