'HOW TO' Category

• What can I DROP?

  September 30, 2011

  So you have inherited a MySQL server and no one know what applications are use what databases.   Space is every tight and every night transactions logs almost fill your hard disk.  The server was once used as a replication server and it seems every database the company uses is duplicated here. You could do [...]

  posted in HOW TO by admin

• The Full Monty – CentOS 5.5, drbd, PaceMaker, MySQL, Tunsten Replication and more

  August 1, 2011

  PART 1 – This will be a multi part post. After years of supporting MySQL, for many different companies, I’ve seen this story played out again and again. The company: chooses a Database Management System (MySQL) installs the DBMS on a computer with other processes writes many programs to access the data (Without concern on [...]

  posted in CentOS, DRDB, HA, Heartbeat, HOW TO, Tips & Tricks by mark

• 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

• Installing HandlerSocket (NoSQL plugin) into MiariaDB on CentOS 5.5.

  December 21, 2010

  The title says it all. If you don’t know what HandlerSocket is or why you would want to use it you need to reads Yoshinori Matsunobu’s blog post. Lets get started. login as root Make sure you have these packages installed: yum install git perl libtool gcc make openssl-devel gcc-c++ perl-DBI perl-DBD-MySQL.x86_64 If you haven’t [...]

  posted in CentOS, HOW TO by mark

• MySQL GIS – Part 1

  August 23, 2010

  In my business (weather) we use lots map based (Geo) information.  Almost every table has latitude and longitude. Working with this kind of data can be exciting and frustrating.  This should give you a quick start into GIS with MySQL. “A geographic information system (GIS), or geographical information system, is any system that captures, stores, [...]

  posted in GIS, HOW TO, Tips & Tricks by mark