The Blog

Linux

Linux Remote Display Software

Posted on
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
Posted in Linux Leave a comment

Copy database or table from one MySQL server to another, clever way.

Posted on

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?

Read More

Posted in Linux, MySQL Leave a comment

(Errcode: 24 – Too many open files) [23] – Plesk Onyx 17.5.3 and Ubuntu 16.04.2 LTS‬

Posted on

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

Posted in Linux, PLESK 2 Comments
Next Page »