Tag Archives: Upgrade

Installing PHP 5.3 and PHP 5.4 on Mac OSX with HomeBrew

June 6, 2012 9:54 am /

Installing PHP 5.3 and 5.4 is really easy with HomeBrew. PHP is included with Snow Leopard and Lion, but isn’t the latest version. If you want to run a newer version of PHP, such as PHP 5.4, you can install it through HomeBrew.

Here’s a site with good instructions on installing PHP via HomeBrew.
http://justinhileman.info/article/reinstalling-php-53-on-mac-os-x/

The only change that I had to make was with the brew install command since there are now two versions supported (5.3 and 5.4).
PHP 5.3:
brew install php53 --with-mysql --with-intl

PHP 5.4:
brew install php54 --with-mysql --with-intl

Posted in: Mac OS X, PHP / Tagged: , , ,

Upgrading Debian Lenny to Squeeze with MySQL for row-based-replication

October 28, 2011 5:46 pm /

I completed an upgrade of Debian Lenny to Squeeze on a production database server over the weekend. It went quite well and I had zero downtime thanks to my secondary database servers running in-place. One of the biggest benefits to running Squeeze is that MySQL runs at version 5.1.49. Lenny only supports up to MySQL 5.0.

Row-based-replication is safer to replicate data to other servers since all changes are replicated. Prior to MySQL 5.1.14, updates to the mySQL database were not replicated. They were updated via statements (e.g. GRANT, REVOKE). This can potentially cause data-consistency between the master and slave servers, if one runs a INSERT and SELECT (w/o ORDER BY) as the order of the results will be different. If you had a SQL statement on the MySQL database that ends up erroring out, your slave connection to the master server would stop.

Read More →

Posted in: debian, MySQL / Tagged: , , , ,

WordPress MU: Fix broken images on 2.9 to 3.0 upgrade

July 28, 2010 11:08 am /

If you have noticed all your blog images breaking after upgrading to WordPress 3.0 from WordPress MU, you will need to make a simple change to the .htaccess file.

Read More →

Posted in: PHP, wordpress / Tagged: ,