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

Memory Leak

Memory Flame Graph    

Your application memory usage is steadily growing, and you are racing against time to fix it. This could either be memory growth due to a misconfig, or a memory leak due to a software bug. For some applications, performance can begin to degrade as garbage collection works harder, consuming CPU. If an application grows too large, performance can drop off a cliff due to paging (swapping), or the application may be killed by the system (OOM killer). You want to take a quick look before either occurs, in case it’s an easy fix. But how?

Debugging growth issues involves checking the application config and memory usage, either from application or system tools. Memory leaks are much …

Does size matter? This question has been teasing mankind since the beginning. But now, due to improvements in technology, size doesn’t really matter. Databases now have the features to tackle all data: big, medium, small, or very small. This Log Buffer Edition is here once again to bring you your data news of all sizes.

Oracle:

Marco tells us how to create a pluggable database by cloning an existing local PDB and talks about a bug in Oracle 12c.

Niall installs …