Feed aggregator

As I mentioned here, there is a slight change for enabling the [original] InnoDB Plugin in MariaDB 5.5 (as compared to how you would enable it in 5.1).

Remember, in MariaDB 5.5, if you do not “enable” (i.e., add anything to the config file to do so) the InnoDB Plugin in MariaDB 5.5, you’ll end up with XtraDB+ for your InnoDb plugin. However, if you do “enable” the InnoDB plugin, then you end up with the original InnoDB plugin provided by Oracle/InnoDB.

The change is that the plugin file (.dll for Windows, .so file for Linux) which was previously named “ha_innodb_plugin.dll” is now just “ha_innodb.dll”.

Thus, if you previously enabled the plugin with (would have been in a 5.1 instance):

[mysqld]
ignore_builtin_innodb
plugin-load=innodb=ha_innodb_plugin.dll;innodb_trx=ha_innodb_plugin.dll;
innodb_locks=ha_innodb_plugin.dll;innodb_lock_waits=ha_innodb_plugin.dll;
innodb_cmp=ha_innodb_plugin.dll;innodb_cmp_reset=ha_innodb_plugin.dll;
innodb_cmpmem=ha_innodb_plugin.dll;innodb_cmpmem_reset=ha_innodb_plugin.dll

You now need to use:

[mysqld]
ignore_builtin_innodb
plugin-load=innodb=ha_innodb.dll;innodb_trx=ha_innodb.dll;
innodb_locks=ha_innodb.dll;innodb_lock_waits=ha_innodb.dll;
innodb_cmp=ha_innodb.dll;innodb_cmp_reset=ha_innodb.dll;
innodb_cmpmem=ha_innodb.dll;innodb_cmpmem_reset=ha_innodb.dll

That is the only difference, so after making that change, just restart your instance, and you’ll be in business.

For reference, if you encounter this, you might see an error similar to the following in your error log:

120524 19:24:56 [ERROR] Can't open shared library
 'C:\Program Files\MySQL\MariaDB 5.5\lib\plugin\ha_innodb.dll'
 (errno: 0 The specified module could not be found.)
120524 19:24:56 [ERROR] Couldn't load plugin named 'innodb' with
 soname 'ha_innodb.dll'.
120524 19:24:56 [ERROR] C:/Program Files/MySQL/MariaDB 5.5/bin/mysqld:
 unknown variable 'innodb_buffer_pool_size=10M'
120524 19:24:56 [ERROR] Aborting

Hope this helps.

 

I built MariaDB 5.5.24 on Windows yesterday from source, so I just wanted to share my steps.

Here is the short version:

bzr branch lp:maria/5.5 maria-5.5
cd maria-5.5
mkdir bld
cd bld
cmake .. -G "Visual Studio 10"
cmake --build . --config relwithdebinfo --target package

Done! Nice, neat zip file is created right there.

Here is the longer version with outputs for those interested:

C:\mariadb-5.5>bzr branch lp:maria/5.5 maria-5.5
Connected (version 2.0, client Twisted)
Authentication (publickey) successful!
Secsh channel 1 opened.
Branched 3418 revision(s).

C:\mariadb-5.5>cd maria-5.5

C:\mariadb-5.5\maria-5.5>mkdir bld

C:\mariadb-5.5\maria-5.5>cd bld

C:\mariadb-5.5\maria-5.5\bld>cmake .. -G "Visual Studio 10"
-- Check for working C compiler using: Visual Studio 10
-- Check for working C compiler using: Visual Studio 10 -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working CXX compiler using: Visual Studio 10
-- Check for working CXX compiler using: Visual Studio 10 -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- MariaDB 5.5.24
-- Check size of void *
-- Check size of void * - done
-- Packaging as: mariadb-5.5.24-win32
-- Looking for include files CMAKE_HAVE_PTHREAD_H
-- Looking for include files CMAKE_HAVE_PTHREAD_H - not found.
-- Found Threads: TRUE
-- Looking for pthread_attr_getguardsize
-- Looking for pthread_attr_getguardsize - not found
-- Check size of time_t
-- Check size of time_t - done
-- Could NOT find Boost
-- Cannot find wix 3, installer project will not be generated
-- Looking for MFC
-- Looking for MFC - not found
-- Configuring done
-- Generating done
-- Build files have been written to: C:/mariadb-5.5/maria-5.5/bld

