'Commentary' Category

• The Full Monty- Part 2

  August 15, 2011

  Installing DRDB in CentOS 5.6. In Part 1 I when through the process of preparing a number of CentOS 5.6 servers. Now make the services they’ll preform more stable. High Availability (HA) I’ll be presenting two ways to provide redundant data and high available services. First, Pacemaker – with DRDB will duplicate your data at [...]

  posted in Commentary by admin

• Update to AutoMySQLBackup.sh

  January 28, 2011

  For a long time I though the AutoMySQLBackup project had died.  Then, after I created many updates, in November of last year I saw some life. Meanwhile, I have continued to update the code and track what people have requested.   Low volume project are sometimes hard to keep alive. People think the project is dead [...]

  posted in Commentary by mark

• It’s about Time.

  January 27, 2011

  WHAT TIME IS IT? This post started with a simple question: “Does the function NOW() get executed every time a row is examined?” According to the manual,  “Functions that return the current date or time each are evaluated only once per query …. multiple references to a function such as NOW() … produce the same [...]

  posted in Commentary, Tips & Tricks, Tunning by mark

• HandlerSocket plugin – NoSQL/SQL interactions

  December 28, 2010

  HandlerSocket is cool. But, it turns out there are a few issues. Justin Swanhart points out HandlerSocket currently lacks atomic operations . Since HandlerSocket uses different connections for reading and writing, you can’t increment/decrement a value without creating a race condition. Still, the idea of skipping SQL interpretation and just reading the data you know [...]

  posted in Code, Commentary 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

• Book Review: Web Operations

  October 19, 2010

  Web Operations - Keeping the Data On Time ByJohn Allspaw, Jesse Robbins Publisher:O’Reilly Media Released:June 2010 This is simply the best book on running a commercial web services I have ever read.  Lots of texts cover parts and pieces of the what it takes from to manage a website. They will tell you how to configure Apache or how [...]

  posted in Commentary by mark

• MySQL GIS – Part 5

  September 28, 2010

  VIEWING THE DATA You’ve seen in the last few postings how to find, import and use GIS data with MySQL. But, the ‘G’ in geographical includes GRAPHIC and a little eye candy never hearts your understanding of the curves. Everyone knows of  map.google.com.  Mark McClure has a great site explaining the use of Google’s APIs.  [...]

  posted in Commentary by mark

• Reply to – Finding a Good DBA

  September 17, 2010

  On DBA Survivor, Thomas LaRock blogged about “Finding a Good DBA“.  This is a reply. Tweet

  posted in Commentary by mark

• MySQL GIS – Part 2

  August 30, 2010

  The “DATA” “The wonderful thing about standards is that there are so many of them to choose from.” – Grace Hopper A Shape file is the most common format for GIS vector data and just about every GIS program can use them.  Unfortunately not all GIS data come in a shape file format. An E00 [...]

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