MySQL Newsletter January 2009

New Release of MySQL Connector/C++ 1.0.2 (Alpha)

A new version of MySQL Connector/C++ has been made available: MySQL Connector/C++ 1.0.2alpha. The MySQL Connector/C++ provides a C++ API for connecting client applications to the MySQL Server. Please see the documentation and the CHANGES file in the source distribution for a detailed description of bugs that have been fixed.

Read the Documentation »

New Release of MySQL Workbench 5.0.29 (GA)

Wasn't there a release just some days ago, you might ask? Yes, indeed - but we had to create a quick follow-up because a nasty bug found its way through our test and into the recently released 5.0.28. Once discovered we found and fixed the root of the problem quite quickly. Additionally we introduced some new icons last time which didn't find their way into the installer script as well. We strongly recommend to update to this release ASAP.

New Release of MySQL Workbench 5.1.5 (Alpha)

We're closing in on features left to be implemented in 5.1 and keep improving on stability. All object editors are in place now (some of them still in a basic version though) and a bunch of memleaks has been fixed already. Additionally we now statically link the ctemplate-library and therefore you won't have to care about installing/maintaining that package on your own anymore. We provide bin and src packages for Ubuntu and Fedora9 (both 32bit) at the moment.

New Release of MySQL Workbench 5.1.6 for Mac OS (Alpha)

Thanks to the hard work of our mac-developers, we just finished and uploaded the first Alpha version for OSX of our upcoming MySQL Workbench 5.1 for everyone to try. It's a 1st alpha version, so don't expect a full blown design application already - and the binary is Intel only this time. But what we deliver, is a working UI where you can load/save existing Workbench-documents and create diagrams from imported SQL-scripts.

Learn More »

Hints & Tips

Workbench Plugin Tutorial: Load INSERTs from a File

Alfredo Kojima

A couple of people have asked for a means to set the list of INSERT statements of a table from data already in an external file. While we haven't implemented that feature in Workbench as of now, that's something that can be easily added as a Lua plugin.

Read the Tutorial »

Documentation: Using MySQL within an Amazon EC2 Instance

The Amazon Elastic Compute Cloud (EC2) service provides virtual servers that you can build and deploy to run a variety of different applications and services, including MySQL. The EC2 service is based around the Xen framework, supporting x86, Linux based, platforms with individual instances of a virtual machine referred to as an Amazon Machine Image (AMI).

Read the Documentation »

Article: GlassFish and MySQL, Part 1: A Perfect Combination for Web Applications

Ed Ort

When used together, MySQL and GlassFish provide an excellent, low-cost solution for quickly developing and deploying web applications that are not only secure and reliable, but also scale to meet increasing demand and are highly responsive to user requests.

Read the Article »

Article: GlassFish and MySQL, Part 2: Building a CRUD Web Application With Data Persistence

Ed Ort and Carol McDonald

This is the second article in a series of articles on GlassFish and MySQL. Part 1 of the series describes the advantages of using GlassFish with MySQL and illustrates why the combination is a perfect choice for developing and deploying web applications. In Part 2, you'll learn how to develop a create, read, update, delete (CRUD) web application that uses GlassFish and MySQL.

Read the Article »

Case Study: Aftonbladet, Sweden's largest news group, bets on MySQL

Aftonbladet was founded in 1830 and is the largest media group in Sweden. The Aftonbladet newspaper is the largest and most read newspaper in the Nordic region, with about 1,209,000 readers a day.

