'MySQL' Tag

• What is this MySQL file used for?

  February 16, 2011

  MySQL keeps many different files, some contain real data, some contain meta data. Witch ones are important? Witch can your throw away? This is my attempt to create a quick reference of all the files used by MySQL, whats in them, what can you do if they are missing, what can you do with them. [...]

  posted in Tips & Tricks by mark

• 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 GIS – Part 6

  November 12, 2010

  Is MySQL’s GIS really worth using? Is GIS worth using in MySQL? In the past few post, I have explored what GIS is and how it is used. GIS encoded data is wonderful and can help with all kinds of cool queries.  I’m late getting this article written so lets get right to it. The [...]

  posted in GIS by mark

• MySQL GIS – Part 4

  September 21, 2010

  WHAT CAN YOU DO WITH GEO DATA? Geo spatial indexes are what make this type of data valuable.  With shape and point data you can find relationships between object in our physical world.  How close is the lightning in the storm front?  What homes where hailed on? (WDT) What schools are in my city?  With a [...]

  posted in GIS 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

• Does Size or Type Matter?

  July 27, 2010

  MySQL seems to be happy to convert types for you. Developers are rushed to complete their project and if the function works they just move on. But what is the costs of mixing your types? Does it matter if your are running across a million rows or more? Lets find out. Here is what the [...]

  posted in Tips & Tricks, Tunning 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

• Federated Tables

  July 7, 2010

  Your searching for how to create a join across two databases on two different servers and it can’t be done directly.   select  d1.a, d2.b from db1@server1 join db2@server2 where db1.c = db2.c; does not work. You learn about federated databases.  The federated storage engine allows accesses data in tables of remote databases.  Now how do [...]

  posted in Tips & Tricks by mark

• Slapping MySQL-Proxy

  June 28, 2010

  I have old applications that need to read (and write) MyISAM tables that themselves receive lots of bulk updates. Time to try MySQL-Proxy. MySQL Proxy is light on documentation and very few people written anything about working.   Most of what I have read says MySQL-Proxy is not ready for prim time.  I have hope so [...]

  posted in Commentary by mark