|Remote Display Software|
|Remmina||GTK+/Gnome Remote Desktop Client|
|TightVNC||Client/server allowing remote network access to graphical desktops|
|Terminal Server Client||GTK2 frontend for rdesktop and other remote desktop tools|
|rdesktop||Client for Windows Terminal Services|
|RealVNC||Client/server allowing remote network access to graphical desktops|
|Vinagre||VNC client for the Gnome Desktop|
|LTSP||Linux Terminal Server Project adds thin-client support to Linux servers|
|x2go||Fast terminal server suite based on NoMachine’s NX libraries|
|NX Free Edition||Terminal Server and Remote Access solution|
|FreeNX||Implementation of the NX Server and NX Client Components|
|OpenSSH||Encrypted communication sessions using the ssh protocol|
This simple bash script can copy database or a table from one remote server to another. Can be used as a backup, but also as a one way sync on a database or table.
ssh -fNg… <- creates a permanent tunnel to the remote server on port 3307. So now from the local server you can access both local and remote MySQL.
export MYSQL_PWD=… <- Helps hide password, as long as you make this script secure, the password it not accessible.
Last one-liner does the rest, if you remove <DB_TABLE_NAME> it will send the entire DB over to the remote, so be carefuller. But you already new that and have a backup, right?
As of MySQL 5.7.7, this is what the documentation recommends for Red Hat Enterprise Linux 7, Oracle Linux 7, CentOS 7, SUSE Linux Enterprise Server 12, Fedora 24 and 25:
On Ubuntu 16.04 the service is called mysql, not mysqld, so this is what I did:
sudo mkdir /etc/systemd/system/mysql.service.d
sudo vi /etc/systemd/system/mysql.service.d/override.conf
Added this in the new file override.conf:
Then restarted the service:
sudo systemctl daemon-reload
sudo systemctl restart mysql
and test it with
cat /proc/$(pgrep mysql)/limits | grep files