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.

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.4. This is an Alpha release. See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 10.0? page in the AskMonty Knowledgebase for general information about the MariaDB 10.0 series.

Download MariaDB 10.0.4

Release Notes Changelog …

This week we talk about MySQL Connect sessions. Ear Candy is the mysqladmin "relative" command, and At the Movies is Manipulating JSON with MariaDB and MySQL. Listen to hear how to win a free pass!

Events
DB Hangops - every other Wednesay at noon Pacific time

FrOSCon - Aug 24-25th, 2013 in St. Augustin, Germany.

Oracle is having a MySQL OTN Virtual Developer Day August 31st.

read more