The old MySQL.com logins will go away on Wednesday, December 19th and will be replaced by the Oracle Single Sign On (SSO).

This Oracle SSO will replace the old MySQL.Com login starting December 20th.

So what do you do? Go to Oracle.com and login. If your account was migrated you will be able to login. But the crimson invalid login message will require you to set up a new account. Some may be wary of providing more personal information. But this is being done to bring the MySQL.com web sites into compliance with our corporate rules and provide a better flow for those of you using more than one Oracle product.

Q: Will this affect voting statistics on Plant.MySQL.Com?
A: Probably. The run away leaders have been Giuseppe Maxia and …

So lots of folks are talking about the newly announced MariaDB Foundation. Some folks are confused as to what happened to the Open Database Alliance?

The MariaDB Foundation members include Monty Program, SkySQL, David Axmark, and Allan Larsson.

The Open Database Alliance members include Monty Program, FromDual, Open query, Percona and SoftMethod. [SkySQL was not founded when the ODBA was announced.]

The mission of the MariaDB Foundation…well, it’s not on the MariaDB Foundation web page yet, but the blog announcement says:

In its mission statement, the MariaDB Foundation exists to improve database technology, including standards …

There’s some media coverage about Wikipedia switching to MariaDB, I just wanted to point out that performance figures cited are somewhat incorrect and don’t attribute gains to correct authors.

Proper performance evaluation should include not just MariaDB 5.5 but Oracle’s MySQL 5.5 version too, because thats where most of performance development happened (multiple buffer pools, rollback segments, change buffering et al).

5.5 is faster for some workloads, 5.1-fb can outperform 5.5 in other workloads (ones with lots of IO), it is good to know that there’s beneficial impact from upgrading (though I’d wait for 5.6), but it is important to state that it is an effort from Oracle as well, not just MariaDB developers.

…

Die MySQL & MariaDB Datenbank Roadshow kommt nach Deutschland: - Stuttgart 25. Januar 2013, 9.00-16.00 Uhr, Sodexo STEP/Engineering Park
- Hamburg 1. Februar 2013, 9.00-16.00 Uhr, Quality Ambassador Hotel

Ab Januar 2013 sind SkySQL und Monty Program unterwegs mit unseren ersten gemeinsamen - kostenfreien - Roadshows in Deutschland: In Stuttgart und Hamburg wird Monty Widenius seine Zukunfts-Vision der MySQL-Datenbank via MariaDB vorstellen (Vortrag in Englisch). Zudem werden Sprecher von Codership/Galera erwartet sowie SkySQL Kunden-Berichte.

…

This is just a reminder: Call for papers for MySQL & Friends devroom at FOSDEM 2013 is open until December 21st, which is this Friday. Please hurry up and submit your proposal. Possible topics include everything related to MySQL.

MariaDB 10.0 has got another new feature: Sanja Byelkin has pushed EXISTS-to-IN rewrite feature. It is an optimization targeted at EXISTS subqueries. The idea behind it is simple. EXISTS subqueries often have form:

EXISTS (SELECT …  FROM … WHERE outer_col=inner_col AND inner_where)

where outer_col=inner_col is the only place where the subquery has references to outside. In this case, the subquery can be converted into an uncorrelated IN:

outer_col IN (SELECT inner_col FROM … WHERE inner_where)

The conversion opens new opportunities for the optimizer. Correlated EXISTS subquery has only one execution strategy. Uncorrelated IN subquery has two:

1. re-run the subquery every time the subquery is evaluated (the same as in EXISTS)
2. Materialize the subquery output …

Some weeks ago I had to migrate some independent MySQL servers (some standard MySQL masters, and some just standalone) to a Percona XtraDB Cluster of 3 nodes.

So the easiest way would be to configure each node to become also an asynchronous slave of one of the production servers.
Like illustrated here:

But in this case there was one major issue, the tables where MyISAM and this is not really recommended with Galera replication even if it’s now supported.

Preparing the slaves would then become a loop :

for each production server
   restoring the dump on the node that will be the dedicated slave
   convert the table in InnoDB
   configure and start the replication 
   finally perform SST on the other nodes....

So in this case that should have be done 3 times… that could take some …

[...] Redis, Memcached, Tokyo Tyrant and MySQL comparision http://ruturaj.net/redis-memcached-tokyo-tyrant-and-mysql-comparision/ [...]

My tutorial at Percona Live London 2012.
Slides + Audio are now available on Youtube


Part One

• Introduction - 00:00
• Indexes - 3:40 
• Finding Bottlenecks - 20:04

Part Two - 42:25

• Partitioning - 43:40
• Intensive Table Optimization - 1:02:16

Part Three - 1:38:49

•  Read Cache - 1:38:58
• Summary Tables - 1:54:46
• Scaling Reads - 2:03:34
• Reporting - 2:07:53
• Write Buffers - 2:12:28
• Scaling Writes - 2:19:31
• Sharding - 2:21:42
• Ending - 2:26:40

What is the value of a seed? 
When I discussed the MariaDB Foundation with friends and colleagues, many said I was exaggerating. My believe is that the Foundation is important for MySQL and for the future of the IT industry - services and applications. Many agreed with me that the Foundation is important for the MySQL ecosystem, but involving the global economy and the whole IT industry is a bit of a stretch.

Fact is, the World Wide Web would not be as it is today without MySQL. MySQL was part of the LAMP stack. It powered - and still powers - some of the most successful web sites in the world. Without LAMP, companies like Facebook, Twitter or Google would have been developed in a completely different way or they would have not been developed at all.

The importance of MySQL for the Internet is pretty clear for many of us. What is perhaps less clear is what is the current situation of MySQL and the …