Tag Archives: mysql

Don’t let the OOM killer stop MySQL

Many of our customers are successfully using MySQL (or MariaDB) databases on their servers, and they usually run fine as installed and do not need any special attention. However, occasionally problems can occur with MySQL, and this may indicate that … Continue reading

Posted in HOWTO, Rimuhosting | Tagged , , | 1 Comment

MySQL replication and verification

We have a number of customer using MySQL replication. For the uninitiated, replication copies changes from a master server to a number of slave servers. This makes scaling your service mush easier and helps improve redundancy and failover. An introduction … Continue reading

Posted in HOWTO | Tagged , , , , | Comments Off on MySQL replication and verification

How to restore a WordPress site after hacks or exploits in 10 easy steps

A lot of people use WordPress, and seemingly a lot forget to click the upgrade button regularly enough and find they are exploited.  In an ideal world, you would click that button whenever you see it needs updates, and have … Continue reading

Posted in HOWTO | Tagged , , , , | Comments Off on How to restore a WordPress site after hacks or exploits in 10 easy steps

Using perror to explain mysql error codes

A customer came to us with a problem copying one database to another, and requested we do it for him.  Once we logged in we saw the error fairly quickly ~# mysqldump -uadmin -p`cat /root/.mysqlpass` database >dbdump.sql mysqldump: Got error: … Continue reading

Posted in HOWTO | Tagged , , , , , | Comments Off on Using perror to explain mysql error codes

Mysql Master/Master Replication & File sync for quick easy scaling or load balance

A lot of our customers often need a quick easy way to scale up without moving to a new host or changing IP, or even just want an overseas copy of their site, so this is a brief tutorial on … Continue reading

Posted in Featured, Rimuhosting | Tagged , , | 9 Comments

Building database clusters with MySQL

MySQL is a mainstay of many web based applications, and is popular with lots of our customers. There does comes a time when a single database server is not enough. To enhance redundancy MySQL has a couple of options. You … Continue reading

Posted in Clustering | Tagged , , , | 15 Comments

Storage Clustering Part 1: An Introduction

John and I have recently been looking at server clusters, and how they can be provisioned to best fit our customers needs. This post is the first in (hopefully) a series on the results of that research. To start with … Continue reading

Posted in Clustering | Tagged , , , , , , , | 2 Comments

Setting up Monit + with tomcat

We get asked a lot by customers to install and setup monit. Its not an overly hard task, in fact its pretty darned easy. Monit is brilliant for monitoring and restarting services when they are down, it can alert you … Continue reading

Posted in Rimuhosting | Tagged , , , , , , , , , , , , , , | 2 Comments

Failover – What happens when your VPS goes down?

A lot of customers are realizing that having 1 single VPS is great, but if for some reason it goes down and crashes, customers are left wondering what happened. Whilst rimuhosting monitor long term excessive CPU useage, it might be … Continue reading

Posted in Rimuhosting | Tagged , , , , , , , , , , , , | Comments Off on Failover – What happens when your VPS goes down?

wordpress & wordpress MU mass upgrade script 2.9.2

Okay, I have rolled the usual ‘upgrade all instances of wordpress’ script. In this version i finally got around to checking the permissions prior to updating and changing the ownership of them back to that owner afterwards. This was breaking … Continue reading

Posted in Security | Tagged , , , , , | 2 Comments