MariaDB: Improve Security with Two-Step Verification

In this primer I will show how to improve the security of your MariaDB installation by using two-step verification and how to use it from your Windows GUI client.

Let’s suppose you have your data in MariaDB, installed, say, on Ubuntu. And your users connect to it to run ad hoc queries, using some sort of a Windows GUI client. You don’t want them to write the access password on post-it notes or have it auto-entered by the client. And you don’t want anyone see the password when one of the salespersons connects to the mother ship from his laptop in the Internet café. …

OLX and MariaDB

OLX, a free classifieds site, is serving up 40 million pages a day using MariaDB. Not an insignificant task.

There’s a nice write-up in the MariaDB knowledgebase with particulars. In short, the 5.2 series of MariaDB and some of the unique features of the project have made a migration easy and valuable.

It’s nice to hear such stories. Both because we like interesting sites and projects, as well as our natural interest in larger scale or larger visibility deployments. Got a story to share? Please create a KB entry, or e-mail the community team. …

Kajona is running with MariaDB

Based on small talk with Stefan Idler and Jakob Schröter at OpenRheinRuhr2010, Kajona CMS now officially works with MariaDB. They tested MariaDB and verified that it was a drop-in-replacement for MySQL without any modifications needed on their side. We are of course happy to hear about all real-life success stories!

You can find more about Kajona here.

If your project or product also supports MariaDB, then please tell us about it! You can find our growing list of supported software on our Knowledgebase. …

Quickly and efficiently migrating hundreds of servers from MySQL to MariaDB

Via SpamExperts:

SpamExperts has their own anti-spam filtering cloud which is provided as a software-as-a-service (SaaS) model. In addition they have an e-mail security product which they install, update and monitor on-site. Most of SpamExperts’ anti-spam technology has been developed in-house and makes extensive use of the MySQL database. All clients contribute in real-time to their filtering effectiveness, so they have many different data flows that are handled by MySQL. Replication is used to synchronize the data between the systems in a cluster and to push data feeds in real-time. The SaaS cloud is replicated across four countries for redundancy, whereas client installations spread the data retrieval around the globe.