C:\mariadb-5.5\maria-5.5\bld>cmake --build . --config relwithdebinfo --target package
.......
lots of output
.......
C:\mariadb-5.5\maria-5.5\bld\...
C:\mariadb-5.5\maria-5.5\bld\...
C:\mariadb-5.5\maria-5.5\bld\...

    46 Warning(s)
    0 Error(s)

Time Elapsed 00:23:18.16

Success \o/

Package is named: mariadb-5.5.24-win32.zip

Full location:

C:\mariadb-5.5\maria-5.5\bld\mariadb-5.5.24-win32.zip

C:\Users\Chris>mysql -uroot -pmysql -P3313 -e"select version()"
+----------------+
| version()      |
+----------------+
| 5.5.24-MariaDB |
+----------------+

With XtraDB+ (i.e., InnoDB plugin is not enabled), it starts fine, and uses InnoDB version 1.1.8-24.1.

If you try to enable the original InnoDB plugin, note the library is now named ha_innodb.dll (or ha_innodb.so) instead of ha_innodb_plugin.dll (or ha_innodb_plugin.so), which is what it was named in MySQL/MariaDB 5.1. I discuss this topic in more detail here, if you’re interested.

Hope this helps.

Further resources:

Full Details on CMake here:

http://forge.mysql.com/wiki/CMake

For details on building on Linux, please see here:

http://kb.askmonty.org/en/source-building-mariadb-on-centos/
..

Related Build Links:

• How to Build MariaDB 5.5 on Windows from Source Code:
  http://www.chriscalender.com/?p=1087

• How to Build MySQL 5.5 on Windows from Source Code:
  http://www.chriscalender.com/?p=689

• Building MariaDB 5.1 on Windows:
  http://www.chriscalender.com/?p=736

• Building MariaDB 5.3 on Windows:
  http://www.chriscalender.com/?p=864

• MySQL 5.5 Windows Build Appendix : Full Outputs and Common Errors from Building MySQL 5.5 on Windows:
  http://www.chriscalender.com/?p=720

• Maintaining (and Building) your MySQL Source Tree on Windows:
  http://www.chriscalender.com/?p=759

• Resolving the bison.exe m4 Invalid argument Error when building MySQL/MariaDB/XtraDB on Windows:
  http://www.chriscalender.com/?p=798

• Building XtraDB on Windows:
  http://www.chriscalender.com/?p=820

 

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 InnoDB Recovery Tool had been released, which can also be used to recover data from a stranded .ibd file too).

However, if you’ve used either my method or the InnoDB Recovery Tool for such a job, it can be a bit of work to get the data dumped. For those experienced, it goes much faster. But still, you cannot get any faster than just being able to (roughly) import the individual tablespace right into any running MySQL 5.6 instance.

Nice work!

Note: Again, I must mention this is only in MySQL 5.6, so if you have a stranded .ibd file you need to recover data from pre-5.6, you’ll either need to use my method or the InnoDB Recovery Tool.

 

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 therefore didn’t realize it was running as a service, and thus since the service manager got no response from mysqld, it terminated the service after 30 seconds (though I could connect and issue any MySQL command or query within that 30 seconds).

Many thanks to Wlad for helping me to track this down!

For reference, here is my terminal output:

C:\>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"
[SC] CreateService SUCCESS

C:\Users\Chris>net start maria55
The maria55 service is starting.
The maria55 service was started successfully.

With the initial service attempt, the service creates fine, but fails after 30 seconds:

C:\Users\Chris>net start maria55
The service is not responding to the control function.

More help is available by typing NET HELPMSG 2186.

Hope this helps.

 

I just wanted to take a moment and say congratulations to all of the 2012 Community Contributor Award Winners!

The usual suspects, Baron, Sarah, Gerardo, and Sheeri, each won, and deservedly so. All 4 contribute a great deal to the MySQL Community and ecosystem, and it is very much appreciated.

However, I was especially happy to hear that James Day was also a winner (a name everyone might not be so familiar with). But, having worked with James for 5 years, I really couldn’t say it better than Henrik Ingo already did (in his initial post of this year’s winners), so let me quote him:

“James was nominated for ‘MySQL advocacy and swimming upstream to keep people informed about bugs and other issues.’ When looking into James’ activities in the community, the panel first didn’t find much evidence to support an award. For instance, unlike most winners, he is not a frequent blogger on Planet MySQL. But when digging deeper it became clear that James’ instead is a very active commenter on everyone else’s blogs, contributing in depth additional information to the community dialogue. James therefore is an excellent example of the kind of helpful support person that tirelessly helps everyone he meets in their use of MySQL.”

