Recently, I found myself needing MariaDB 5.1.60 for Windows for some testing purposes. Therefore, I needed to build it from source. I ended up using what I’d call a “blend” of the commands listed in this “how-to” and the readme file INSTALL-WIN-SOURCE, so I thought I’d post those steps.

Download 5.1.60 MariaDB source from here.

cd C:\mariadb-5.1

win\configure.js

cmake .

VS: File -> Open -> Solution -> MySql.sln

VS: Build -> Build Solution

VS: Right-click “PACKAGE” -> Build (in “Solution Explorer” View)

That’s it.

Let’s fire it up:

MariaDB> select version();
+----------------------+
| version()            |

  [Read more...]

The NoSQL/relational database debate has been going on for quite some time. MariaDB, like MySQL is relational. And if you read these series of blog posts, you’ll realise that if you use MySQL correctly, you can achieve quite a lot.

It all starts with Kellan Elliott-McCrea with his introductory post on Using, Abusing and Scaling MySQL at Flickr. Follow the entire series.

He starts of the series with Ticket Servers: Distributed Unique Primary Keys on the

  [Read more...]

You can now yum (RPM) or apt-get (DEB) MariaDB 5.1.39, courtesy of OurDelta and in close cooperation with Monty Program Ab. Simply follow the info on the CentOS, Debian or Ubuntu pages.

(note: give the mirrors some hours to sync up)

Quick overview

• See the Release Notes for relevant bugfixes.
• Drop-in replacement for stock MySQL 5.0 or 5.1 (If you’re coming from stock MySQL, see the MariaDB extras/differences overview).
• If you are upgrading from 5.0, please review the

  [Read more...]

I'm extremely happy to announce that the MariaDB project has integrated FederatedX into the main tree and has replaced the old, un-maintained Federated storage engine! This means that from now on, I will target any FederatedX changes and enhancements for MariaDB since it will be easier than having to try to make it run as a pluggable storage engine. This also means I will have another reason why I should keep this project moving forward. I will still provide the ability for anyone who wants to use it as a pluggable engine (not that difficult) so this can be loaded with MySQL as well.

Also changed: I changed to using the BSD license for FederatedX.

For Drizzle, I will need to rewrite a good part of the code base to use libdrizzle as well as the new storage engine interface, so they will be somewhat separate projects -- though I'll do my best to keep them the same single project.



  [Read more...]

Just a quick post that I've moved The FederatedX Storage Engine for MySQL to Launchpad from my Mercurial repository. I'm trying like anything to get a spare moment to work on it-- writing a book takes every spare moment I have. I have made it group accessible and am working with Antony Curtis (who with Arjen encouraged me to get this on LP) on it. So, what I need to do is start a 5.1 compile (it has a problem with latest 5.1) and then give it a test run to see what the problem is. I want to keep this project moving!

The Launchpad page for it is:

https://launchpad.net/federatedx