Again, I have moved to a new hosting provider after my free-tier with Amazon EC2 expired.  As usual I was looking for a good VPS provider with a decent price, providing good support and in particular a provider supporting FreeBSD, my favorite OS for server (for desktop I still prefer GNU/Linux.)

This time I have carefully reviewed many options and have finally settled with RootBSD, one of the reputed VPS hosting providers if you are choosing FreeBSD as your server OS.  One of the prime reasons for choosing FreeBSD is its performance, stability and the FreeBSD ports system.

Although my …

New feature provides significantly faster insight and root cause analysis

SAN JOSE, Calif., February, 15, 2012 – Monitis, the leading cloud and web application monitoring software provider, today announces that it has added comprehensive MySQL database monitoring to its award-winning Application Performance Management & Monitoring platform. The robust Software-as-a-Service (SaaS) tool enables users to gain significantly faster insight when conducting root cause analysis.

The MySQL monitoring feature includes 246 monitoring variables and more than 21 different metrics to provide one of the easiest to use, yet comprehensive database monitoring tools available. It was first introduced into the free Monitor.Us platform back in June last year and has seen the code battle hardened by many hundred free users over the last 8 months.

…

Read the original article at 5 Tips to Cache Websites and Boost Speed

Often when we think about speeding up and scaling, we focus on the application layer itself.  We look at the webserver tier, and database tier, and optimize the most resource intensive pages.

There's much more we can do to speed things up, if we only turn over the right stones.  Whether you're using WordPress or not, many of these principals can be applied.  However we'll use WordPress as our test case.

Test Your Website speed

There are web-based speed testing tools that will help with this step.  Take a look at Webpagetest , …

Have you ever noticed that, if you implemented Facebook like or Facebook Share in wordpress blog and when people click Like the shared post on user wall looks not good most of the time. This is because you didn’t implement the facebook open graph meta data in your blog post or page. As a result when facebook parse the link sometimes they can’t parse it properly that you expected.

To solve the situation you’ve to add open graph meta data in your site. Some days ago I manually added this in my blog’s theme, but later I decided to make a wordpress plugin so that it become easier to use and share with others.

My plugin features:

1. Automatically set facebook open …

WordPress sites can get big. Really big. When you’re looking at a site of Cheezburger, Engadget or Techcrunch proportions, you get hundreds of comments per post, on dozens of posts per day, which adds up to millions of comments per year.

In order to keep your site running in top condition, you don’t want to be running queries against tables with lots of rarely accessed rows, which is what happens with most comments – after the post drops off the front page, readership drops, so the comments are viewed much less frequently. So, what we want to do is remove these old comments from the primary comment table, but keep them handy, for when people read the archives.

Enter partitioning.

The idea of MySQL partitioning is that it splits tables up into multiple logical tablespaces, based on your criteria. Running a query on a single partition of a large table is much faster than running it across the entire table, even with …

Since the GA release of Drizzle7 I’ve had several people asking me about how to convert their MySQL sites to use Drizzle instead.  By far the most common one to crop-up is WordPress.  This is aimed to be a simple guide to starting a new blog using WordPress 3.1 and Drizzle.

Initial Problems

WordPress by design is very MySQL orientated, for the most part this is good thing, but when trying to switch to another database for it there can be complications.  An attempt has been made to create a plugin to use Drizzle, but unfortunately it has side-effects such as modifying your content if you happen to blog about anything related to MySQL or Drizzle.  For the purposes of this blog post I have create a patch and will give instructions on how to use it below.  If any WordPress guru has a way to make this into a good plugin, please get in touch!

Conversions Needed

Almost all the conversions for …

Since the GA release of Drizzle7 I've had several people asking me about how to convert their MySQL sites to use Drizzle instead.  By far the most common one to crop-up is Wordpress.  This is aimed to be a simple guide to starting a new blog using Wordpress 3.1 and Drizzle.
Initial Problems
Wordpress by design is very MySQL orientated, for the most part this is good thing, but when trying to switch to another database for it there can be complications.  An attempt has been made to create a plugin to use Drizzle, but unfortunately it has side-effects such as modifying your content if you happen to blog about anything related to MySQL or Drizzle.  For the purposes of this blog post I have create a patch and will give instructions on how to use it below.  If any Wordpress guru has a way to make this into a good plugin, please get in touch!
Conversions Needed
Almost all the conversions for Wordpress …

The new year is here and I have moved my (so far quite silent) blog to use WordPress and MySQL 5.5 GA.

Since I am using Ubuntu I downloaded a compressed tar archive. I installed it in a custom directory and for starting I wrote a little upstart script.

$ cat /etc/init/mysql-5.5.conf
start on startup
stop on shutdown

env basedir=/opt/mysql/mysql-5.5
env defaults=/etc/mysql-5.5/my.cnf

script
        cd $basedir
        $basedir/bin/mysqld_safe --defaults-file=$defaults
end script

In wp-config.php I have set:

define('DB_HOST', …

A special extended edition of Tech Messages for 2010-12-22 through 2011-01-04:

• WS-C3560V2-XXXX-X, WS-C3750V2-XXXX-X Series RPS cover and rare power reset – Replacement Recommended
  The RPS cover for wall-mount of the Acc Kits in the BOM was not correct; it should be 22P instead of 14P. The issue is a safety issue for those who choose to wall-mount the RPS. It's found on WK48P/NZ48P that the magjack connector's shielding were short to the test via 2.5v to ground. Adding capton tape underneath Belfuse/Pulse connector to avoid the short via ECO as a short term solution will respin PWB to correct issue.
• WordPress › 3.0.4 Important Security Update
  Time to update!
• …

I did a clean install on my Macbook Pro this morning, part of the clean install means, re-downloading things like MySQL.

When I installed it, I noticed that the pref-pane wouldn’t start MySQL. Even when it asked for my admin password. I thought maybe it was a boot up issue, so I rebooted, and got an error telling me that the permissions for the start up item were in secure.

Here’s what I did to debug/fix the problem.

• Change permission of /Library/StartupItems/MySQLCOM/MySQLCOM
• edit /usr/local/mysql/support-files/mysql.server and edited line 46 and 47 to say

chown -R root:wheel /Library/StartupItems/MySQLCOM
x

[content_box style="yellow-box" title="Edit mysql.server file"]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
[/content_box]

[break]
There is already a …