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 …

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 …

Great turn out at SCALE !
MySQL Day on Friday was a great success. MySQL sessions packed all day.

So far Saturday has had a great turn out at the booth with numerous questions about MySQL.

Tux even gave us a visit.

If you're using MySQL replication, then you're probably counting on it for some fairly important need. Monitoring via something like Nagios is generally considered a best practice. This article assumes you've already got your Nagios server setup and your intention is to add a Ubuntu 10.04 NRPE client. This article also assumes the Ubuntu 10.04 NRPE client is your MySQL replication master, not the slave. The OS of the slave does not matter.

Getting the Nagios NRPE client setup on Ubuntu 10.04

At first it wasn't clear what packages would be appropriate packages to install. I was initially misled by the naming of the nrpe package, but I found the correct packages to be:

sudo apt-get install nagios-nrpe-server nagios-plugins

The NRPE configuration is stored in /etc/nagios/nrpe.cfg, while the plugins are installed in /usr/lib/nagios/plugins/ (or lib64). The installation of this package …

MySQL Day at SCaLE

The MySQL Day at the Southern California Linux Expo (SCaLE) is all but over with just a Birds of a Feather Session before we finish. The room was packed all day and often at standing room only. Thanks to all the SCaLE volunteers and especially Solomon Chang who was the MC for the room.

Thanks to Lynn Ferrante, Keith Larson, Colin Charles and Max Mether for presenting. And thanks for those who attended the sessions. Sorry we didn’t have more seats and we will see what we can do for 2013!

SCaLE runs for two more days and there are a few more MySQL sessions scheduled. If you are in the area of LAX, you really need to be here.

…

If you’ve missed Percona Live in Washington,DC and even if you did not you should be happy to know we have now published slides from majority of talks at this conference. Enjoy! This conference had great talks, whenever you’re Beginner or Advanced when it comes to MySQL. Also remember not to miss MySQL Conference in Santa Clara,CA April 10-12 2012.