SecaServer
  • About
  • Contact

Linux: Install and Configure Varnish as Cache Server

By SecaGuy On 16 May 2012 · Leave a Comment

In same cases, one of my server is having problem delivering static content due to low I/O disk capabilities. So we need something to help our web service to deliver and cache the static content (mostly pictures and HTML) to help reduce the load of the main server.

You can refer to the diagram below [...]

Continue Reading →

CentOS: Install TP-Link TL-WN821N Wireless USB Driver

By SecaGuy On 8 May 2012 · Leave a Comment

I have a small server in my office which having network card problem because being stroked by lightning. So I decided to use TP-Link wireless USB adapter because this is the only available wireless adapter that we have in office.

This server has GNOME user interface. So I will let ‘Network Manager‘ to manage the wireless network. [...]

Continue Reading →

MySQL: Live Backup using LVM Snapshots

By SecaGuy On 4 May 2012 · Leave a Comment

LVM snapshot is an exact copy of an LVM partition that has all the data from the LVM volume from the time the snapshot was created. The advantages of this is that we can get reliable backup in a small matter of time without suspending the MySQL service. Normal backup using mysqldump or mysqlhotcopy will [...]

Continue Reading →

MySQL: Advantages and Disadvantages of Galera

By SecaGuy On 24 April 2012 · Leave a Comment

Galera cluster replication are now supported in MySQL InnoDB and Percona XtraDB. Even it is new, this technology is having bright future to be developed and is coming into trend to achieve high availability and scalability on database server.

Advantages:

No need to learn new storage engine technology like NDBCluster. Learning new technology will require [...]

Continue Reading →

CentOS: Using XFS File System for MySQL

By SecaGuy On 17 April 2012 · Leave a Comment

MySQL is preferred to be run on XFS file system due to its performance on direct IO. Even though many benchmarks have already come out with the latest Linux default file system Ext4 versus XFS, it still convenience to use this file system for our MySQL data directory.

XFS is not come by default in [...]

Continue Reading →

High Availability: Web Server Cluster using Apache + Pound + Unison

By SecaGuy On 13 April 2012 · 4 Comments

To achieve high availability, what we really need is to eliminate single point of failure as many point as possible but, it comes with expensive way to do this. What if we just have 2 servers, and we want to have highest web service availability possible with lowest cost?

Most important part in this high [...]

Continue Reading →

FreeBSD 9: Shared Object “libutil.so.8″ not Found

By SecaGuy On 12 April 2012 · Leave a Comment

Problem

After upgrading to FreeBSD 9, whenever I try to use ports to install something, I will get following error:

$ cd /usr/ports $ make search name=nano The search target requires INDEX-9. Please run make index or make fetchindex.

Then, I whenever I run make index command, it will prompt following error:

$ cd /usr/ports [...]

Continue Reading →

MySQL: Generate Random Data using Stored Procedure

By SecaGuy On 4 April 2012 · Leave a Comment

If you have setup your MySQL cluster or standalone database server correctly, you might need to do a stress test to the server. You can use many ways to achieve this and in my case, I will use the simplest way which is create generate a fake data and insert them into table using stored [...]

Continue Reading →

MySQL User Privileges Explained

By SecaGuy On 2 April 2012 · Leave a Comment

If you familiar with MySQL, following are the user privileges which available:

Data

SELECT - Allows reading data
INSERT - Allows inserting and replacing data
UPDATE - Allows changing data
DELETE - Allows deleting data
FILE – Allows importing data from and exporting data into files

Structure

CREATE - Allows creating new databases and tables
[...]

Continue Reading →

cPanel: Auto Backup and Remote Transfer using API + PHP

By SecaGuy On 29 March 2012 · Leave a Comment

The good thing about cPanel is you can generate your own backup automatically using cPanel API. In this case, we will use PHP to run on schedule to automatically generate backup and transfer via FTP or SCP to another server. This implementation can be done on user level without need to login into cPanel login page.

To [...]

Continue Reading →

cPanel: Trigger Alert from Munin

By SecaGuy On 27 March 2012 · Leave a Comment

For cPanel servers, Munin is one of important plugin that need to be enabled in the server. cPanel has provide this plugin to be install with just one click under WHM > cPanel > Manage Plugins > Munin. We can monitor and understand what is going on with our server resources while predicting future problems [...]

Continue Reading →

cPanel: Install PHP SSH2 Module

By SecaGuy On 21 March 2012 · Leave a Comment

One of my developer required PHP SSH2 module to be loaded into the cPanel server. Since this module is not available inside EasyApache, I need to install it separately and integrate to the current configuration that we have build using EasyApache.

1. Download and install libssh2 from this website, http://www.libssh2.org/snapshots/

$ cd /usr/local/src $ [...]

Continue Reading →
← Previous Entries
  • Subscribe via Email

    Enter your email address:

    Delivered by FeedBurner

  • Recent Posts

    • Linux: Install and Configure Varnish as Cache Server
    • CentOS: Install TP-Link TL-WN821N Wireless USB Driver
    • MySQL: Live Backup using LVM Snapshots
    • MySQL: Advantages and Disadvantages of Galera
    • CentOS: Using XFS File System for MySQL
  • Categories

    • Applications
    • Articles
    • BSD
    • Cluster
    • cPanel
    • Debian
    • Disk Management
    • Filesystem
    • Installation
    • Linux
    • Mail Server
    • Monitoring
    • Networking
    • Plesk
    • Scripts
    • Security
    • SpamAssassin
    • SQL
    • Troubleshooting
    • UNIX
    • Web Server
    • Windows
  • RSS Sci/Tech – Google News

    • Alibaba buys back 20% stake held by Yahoo - Hindustan Times 21 May 2012
    • A Leap into the future with 3D gestures - FT.com (blog) 21 May 2012
    • PHOTOS: FACEBOOK Owner Mark Zuckerberg Marries Pricilla Chan - Peace FM Online 21 May 2012
    • Eclipse 'ring of fire' wows Asian, US sky-gazers - Times of India 21 May 2012
    • Nasdaq chief embarrassed by Facebook glitch - The Independent 21 May 2012
  • QR Code

    qrcodeSimply take a photo of this unique barcode with your camera phone. Like magic, your phone will call up this website!
Facebook Google Yahoo Wordpress.com

Enter your WordPress.com blog URL


http://.wordpress.com

Proceed

Meta

  • Register
  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Calendar

May 2012
M T W T F S S
« Apr    
 123456
78910111213
14151617181920
21222324252627
28293031  
Platform by PageLines