myhosting.com Knowledge Base - Centos

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:12:59 +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 CentOS

Since their is no repository package for imapcopy…

OpenVPN VPS - Getting Started Guide

Thu, 18 Apr 2013 16:39:26 +0000

Overview

Welcome to your new OpenVPN VPS, VIP! We’re happy to have you aboard! Your new VPS with OpenVPN will enable you to travel the world wide web through private tunnels and create connections to other servers, VPS’ and services ensuring security, productivity and more!

Your…

Mobile VPN (PPTP) Getting Started Guide (Requires OpenVPN Template)

Mon, 14 Jan 2013 14:26:17 +0000

OpenVPN VPS: PPTP VPN Server

Recommended setup of your VPN service is using to use OpenVPN for greatest security. Se

SQL Bench

Tue, 08 Jan 2013 17:15:35 +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…