MySQL has two upcoming European Customer Conferences which will feature customer presentations by the likes of BBC News, Neckermann, Siemens and Tiger Communications.  The events are sponsored by Unisys, which is helping many large clients successfully integrate open source technology into their IT strategy.  The agenda includes a range of business and technical presentations covering case studies, best practices, product roadmap, high availability and performance tuning.

More information is available on the MySQL web site.  Space is limited and last year's events sold out.  So please register early if you want to attend. 

• MySQL: MySQL Hosts European Conferences in October
• London - …

My Regular Exrepssion UDFs for MySQL have been available on MySQL Forge for a while already, now i've taken the time to create a Trac project page for them.

I've implemented the following four functions

* REGEXP_LIKE(text, pattern [, mode])
* REGEXP_SUBSTR(text, pattern)
* REGEXP_INSTR(text, pattern [,position [,occurence [,return_end [,mode]]]])
* REGEXP_REPLACE(text, pattern, replace)

that behave very similar to their Oracle counterparts, using the same regular expression syntax as the MySQL REGEXP operator.

Back in April, I wrote On IPs, hostnames, and MySQL, which described the (sometimes surprising) ways in which MySQL deals with IP addresses, hostnames, and privileges, as well as some basics about the host cache itself. In a footnote to that post, I mentioned a patch I had written against MySQL 4.1 to give some more visibility into the host cache.

Over the past two days, I have worked on porting that patch to MySQL 5.01, 2, and making some fairly large improvements to it. The patch implements a few things:

1. Configurable Size — Without the patch, the size of the cache is fixed at 128 entries, and can only be changed by changing a #define and recompiling. You may now tune the size of the host cache using SET GLOBAL …

The domain registrars are making more money again, this time with .mobi. Naturally, people with a trademark or other (like .com) domain will be wanting to grab their .mobi so noone else can nick off with it. But what's the practical purpose of all these additional toplevel domains?

As far as I can tell, it's just a money making scheme just like .biz was. You may use one or the other to provide advance clarity to your users/customers, but you'll want/need to grab all the domains anyway to keep them safe.
Guh.

In MySQL 5, at the moment you can't write a recursive stored functions. It is forbidden.
Instead you can write a recursive stored procedure. That is not permitted by default but modifying a variable you can achieve such a recursion.
The variable is max_sp_recursion_depth.

SET GLOBAL max_sp_recursion_depth = 0.
A value of zero means: "no recursion" (the default value)

SET GLOBAL max_sp_recursion_depth=255
A value greater then zero means: the maximun number of nested recursion in a procedure. Max value is 255.

Pay attention to the variable named thread_stack, it is the amount of memory allocated for the stack of a thread. Writing a recursive routine the tipical error is to create an infinite recursion An infinite recursion leads very soon to fill up the stack. (the default value of the thread stack is less than 200K)
So, if you have …

Peter Zaitsev's blog entry on Duplicate indexes and redundant indexes certainly made a bit of a stir! It has already led to a new (mini) project by Baron Schwartz, the Duplicate index/foreign key finder which is publicly available on MySQLForge as a perl script. Daniel Schneller has entered the arena as well, devoting an entire blog to his own java implementation to tackle this and other index trouble.

I figured it would be fun …

I wonder how many people will attend a session at a tech conference where the start of the description reads as follows:

Hey You! Yes, You! Manager, marketeer, sales professional: are you tired of 98lb weaklings kicking silicon in your face?

I am thinking this way because my friends at MySQL AB are putting on another MySQL User Conference - this time from April 23 - 26 in Santa Clara, California.

The Call for Participation went live a few days ago and, as always, I am proposing a session. I don’t really need to go, but I definitely have a soft spot for the event, as I chaired the first two MySQL UCs. Also, I had a good deal of fun working on the …

Hello,

For those of you who are interested in learning more about MySQL Cluster, check out tomorrow's webinar presented by Vinay Joosery.

Info and registration:

http://www.mysql.com/news-and-events/web-seminars/mysql-ha-clustering.php

See you there,

Jimmy

I did a webinar for EMEA last week on tuning indexes and optimal SQL coding, and I had forgotten to publish the slides. Here they are in PDF format... Feel free to email me if you have any questions!

In other news, work on my new blog site is progressing. I should be done with this hideous beast of a website soon!

Zmanda has released their Recovery Manager for MySQL.  This is a great solution for DBAs seeking an easy-to-use backup and recovery solution.  Zmanda is based on the open source Amanda project started at the University of Maryland and the Zmanda team is a significant contributor to the Amanda project.  Zmanda offers support through their Zmanda Network subscription offering. 

Zmanda's has built on what was a rather generic backup project and now given it a much sharper focus by targeting the needs of DBAs.  The Zmanda Recovery Manager includes support for automatic backup scheduling, monitoring and reporting, backup analysis and granular recovery. Backup is a must-have capability for …