Warning: this is a mixture of historical content, biases, stupid marketing and unknown/proprietary/closed source technologies. Proceed with caution.

NuoDB marketing was sending out this message, encouraging me to blog (they were looking for bloggers too):

And while Facebook sharded MySQL 4000 times, even they call it a “fate worse than death.”

We’ve seen this phrase before and it did not come from us. For whatever reason NewSQL echo chamber is repeating this with less and less truth in it. In various whitepapers (all behind registration walls) they mention some analyst estimates and try to put a parallel between operating costs of large companies and something a new developer would do, as if everyone is living under same constraints.

I don’t know if NuoDB is a good technology for the customer they’re targeting, all their diagrams essentially …

I’ll be joining Percona for a free day of MySQL education and insight at their upcoming Percona University Washington DC event on September 12th. My topic is accessing MySQL from Google’s Go programming language. I’ve learned a lot about this over the past year or so, and hopefully I can help you get a quick-start.

If you’re not familiar with Go, it’s the darling of the Hacker News crowd these days. Anything with “Go” in its title gets to the front page for at least a little while! Go is a great systems programming language. It’s safe to say I’ve fallen in love with it, and it’s now my favorite programming language of all those I’ve used over my entire career. I chose it because it’s ideally suited for VividCortex’s agent programs (zero dependencies, compiled, lightweight, high performance, robust, makes concurrency …

Giuseppe Maxia has long been a leader of the MySQL Community and is going to be a presenter at MySQL Connect. It is hard to list everything he has done for MySQL (and harder to try to find something he has not done).

What are your speaking about at your session?
a) MySQL in a laptop, or how to test and run database servers in a single box
b) juggling your data with Tungsten replicator, or the joys of complex topologies at your fingertips.

Who would benefit most from attending your session?
DBAs, testers, database designers, application designers

What other sessions would you recommend or are planning to attend?
MySQL Replication Roadmap [CON2615]
MySQL Replication: Deep Dive into GTIDs for Scaling and High Availability [CON2610]
Big Data with MySQL and Hadoop [CON2342]
…

I’ll be joining Percona for a free day of MySQL education and insight at their upcoming Percona University Washington DC event on September 12th. My topic is accessing MySQL from Google’s Go programming language. I’ve learned a lot about this over the past year or so, and hopefully I can help you get a quick-start. If you’re not familiar with Go, it’s the darling of the Hacker News crowd these days.

MySQL 5.6 surely changes the game when it comes to security vs ease of use. Before MySQL 5.6 we would get default MySQL installation being pretty insecure – the user “root” will be created with no password as well as anonymous user with limited access from local host (though still enough to cause DOS attack or crash MySQL Server.

There were some exception to this rule – such as Debian/Ubuntu install scripts would interactively suggest you to set password for root user if it was not set. Still most users would get MySQL install with root account and no password.

This is not the case with MySQL 5.6 when you’re doing fresh MySQL install! Installing official RPM on CentOS6 I’m getting this:

A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !
You will find that password in '/root/.mysql_secret'.
You must …

Taxonomy upgrade extras: galerastartstop

It took me quite a while to find out how the beast Galera Arbitrator (garbd) works. To safe your time here a short summary:

How to start Galera Arbitrator (garbd)

shell> ./garbd --address gcomm://192.168.13.1,192.168.13.2 --group "Our Galera Cluster" --log /tmp/garbd.log --daemon

How to stop Galera Arbitrator (gardb)

shell> killall garbd

How to start Galera Arbitrator (garbd) with a configuration file

shell>./garbd --cfg /tmp/garb.cnf --daemon

The configuration file looks as follows:

#
# /etc/mysql/garb.cnf
# …

So just a quick note to express how great it felt to get the first MySQL Meetup in the UK's Bristol done. We had great enthusiastic attendees bringing their own curiosity about the product. We spent a couple of hours in conversation about a broad range of MySQL related topics. Amongst the points discussed were; MySQL Connect, Percona Live London, InnoDB vs. MyISAM, replication, query tuning and Ben gave a demo on pt-query-digest and pt-visual-explain. Although we touched many aspects it was really a primer for what we would like to achieve going forward. We're planning content and dates for the next meetup so keep an eye on the meetup page. I want to express that all comers are welcome whether you're fantastically experienced or a curious noob there's place for you. The group has already made many friends such as TomD from Percona, Stoker from Oracle and Marco from Pythian. …

MySQL Connect is just around the corner and one of the most popular speakers in the MySQL Community is Yoshinori Matsunobu from Facebook. This year we are lucky to have him as a speaker.

What are your speaking about at your session?
MySQL 5.6 at Facebook

Who would benefit most from attending your session?
People considering to upgrade to 5.6. I have heard many people are waiting until
we (Facebook MySQL team) deploy 5.6 in production. I can tell you our story.

What other sessions would you recommend or are planning to attend?
MySQL at Twitter [CON8194]
InnoDB: Table and Index Data Structures Architecture [CON6897]
Unlocking MySQL: Dealing with Locking in MySQL [CON4038]
MySQL Replication: Deep Dive into GTIDs for Scaling and High Availability [CON2610]
MySQL @ …

In the new Workbench, click on the "Planet MySQL" shortcut, then search for my feed and find this post.

MEM

This post will show how to use Connector/NET and Windows Store Apps in Windows 8 to connect and retrieve data from a MySql Server database.