| 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:
https://dev.mysql.com/doc/refman/5.7/en/using-systemd.html
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:
[Service]
LimitNOFILE=1024 4096
Then restarted the service:
sudo systemctl daemon-reload
sudo systemctl restart mysql
and test it with
cat /proc/$(pgrep mysql)/limits | grep files