am3n portfolio

Since I sometimes get replication problem, so I make several script to check replication automatically and report to me:

To check replication status when I in the console and playing with replication configuration or when I have nothing to do yet I want to see a black screen

monitorreplication.sh

#!/bin/bash
while [ 1 ]
do
        # Your code goes here
        echo ""
        date
        echo "=============================="
        mysql -u backup -pmysqlback -e "show slave status\G;"

        # Modify sleep time (in seconds) as needed below
        sleep 10
done

Another scripts to send replication status via email
(more…)

Simple Harddisk partition, assume only for vps and have or more 50GB of space

/boot    200MB
/tmp    2GB
/    20GB
/home    rest of partition

(more…)

Integration Project: as it’s name will integrate all branch infrastructure and operation work flow. In this project my job is to setup servers for 17 branches and 1 big server on HQ. The Branches servers act as child for parent (HQ) server. One way to integrate data, we transferred them using FTP from PDA to Branch Server then to HQ Server or from PDA directly to HQ Server using GPRS technology. So all servers must be configured to act as FTP Server, in this case I choose built-in Windows IIS Server. Then this Integration Server also act as Primary Domain Controller, File Server and Symantec AV Server .

Complete Integration Server Installation Manual – Password required to open

(more…)

Monday, Today when I check the server room, one of Mailserver’s harddisk turns into red. Indicating failed access. I remembered it already happen before. So I am not worried.
Because the mail server has fail over configuration, so I can easily shutdown the server as other server will take over it function. After shutdown, I removed the failed harddisk and re-plug in again. Somehow the server detect the same harddisk as new one, and not detect any fails, so it starts mirroring data from existing harddisk. I have no idea why the server detect it’s a good harddisk while not long time ago detect it as failed harddisk.
Well this has been noted for future reference.