There is not a single bug comment from James that I don’t appreciate, and he gladly shares his in-depth knowledge, and always has.

So this was definitely great to see, and that award, as were all, were well deserved!

Congratulations, James, Baron, Sarah, Gerardo, and Sheeri!

 

I am very pleased to say that earlier today, SkySQL announced it has raised $4 Million in Series A Round Funding.

Let me post the main part of the press release here:

SAN JOSE – April 18, 2012 – SkySQL, the first choice in affordable database solutions for the MySQL® and MariaDB® databases in the enterprise and the cloud, today announces that the company has raised $4 million in Series A funding from a number of investors, including OnCorps, an elite peer-based community of veteran technology investors and advisors committed to bringing better, cost-disruptive technologies into the mainstream. Also funding the round are European investors including Finnish Industry Investment Ltd., Spintop Ventures and Open Ocean Capital.

SkySQL will primarily use the investment to fund growth in its new product development, including adding critical positions. This is the company’s most recent move in expanding beyond a MySQL and MariaDB services-only company into a fully-fledged database products and services provider. SkySQL made its debut in October 2010 and has been funded to date with seed money from OnCorps, as well as Open Ocean Capital. Today, SkySQL is currently operating in 13 countries.

“The SkySQL strategy aligns well with OnCorps’s technology leadership vision,” said Bob Suh of OnCorps. “SkySQL will capitalize on the growing database and cloud services market. We are delighted and look forward to working with the SkySQL team to contribute to their continued success.”

“This investment will let us focus on ramping up development and efforts behind both enterprise and cloud database products that address a very real need in the marketplace,” said Ulf Sandberg, chief executive officer of SkySQL. “We also plan to build on our existing MySQL and MariaDB services offering, which offers customers unrivaled support, consulting and training.”

You can read the full press release here:

http://www.skysql.com/news-and-events/press-releases/skysql-raises-4-million-series-round

Very exciting times!

 

Last week was full of exciting news for all things MySQL.

However, SkySQL also had some great individual news in that it announced 2 new partners:

• hastexo
• PalominoDB

I just wanted to take a moment and officially welcome both to the SkySQL fold!

PalominoDB and hastexo, it’s great to be partnered with you!

And we’re looking forward to all the exciting things the future has to hold!

For those interested, you can read more about each partnership here:

SkySQL & hastexo Partnership Press Release
SkySQL & PalominoDB Partnership Press Release

 

Well, as you or may not have heard, MariaDB 5.5 (5.5.23) was declared GA last week!

It was only about 6-ish weeks ago that MariaDB 5.5 had been released as alpha, so the fact it’s already GA is excellent news for all MariaDB users (and MySQL 5.5 users looking to migrate).

Some of the 5.5 enhancements include:

