Saw this on @awsmarketplace the other day:

#opensource #MariaDB by @SkySQL on @AWSMarketplace http://t.co/o3KQ9xe9sr #mysql

— AWS Marketplace (@awsmarketplace) October 8, 2013

Now on the AWS Marketplace, you can …

Percona XtraDB Cluster (PXC) itself manages quorum and node failure.  Minorities of nodes in a network partition situation will move themselves into a Non-primary state and not allow any DB activity.  Nodes in such a state will be easily detectable via SHOW GLOBAL STATUS variables.

It’s common to use HAproxy with PXC for load balancing purposes, but what if you are planning to just send …

5.6.Debian

Installing MySQL 5.6 using the package provided via dev.mysql.com is some kind of silly.
Using a package you expect the packagemanager to solve conflicts and dependencies and you expect to have a running application after install.But ..
I downloaded the Debian Package.

root@debianmy56:/var/tmp# dpkg -i mysql.deb 
Selecting previously deselected package mysql.
(Reading database ... 8799 files and directories currently installed.)
Unpacking mysql (from mysql.deb) ...
Setting up mysql (5.6.14) ...

Ok - beside the unusual name for the package - everything worked fine. Lets see if we got mysql user and group:

root@debianmy56:/var/tmp# getent passwd mysql
root@debianmy56:/var/tmp# getent group mysql

Oha, is there an init-script?

root@debianmy56:/var/tmp# ls /etc/init.d/| grep -i mysql

Ok thats consequent and of …

…

Done is better than perfect. That is one of Spil Games Engineering’s principles and it is really something I embrace. Almost one and a half year ago, Engineering started to use StatsD and Graphite for collecting and graphing performance metrics and one year ago I got fed up that there was, except for a couple of […]

The post MySQL StatsD project on Github appeared first on Spil Games Engineering.

Today we released TokuDB v7.1, which includes the following important features and fixes:

• Added ability for users to view lock information via information_schema.tokudb_trx, information_schema.tokudb_locks, and information_schema.tokudb_lock_waits tables.
• Changed the default compression to zlib and default basement node size to 64K.
• Changed default analyze time to 5 seconds.
• Added server variable to control amount of memory allocated for each bulk loader. In prior TokuDB versions each loader allocated 50% of the available TokuDB cache.
• Changed table close behavior such that all data for the table remains in the cache (and is not flushed immediately).
• Removed user reported stalls due to cache pressure induced by the bulk loader, lock tree escalation, and a particular open table stall.
• Several bugs and behavioral issues reported by users. …

It's no secret that you shouldn't rely on replication filtering. Recently a customer asked if an `ON DELETE CASCADE` would still affect the data on a slave if the table was being ignored through replication filtering. It was one of those occasions that I couldn't give a confident answer without a quick test but alas the gut was right and the obvious answer is yes, "ON DELETE|UPDATE CASCADE" will change data even if you replicate using replication filters.

I tested using RBR and SBR. If anything I was questioning the behaviour of RBR here but it turns out to be consistent with SBR. I had a master-slave setup already deployed for some other testing so it was easy to implement the FKs needed for this. The dataset is the trusty world db available from dev.mysql.com and I needed to change the constraints on the table to match the conditions proposed.
Master …

We all know that MySQL says it is "the world's most popular open-source database". And PostgreSQL has a firm hold on second place while claiming to be, instead, "the world's most advanced open source database". But the horse that comes in third can return some money to gamblers who bet "to show". And the horse that shows momentum or gets close is worth watching for next time.

So I'll just ignore the dolphin and the elephant in the room, and go on to a harder question: who's number three?

According to Wikipedia

To find out how many times someone has expressed interest in a topic, I can go to stats.grok.se and ask how many times someone has looked at that topic's page in Wikipedia. Evil-thinking people could manipulate these numbers with ease, but until now they have …

It will be a busy Fall season for the staff at PalominoDB as we will be sponsoring and speaking at two major international conferences.

First up is the MYSQL NOSQL & Cloud Expo in Buenos Aires, Argentina, OCT 15-16 2013. PalominoDB CTO Jay Edwards & DBA Emanuel Calvo will be featured speakers at this 2nd annual conference dedicated to building communities in Latin America.

Next is the AIOUG-SANGAM 13 in Hyderabad India, Nov 8-9, 2013.
PalominoDB CTO Jay Edwards and VP of International Operations Shiv Iyer, will be representing PalominoDB as a Silver Sponosor at one of the largest events in India.

• …

GUI monitoring tools for MySQL are not always suitable for all our needs or situations. Most of them are designed to provide historical views into what happens to our database over time rather then real-time insight into current MySQL server status. Excellent free tools for this include Cacti, Zabbix, Ganglia, Nagios, etc. But each of them needs to be properly configured to provide details on what is going on in our MySQL instances. And setting up one of these monitoring solutions is neither quick nor trivial (well, maybe with the exception of Ganglia).

MySQL Workbench provides …