Archive for June, 2008

PHP Parse XML from mysql

June 30, 2008

Today we were looking at migrating data from one database to another and thought that we’d try out Mysql command line XML output format. The format is fairly simple, so we decided we’d run with it instead of CSV. To parse the XML file, we use PHP, and soon discovered there’s no real [...]

Tags:
Posted in Research & Dev | No Comments »

csync2: Install and setup csync2 on CentOS 5

June 28, 2008

This blog details how to build and install csync2 form source, as well as configure it.
Step 1) Download and install required libraries
If you haven’t already done so, install graft – it’s great. Here’s a tutorial how to install graft:
http://blog.rackcorp.com/?p=16
Go to ftp://ftp.gnupg.org/gcrypt/libgpg-error/ and download the latest version of libgpg-error
cd /usr/local/PKG_BUILD
wget ftp://ftp.gnupg.org/gcrypt/libgpg-error/libgpg-error-1.6.tar.bz2
bzip2 -d libgpg-error-1.6.tar.bz2
tar -xvf libgpg-error-1.6.tar
cd [...]

Posted in System Administration, Uncategorized | 1 Comment »

graft: Install and Configure package management

June 28, 2008

Graft is a great little tool for package management on UNIX systems such as Linux. The tool itself allows you to keep a package isolated in it’s own directory, and uses symlinks to combine them in with the rest of the operating system.
An example would be a new tool that has one binary and [...]

Posted in System Administration | No Comments »

nginx error – upstream sent too big header

June 23, 2008

We recently decided to test nginx with our CDN.  It seems that lighttpd just isn’t up the the task of serving high-connection rate services.  It was grinding to a halt on our systems as they started processing 400 – 600 connections per second.  We ended up running multiple lighttpd’s on single servers to alleviate this [...]

Posted in Research & Dev | 2 Comments »