• Significantly more efficient thread pool, comparable in functionality to the closed source feature in MySQL Enterprise.
• Non-blocking client API Library (MWL#192)
• @@skip_replication option (MWL#234)
• SphinxSE updated to version 2.0.4.
• “extended keys” support for XtraDB and InnoDB
• New INSTALL SONAME statement
• New LIMIT ROWS EXAMINED optimization.
• mysql_real_connect() Changes
  In MySQL, and in MariaDB versions before 5.5.21, mysql_real_connect() removes from the MYSQL object any options set with mysql_option() when it fails. Beginning with MariaDB 5.5.21, options are preserved by a failing mysql_real_connect(); use mysql_close(), as normal, to clear them.
  This only has effect if the MYSQL object is reused after a mysql_real_connect() failure (which is unusual). No real-life incompatibilities are expected from this change (it is unlikely that an application would rely on options being automatically removed between connection attempts).

• The variables replicate_do_*, replicate_ignore_*, and replicate_wild_* have been made dynamic, so they can be changed without requiring a server restart. See Dynamic Replication Variables for more information.
• Updates to performance schema tables are not stored in binary log and thus not replicated to slaves. This is to ensure that monitoring of the master will not cause a slower performance on all slaves. This also fixes a crash on the slaves.

Here is the official “What is MariaDB 5.5″ page:

http://kb.askmonty.org/en/what-is-mariadb-55

Also of interest:

Release Notes
Changelog
General Info

And as always, if you’d like full support for MariaDB, just contact us at SkySQL.

Hope this helps.

 

I’m proud to say that my wife, Vida, has officially launched her invention and it is now available for purchase at www.periodpanteez.com.

This is an invention she’s been perfecting for over 4 years, so this was a long-time coming, and I’m just so proud of her for creating such an innovative and quality product.

All menstruating women will want to own a pair (or two or three) of these, and I think it’s awesome that Vida had the idea, and so will women everywhere once they get a chance to try them out.

And it is not just for women. There are great resources for Dads who have to have “the talk” with their daughter. And Period Panteez make a great gift ideas for Dads, husbands, or boyfriends.

Let me post her full, recent press release:

Cincinnati, OH, April 4, 2012

Ohio Woman Invents What She Calls “The Product of the Year for Women, Period!”

Thanks to entrepreneur and inventor, Vida Calender, of Hamilton, Ohio, women can finally throw out their old granny panties and own a pair of real Period Panteez! Until now, women have had to worry about accidents while on their period, especially while sleeping or exercising, but with Period Panteez, worry no more! Period Panteez are a trendy, triple-layered boy short that provide support and peace of mind, protect clothing and bedding, and prevent accidents and embarrassment.

From tween girls to mature women, Period Panteez offer the solution to an age old problem that nearly all menstruating ladies experience! After buying brand new soft sheets and then having to sleep on itchy, uncomfortable towels to protect her bedding while menstruating, Vida said, “There’s got to be a better way!”, and Period Panteez was born. “I’m comfortable knowing I won’t ruin my clothing or embarrass myself with leakage. I love the product! I do not worry anymore about leakage and that is a huge relief! Thank you!”, commented Jackie, a focus group participant from Hamilton, Ohio.

After more than four years of research and development, countless prototypes, and extensive product testing, Period Panteez finally had its official product launch at Tri-County Mall in Springdale, Ohio on March 31, 2012. To celebrate the launch of Period Panteez, there will be fun giveaways the entire month of April. Visit Period Panteez’ website at http://www.periodpanteez.com to enter to win movie passes and shopping gift cards!

Once Vida had her “Aha” moment and discovered that nothing like her invention existed, she applied for a patent, located all necessary suppliers, and not only began manufacturing her product, but began transforming her dream into a reality! “My dream is that through Period Panteez, I can help improve the quality of women’s lives, from tweens to grandmas, and help make the world a better place by putting people first, period”, said Vida.

Being part Cherokee herself, Vida is honored and proud to design and manufacturer Period Panteez in the United States of America, for women by women, using fine quality, hand picked fabrics. Period Panteez can be purchased at http://www.periodpanteez.com at any time.

“The product is fantastic and solves a problem I have had since my menstruation cycles began, and helps me to feel totally confident that my period nightmare isn’t going to happen!”, said Lauren from Oakland, California.

Press Contact:
Vida Calender, Inventor/President
Period Panteez, LLC
vida@periodpanteez.com
http://www.periodpanteez.com
1-888-878-8364

# # #

 

With all of the new news coming out right now, it can be easy to miss or overlook some of the new features.

While there’s been a lot of talk about MySQL 5.6 Replication, I specifically wanted to mention the new ‘mysqlfailover’ and ‘mysqlrpladmin’ utilities.

These are two new MySQL replication utilities (results of the new Global Transaction Identifiers (GTIDs) in MySQL 5.6).

Let me quote the MySQL 5.6 Replication article for both of these utilities:

mysqlfailover

“Provides continuous monitoring of the replication topology, enabling failover to a slave in the event of an outage on the master.

The default behavior is to promote the most up-to-date slave, based on the sets of GTIDs that have been applied, but the promotion policies are fully configurable. Therefore, a user can nominate a specific candidate slave to become the new master (i.e. because it is configured in a certain way or has better performing hardware), and the utility will automatically poll the other slaves to retrieve any events so far not replicated to the candidate slave’s relay log.

This ensures no replicated transactions are lost, even if the candidate is not the most current slave when failover is initiated.”

mysqlrpladmin

“If a user needs to take a master offline for scheduled maintenance, mysqlrpladmin can perform a switchover to a slave, defaulting to the most recent slave, or to a nominated candidate slave. It can also perform a manual failover in the event a master server has gone offline.

The utility can also be used to start and stop slaves, as well as provide slave discovery and basic monitoring, including

• Status of the slave and its I/O and SQL threads;
• Status of replication processing through the topology, including any lag or errors;
• Configuration of slave promotion policies.

With either of these utilities, the user may register scripts to be called in the event of a slave promotion – for example to redirect an application to use the new master for writes and for reads that must always be consistent.”

The new MySQL Utilities are only included in MySQL Workbench, which you can download from:

http://www.mysql.com/downloads/workbench/

Again, I should note this functionality is included in 5.6, which is not GA, so I certainly don’t recommend this for production usage.

I’ve not had a chance to test these out yet myself, but Dr. Chuck Bell has posted some usage/results here, which I think you’ll find useful.

Hope this helps.

 

This is just an update to let you know that the new SkySQL Training Schedule is now available online.

The schedule extends as far as September 2012.

There are courses in the Belgium, Germany, France, the United Kingdom, Ireland, the Netherlands, Sweden, and and the United States.

And some of the course titles include:

• Administering a MySQL® Database
• Developing Applications with the MySQL® Database
• Performance Tuning for the MySQL® Database
• High Availability for the MySQL® Database
• Administering MySQL® Cluster

You can read the full schedule here:

http://www.skysql.com/services/training/schedule?vdt=training_course_list|page_3

 

This is just a post to let you 5.0 users know that 5.0.96 is now available.

You may have read about some of the security bugs fixed in the recent 5.0.95, and now 5.0.96 is available (it’s been nearly 9 months since 5.0.94 was released – so this is quite a lot of activity as far as 5.0 is concerned).

So if for some reason you’re still running MySQL 5.0, you should at least upgrade to the latest 5.0.96.

The upgrade process should be smooth and simple if you’re already running 5.0 (just be safe and backup your data first though).

You can download 5.0.96 from here:

http://downloads.skysql.com/archive/index/p/mysql/v/5.0.96

And if you’re interested in the 5.0 changelogs, I have direct links to them here (just look for MySQL 5.0):

http://www.chriscalender.com/?page_id=595

Hope this helps.

 

If you’re attending the conference, be sure to stay the extra day (this Friday) for the SkySQL and MariaDB Consulting Lounge and Solutions Day.

You can register for the Free Solutions Day here (just name, email, company, and country):

http://www.skysql.com/mysql-solutions-day

And if you’re around that day, there will be a SkySQL and MariaDB Consulting Lounge open all day long, so feel free to stop by and speak directly with the SkySQL and MariaDB Experts.

More about the Consulting Lounge can be found here too.

 

I just wanted to give a quick shout out and say thank you to all who have been sharing talks and exciting news from the conference for those of us who weren’t able to attend!

It’s greatly appreciated!

And please keep up the great work.

 

The other day, I was troubleshooting a deadlock, and I wondered if any of the table’s columns were referenced by any foreign keys (fks) from any other tables in the instance.

Well, this is actually very simple with information_schema (I_S):

SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE REFERENCED_TABLE_NAME='parent';

Where `parent` is the name of the table you’re searching for.

Note this query does not restrict on the database, or schema, name, but that could easily be added (or any other number of conditions). Here is an example where I only return the most useful columns (which could be useful for determining said conditions):

SELECT CONSTRAINT_SCHEMA, CONSTRAINT_NAME, TABLE_SCHEMA,
	TABLE_NAME, COLUMN_NAME, REFERENCED_TABLE_SCHEMA,
	REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE REFERENCED_TABLE_NAME='parent';

If there are any fks, this will return something like:

+-------------------+-----------------+--------------+------------+-------------+
| CONSTRAINT_SCHEMA | CONSTRAINT_NAME | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME |
+-------------------+-----------------+--------------+------------+-------------+
| test              | child_ibfk_1    | test         | child      | parent_id   |
+-------------------+-----------------+--------------+------------+-------------+

+-------------------------+-----------------------+------------------------+
| REFERENCED_TABLE_SCHEMA | REFERENCED_TABLE_NAME | REFERENCED_COLUMN_NAME |
+-------------------------+-----------------------+------------------------+
| test                    | parent                | id                     |
+-------------------------+-----------------------+------------------------+

Hope this helps.

 

If you still have not signed up for the Percona Live MySQL Conference & Expo (week of April 9th), use the following discount code from SkySQL to receive 10% off when registering:

SKY-PL12

And while you’re there, don’t forget to attend the following events on the day-after (4/13/2012) the Expo:

• SkySQL & MariaDB Solution Day – FREE!
• Drizzle Day (4th Annual) – FREE!
• Sphinx Search Day (1st Annual) – FREE!

 

This is another, in-case-you-missed-it, but it is definitely worth mentioning again:

MariaDB 5.3 is now GA

So, if you’re using MariaDB 5.1 or 5.2, I’d definitely recommend upgrading to the new MariaDB 5.3.

Also, if you’re a Windows user using MySQL 5.1, I’d highly consider making the switch to MariaDB 5.3 due to all of the Windows-specific improvements in it.

MariaDB 5.3 Enhancements:

• Subquery optimizations
• Semi-join subquery optimizations
• Non-semi-join optimizations
• Subquery Cache
• Subquery Optimizations Map
• Optimizations for derived tables and views
• Disk access optimization
• Join optimizations
• Index Merge improvements
• Optimizer control
• NoSQL-style interfaces
• Group commit for the binary log
• Replication and binary logging enhancements
• Microsecond support for NOW() and timestamp, time, and datetime columns
• Windows performance improvements
• And a number of other general improvements

MariaDB 5.3 Windows-Specific Performance improvements include:

• Backported Windows performance patches from MySQL 5.5
• Asynchronous IO in XtraDB is redesigned and is now faster, due to the use of IO completion ports
• Additional durability option for XtraDB : innodb_flush_method can now be O_DSYNC, like on Unixes. (The effect of using this option is that the log file is opened with FILE_FLAG_WRITETHROUGH, and FlushFileBuffers() is not done. This may improve speed in write-heavy scenarios.)
• A new Windows MSI installer
• Includes a GUI-tool, HeidiSQL

All of the above, and more are documented in further detail here:

http://kb.askmonty.org/en/what-is-mariadb-53

You can download it here:

http://downloads.askmonty.org/mariadb/5.3/

(And just for reference, if running MariaDB you should probably keep your eye on the new MariaDB 5.5 too (5.5.20 was alpha, 5.5.21 is now beta), benchmarks here).

Hope this helps.

In case you didn’t notice it last week, MariaDB 5.5 (5.5.20, specifically) has been released.

It’s a release I’ve been looking forward to for a while now, so I’m very excited that it’s now available!

Note that it is currently ‘alpha’ since it is the very first release of MariaDB 5.5. However, it is not your typical new ‘alpha’, so I would expect it to be GA in the not-so-distant future (please don’t quote me on this though, as I have no idea of the true time table – but the goal is for the next 5.5 release to be ‘beta’).

You can download MariaDB 5.5 from the following location:

http://downloads.askmonty.org/mariadb/5.5/

There are also more details on this 5.5.20 MariaDB version here:

What is MariaDB 5.5
Release Notes
Changelog
General Info

 

I’m happy to announce the new SkySQL Training schedule is now available.

In fact, some classes began this week.

Here is the upcoming Performance Tuning class schedule:

• Mar 05, 2012 – Mar 08, 2012 :: San Francisco
• Mar 27, 2012 – Mar 30, 2012 :: Paris
• Apr 02, 2012 – Apr 05, 2012 :: Boston
• May 15, 2012 – May 18, 2012 :: Paris
• Jun 18, 2012 – Jun 21, 2012 :: Paris

More details on the Performance Tuning Class are here:

http://www.skysql.com/services/training/courses/performance-tuning-mysql-database

And note the Performance Tuning class is not the only available class at the moment. The full SkySQL Training Schedule can be found here:

http://www.skysql.com/services/training/schedule

I think a lot of folks are aware of this already, but just in case anyone missed it, let me post it again, as I’m quite excited about it.

What: SkySQL & MariaDB Solution Day When: April 13, 2012 (Friday) Where: The Hyatt Regency Santa Clara (5101 Great America Parkway Santa Clara, CA 95054)

Main Benefits:

• Monty Widenius and David Axmark will reunite for the key note!
• Six intensive tutorials!
• Free Lunch!

You can sign up for it in just a couple of seconds here .. and best of all, it’s completely FREE:

http://www.skysql.com/mysql-solutions-day

This is the day after the Percona Live MySQL Conference And Expo 2012 so if you’re attending, be sure you stay the extra day, as it will be well worth it.

Furthermore, note that both Drizzle Day (4th Annual) and Sphinx Day (1st Annual) are also on the same day, so be sure to catch as much of all of these great programs (and resources) as possible too!

Safe travels and we hope to see you there.