In his blog, Vadim reports that a new storage pluggable engine for MySQL has appeared in the source tree, to support IBM DB2 for i as a back-end.This reminds me that I hate the IBM System i platform (aka IBM Power Systems, aka iSeries, aka AS/400).Don't get me wrong -- I'm sure it's terrific technology. I'm sure IBM supports many businesses with it and they're happy (although I do wonder why

This time I'll write about a nice featured we now have on the MySQL Proxy.

Parsing master.info
The master.info is a file that the MySQL server creates when you are running a slave server, you can read the manual for more details.
And now you can use the MySQL Proxy to read that file and parse the data from it.

Background
It all started when Jan emailed the proxy discuss mailing with the Changelog from 0.6.1 to 0.7.0. The part that got my attention was:
"...
Core
[skip]
* added parser for master.info files"
... "
As I was working on a Lua script that did some simulation, I …

When you have to evaluate a MySQL System & Environment, what questions do you ask in order to determine critical information about the environment and evaluate the business success and viability. You don’t have to be a consultant to ask these questions, ask them of your own environment. Do any of the answers shock or concern you?

I was prompted to write about this from a conversation with a colleague about “accepting risk”. His comment was, “every IT server on the planet is vulnerable regardless of best practices.”

Here is my list of questions for you based on an immediate response from this discussion?

Technology

• What is your full technology stack, i.e. Operating System, Database, Application Server, Development Language(s) and other essential components?
• What are the versions of these technologies?
• What new technologies or versions of existing technologies are you …

This is the Who-is-who of the MySQL driver for C++. From top left to bottom right: Andrey Hristov, Edwin Desouza, Lawrenty ‘’Lawrin'’ Novitsky (the older guy), Ignacio “Iggy” Galarza, Georg Richter, Kent Boortz, Elizabeth “Liz” Drachnik, Michael “Mike” Frank, Anthony “Tony” Bedford.

Andrey Hristov is the main developer of the driver. He has earned credits at MySQL before as the developer of the Event Scheduler and the MySQL native driver for PHP (mysqlnd).

Edwin Desouza is responsible for the morning greetings. Every second morning we can expect to see some suggestions or hints from him on how to improve the driver. Edwin works as a Senior Director Product …

This is the Who-is-who of the MySQL driver for C++. From top left to bottom right: Andrey Hristov, Edwin Desouza, Lawrenty ‘’Lawrin'’ Novitsky (the older guy), Ignacio “Iggy” Galarza, Georg Richter, Kent Boortz, Elizabeth “Liz” Drachnik, Michael “Mike” Frank, Anthony “Tony” Bedford.

Andrey Hristov is the main developer of the driver. He has earned credits at MySQL before as the developer of the Event Scheduler and the MySQL native driver for PHP (mysqlnd).

Edwin Desouza is responsible for the morning greetings. Every second morning we can expect to see some suggestions or hints from him on how to improve the driver. Edwin works as a Senior Director Product …

Introduction

DBT2 is a TPC-C like benchmark tool supporting MySQL. The results of a test run include transactions per minute, CPU utilization, I/O activity, and memory utilization. The DBT2 test kit can be downloaded from the DBT sourceforge site. The purpose of this document is to show how to use the virtualization technology: Solaris container to scale-out multiple mysql instances on the Sun's CoolThreads server.

Hardware and Software configurations

Sun SPARC T5240 Server: 2x8-core UltraSPARC T2 Plus(1165 Mhz,128 Threads) Processor; 64GB RAM; 2x146GB Internal Disk

Database: MySQL 5.1.30

Operating System: Solaris Express Community Edition snv_98 SPARC

Test Case 1: Single MySQL server on T5240 in 32 warehouse DBT2 Test …

Introduction

DBT2 is a TPC-C like benchmark tool supporting MySQL. The results of a test run include transactions per minute, CPU utilization, I/O activity, and memory utilization. The DBT2 test kit can be downloaded from the DBT sourceforge site. The purpose of this document is to show how to use the virtualization technology: Solaris container to scale-out multiple mysql instances on the Sun's CoolThreads server.

Hardware and Software configurations

Sun SPARC T5240 Server: 2x8-core UltraSPARC T2 Plus(1165 Mhz,128 Threads) Processor; 64GB RAM; 2x146GB Internal Disk

Database: MySQL 5.1.30

Operating System: Solaris Express Community Edition snv_98 SPARC

Test Case 1: Single MySQL server on T5240 in 32 warehouse DBT2 Test …

No, this is not about Sun and IBM This is about MySQL. If you download latest 5.1.33 source code you may find there storage/ibmdb2i directory, which obviously is IBM DB2 related. Interesting that there is no mentioning of new engine in Announcement http://dev.mysql.com/doc/refman/5.1/en/news-5-1-33.html.
Quick look into source code says

PLAIN TEXT CODE:

1. MYSQL_STORAGE_ENGINE([ibmdb2i], [], [IBM DB2 for i Storage Engine],                                                               
2.         [IBM DB2 for i Storage Engine], [max,max-no-ndb])    …

It's been a few days since returning from the Pentaho Partner Summit. When I get the chance to attend company events, conferences or seminars (the opportunities are rare), I try to sum for myself the benefits of having traveled, gathered and given my attention to the occasion at hand.

In the case of the Partner Summit, I thought of several key revelations that came about as a result of the trip. The one that stands at the forefront of my mind: every developer needs a roadshow.

Not as a roadie in a product tour, or as booth Bob at a trade show, but as an interested attendee at an event that showcases whatever you have been working on as a developer. Mind you, this is not a NEW revelation for me; I've had the privilege of representing Hyperion Analyzer at Java One as a developer on that project, and talked to many talented Oracle folks about Pentaho at ODTUG, as well as many other roadshows of my own. I always have come …

Sun Microsystems today announced that Tema Networks has selected Sun's MySQL Embedded Server to meet to its demanding database requirements. Tema Networks' Home Zone Billing (HZB) telecom solution handles over a thousand queries per second and tens of Gigabytes of data, with rapid data volume growth expected as the service is deployed to more regions.