myhosting.com Knowledge Base - Ubuntu

How To Repair MySQL Replication

Fri, 03 May 2013 20:34:05 +0000

How To Repair MySQL Replication

If you have set up MySQL replication, you probably know this problem: sometimes there are invalid MySQL queries which cause the replication to not work anymore. In this short guide I explain how you can repair the replication on the MySQL slave without…

Load Balancing MySQL with MySQL Proxy

Fri, 03 May 2013 20:32:26 +0000

Load Balancing MySQL w/ MySQL Proxy

We have the technology

Install MySQL Proxy on the load balancer box(es).

sudo apt-get install mysql-proxy --yes

Configure and run MySQL Proxy

You'll also need to open the MySQL port on

Clustering MySQL

Fri, 03 May 2013 20:30:25 +0000

Clustering MySQL

To begin with we'll install and configure MySQL for normal use on each of the boxes.

sudo apt-get install mysql-server --yes Set a strong MySQL root password and wait for the packages to download and install, then edit /etc/mysql/my.cnf

MySQL Basics

Fri, 03 May 2013 20:25:46 +0000

What is MySQL?

MySQL is the world's most used open source relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases.

Daily Op

fail2ban

Fri, 03 May 2013 19:02:36 +0000

What is fail2ban?

Fail2ban is an intrusion prevention framework written in the Python programming language. It is able to run on POSIX systems that have an interface to a packet-control system or firewall installed locally (for example, iptables or TCP Wrapper).

Migrate E-mail using imapcopy

Fri, 03 May 2013 18:14:13 +0000

What is imapcopy?

IMAPCopy is a small command line tool to copy messages for multiple users from one imap server to another. It was designed for migration of Linux imap mail to exchange servers.

Installation Debian and Ubuntu

Install the pack

SQL Bench

Thu, 21 Feb 2013 03:29:24 +0000

How to Secure your VNC by Tunneling over SSH

Sun, 06 Jan 2013 06:20:31 +0000

How to Secure your VNC by Tunneling over SSH

In this guide, you will learn how to tunnel your VNC connection over SSH. Now why would we go to the trouble to do this? The answer is simple: VNC traffic is all sent in plain-text and is not secure by its own. Due to this we'll want to secure…

Ubuntu VPS - Desktop (LXDE) Installation and VNC

Fri, 04 Jan 2013 02:00:36 +0000

Installing LXDE desktop environment and VNC server

This guide will walk you through the steps necessary to install the LXDE desktop as well as the vnc4server package for remote desktop access on your Ubuntu 12 VPS. For this guide we will be using a one user VNC set up, though adding…

Ubuntu VPS - Desktop (GNOME) Installation and VNC

Fri, 04 Jan 2013 00:59:50 +0000

Installing GNOME desktop environment and VNC server

This guide will wal