'MariaDB' Tag

• 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 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

• 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