Read the Case Study » (http://www.mysql.com/why-mysql/case-studies/mysql-cs-aftonbladet.php)

PlanetMySQL Blog Posts

The following blog posts are from PlanetMySQL. PlanetMySQL is an aggregation of blogs and news from MySQL developers, users and employees. It is an excellent source of all things about MySQL, including technical tips and best practices.

Visit PlanetMySQL »

Submit Your Blog Feed »

PlanetMySQL Blog: A little MySQL Conference & Expo 2009 update

Colin Charles

The one thing that has consumed my days (and nights) recently, has been the organising of the MySQL Conference & Expo 2009 (hereinafter, referred to as the CE2009).

For starters, we've had 356 proposals. That basically provides a 1:3 acceptance:rejection ratio. So the voting committee had a really, really hard task to look at talks.

PlanetMySQL Blog: 2008 certification results, 2009 news

Dave Stokes

2008 was a good year for MySQL Certification. 1,986 folks took exams which is a 14.6% gain over 2007. 736 candidates earned certifications and that is a 14.4% gain. The biggest gains were in Associate (up 300%) and DBA (up 35%) certifications. Oddly the Developer cert was down 40%.

So what happens in 2009?

PlanetMySQL Blog: Mind the SQL_MODE when running ALTER TABLE

Augusto Bott

The other day, a client mentioned they were getting strange results when running ALTER TABLE. The episode involved modifying an existing primary key to add an auto_increment primary key: it was "shifting" values. Say what?!

PlanetMySQL Blog: Using triggers for performance

Anders Karlsson

Can you use TRIGGERs to increase performance? Really? Isn't so that a TRIGGER on a table will reduce performance, just as any FOREIGN KEYs will? Right?

PlanetMySQL Blog: FULLTEXT and Asian Languages with MySQL 5.0

Lachlan Mulcahy

I have seen a few people now ask about using MySQL's FULLTEXT indexing with asian languages such as Chinese, Japanese and Korean (herein referred to as CJK.), however, there doesn't seem to be a good centralised article that covers it.

PlanetMySQL Blog: Ideas on Integrating Memcached into MySQL Queries

Duleepa Wijayawardhana

There's any number of ways to integrate your application with Memcached to take advantage of Memcached's power. Here's a list of some of them (and because I am most familiar with PHP in this case so that's what I've listed, and by no means is it exhaustive).

PlanetMySQL Blog: Triggers Use Case Compilation, Part I

Shlomi Noach

I've run by quite a few triggers lately on production systems. In previous posts, I've written about problems solved with triggers. So here's a compilation of some solutions based on triggers; and some problems which are not (yet?) solvable due to current triggers limitations.

Industry Spotlight: MySQL in Telco

MySQL Exhibiting at GSMA Mobile World Congress

MySQL will be exhibiting at this year's GSMA Mobile World Congress to be held in Barcelona between February 16 and 19, 2009. Come and see MySQL Cluster Carrier Grade Edition in action as it provides 99.999% data availability and millisecond response times while supporting a SIP communicator application.

MySQL will be part of the Sun Microsystems stand, located in Hall 2, Booth #2C12.

Fill the inquiry form to book a meeting with a MySQL representative at the Congress » (http://www.mysql.com/about/contact/)

Quick-Start scripts for evaluating and developing new HA services on MySQL Cluster - the new MySQL Cluster Sandbox

MySQL Cluster Sandbox let's you get going within seconds. The packages contains a number of scripts to install, setup, and run MySQL Cluster and are intended for localhost installation only. They can be used for evaluation and development, as well as getting familiar with MySQL Cluster.

Download the Package »

MySQL Cluster Sandbox - test cluster to cluster replication!

Johan Andersson

If you have max 15 minutes and want to try out MySQL Replication (geo redundancy) between two Clusters on your localhost (only tested on Linux) or on vmware then this Sandbox is for you.

950k reads per second on 1 datanode

Jonas Oreland

I spent last night adding 75% of the next step for our multi-threaded datanode and got new numbers... The config is the same as earlier post, with the exception that MaxNoOfExecutionThreads=8.

MySQL Cluster - session management tips and tricks

Johan Andersson

Many users use MySQL Cluster for session management. In MySQL Cluster tables are checkpointed and redo logged to disk.

But for session data, do we really care?

Disk Data Tables in MySQL Cluster - a summary

Johan Andersson

Here is a summary about Disk Data tables in MySQL Cluster.

How much DataMemory+IndexMemory do you need for disk data?

Henrik Ingo

One thing we were guessing at with Massimo yesterday is, if you store large blobs as disk data, how much will they consume DataMemory and IndexMemory (primary key, each "chunk" has a hidden primary key, first 25x bytes of blob stored in memory...)?