Over the past few days extensive conversations around a new security vulnerability in MariaDB and MySQL have taken place.

It all started as a chain reaction when Monty Program publicly disclosed information about the flaw they had found and about how to make sure your MariaDB and MySQL installations can be fixed. The initial information got assigned the security vulnerabitlity identifier CVE-2012-2122 and the contents can be seen e.g. here http://seclists.org/oss-sec/2012/q2/493.

The bug was found two months ago on April 4th.

Before disclosing the information publicly, given the seriousness of this bug and considering the millions of MySQL and MariaDB installations deployed worldwide, Monty Program informed the biggest distributors of MySQL and MariaDB as a precaution.

On April 6th, Monty Program informed Oracle about it in bug report …

Are you looking to expand your knowledge about MySQL and MariaDB database solutions?

Well, you’re in luck! SkySQL is introducing an exclusive collection of educational videos featuring some of the industry’s leading experts on the MySQL database and related technologies. View informative, technical talks on a variety of topics, from the experts at SkySQL, MariaDB, Calpont InfiniDB, Continuent, ScaleDB, Severalnines, Sphinx, Webyog, and others.

read more

Retrouvez SkySQL et ses partenaires sur le stand C21 du Salon Solutions Linux 2012 au CNIT à Paris du 19 au 21 juin

Cette année, le Salon Solutions Linux à Paris coincide avec la Fête de la Musique. C’est donc avec enthousiasme que nous nous préparons pour cet évènement annuel incontournable dédié aux logiciels libres et à l’Open Source.

read more

The South East LinuxFest is this weekend (June 7-9) in Charlotte, North Carolina and SkySQL will be attending the conference both as a sponsor and with talks. 

read more

Yesterday, it was announced that SkySQL has raised an additional 2.5 million dollars in Series A funding from California Technology Ventures.

This comes along with the news of the new CEO, Patrik Sallner, taking the CEO role at SkySQL on July 1st.

Here are some relevant snippets:

“SkySQL also announced today that CTV, a venture capital fund that makes direct investments in technology and life science companies globally, invested an additional $2.5 million as part of the company’s recent A round of funding. With this latest investment, SkySQL has collected EUR 6 million to fund further growth.”

“About California Technology Ventures, LLC
California Technology Ventures, LLC is a venture capital fund that makes direct investments in technology and life science companies. CTV has built a strong reputation for its entrepreneurial approach to investing and working with companies. They believe in guiding …

In case you may have overlooked yesterday’s post from Ulf Sandberg, I thought I’d go ahead and reiterate the main points, as it is big news, at least for those interested in SkySQL.

SkySQL has been like a rocket ship with it’s growth since we started, and now we’re making some even bigger changes to help accelerate that effort further.

As Ulf announced, we’ve named a new CEO, Patrik Sallner, to take over after the initial bootstrap period.

Patrik, a former executive at F-Secure, will officially become CEO on July 1st. “Patrik comes to SkySQL with demonstrated experience in building international software and services businesses, including delivering cloud storage solutions to the world’s largest telecommunications operators. The addition of Patrik to SkySQL’s Leadership Team is a tremendous boon to …

When we launched SkySQL at the company meeting in Istanbul, Turkey, in October 2010, I charged the SkySQL Team - then only 13 strong - to “Go Big, or Go Home”. Two weeks ago, while at our company meeting in Athens, Greece, as I listened to SkySQLers - now numbering 40 plus - share their experiences with customers, their ideas for new products and solutions, their suggestions for bettering the company, etc., I found it abundantly clear that the Team had taken my words to heart, and had exceeded my expectations.

It’s been six quarters since our launch, and the company has had a remarkable run. In this short time, we’ve increased our customers tenfold and have more than tripled our staff; we’re now serving customers in 30 countries around the globe. Additionally, thru numerous strategic partnerships with MariaDB and key MySQL ISVs, including Calpont InfiniDB, …

The good news is that we have just released plenty of MariaDB & MySQL training dates covering the summer months and even into October across the globe.    This new training calendar includes all of our current training courses in plenty of locations both in North America and Europe. 

read more

Being a data recovery specialist and having recovered countless GBs of corrupted, and/or stranded, InnoDB data in my days, I am very happy to hear about the new InnoDB Transportable Tablespaces coming in MySQL 5.6!

Back in the day, if you had a stranded .ibd file (the individual InnoDB data file with –innodb-file-per-table option), you basically had nothing (even though that file contained all of the data). This was because unless you had the original instance that that particular .ibd file (table) originated from, there was no way to load it, import, or dump from it. So it was not of much use, though all the data was *right* there.

Thus I created the method of Recovering an InnoDB table from only an .ibd file (I should note that this was before the …

I’d had some difficulty manually creating my own windows service for MariaDB (worked fine from the installer), but it was due to the way I was creating it, so I wanted to share the proper approach:

Old Way:

sc create "maria55" binpath= "\"C:/Program Files/MySQL/MariaDB 5.5/bin/mysqld\"
\"--defaults-file=C:/Program Files/MySQL/MariaDB 5.5/data/my.ini\""
DisplayName= "Maria55" start= "auto"

New Way:

sc create "maria55" binpath= "\"C:/Program Files/MySQL/MariaDB 5.5/bin/mysqld\"
\"--defaults-file=C:/Program Files/MySQL/MariaDB 5.5/data/my.ini\" maria55"
DisplayName= "Maria55" start= "auto"

The key is adding the name, maria55, after the –defaults-file=.. option, but still within the “” that belong to “binpath”.

This extra parameter exists so that mysqld knows whether or not it was started as a service or not.

Without it, the server does not know, and …