After a long wait post Lavasa Bike Ride, another was due. I remembered my old trek of Tringalwadi where we had a soulfoul swim in the Tringalwadi dam. The date was set, 25 Feb 2012.

We had a cold water swim on a super-hot sunny day in the Tringalwadi dam. On our return back, had our lunch around 1.15pm @ the Greenland restaurant near Igatpuri on NH3. The timing was more protect ourselves from the heat.

Next stop was the Bhatsa Reservoir, however being a “protected” dam, we couldn’t really enjoy its waters

Photos

A big congrats to Ligaya Turmelle for being Oracle's most recent Oracle ACE for MySQL!

You can often find her on freenode. You can also keep up with her via her blog blog.khankennels.com

Ligaya will be presenting two sessions in Chicago at Tek.  Be sure to stop by and give her a big congrats !

O’Reilly authors get 10 copies of their own books for free, and my copies of the third edition of High Performance MySQL arrived yesterday. Now it’s official! It feels nice to actually hold it in my hand. A few people have asked me about messages from Amazon saying that their ship date has changed. I don’t know anything about that; maybe Amazon just made a wild guess the first time and now they actually know something more realistic.

I am generally a big fan of command line tools. This also applies to MySQL client software such as mysql or mysqladmin. To those spoiled by graphical interfaces, working in text mode may seem crude or even difficult. But the truth is that once you get used to these tools, you will be able to accomplish many things a lot faster than with any GUI client. Of course, using text terminal, which is the environment for any command line tool, has its drawbacks and limitations. For example on a relatively busy MySQL server, every so often when you run SHOW [FULL] PROCESSLIST, which lists client threads connected to a database, you can receive an output that will be many screens long. Sometimes it might be due to the high number of established connections – each takes at least one line on the screen, or sometimes due to some longish queries spanning over multiple lines. Finding relevant information there usually isn’t …

Dear Readers,

dbasquare.com is a new blog that describes various aspects related MySQL. We hope you will find this website valuable, especially as resource for database administrators, application developers and all other professionals interested in learning more about this database.

We will offer free knowledge to everyone. Whether you are a MySQL newbie or a skilled DBA, you should be able to find something interesting for yourself:

• answers to even very simple questions that often bother many
• tips on how to do neat things without a lot of effort
• but also help with solving more complex problems

We have gained our knowledge during many years of work with MySQL and a lot of other open source technologies. Our expertise covers many areas including:

• MySQL performance optimization
• MySQL High availability and failover
• Database …

Come see Schooner at Percona Live Conference (Booth #201) and learn about SchoonerSQL’s approach to both sync and async replication with parallel appliers. Tired of stale or lagging data in MySQL? Learn how you can achieve data consistency and eliminate slave lag with SchoonerSQL while maintaining 100% compatibility with standard MySQL. Zero changes required for your application if you have already deployed on MySQL. Visit the Schooner booth to learn more.
Experience a live GUI demo at the booth that will illustrate SchoonerSQL features in a real-world, hands-on format:

• Instance provisioning and cluster management & monitoring via the Schooner Administrator (GUI)
• Fault detection and automated failover within a LAN and across the WAN
• Configuration of synchronous and asynchronous replication clusters
• Online backup and restore
• Event-driven e-mail alerts

…

When I published the MariaDB-5.3.4 sysbench results I said “if your workload includes complex (sub)queries, then you will probably benefit more from MariaDBs new optimizer features”. Today I will present some benchmark results for complex workload.

The benchmark is DBT3, an implementation of the TPC-H specification. DBT3 is written in C and hosted at Sourceforge.

The DBT3 benchmark can run at different scale factors – defining the size of the database. I used a scale factor of 30 which yields ~30GB of raw data and ~48GB of disk footprint. The machine running the benchmark had 16G of memory.

InnoDB has the problem of fluctuating table statistics, leading to rather unpredictable query plans. For this reason the benchmark tables were created with the …

Why do we have to bother about built-in GTID support in MySQL 5.6 at all? Sure, it is a tremendous step forward for a lazy primary copy system like MySQL Replication. Period. GTIDs make server-side failover easier (slides). And, load balancer, including PECL/mysqlnd_ms as an example of a driver integrated load balancer, can use them to provide session consistency. Please, see the slides. But…

MySQL 5.6 Global Transaction IDs - Use case: (session) consistency
View more presentations on MySQL and …

I recently joined Facebook. I relocated to Redwood City (less than 10km from Facebook Menlo Park office) and I commute by bicycle (or caltrain + shuttle on rainy days). I'm currently taking a bootcamp training with Lachlan and other new employees, and will soon join database team.

I really enjoyed MySQL life at DeNA. This was actually the first time experience for me to manage hundreds to thousands of rapidly growing servers. I believe DeNA is the most technically advanced MySQL users in Japan. As you may know, DeNA is a creator of HandlerSocket NoSQL plugin. I created MHA for automating master failover and semi-online master switch. When I worked as a consultant at MySQL/Sun/Oracle, it was very difficult to allocate enough time for creating new products since I spent most of the time for 1-5 day consulting delivery to achieve sales/billing targets. I like short-term consulting, but I like long-term development/enhancement engagements, …

Complex multi-master solutions made easy with Tungsten by Robert Hodges & Giuseppe MaxiaFriday, April 13 at 1:00 pmTungsten has broken new ground how to make previously complex or completely unattainable solutions very simple and easy to deploy. Tungsten Replicator offers improvements in replication topologies and performance, using technologies that were either unknown or not used together