Robert – only our recent RPMs have IO statistics for the replication threads in information_schema.user_statistics. That is a good metric but it will take a while to deploy the RPM.

There is a huge amount of buzz around NOSQL, and we at ScaleBase are happy to see companies making the move to NOSQL. Despite what some people might think, we consider it a blessed change. It is time for applications to stop having a single data store – namely a relational database (probably Oracle) – and start using the best tool for the job.

In the last couple of years, since NOSQL technologies broke into our world, a lot of experience has been gathered on how to use them. Mainly, we see NoSQL technologies used for one of the following scenarios:

• Queries that require a very short response time
• Storing data without a well-defined schema, or storing data with a frequently modified schema

Now, I’m not in any way saying that NOSQL solutions are not used for other scenarios as well; I’m only saying that from our experience here at ScaleBase ,  these are the most common scenarios.

SCaLE 10X is the premier Open Source show in Southern California. This year it will feature a MySQL day with top speakers from the MySQL Community. Volunteers run SCaLE and do such an amazing job that they charge only $60 for a full pass. If you are anywhere near Southern California January 20th to the 22nd, you need to be at SCaLE.

SCaLE MySQL Day (Friday) Presentations MySQL Replication (Keith Larson) The MySQL Storage Engines Landscape (Colin Charles) A Closer Look at MySQL Cluster: An Architectural Overview (Max Mether) Playing in the Same Sandbox: MySQL and Oracle (Lynn Ferrante) Care and Feeding of a MySQL Database for Linux Administrators (Dave Stokes) MySQL Update (Dave Stokes)

Solomon Chang is going to present a four hour MySQl Replication Tutorial (but I am unsure of the date) …

As the saying goes, we at Severalnines have been walking on several clouds this year, 9 to be precise!

Today, we are proud to say that we are on walking on Cloud 9!

And in the spirit of celebration, we would like to announce our:

Top 9 Clouds of the Year 2011 for Severalnines

Cloud 1 – releasing ClusterControl™ - our first commercial product in April!

ClusterControl™ is our flagship product. It enables developers and database administrators to Deploy, Manage, Monitor and Scale their clustered database platforms, free …

MySQL 5.6 in among CRN’s 10 Best Open Source Products of 2011.

“MySQL 5.6, now in beta, includes significant advances in text-based search inside a database, as well as performance enhancements. With the growth of the world’s data set to explode like never before with the advent of data-capturing and data-creating mobile devices, MySQL 5.6 is firmly in place as the strongest open-source database.”

Check it out.

We already blog a lot on temporary tables on disk, how this could be bad for your workload and should be avoid.  Each temporary table will open a file descriptor,  external kernel call and by nature a well know file system slow operation.

We can point this benchmark simulating a working mail server


Monitoring of such queries can be trace via the status of

created_tmp_disk_tables 
Evidence of what is happening watching many Aria or MyISAM tables created on disk :

/usr/sbin/lsof  | grep "mysql" | grep "#"
mysqld     1855     mysql 1658u      REG                8,1       8192    1505932 …

The binary version for MySQL Cluster 7.1.18 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.1.18 (compared to 7.1.17) will appear in the 7.1.18 Change log soon.

MySQL 5.6 in among CRN’s 10 Best Open Source Products of 2011.

“MySQL 5.6, now in beta, includes significant advances in text-based search inside a database, as well as performance enhancements. With the growth of the world’s data set to explode like never before with the advent of data-capturing and data-creating mobile devices, MySQL 5.6 is firmly in place as the strongest open-source database.”

Check it out.

This is more of a log for me than anything else, but perhaps someone will find this useful.

OpenBSD includes a software RAID implementation which supports booting in newer snapshots, and I was itching to install the latest version and use it as my file server, which has 4 750GB disks. There is a small bit of preparation work to do prior to installing, which is the bulk of this entry, most of which is based on this undeadly.org article.

Grab latest amd64 snapshot, boot it, drop into (S)hell mode and set up the disks:

#!/bin/sh

cd /dev
sh MAKEDEV sd1 sd2 sd3 sd4 sd5
for disk in 0 1 2 3
do
  # Clear beginning of disks..
  dd if=/dev/zero of=/dev/rsd${disk}c bs=1m count=10

  # ..and initialise new partition table
  fdisk -iy …

Have you ever come across this error?

MySQL Error Number 1005
ERROR 1005 (HY000): Can't create table './wordpress/#sql-2693_f74e.frm' (errno: 150)

Jason summarized very good article to track down error reported on his blog.

It helped me , hopefully these tricks will help you as well!!

Post in comment , if it helps to save your day!!