I recently found Todd's posts on interceptors which allow callbacks (called interceptors) to be registered with the connector so that you can intercept a statement execution, commit, or any of the many extension points supported by Connector/Java. This is a language feature that allow you to implement a number of new features without having to change the application code such as load-balancing policies, profiling queries or transactions, or debugging an application.

Since Python is a dynamic language, it is easy to add interceptors to any …

Recently, I found myself needing MariaDB 5.1.60 for Windows for some testing purposes. Therefore, I needed to build it from source. I ended up using what I’d call a “blend” of the commands listed in this “how-to” and the readme file INSTALL-WIN-SOURCE, so I thought I’d post those steps.

1. Download 5.1.60 MariaDB source from here.

2. cd C:\mariadb-5.1

3. win\configure.js

4. cmake .

5. VS: File -> Open -> Solution -> MySql.sln
6. VS: Build -> Build Solution
7. VS: Right-click “PACKAGE” -> Build (in “Solution Explorer” View)

That’s it.

Let’s fire it up:

MariaDB> select version(); …

If you’re a MySQL user, tell us about your adoption plans by taking our current survey.

Back in late 2009, at the height of the concern about Oracle’s imminent acquisition of Sun Microsystems and MySQL, 451 Research conducted a survey of open source software users to assess their database usage and attitudes towards Oracle.

The results provided an interesting snapshot of the potential implications of the acquisition and the concerns of MySQL users and even, so I am told, became part of the European Commission’s hearing into the proposed acquisition (used by both sides, apparently, which says something about both our independence and the malleability of data).

One of the most interesting aspects concerned the apparently imminent decline in the usage of …

SkySQL™ today announced the immediate availability of SkySQL™ Enterprise HA, its leading 360° degrees High Availability solution for the MySQL® & MariaDB® databases.

High Availability is the #1 requested enhancement to the MySQL & MariaDB servers, even more popular than scalability and performance.  And with SkySQL's expertise at hand, it is now easier than ever before for customers to achieve the level of High Availability that they want.

SkySQL™ Enterprise HA is SkySQL's 360° answer to providing a …

Jet Profiler for MySQL 2.0.5 is now available!

We recently announced that we now provide multi-language support for English, German and Swedish. This time, the latest version adds French language support. By meeting requests from our French speaking users we hope to help even more companies manage their MySQL database performance.

This release also contains bug fixes and adds support for explaining CREATE TABLE ... AS SELECT ... queries by just explaining the SELECT part.

See also this press release.


3 Comments

Next Tuesday, January 31st, it’s going to be all about MySQL Embedded!

We will be running an Online Forum from 9.00 am to 12.00 pm PT. Oracle’s MySQL Embedded experts will deliver 4 technical sessions addressing “what all ISVs & OEMs should know about embedding MySQL…but often don’t”.

By attending the Online Forum you will learn:

• Why MySQL is a great embedded database choice for both startups and the largest software, hardware, and appliance vendors in the world, and how its features ensure costs remain low throughout an application's life cycle
• MySQL installation options that require minimal or zero end-user effort, and how to easily build them into your application
• How to secure MySQL embedded in applications, appliances, and devices
…

Next Tuesday, January 31st, it’s going to be all about MySQL Embedded!

We will be running an Online Forum from 9.00 am to 12.00 pm PT. Oracle’s MySQL Embedded experts will deliver 4 technical sessions addressing “what all ISVs & OEMs should know about embedding MySQL…but often don’t”.

By attending the Online Forum you will learn:

• Why MySQL is a great embedded database choice for both startups and the largest software, hardware, and appliance vendors in the world, and how its features ensure costs remain low throughout an application's life cycle
• MySQL installation options that require minimal or zero end-user effort, and how to easily build them into your application
• How to secure MySQL embedded in applications, appliances, and devices
…

Patrick, great article! One lovely little tip for making your mysql client prompt informative.

From

mysql>

to

root@scaramanga [wordpress]>

Tuck this in the mysql or client sections of your my.cnf file. my.cnf can be in lots of places – mine is at /etc in os x, but you can find out where your client and database are looking for it by typing

mysql –help

and make or move an existing file there.

[mysql]
prompt=\\u@\\h [\\d]>

where u = who you’re logged in as, h = host and d = database you’re working on. There are lots of configurations to optimise the prompt just the way you want it at http://bit.ly/z0N9Id – point 4.

Selena and I gave a talk on the various issues of running databases “in the cloud” at the recent linux.conf.au in Ballarat. Video is up, embedded below:

Starting with MySQL 5.5.7 or MariaDB 5.2, the server allows the client to authenticate via plugin. HeidiSQL now fully supports establishing such connections, by providing an exported method called mysql_authentication_dialog_ask, which is automatically invvoked by libmysql.dll, if the server says so during the connection handshake.

Curious how that works? Here's a simple example:

1. Be sure to have the "plugins" directory in C:\Program files\HeidiSQL\, and the dialog.dll. This is done automatically when installing a newer beta build from the download page.

2. On your server, install the plugin "dialog.dll":

INSTALL PLUGIN three_attempts SONAME 'dialog.dll';

3. On your server, create a new user which authenticates via this plugin:

CREATE USER test_dialog IDENTIFIED VIA three_attempts …