Johan
- Total activity 435
- Last activity
- Member since
- Following 0 users
- Followed by 1 user
- Votes 1
- Subscriptions 103
Comments
Recent activity by Johan Sort by recent activity-
what do you get?
-
Are the file size even the same after the copy? You can also try to unpack the xtrabackup on the controller if you want to see that it unpacks okay. In this case i recommend you copy it to a temp p...
-
Did you figure out the md5 issue? If so, i recommend you use the UI. If not, cd /root/tempinnobackupex --apply-log ./rm -Rf /var/lib/mysql/*innobackupex --copy-back ./chown mysql:mysql -R /var/lib/...
-
Hi, it seems you have written in the config file:'SET GLOBAL event_scheduler=ON' But it should be: event_scheduler=ON BR johan
-
Maybe, but that is the problem anyways that someone has typed "SET GLOBAL event_scheduler=ON" in the my.cnf file. it needs to be taken out or replaced with: event_scheduler=ON BR johan
-
Hi, I am not sure how the data files are loaded in, but it seems that they are loaded in parallel on multiple servers. E.g I see multiple LOAD DATA .. for the table 'ecdrsmall'. Furthermore, i do...
-
You can also try ( if it is a problem with flow control) set: SET GLOBAL wsrep_provider_options='gcs.fc_limit=1024'; On ALL galera nodes (But then they must be a good state, i.e, not as indicated...
-
1024 is a bit extreme:SET GLOBAL wsrep_provider_options='gcs.fc_limit=256'; Is probably more sane. It is hard to say. Depends on disk, network, #cores etc.. And of course the table structures of t...
-
Hi, Galera itself does not facilitate read/write splitting.If you dont use a load balancer, then you could just simply connect to one galera node, and then if that galera node fails, failover to an...
-
Depending of the contents of the failed node's log, then it would be easier to determine the problem. If you see any "[ERROR] Innodb" , then it is probably data corruption, then removing the conten...