We have spent months planning and preparing for the MySQL conference that begins tomorrow. It seems appropriate to reflect on this process, where the open source and business communities are now, and what we have planned for the future.

The annual April MySQL conference was a strong and growing event for years, drawing hundreds of people at its peak. The conference has always been vital not only to MySQL and those who care about MySQL, but also to the many companies that use and enhance MySQL, and that contribute far more to MySQL than might be apparent. But after the acquisitions by Sun and Oracle, O’Reilly found it more difficult to promote the conference. When it became clear that Oracle wouldn’t change their mind about not supporting the event, O’Reilly did not announce a 2012 event.

That’s where Percona stepped in. We were not willing to let the conference die. Others talked about doing something, but Percona took the …

Hi Everyone!

Just a reminder to all of those who are attending the MySQL Conference in Santa Clara this week that I'll be presenting a session all about XtraBackup Manager.

My session will be entitled "Introducing XtraBackup Manager" and happens on 11 April 15:30-16:20 @ Ballroom D.

If you are interested in learning more about XtraBackup Manager, or would just like to come support me - I look forward to seeing you there!

Cheers,
Lachlan

If you have a Java-based product and are, or are thinking of, using MySQL as an embedded database, this webinar is for you. This is a great webinar for OEM/Embedded customers/prospects (particularly, if they develop in Java)!

Mark Matthews is not only the creator and maintainer of MySQL’s JDBC connector (MySQL Connector/J); as an architect on the MySQL Enterprise Tools Team, he is also an OEM user of MySQL and Connector/J. The Java-based MySQL Enterprise Monitor has used MySQL as its embedded repository for the past nearly 8 years.

Most users of MySQL Enterprise Monitor have no idea that it embeds a MySQL database. Like most OEM customers, the MySQL Enterprise Monitor team (and Oracle MySQL) wants its embedded database to perform optimally every time and at all times – without requiring any end-user intervention.

Join this …

Read the original article at Autoscaling MySQL on Amazon EC2

Autoscaling your webserver tier is typically straightforward. Image your apache server with source code or without, then sync down files from S3 upon spinup. Roll that image into the autoscale configuration and you’re all set.


With the database tier though, things can be a bit tricky. The typical configuration we see is to have a single master database where your application writes. But scaling out or horizontally on Amazon EC2 should be as easy as adding more slaves, right? Why not automate that process?

Below we’ve set out to answer some of the questions you’re likely to face when setting up slaves against your master. We’ve included …

I will be at the Indiana Linux Fest this weekend, presenting the Care and Feeding of a MySQL Database for Linux Administrators on Saturday just before lunch. Later this month I will be in Las Vegas for Collaborate 12 to present MySQL for Oracle DBAs or How to Speak MySQL for beginners on April 25th at 12:15. And later this summer I will presenting a Moodle=dentric look at MySQL administration on August 1st at 1:15 at the West Coast Moodle Moot.

…

MySQL Enterprise Monitor has been an “internal” OEM customer of MySQL for over 6 years. We store all of our inventory, configuration and historical data in a MySQL-based repository. Given that our application is also developed using Java, I think we have some hard-learned lessons to pass on to those of you looking to ship your own applications that use Java and MySQL about how to pull this off. I‘m giving a webinar (http://mysql.com/news-and-events/web-seminars/display-703.html) on April 12th where I‘ll talk about what we‘ve figured out shipping a Java-based MySQL application over the years, including dealing with upgrades, backups, data purging, ORMs and schema evolution. Hope to see you there!

This week we talk with Martin Farach-Colton of Tokutek about what's new with TokuDB.

News/Events/Feedback
Oracle announced the MySQL Connect Conference to be held in San Francisco on Saturday, September 29 and Sunday, September 30th. Call for papers and registration will open on April 16th.

There is a free webcast on Efficiently deploying new MySQL applications on Windows .

read more

We are excited to announce TokuDB® v6.0, the latest version of Tokutek’s flagship storage engine for MySQL and MariaDB.

This version offers feature and performance enhancements over previous releases, support for XA (two-phase transactional commits), better compression, and reduced performance variability associated with checkpointing. This release also brings TokuDB support up to date on MySQL v5.1, MySQL v5.5 and MariaDB v5.2. There’s a lot of great technical stuff under the hood in this release and I’ll be reviewing the improvements one-by-one over the course of this week.

I’ll be posting more details about the new features and performance, so here’s an overview of what’s in store.

Replication Slave Lag

One of the things TokuDB does well is single-threaded insertions, which translates directly into less slave lag. With TokuDB v6.0, we introduce support for XA, which insures for …

We are pleased to announce the immediate availability of MariaDB 5.3.6. This stable (GA) release incorporates MySQL 5.1.62, some performance improvements, and several bug fixes.

Most importantly, MariaDB 5.3.6 includes a fix for a bug which, under certain rare circumstances, allowed a user to connect with an invalid password. This is a serious security issue. We recommend upgrading from older versions as soon as possible.

• MariaDB 5.3.6 Release Notes
• MariaDB 5.3.6 Changelog
• MariaDB 5.3.6 …

Note to self

Getting a query-digest report for 20 seconds worth of tcp traffic on linux
(no special slow log/microslow patch needed):
tcpdump -s 65535 -x -nn -q -tttt -i any -c 99999 port 3306 | pt-query-digest --type tcpdump --run-time 20s
thanks to aaron brown

Connect to Anemometer instead of using slow log
#crontab entry
*/5 * * * * tcpdump -s 65535 -x -nn -q -tttt -i any -c 99999 port 3306 | pt-query-digest --type tcpdump --run-time 20s --user=anemometer --password=superSecurePass --review h=db.example.com,D=slow_query_log,t=global_query_review --review-history h=db.example.com,D=slow_query_log,t=global_query_review_history --no-report --limit=0% --filter=" …