Giuseppe Maxia and I are in the exact middle of our leg of the MySQL Campus Tour. Yesterday's session is was recorded -- A PDF of the slides can be downloaded at http://technocation.org/files/doc/2009_04_Tour.pdf (21 Mb).

The video is below:

read more

Three great beta deliveries in one week!

MySQL Connector/.Net 6.0.2 beta, a new version of the all-managed .NET driver for MySQL.

MySQL Connector/C++ 1.0.4 beta, a new release providing  C++ API for connecting client applications to the MySQL Server. If you know JDBC, this should be familiar to you.

MySQL Connector/C 6.0.0 beta, a new version of the C API for accessing MySQL database servers

Use them and let us know what you think.

Learn more about Connector/C++ here.

Learn more about Connector/C …

Three great beta deliveries in one week!

MySQL Connector/.Net 6.0.2 beta, a new version of the all-managed .NET driver for MySQL.

MySQL Connector/C++ 1.0.4 beta, a new release providing  C++ API for connecting client applications to the MySQL Server. If you know JDBC, this should be familiar to you.

MySQL Connector/C 6.0.0 beta, a new version of the C API for accessing MySQL database servers

Use them and let us know what you think.

Learn more about Connector/C++ here.

Learn more about Connector/C …

After I yesterday checked the size of wchar_t on range number of platforms I decided to extend this to many more types. Again the same systems were used, a few more were added (MacOSX 10.5 x86 and x86_64 are the ones most used). The information is in pretty raw state bug my blog software is not able to present big tables correctly, thus I am going the raw way.

What is most interesting?

• long double varies a lot. Between 8 bytes (AIX 5.2 and 5.3 (ppc32/ppc64), Windows 32 & 64) through 12 bytes (Linux/FreeBSD/Solaris but not MacOSX on  x86) to 16 byte (x86_64, ia64, hppa32, hppa64, ia64, ppc32/ppc64 (all MacOSX), sparc32, sparc64)
• Windows is missing few types
• MacOSX (10.4 & 10.5) doesn't have clock_id and timer_t
• time_t is 4 bytes on x86, ppc32, hppa32
• time_t is 8 bytes …

Hi,
MySQL Connector/Net 6.0.2, a new version of the all-managed .NET driver for MySQL has been released.  This is a beta release and is intended to introduce you to the new features and enhancements we are planning.  This release should not be used in a production environment.

This release was quickly pushed out due to a problem that caused 6.0.1 to not register with Visual Studio correctly.  We also made a small correction to a previous bug fix.  SQL generated from entity framework for stored procedures will now not directly reference the schema.  This allows the model to move to a different database without need of change.  We had previously made this change for tables but failed to do so for procedures.

It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/6.0.html] …

It's good to get out of the office and meet people. This year I'll be doing several presentations at the 2009 MySQL Conference and adjacent Percona Performance Conference in Santa Clara. These include among others a talk on Tungsten Replicator on Thursday April 23 at 10:50.

In case you don't read this blog regularly, Tungsten Replicator provides advanced open source replication for MySQL. The term "advanced" is not an exaggeration. I'll be covering how to solve practical problems including the following:

• How to install and configure Tungsten Replicator in 5 …

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 …

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 …