Avatar

Johan

  • Total activity 381
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 1 user
  • Votes 1
  • Subscriptions 78

Activity overview

Latest activity by Johan
  • Avatar

    Johan commented,

    Hi,   yes it could be by using the 'system' function on the host  object.   function main() { var hosts = cluster::hosts(); var host = hosts[0]; var retval;   retval = host.system("ls -lha /h...

  • Avatar

    Johan commented,

    Hi Here is an example to read the properties and print them out: https://gist.github.com/freddielunchbird/d0eef43a5dfa6e643b9979e19eda2250 To shutdown a node, i must check with the devs; i could no...

  • 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...