This is a one-liner that will show you the size of your MySQL databases. This works for RDS MySQL databases. Having logged into your MySQL server as the root user: SELECT table_schema “Database Name”, sum( data_length + index_length ) / 1024 / 1024 “Database Size in MB” FROM information_schema.TABLES GROUP
Read moreContact our friendly team to get started.
Install OpenShift Origin on CentOS 6.4
This article describes how to install OpenShift Origin (the community version) on a Redhat or CentOS 6.4 server. We’re doing this as a test on an AWS EC2 CentOS 6.4 (With Updates) and a machine type of “m3.medium”. Do this on a fresh system, not one that has real previous
Read moreReset a lost MySQL Password on CentOS and Redhat Linux
Use these instructions to reset a lost MySQL root password. I’ve taken these steps from the website “http://www.rackspace.com/knowledge_center/article/mysql-resetting-a-lost-mysql-root-password”. All credit to them. Note that this is done as the ‘root’ user. First stop MySQL and start it in ‘safe mode’: service mysqld stop mysqld_safe –skip-grant-tables & Now login without the
Read moreApache proxy to Tomcat on CentOS/Redhat
This article discusses how to use Apache web server as a proxy (reverse proxy) to a Tomcat server. Apache is often used as a proxy to Tomcat. This allows the server to host a website that needs a traditional site (html, php, etc) as well as some java served by
Read moreMac Botnet you say?
The new well sort of new (The light bulb has only just come on for some users) Mac.BackDoor.iWorm backdoor appears to be causing some concern just lately, I have added a brief description of how it works below but if you want to know more I have linked some good
Read moreSee your YUM history
Yum has the ability to show you the yum activity of the past. For example, if you want to know when you (or someone) ran a YUM command on a given system, you can. To get an overview, issue the following command yum history You’ll get something like this: [[email protected]:
Read moreGit with OpenShift for SysAdmins
This article is a short overview of how to use Git for Linux system administrators particularly when using OpenShift. When you create your OpenShift application, OpenShift will present you with the Git location you must use for uploading and downloading the web-application code. Updates to the web application code in
Read moreRed Hat Enterprise Linux 7 – an overview of changes
Red Hat has provided a short PDF document describing the changes and new features in RHEL 7. There isn’t much that has changed in the way you’d administer a RHEL system except for a handful of components such as the new firewall (firewalld), network control and service control. I’d say
Read moreInstall security updates only with YUM
This article is a quick description of how to install security updates on a CentOS or Redhat system without installing other normal updates. First install the YUM Plugin: yum install yum-security You can optionally list the available security updates: yum list-security Now you can run the following to install security
Read moreUnderstanding the cloud in 3 minutes – a guide for Executives
The cloud is a nice name for the services offered via the Internet. For example, if i said i have built you an online shop and i am hosing it for you, you could say you have an online shop in the cloud. So services that make up the cloud
Read more