WoW – Wordpress on Windows

JessCoburn.Com running on ARR! and that not be Pirate speak thar Matey!

3 Blog posts to say “Hey I’m running on my site load balanced using ARR”. This is the third and hopefully last blog post for tonight.  I posted two other posts tonight:

  1. Discusses the first stage of Applied Innovations Cloud Initiative.
  2. Discusses ARR & Load balancing.

All of this was to explain how I’m running my website currently (which I tend to test everything on first so I break it a lot but you have to break eggs to make cake, right?).

ARR or Application Request Routing is a new extension to IIS7 that allows you to turn a Windows Server (or VPS as in my case) into an Application Aware Load Balancer with such features as offloading compression and SSL encryption!

How I’m running JessCoburn.com

For the past year and a half, JessCoburn.com has (and continues to) run on a shared web hosting server that runs IIS7 on top of Windows Server 2008. My site is treated identically to how my customers sites are treated as I firmly believe in eating your own dog food (no not ALPO but using the same services you sell). The site makes use of FastCGI to run the PHP engine and backends to a shared MySQL server. All of our shared web servers connect to the SQL servers via a private dedicated gigabit network for optimal performance. In addition, I make use of expiry headers for output caching of my images and also use the wordpress plugin supercache to reduce my reliance on MySQL queries so my pages render faster.  So that’s why it’s been fast, I think you’d agree that’s pretty well optimized for a Windows shared hosting website (same thing you could for as little as $8.33 a month with one of our Windows hosting accounts..  Sure it’s optimized but there’s still a problem.

What’s the problem with JessCoburn.com?

The problem is my web site runs on a single web server. This means if there’s maintenance on the box (don’t worry we do this during load traffic times) there’s still potentially downtime. This also means if my site ever gets popular enough to make the first page of DIGG or REDDIT (use those social bookmarks please) then no matter how much I optimize my site on that one web server, I could have a problem… These are the trade-offs we accept with shared hosting (today).

But what if, I could run JessCoburn.com on multiple web servers and load balance them? Yeah who’s going to go out and spend 20K to load balance his little wordpress blog (the profit margins aren’t that good you know).  Well thanks to our own cloud computing initiative and the good folks on the IIS Team at Microsoft I can do just that for peanuts! Today!

My new configuration

I have a Windows 2008 VPS running IIS7 with ARR 2.0 Beta 2 on it. It’s of course running on our High Availability Managed Windows VPS Hosting Cluster.  I also have JessCoburn.com still running on the shared Windows Hosting server running on IIS7 and I setup another VPS server running on top of Virtuozzo running Windows 2003 and copied the site there. Just to show that you can route requests to any kind of server.  Both servers back end to the same MySQL server.

All requests for JessCoburn.com come into the ARR server and it then proxies these requests between the Shared Server and the Win2003 VPS server.  In the event one of the sites crashes, is down or has problems, ARR will redirect all requests to the other server.

image.png

The easy way to create your first WordPress Theme.

Tired of trying to find just the right wordpress theme? There’s millions of them to choose from afterall. Would love to create your own but have less artistic talent now than you did in Kindergarten with a box of busted chunks of crayolas? (You know what I’m talking about. First week of school you had brand new Crayolas by the second week they were all bits and pieces and nubs)

Well No worries! Artisteer to the the rescue!  If you can use word, if you can click a couple buttons you can create your own WordPress theme with ease.

Creating your first wordpress theme is as easy as 1, 2, 3

After you download and install Artisteer you’ll want to run (uh duh, tell me something I didn’t know Jess). You’ll be prompted to pick what kind of theme you want to create and it supports more than just WordPress. In fact today it supports WordPress, Joomla, Drupal, an HTML template, an ASP.NET Application and a CodeCharge Studio Template (CodeCharge is for wannabe programmers just like us wannabe artists, I’ll talk about it in the next series and yeah, I use it too and no real programmers use it too).

Here’s the startup screen:

image

You’ll select WordPress and then get a screen like this:

image

Now with absolutely ZERO artistic ability and effort. I could export that theme and have just created my first WordPress theme. Let me show you how.

First you’ll click on the Export Button on the top right.  and it will prompt you with a screen:

image

You’ll give it a name and set a path to where you want it to export to as I did above and then click the OK button to let the magic happen. Open up that folder you had it export to and ta-dah! There it is:

image

That’s it upload that folder to your  wwwroot/wp-content/themes folder and you’ve got your own theme installed and ready to go.

Here’s my blog right now (that uses an artisteer theme)

image

and Here’s my blog with that new theme we just created selected as the theme to use:

image

Just as easy as 1, 2, 3 I was able to completely change up my blog’s design.

Making the Artisteer theme, your theme.

Here’s the thing. I don’t really care for the yellow sunburst, the palm trees or  general layout of this theme so let’s change it up. By clicking the “Suggest Design” a few times, artisteer will randomly create some suggested designs for me and every time it’s something completely different.

After three clicks I got this:

image

I like the design, but I don’t care for the colors. So I click the suggest colors button a few times and I get:

image

Those are colors I can live with but I don’t like the background so guess what, I click suggest background:

image

Now I can go through and get suggestions for every element of my theme and I can also go in and tweak the particular features of the theme as well. Let’s look at the header. I want to change it up. So at the top I click Header and get a new menu bar at the top:

image

Now I can change the background image, the text location, add a foreground photo, etc, etc, etc.

With a little playing around (and don’t worry if you goof it up just click the undo button at the very top to roll back) this is what I came up with:

image

Yeah, I know what’ you’re thinking. That’s one scary clown Jess.. But you get the idea, you can tweak every single element of your theme and if you actually have (unlike me) more artistic talent than you did in kindergarten with those broken bits of crayola, it will look pretty nice.

If you haven’t grabbed artisteer yet, definitely do head over and give it a whirl.

image.png

Cleaning out unused tables in your WordPress Blog

Today I moved my database from a MySQL 4 database server to a MySQL 5 database server, for no reason other than to move to 5. But I found a ton of tables in my database for various plugins that I knew I was no longer using. In fact, I had disabled ALL plugins shortly before this move.  I wanted to go in and delete all tables except those absolutely required for a base wordpress install.

To do the clean up I used two things:

  • a plugin called CleanOptions for WordPress
  • a MySQL database client

Before the cleanup

Here’s what my tables looked like before:

image 

and

image

After the cleanup here’s what was left

image

Here’s how I did it.

Step 1 backup your database (you never know)

Step 2 remove database tables I no longer require

By working off the Database Description in the WordPress Codex I was able to identify what tables were absolutely required by WordPress in a default install. Since all plugins were deleted/disabled all other tables were not needed. So I nuked them.

Step 3 remove all options no longer required.

This involved installing and executing the Clean Options plugin and best I can tell it got everything.

Finally re-enable the plugins I required

The only plugins I kept after this clean up were Akismet, WP-SuperCache (I didn’t need to hack it to work, it just worked this time) and a lightbox plugin that I need to re-enable. I like to test out and install plugins so I had so much garbage in there over the past few years that I really needed to clean house. Well, the house is very clean now I also deleted more than 120 different themes I had tested over the years and only have the default themes and the one I’m currently using enabled now.