Pablowe

MySQL RSS Feeds

Issue Five of MySQL Magazine just came out and it included the results from its Annual MySQL Usage Survey. Among a bunch of other cool information, it asked the question: “What is your favorite blog?” (Q26). The results were as follows:

The first interesting thing that I noticed was that the #1 result (with 100 votes) is not an actual blog, but rather a domain owned by a squatter (current asking price is $2,000USD). I assume that they meant http://www.mysqlperformanceblog.com/. So, in the spirit of sharing favorite blogs, I have compiled a list of all of the MySQL-related RSS feeds that I follow regularly. The list is maintained here.

http://dammit.lt/ - domas mituzas: vaporware, inc.
http://izoratti.blogspot.com/ - Ivan Zoratti’s Blog (on MySQL)
http://jpipes.com/ - Jay Pipes
http://mysql-dba.com/ - The MySQL DBA Feed Resource
http://www.planetmysql.org/ - Planet MySQL
http://www.mysqlperformanceblog.com/ - MySQL Performance Blog
http://feeds.feedburner.com/techrepublic/datacenter - Servers and Storage
http://ramonspage.blogspot.com/ - Ramon’s Page (MySQL Cluster)
http://mysql-ha.com/ - High Availability MySQL
http://blogs.sun.com/carriergrademysql/ - MySQL in Communications Blog
http://blog.plasticfish.info/ - Jon Stephens
http://mikaelronstrom.blogspot.com/ - Mikael Ronstrom
http://jonasoreland.blogspot.com/ - Jonas Blog (MySQL Cluster)
http://www.bcs.org/server.php?show=ConBlog.5 - Johnny’s Data Migration Blog
http://johanandersson.blogspot.com/ - Johan Andersson’s Blog (High Availability MySQL)
http://blog.kovyrin.net/ - Homo-Adminus Blog
http://highscalability.com/ - High Scalability
http://database-programmer.blogspot.com/ - The Database Programmer
http://crazydba.blogspot.com/ - Crazy DBA
http://www.xaprb.com/ - Baron Schwartz
http://datacharmer.blogspot.com/ - The Data Charmer
http://krow.livejournal.com/ - Brian Aker
http://www.jpipes.com/ - Jay Pipes
http://www.pythian.com/blogs/ - Pythian
http://jcole.us/blog/ - Jeremy Cole
http://www.pablowe.net/ - My Blog:)
http://www.honeysoftware.it/sleto/blog/ - Yabomsat! (Yet Another Blog On MySQL® Server Administration, monitoring and Tuning!)

Start Slide Show with PicLens Lite

Setting Up WordPress on FreeBSD

I suppose that it is only fitting that my first blog post be an instructional tidbit on installing WordPress on FreeBSD. As primarily a Linux user, I find the BSD package management system tedious at times. First, version information:

FreeBSD 7
Apache 2
MySQL 5.0.51a
PHP 5.2.6

This tutorial assumes two jails; one that serves as a MySQL database server, the other that functions as the web server.

Step 1: Install MySQL

On the host that will serve as your MySQL database server, run the following commands:

bash> cd /usr/ports/databases/mysql50-scripts
bash> portinstall -pvf
bash> cd /usr/ports/databases/mysql50-client
bash> portinstall -pvf
bash> cd /usr/ports/databases/mysql50-server
bash> portinstall -pvf
bash> /usr/local/etc/rc.d/mysql-server rcvar

Add the following line to /etc/rc.conf:

mysql_enable="YES"

Issue the following commands:

bash> mysql_install_db
bash> mysql_secure_install

Add a WordPress database and user in MySQL:

bash> mysql -uroot -p
mysql> CREATE DATABASE IF NOT EXISTS `wordpress_db`;
mysql> GRANT ALL PRIVILIGES ON `wordpress_db`.* TO 'wordpress_user'@'‘ IDENTIFIED BY ‘ ‘;

The rest of the steps will be on your webserver:

Step 2: Install Apache

bash> cd /usr/ports/www/apache20
bash> portinstall -pvf

Step 3: Install PHP

bash> cd /usr/ports/lang/php5
bash> make config

Check the “Build Apache Module” checkbox to enable mod_php:

bash> portinstall -pvf

Step 4: Configure & Start Apache

Add the following line to /usr/local/etc/apache2/httpd.conf in the “Dynamic Shared Object (DSO) Support” section:

LoadModule php5_module libexec/apache2/libphp5.so

Start Apache:

bash> apachectl restart

Step 5: Install MySQL Client

bash> cd /usr/ports/databases/mysql50-client
bash> portinstall -pvf
bash> cd /usr/ports/databases/php5-mysqli/
bash> portinstall -pvf

Step 6: Install and Configure WordPress

bash> cd /usr/ports/www/wordpress
bash> portinstall -pvf
bash> cd /usr/local/www/data-dist/wordpress/
bash> mv wp-config-sample.php wp-config.php

Edit the following lines of wp-config.php to suit your installation (refer to step one):

define('DB_NAME', '');
define('DB_USER', '');
define('DB_PASSWORD', '');
define('DB_HOST', 'localhost');
define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');

define('SECRET_KEY', '');

Step 7: Perform WordPress Setup

Visit your new blog in your favorite browser and follow the simple steps. Viola! You are now running WordPress:)

Start Slide Show with PicLens Lite Tags: WordPress on FreeBSD