theMySQLGuy Podcast

International Business Machines said on Friday it has agreed to buy in-memory database software provider Solid Information Technology from private owners for an undisclosed sum. Solid’s largest owners were private equity firms Apax Partners and CapMan.

Solid is expected to have 2007 sales of around $14.4 million, Vesa Wallden, a member of Solid’s board told Reuters. IBM said the acquisition is expected to close in the first quarter of 2008. “IBM’s acquisition of Solid Information Technology supports the company’s growth strategy and capital allocation model, and it is expected to contribute to the achievement of the company’s objective for earnings-per-share growth through 2010,” IBM said in a statement.

Story Copyright © 2007 Reuters Limited. All rights reserved.

 

 Episode 6 - SolidDB [8:47m]: Play Now | Play in Popup | Download

Recently we ran into a wall in one of my customers’ sites. They built an application that processed EDI documents. Each document, contained a list of transactions. Their application would launch a thread for each transaction in the document. On the surface this sounds good and the multi-threaded approach would speed up processing of a document.

InnoDB is the only built-in transactional storage engine and unfortunately has some limitations.

TX1 SET TRANSACTION ISOLATION LEVEL READ COMMITTED
TX2 SET TRANSACTION ISOLATION LEVEL READ COMMITTED
TX1 START TRANSACTION
TX2 START TRANSACTION
TX1 INSERT INTO child
TX2 INSERT INTO child (with same parent)
TX1 UPDATE parent
TX2 UPDATE parent (same parent row)

ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction

We solved this issue using a third party storage engine; solidDB.

Other storage engines available with MySQL

 

 Episode 5 - Federated Storage Engine [9:46m]: Play Now | Play in Popup | Download

Federated Storage Engine (FSE) allows you to connect to a remote server and “mount” a table on your local server, which links to the data on the remote server, for read-only access.

$ mysql -u root -ppassword -h remote

mysql> CREATE DATABASE test;

mysql> use test;

mysql> CREATE TABLE drivers (id INT,name VARCHAR(100));

mysql> INSERT INTO drivers (id, name) VALUES (1, ‘Chris’);

mysql> INSERT INTO drivers (id, name) VALUES (2, ‘Sheeri’);

mysql> INSERT INTO drivers (id, name) VALUES (3, ‘Elie’);

mysql> select * from drivers;

+------+--------+
| id   | name   |
+------+--------+
|    1 | Chris  |
|    2 | Sheeri |
|    3 | Elie   |
+------+--------+
3 rows in set (0.08 sec)

mysql> exit;

$ mysql -u root -ppassword -h local

mysql> CREATE DATABASE test;

mysql> use test;

mysql> CREATE TABLE drivers (id INT,name VARCHAR(100)) ENGINE=FEDERATED
CONNECTION=’mysql://root:password@remote:3306/test/drivers’;

mysql> select * from drivers;

+------+--------+
| id   | name   |
+------+--------+
|    1 | Chris  |
|    2 | Sheeri |
|    3 | Elie   |
+------+--------+
3 rows in set (0.14 sec)

mysql> exit;

Enjoy FSE tables!

Bye! Thanks for all the fish!

christos@themysqlguy.com

I wanted to let you know all about a blog and podcast I have been reading/listening to lately. Its called OurSQL and the author is Sheeri Kritzer.I have been in email contact with Sheeri and she seems like a really great person. Why wouldn’t she be? She’s a MySQL DBA after all! The self proclaimed “She-BA”.

Check out her blog at sheeri.net and her Podcast OurSQL on iTunes.