Now that the thanksgiving holiday is over, it seems like the perfect time to have another #DBHangOps. If you're interested, check this twitter search or check back on my blog here for a link to the google hangout.

Items currently on our agenda for today: * Data corruption! * Monitoring -- what do you monitor, why, etc. * Query killing -- do you kill queries in production regularly, or in emergencies? * Fun or useful configurations

Looking forward to chatting about MySQL stuff today! Fun time hitting these topics this week. Check out the recording:

I am attending the Percona live conference in London on 4'th of December.

I will there hold a keynote about State of MariaDB & its growing Ecosystem and a session, together with Colin Charles, about Using NoSQL Techniques with MariaDB.

During the keynote there will be announcements that many of you should find exciting...

Sergei Golubchik will be there and talk about the new features in MariaDB 5.5 and MariaDB 10.0

Colin Charles will also have a talk about …

In this webinar we will show step by step how to install, configure, and test TokuDB for a typical performance evaluation. We’ll also be flagging potential pitfalls that can ruin the eval results. It will describe the differences between installing from scratch and replacing an existing MySQL / MariaDB installation. It will also review the most common issues that may arise when running TokuDB binaries.

Date: December 11th
Time: 2 PM EST / 11 AM PST
REGISTER TODAY

Topics will include:

• Memory allocation
• Initial data load
• Indexing, including clustering indexes
• compression algorithms

We look forward to having you join the …

There will be four MySQL Tech Tour is the next few weeks.

MySQL Tech Tour — December 4, 2012 – San Diego, CA

Please join us for our Tech Tour event hosted by Oracle MySQL experts and learn more about Oracle’s strategy for MySQL, including continued investment in the world’s most popular open source database.

Learn more and register for the event »

———

MySQL Tech Tour — December 5, 2012 – Irvine, CA

Please join us for our Tech Tour event hosted by Oracle MySQL experts and learn more about Oracle’s strategy for MySQL, including continued investment in the world’s most popular open source database.

…

The binary version for MySQL Cluster 7.2.9 has now been made available at http://www.mysql.com/downloads/cluster/ (GPL version) or https://support.oracle.com/ (commercial version).

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.2.9 (compared to 7.2.8) is available from the 7.2.9 Change log.

This Week in Website Performance is a weekly feature of the Monitis.com blog. It summarizes recent articles about website performance. Why? Because your friends at Monitis.com care.

Full table scan vs full index scan performance

Author: Stephane Combaudon.

Using full index scans are not always faster than a full table scan. Stephane explores the situations in which a sequential read through of a full table performs better than using randomly-read full index.

Big Data …

First 10 to register this week will benefit from a 40% discount

The Percona Live MySQL Conference: London 2012 is just around the corner and we’ll be present both with talks as well as in the exhibition hall alongside other sponsors of the conference.

Talks & Hot Topics

Our very own Ivan Zoratti has the following two talks on Tuesday December 4th:

read more

MySQL and WordPress welcome Google Cloud Storage

OblakSoft is pleased to announce that the Cloud Storage Engine for MySQL (ClouSE) now supports Google Cloud Storage.  Using MySQL to store data directly in Google Cloud Storage becomes a simple deployment choice: pick your Google Cloud Storage bucket and migrate any or all of your tables to the cloud.  We would like to thank Google storage team for their support and contributions.

This functionality opens Google Cloud Storage to millions of MySQL-based applications – cloud storage becomes a better alternative to local storage, no matter where you host the application, on premise or in the cloud.  Applications can now store data on Google’s infrastructure, and enjoy high availability, high durability and high scalability of …

1. install Cmake

wget  http://www.cmake.org/files/v2.8/cmake-2.8.10.1.tar.gz
tar xvfz cmake-2.8.10.1.tar.gz
cd cmake-2.8.10.1/
./configure
gmake -j3


2. install libaio

gmake -wget  http://www.kernel.org/pub/linux/kernel/people/bcrl/aio/libaio-0.3.92.tar.gz
tar xvfz libaio-0.3.92.tar.gz
cd libaio-0.3.92/
make prefix=/usr/
make prefix=/usr/ installj3 install

3. install MariaDB 5.5.28
go to https://downloads.mariadb.org/mariadb/5.5.28/ OR

wget https://downloads.mariadb.org/f/mariadb-5.5.28/kvm-tarbake-jaunty-x86/mariadb-5.5.28.tar.gz/from/http:/mariadb.ulak.net.tr/
tar xvf mariadb-5.5.28.tar.gz
cd mariadb-5.5.28/

the build will fail :

root@bubu:[Tue Nov 27 10:15:45]:[/opt/installs/mariadb-5.5.28]$ ./BUILD/compile-pentium-max
testing pentium3 ... ok
+++ /bin/rm -rf configure
+++ /bin/rm -rf CMakeCache.txt …

MySQL Connector/Net 6.4.6, a new version of the all-managed .NET driver
for MySQL has been released.  This is a maintenance release and is recommended for use in production environments.
It is appropriate for use with MySQL server versions 5.0-5.6.
This is intended to be the final release for Connector/NET 6.4.