'CentOS' Tag

• PostGIS 1.5 in Postgresql 9.0 install on CentOS 5.6

  July 14, 2011

  I love short and consist install instructions. I know this is a MySQL blog but our good friend PostGreSQL has a great GIS library. This is what I learned upgrading our PostGIS system to GIS 1.5. Much thanks to Jeremy Tunnell for give this document it’s start. Start with CentOS 5.6 x86_64 basic install. Add [...]

  posted in CentOS, HOW TO by admin

• Using HandlerSocket Plugin for MySQL with PHP

  December 28, 2010

  This document was updated and tested for CentOS 6.0 In my last two posts I installed the HandlerSocket plugin into MariaDB and showed how to use it with Perl.  That’s good, but if you are thinking of using HandlerSocket  I’m guessing you have a very high traffic website and it’s written in PHP.  In this [...]

  posted in CentOS, Code, HOW TO by mark

• Using HandlerSocket Plugin for MySQL with Perl

  December 23, 2010

  In my last post I installed the HandlerSocket plugin into MariaDB and tested it.  Like the last post these examples are done with Linux CentOS 5.5. HandlerSocket some with Perl code for the Net:: module group. When you build and install the HandlerSocket plugin it does not build the Perl module. I looked and it [...]

  posted in Commentary, HOW TO by mark

• MySQL HA with DRDB and Heartbeat on CentOS 5.5

  July 20, 2010

  This is one of a few MySQL High Availability strategies.  I have used this for years and found it work great.  If you don’t know about DRBD and MySQL you should read Peter’s comments. These are step by step instructions for Redhat 5 or CentOS. If you need more details please refer to: http://www.drbd.org/users-guide/ Configuring [...]

  posted in CentOS, DRDB, HA, Heartbeat, Redhat by mark

• Install MariaDB on RedHat 5.4

  May 4, 2010

  Is MariaDB really a drop in replacement for MySQL?   I’m running CentOS 5.4.  What happens if… Use “mysqldump –all-databases > FullBackup.sql” to make a full backup. (Better safe then sorry) Go to http://askmonty.org/wiki/MariaDB:Download and download the CentOS 5 packages. Stop msql “service mysqld stop” Pull MySQL out by the roots with “rpm -e mysql-server mysql [...]

  posted in Commentary by mark

• Compiling Drizzle on CentOS 5.4

  April 6, 2010

  I was able to compile Drizzle on CentOS today thanks to Neil Armitage post on his website. Clean install centos 5.4 with Development Tools and Development Libraries yum groupinstall “Development Tools” yum groupinstall “Development Libraries” Setup the drizzle user account and allow it to sudo /usr/sbin/visudo uncomment %wheel ALL=(ALL) NOPASSWD: ALL useradd drizzle gpasswd -a [...]

  posted in Tips & Tricks by mark