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!)

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