The overriding theme this week – we are still doing a lot of shifting around of databases pending our data center move.

This week, the database team at Mozilla has:
- Discovered some minor but important issues following a crash. We have increased alerting to ensure that if cleanup after a crash is necessary, the proper folks will be notified.
- Created a new database for Tinderbox Push Log for bug caching. In the process, updated some sorely out-of-date database documentation.
- Added new machines to graphs.mozilla.org

- Cleaned out puppet entries from some database machines that no longer exist.

- Updated database entries in puppet to include or exclude the “read_only” setting as appropriate, and are monitoring that setting with the …

News/Feedback:
This week we have some fun audio feedback from Patrick Hurley, a MySQL DBA in the UK.

The Percona Live: MySQL Conference and Expo is from Tuesday, April 10th through Thursday, April 12th. The conference is at the Santa Clara, CA Convention Center. Early bird pricing ends March 12th, 2012. Use code PL-pod and save 10% off the early bird prices!. Check out the tutorial and session schedule.

read more

The PHP UK 2012 has started and the three meetings rooms are packed. The show continues on Saturday the 25th where you cam catch me talking about the latest changes in MySQL at 1400, Johannes Schluter sharing the secrets of PHP under the hood at 1600, and then both of us are on a panel SQL versus NoSQL at 1650. If you are in the area, be sure to drop by!

…

We are on our way to delivery a production ready release of Percona XtraDB Cluster by the end March-2012.
We will do couple events to cover features and architecture of XtraDB Cluster.

• I will give a talk on San Francisco MySQL Meetup, on March-21: Percona’s new HA solution for MySQL with XtraDB Cluster. If you are in the area, I hope to see you there. I will give away some good stuff, including free copies of our new book: High Performance MySQL, 3rd edition
• Webinar on April-4 A New High Availability Solution for MySQL

. If you are not in San Francisco and can’t not make to …

Changes (as compared to 9.6) include:

Features:
* A Chinese (Simplified) translation is now included.

Bug fixes:
* When there was an INFO tab open the server was unnecessarily queried for the content of the INFO tab (based on Object Browser selection) when closing the program. This could cause a slow shutdown.
* Fixed a crash occurring when pressing the ESC key in the CREATE/ALTER tab/dialog. This bug was introduced in 9.6.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

…

MySQL Cluster has long been used in telecommunications network services for Subscriber Data Management (HLR/HSS), Service Delivery Platforms and Value-Added Services, and has also been deployed in certain parts of general web infrastructure.

Following the announcements of MySQL Cluster 7.2 General Availability, including new benchmarks demonstrating MySQL Cluster delivering 1 Billion Queries per Minute, I thought it might be worthwhile to highlight examples of use cases for MySQL Cluster .

Web-Based Payment & Financial Services Platforms

MySQL Cluster can be deployed across a range of applications including payment gateways, trading systems and …

Nothing pleases the technology bloggers more than the moment when somebody thank them for a helpful blog entry. That is one of the many awesome advantages of the technology blogs. In database arena, the developers, DBAs and evangelists are sharing their tips and tricks through their blogs and this Log Buffer Edition is projecting them [...]

Note: I’ve decided not to use Veewee due to silly compatibility issues for now.

Quoting from Vagrant’s web site:

Vagrant is a tool for building and distributing virtualized development environments. By providing automated creation and provisioning of virtual machines using Oracle’s VirtualBox, Vagrant provides the tools to create and configure lightweight, reproducible, and portable virtual environments.

A complementary technology called Veewee makes building VirtualBox VMs easier by automating away a lot of manual steps. Marius Ducea has a great blog post on how to use it.

My observations:
1. According to Vagrant’s web site, it should work on Windows. I’ve …

I am happy to announce the availability of beta release of our new product Percona XtraDB Cluster.

Percona XtraDB Cluster is High Availability and Scalability solution for MySQL Users and the beta release is based on Percona Server 5.5.20 and the recently released Galera 2.0 GA

The main focus in this release:

• Incremental State Transfer, especially useful for WAN deployments
• Support of Percona XtraBackup for Snapshot State Transfer. This feature is available in pre-release series for XtraBackup 2.0

Despite Galera 2.0 has status “production ready”, we still …

Edit:

Thanks to a comment by Maxim Krizhanovsky,  this is all actually documented in quite a bit of detail.  It's a long read, but well worth it: http://dev.mysql.com/doc/refman/5.1/en/innodb-auto-increment-handling.html

The really important part to note, is that the behavior of auto increment in some cases can be modified with the server setting innodb_autoinc_lock_mode including when you use INSERT ... SELECT and LOAD DATA INFILE.  Some settings are not safe to use with statement based replication. The default setting is safe, but doesn't have the best performance.

Original article follows:


Using a multi-insert to save …