Avatar

Johan

  • Total activity 378
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 1 user
  • Votes 1
  • Subscriptions 77

Activity overview

Latest activity by Johan
  • Avatar

    Johan commented,

    Hi, I think you should do like this: 1) Remove two nodes you have only 3 nodes in the galera cluster 2) remove the load balancer (if you have one)3) read and write from only one node.What perf do y...

  • Avatar

    Johan commented,

    Also if you can share:   SHOW GLOBAL VARIABLES; SHOW GLOBAL STATUS;   would be nice.   THanks

  • Avatar

    Johan commented,

    Hi! Can you send error logs from the failed nodes (you may need  to create a support ticket for this as i think it does not work to attach logs here). Or if you can paste  the logs from a complete ...

  • Avatar

    Johan commented,

    Hi, Can you also bypass the HAProxy and redirect traffic to only one mysql server in the galera cluster? This way it is very easy to see if your application is subject to collisions and that flow c...

  • Avatar

    Johan commented,

    Official comment

    Hi,I can give a quick example. Hope it helps. I have 3 galera nodes: 10.10.10.10 10.10.10.11 10.10.10.12 MariaDB [(none)]> select * from johan.t1; +---+ | a | +---+ | 1 | | 2 | | 3 | +---+ 3 row...

  • Avatar

    Johan commented,

    Hi, [root@cluster ~]# ssh-copy-id -i -oPort=1886 xxx.xxx.xxx/usr/bin/ssh-copy-id: ERROR: No identities found[root@cluster ~]#   here you specify -i   , but no path to the file, so i believe that is...

  • Avatar

    Johan commented,

    Hi,Please double check you really have an identitiy file: ls ~/.ssh/id_rsaElse re-run ssh-keygen -trsa just press enter on any question (or 'yes' to overwrite in case of overwriting an existing). W...

  • Avatar

    Johan commented,

    For me it looks like this: ssh-copy-id -oPort=2222 10.10.10.10/usr/bin/ssh-copy-id: INFO: attempting to log in with the new key(s), to filter out any that are already installed /usr/bin/ssh-copy-id...

  • Avatar

    Johan commented,

    Hi.On what OS and version are you trying to execute the command on? BR johan

  • Avatar

    Johan commented,

    Official comment

    Hi,   Can you try and do: ssh-copy-id -oPort=xxxx [ClusterControl IP address]However, you *must* also setup password less SSH between the controller and the data nodes you wish to use in the cluste...