OpenAds 0.3.30-alpha to 2.4.2 Upgrade
There's a nice clear upgrade path from 0.3.31-alpha-pr3 but not from 0.3.31-alpha. Thankfully OpenAds is a well written app and rolling up to 0.3.31-alpha-pr3 wasn't much of a problem.
EDIT : Totally not true any more with the 2.4.4 release.
Well now of course OpenAds has become OpenX since I've been dragging my feet on getting this up. However that doesn't change the underlying code much and the changes from 2.4.2 to 2.4.4 aren't that great.
What's even nicer is in the release notes upgrades from v0.1.29-rc now appear supported. 2.4.2 required v0.1.31-alpha-pr3. So I guess this post is a bit deprecated but might still help some. The install/upgrade procedure on the OpenX site is also recommended reading.
Let me get back to the initial upgrade that I meant to be writing about. The install that I was working on upgrading has been in use since way back when OpenX was known as phpAdsNew and version 2.0 was not released yet. As such sometimes upgrades require just a little more manual massaging.
While v0.3.30 was running well enough there were plenty of change in the move to 2.4.x and it's always good to keep current especially for security. My main goal was to speed up things a bit more on the admin site of the install. Along with the code upgrade I also switched all my tables to MyISAM type instead of InnoDB.
The CPU usage graphs below is from my webserver and the other is a query graph of my DB server. There is an increase in overall CPU usage once the upgrade was in place on the webserver went up a bit. The two query graphs show that my cronjob for maintenance seemed to have stopped working. Once it was enabled the queries went back to normal.
Overall Openads/OpenX continues to support what we need extremely well. It's versitile to handle some interesting ad formats without requiring much tinkering.
As always remeber to back up those databases before preforming upgrades.
Search Google for openads upgrade
February 21st, 2008
Leave a Reply