Skip to main content

Posts

2008


Adjusting CPAN mirror list

··241 words·2 mins
One of the most frustrating aspects of CPAN is connecting to mirrors via FTP.

Backing up MySQL to Amazon’s S3

··123 words·1 min
I received an e-mail from Tim Linden about a post he made in his blog about backing up MySQL data to Amazon’s S3.

Forcing qmail to process e-mail in the queue

··92 words·1 min
Normally, qmail will be able to process the mail queue without any interaction from the system administrator, however, if you want to force it to process everything that is in the queue right now, you can do so:

Best PHP and MySQL development book

··167 words·1 min
I finally remembered this book when someone asked me about how to get started with PHP and MySQL development.

Reducing locking delays in MySQL

··801 words·4 mins
Before getting started, it’s important to understand why MySQL uses locks.

Small Companies: How to hire and fire a technical person

··1427 words·7 mins
DISCLAIMER: Okay, technical folks - I’m doing this as a favor to the general community of people that aren’t very technical, but they need to know some tips for ridding themselves of a technical person that is harming their business.

Strange error with Horde 3.1.3 and Plesk 8.1.1

··80 words·1 min
I saw a ticket the other day where a customer received this error from Horde when trying to expand items on the left pane of the interface:

sendmail: savemail panic

··139 words·1 min
If you see a large mail queue and your system’s I/O is increasing, you may find messages like these in your syslog:

Plesk and MySQL 5

··110 words·1 min
One of the questions I receive the most is: “What version of Plesk works with MySQL 5?

Removing news feeds in Horde

··95 words·1 min
If you’ve used newer versions of Horde with Plesk, you have probably noticed the news feed that runs down the left side of the screen.

MySQL Replication: Wrap-up

··71 words·1 min
After a couple of weeks, my MySQL replication series has come to a close.

MySQL Replication: Slave Performance

··124 words·1 min
There’s a few final configuration options that may help the performance of your slave MySQL servers.

MySQL Replication: Upgrading the MySQL server

··197 words·1 min
If you want to make a DBA nervous, just let them know that they need to upgrade MySQL servers that are replicating in a production environment.

MySQL Replication: Breakdown

··313 words·2 mins
On some occasions, MySQL replication can break down if an statement comes from the master that makes no sense to the slave.

MySQL Replication: Delayed Slaves

··385 words·2 mins
In a perfect world, slaves will contain the same data as the master at all times.

MySQL Replication: Horizontal Data Partitioning

··110 words·1 min
If you have a master with multiple slaves, you can get some performance and save money on hardware by splitting data horizontally among your servers.

MySQL Replication: Backups & Data Integrity

··180 words·1 min
An often overlooked benefit of MySQL replication is the ability to make reliable backups without affecting the integrity of the MySQL data.

MySQL Replication: Redundancy

··311 words·2 mins
Although performance is a much larger benefit of replication, it provides some redundancy for your application as well.

MySQL Replication: Performance

··269 words·2 mins
MySQL replication can increase performance by allowing developers to spread queries over two servers.

2007


Seven Step MySQL Replication

··133 words·1 min
MySQL replication may sound complicated, but it can be done easily.

Sort e-mail in Plesk with procmail

··190 words·1 min
One of my biggest beefs with Plesk’s e-mail handling is the lack of server-side filtering.