RimuHosting Blog

Tag: Databases

  • 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 some manual tuning is required. One scenario is when the system is short of memory,…

  • Debian 8 (Jessie) available

    We now have a Debian 8 image available for new VM setups and reinstalls. Debian 8 is code named “Jessie”. There is only a 64 bit image.  Most customers are now ordering 64 bit distros.  And some distros only come in a 64 bit flavor now, e.g. Centos 7. Debian 8 is also an option…

  • Centos 7 Release – Whats New

    Hot on the heels of the Red Hat Enterprise Linux 7 release the Centos team have put out Centos 7 and now we are happy to offer a Centos 7 VM image on our control panel.  You can select it on new installs and also on re-installs. This has been a long awaited update due…

  • Connecting to MySQL from external sources + IPTables

    By default, MySQL only allows local connections. This is due to security, and for the most part works just fine for most people. Ideally you can use things like PHPMyAdmin for things like this, or even command line. Occasionally people need to connect from externally, either from a web front end, or some other PC,…

  • Sync live sites to in-house dev servers

    One of our customer found it tedious to sync his live websites to his dev servers, it involved using FTP (since he had no version control) as well as the database. The files were over 2GB by themselves, so it could be a time consuming task. As a result he asked us for a solution,…

  • 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 to setting that up is available in our Mysql Replication guide. Once you have replication…

  • 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: 29: File ‘./database/tablename.MYD’ not found (Errcode: 24) when using LOCK TABLES ~# It can be…

  • Installing Oracle RDBMS Server

    Oracle is a very popular database.  Particularly for enterprise customers running on dedicated servers with lots of CPU and fast RAID setups. This tutorial will guide you to install Oracle database server on CentOS Linux distro.  Hopefully the steps are simple enough that even a technically minded non-DBA can get the database installed. Oracle RDBMS…

  • Emailed backup of a database via cron – Attaching files via command line

    Sometimes people want an easy offsite backup option for important databases or files, and having a cron to automate that can be helpful. One of our customers had such a case so i wrote a shell script which emailed him a copy of his database every day. Since i thought it was a handy thing…

  • 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 how to duplicate your server, and have the database and files replicate between the 2…