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 [...]
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 [...]
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 [...]
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 [...]
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 [...]