I was experiencing a worrying issue on one of my servers recently. It’s a web server that hosts some low traffic WordPress blogs for some customers. Recently, the disk I/O chart for the server showed sudden rise in disk read, as shown in the graph below. Investigating the issue To investigate the issue, I connected […]
Category Archives: Administration
Moving an AppGini application to a new server
So, you have an AppGini-generated application that is up and running on your server. You then decided you want to move it to a new server. May be because you found a better hosting service, or you’re upgrading the server, or for any other reason. This is a simple checklist of the steps you should […]
Automatically be notified of any errors on your server
Sometimes a script on your website/server might be causing some errors that you are unaware of. Some users might be seeing these errors under certain circumstances and others not. If users don’t report these errors, you won’t know unless you’re regularly checking your server logs. But no one likes to check server logs as part […]
Retrieve a list of users who haven’t made any activity in the last x months
I just got an interesting question from an AppGini user: Is there an SQL query that I can run manually in PhpMyAdmin that will show me a list of all users that haven’t logged into AppGini for the last 6 months please? Even if it is using one of the date fields in the membership_users […]
Prepare a LAMP web development server on Amazon EC2
Here is a quick checklist for setting up LAMP development server on Amazon EC2. I used a standard Amazon Linux AMI on a T2.micro instance, which costs about $9/month at the time of writing this. Edit the DNS zone for your domain to add an A record for a sub-domain to point to the public […]