Redirect HTTP to HTTPS on Apache

SSL secured websites or HTTPS has now become a must to have on website, especially those handling sensitive client information. Having a HTTPS enabled website means that a intruder can’t intrude to communication between users and website. HTTPS not only secures communication but is now a requirement for many new features like http2, which requires you to have https enabled on your server. Having a HTTPS enabled website also improves your Google SEO (Search Engine Optimization) ranking.

In this tutorial, we will discuss two methods on how we can redirect http traffic to https on Apache web servers.
Continue reading “Redirect HTTP to HTTPS on Apache”

Setup Master Slave replication in MariaDB

Databases are arguably one of the main component of any modern application. And one of the most popular implementation of SQL databases is Mysql or the new replacement MariaDB. As a system administrator, you probably have installed and configured a database before. This tutorial will walk though setting up the master-slave replication of MariaDB.
Continue reading “Setup Master Slave replication in MariaDB”

Setup VNC for remote access on Raspberry Pi

Most of the time, I’m using SSH to connect remotely with the Raspberry Pi. If you are more accustomed to a GUI, you can use VNC for remote access via the network. With VNC, you can access your Raspberry Pi’s GUI screen from a laptop or desktop computer using the same mouse, keyboard, and display of your own computer. Here’s the steps you need to do to setup a working VNC server/client to access your Raspberry Pi remotely. This is an tutorial done  on Raspbian OS.

Continue reading “Setup VNC for remote access on Raspberry Pi”

Configuring Elastic Load Balancer on Amazon EC2

Load balancers are used to distribute the requests/queries to multiple server instances. Most web infrastructures have multiple front-end servers that share the load of the application. Although there are multiple server instances, the end-user only see them a single node. In this tutorial, I’ll walk you on how to configure an Elastic Load Balancer on Amazon, add your web server nodes and point your domain name to the EC2 load balancer.

Continue reading “Configuring Elastic Load Balancer on Amazon EC2”

Adding new disk on Amazon EC2 instance Centos/RHEL 6

Amazon VPS instances, by default only have a single disk for the whole filesystem of the server. Unless you chose to add an additional disk when you provision the server, adding disk space to your VPS can be tricky. Here’s a run down on how to add more storage to your server on amazon by mounting a new drive.

In this tutorial, I’ve mounted the new drive to /var/lib/mysql since I need to increase the disk space used by the database. This tutorial is still applicable even if you want to increase a different folder. The process will be the same.

Continue reading “Adding new disk on Amazon EC2 instance Centos/RHEL 6”

Install Gitblit Go on CentOS/RHEL 6/7

If you are a programmer or work with programmers, managing code repositories is one the task you’ll likely to encounter. Git has become widely popular for storing/managing code repositories.
Gitblit GO is an open-source, pure Java stack for managing, viewing, and serving Git repositories. It’s designed primarily as a tool for workgroups who want to host centralized repositories. Gitblit GO is an integrated, single-stack solution based on Jetty.
In this fast tutorial, you’ll be able to install GitBlit Go and create you own git repositories.
Continue reading “Install Gitblit Go on CentOS/RHEL 6/7”

Important MySQL commands

The following tutorials are example of the essential MySQL commands and techniques needed by system administrators. Although there are people/departments that specializes on Database administration, knowing these commands will help you understand and collaborate effectively with database administrators.
Continue reading “Important MySQL commands”

Additional MySQL Commands

When you forgot the password to your MySQL server, you can reset it using the following steps. This will require a downtime since you are going to stop MySQL service. After this, remember to keep you mysql root password.

Continue reading “Additional MySQL Commands”