How to Install and Configure MySQL Cluster

To implement a MySQL Cluster, we have to install three types of nodes. Each node type will be installed on it’s own server. The components are:

1. Management Node – NDB_MGMD/MGM
The Cluster management server is used to manage the other node of the cluster. We can create and configure new nodes, restart, delete, or backup nodes on the cluster from the management node.

Read More

What is SFTP?

FTP, or “File Transfer Protocol” is a popular method of transferring files between two remote systems.

SFTP, which stands for SSH File Transfer Protocol, or Secure File Transfer Protocol, is a separate protocol packaged with SSH that works in a similar way over a secure connection. The advantage is the ability to leverage a secure connection to transfer files and traverse the filesystem on both the local and remote system.
Read More

Trying to run rsync between two remote servers

I’m trying to run an rsync between two servers. I’m basing things off of this post: How to rsync files between two remotes?

What I find missing is how to facilitate the rsync (via ssh) when a key (the same key) is required for logging into each server.

Here’s the closest I’ve got:

ssh -i ~/path/to/pem/file.pem -R localhost:50000:SERVER2:22 ubuntu@SERVER1 ‘rsync -e “ssh -p 50000” -vur /home/ubuntu/test localhost:/home/ubuntu/test’
It seems like the initial connection works properly, however I can’t seem to figure out how to specific the key and username for SERVER2.
Read More