Some of you in the MySQL world may have missed FAQ: Sun Certifications and Oracle-Branded Certificates from the Oracle Certification Blog. The synopsis is that anyone earning a MySQL certification before September 1st will be a SUN Certified MySQL {associate|DBA|Cluster DBA|Developer}. And starting September 1st you will be an ORACLE Certified MySQL {associate|DBA|Cluster DBA|Developer}. There is no need to replace your old certificates to get the Oracle branding and will continue to be recognized under the Oracle certification program and will be valid without expiration.

Want a new certificate anyway? Well, Oracle is planning an upgrade path in the future. Please see the linked article above for details.

We’re happy to announce the latest maintenance release of MySQL Connector/Net 6.3.5.

Version 6.3.5 maintenance release includes:

• Fixes to some installer bugs related to .NET Framework 4.0
• Fixes for several other bugs

For details see http://dev.mysql.com/doc/refman/5.1/en/connector-net-news-6-3-5.html

MySQL Connector 6.3.5 :

1. Provides secure, high-performance data connectivity with MySQL.
2. Implements ADO.NET interfaces that integrate into ADO.NET aware tools.
3. Is a fully managed ADO.NET driver written in 100% pure C#.
4. Provide Visual Studio Integration

If you are a current user, we look forward to your feedback on all the new capabilities we are delivering.

As always, you will find binaries and source on our …

Translation of "Methods for searching errors in SQL application" just finished, epilogue is at http://sql-error.microbecal.com/en/concl.html

It contains list of methods which had been discussed.

Epilogue

Finally I'd like to repeat methods which we discussed. Unfortunately
there are several problems left. I will be glad to know your opinion
about what else to descuss. I will be waiting your notes at sveta_dot_smirnova_at_oracle_dot_com or sveta_at_js-client_dot_com

List of methods.

...

Rest of the text is …

UPDATE - 15TH NOVEMBER
An on-demand replay of the webinar discussed below is available from the following URL:
http://www.mysql.com/news-and-events/on-demand-webinars/display-od-583.html

The development team would highly value feedback on your experience with the Push Down Joins project, and whether any current limitations prevent you from using this functionality.
Please send feedback or questions via the following mailing list:
spj-feedback@sun.com

You can access the binary (Linux-only) and source here:
ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/mysql-5.1.51-ndb-7.1.9-spj-preview/

ORIGINAL BLOG POSTING:
Ok, so the title maybe a little melo-dramatic, but for those who work with databases that distribute tables and rows across multiple nodes, pursuing the holy grail may not be that far from the truth.

We are running a live …

1. Using MysQL as NoSQL -- 750,000+ qps on a commodity MySQL/InnoDB 5.1 server from remote web clients.
2. Making an SLR Camera from Scratch -- amazing piece of hardware devotion. (via hackaday.com)
3. Mac App Store Guidelines -- Apple announce an app store for the Macintosh, similar to its app store for iPhones and iPads. "Mac App" no longer means generic "program", it has a new and specific meaning, a program that must be installed through the App store and which has limited functionality …

Dans cet article nous allons essayer de mettre en place une solution qui assure la redondance d'une base de données MySQL et qui permet de partager la charge entre deux nœuds.
Pour assurer la redondance des données nous allons avoir recours à la réplication native de MySQL.
En ce qui concerne le partage de charge, nous allons utiliser MySQL Proxy bien qu'il soit encore à sa version 0.8 Alpha.

Redondance des données:

Dans cette section, nous allons configurer une réplication entre deux Maîtres MySQL, identifiés par DB-1 et DB-2, sachant que dans cette configuration, chaque Maitre sera en même temps l'esclave de l'autre.
Ce schéma est plus …

Last year I had a chance to talk about the internals of our service: Pathtraq at Percona Performance Conference (slides), in which I described the methods we use to compress the URLs in our database to below 40% of the original size, however had not released the source code since then.  I am sorry for the delay, but have finally uploaded the code to github.com/kazuho/url_compress.

It is generally considered difficult to achieve high ratio for compressing short texts.  This is due to the fact that most compression algorithms are adaptive, i.e., short texts reach their end before the compressors learn how to encode them …

Last year I had a chance to talk about the internals of our service: Pathtraq at Percona Performance Conference (slides), in which I described the methods we use to compress the URLs in our database to below 40% of the original size, however had not released the source code since then.  I am sorry for the delay, but have finally uploaded the code to github.com/kazuho/url_compress.

It is generally considered difficult to achieve high ratio for compressing short texts.  This is due to the fact that most compression algorithms are adaptive, i.e., short texts reach their end before the compressors learn how to encode them …

It just it trunk – if you have HailDB installed when you build Drizzle, you will now get the HailDB plugin built. You can even run Drizzle with it (remove innobase plugin, load HailDB plugin). Previously, we had problems building both due to symbol conflicts between innobase and HailDB. We’ve fixed this thanks to the linker.

So, enjoy HailDB… welll, test it and report bugs that I can fix :)

Answering questions asked on the site.

Beren asks:

In my database, I store the information about the game matches.

A match can be played between two players (mostly) or, occasionally, between two teams of 2, 3 or 4 players.

I store the matches in a table like this:

, where type is ENUM(player, team).

If type is player, the ids of players are stored in the record; if type is team, those of teams are stored.

Now, the tricky part. For a given game, I need to select two lists of players from both sides, comma separated, be they single players or members of a team.

Are two separate queries required for …