The OpenBSD Foundation is raising funds - they’ve got a goal of USD$150,000 (so far they’ve achieved $100,000). A few days ago they had potential trouble keeping the lights on for this secure BSD distribution, and today they’re all set in terms of electricity to power servers and looking for more around project expansion. 

If you dig MariaDB, it’s worth noting that MySQL 5.1.73 ships and the MariaDB branch in the ports tree is currently at MariaDB 10.0.7. Previously they shipped MariaDB 5.5.

Donate to keep the lights on for …

The availability of the node.js binding for MariaDB’s non-blocking client library together with the GIS capabilities of MariaDB inspired me to make an example of using node.js and MariaDB to import so-called GPX tracks to a MariaDB database and then show them on a map. GPX tracks are what are stored by many GPS devices including running watches and smartphones.

My project makes use of MariaDB’s non-blocking client library together with the node.js platform and on top of that uses the GIS functionality found in MariaDB 5.5 and 10.0.

To start with let’s go through the software and components I’m using:

• Node.js – The popular Node.js platform built on Chrome’s JavaScript runtime. An event-driven and …

FOSDEM happens this year, February 1&2 2014. This year is a special year as it is the 10th anniversary: great content in the schedule, you must pre-register for dinner (lot’s of wonderful Belgian food & drink), and we have a shared booth in the expo hall.

Read more about the event with a wonderful post by Kenny. Again, much thanks to Liz, dim0, Kenny, Frederic for organising the venue, and the sponsors Oracle/SkySQL/Percona.

…

I’m back home in Toronto, after having spent part of last week in Washington DC meeting Oracle’s Federal MySQL users.

I think generally speaking when you look at buzzwords in the startup scene, there is a filter as to what bubbles up into the more conservative enterprise and public sector.

My impression was that there is some interest in big-data, but there is absolutely phenomenal interest in cloud computing. This was a real take away for me, and next time I plan to talk more about the MySQL utilities and MySQL Fabric.

There were two side discussions that affected a number of users that I wanted to follow up with here:

• When upgrading from MySQL 5.5 to 5.6, secure-auth is enabled by default. This incompatible change is unfortunate, but was required to improve MySQL’s password hashing strength. My …

Over the last few days, I integrated the MySQL 5.6 GTID version of the Percona Replication Manager (PRM) work of Frédéric Descamps, a colleague at Percona. The agent supports the GTID replication mode of MySQL 5.6 and if the master suffers a hard crash, it picks the slave having applied the highest transaction ID from the dead master. Given the nature of GTID-based replication, that causes all the other slaves to resync appropriately to their new master which is pretty cool and must yet be matched by the regular PRM agent.

For now, it is part of a separate agent, mysql_prm56, which may be integrated with the regular agent in the future. To use it, download the agent with the link above, the pacemaker configuration is similar to the one of the regular PRM agent. If you start from scratch, have a look …

Continuing my investigation of single-threaded performance in the MariaDB server, I managed to increase throughput of single-threaded read-only sysbench by more than 40% so far:

I use read-only sysbench 0.4.12 run like this:

    sysbench --num-threads=1 --test=oltp --oltp-test-mode=simple --oltp-read-only --oltp-skip-trx run

And mysqld is run with minimal options:

    sql/mysqld --no-defaults --basedir=X --datadir=Y --innodb-buffer-pool-size=128M

With modern high-performance CPUs, it is necessary to do detailed measurements using the built-in performance counters in order to get any kind of understanding of how an application performs and what the bottlenecks are. Forget about looking at the code and counting instructions or cycles as we did in the old days. It no longer works, not even to within an order of magnitude.

This year we have a dedicated track for MySQL at the Oracle User Group event in Norway.
This event is scheduled between 3rd of April and 5th of April.

We have 7 great session on MySQL at the event:

• Next generation MySQL: News in MySQL 5.7
• MySQL and NoSQL: Best of both worlds
• Introduction to MySQL Database Development with MySQL Workbench
• Quick Dive into MySQL
• How are queries optimized? An introduction to the optimizer
• MySQL Replication and MySQL Utilities – including demo!
• MySQL EXPLAIN Explained

See full agenda here: http://ougnvarseminar2014.sched.org/overview/type/mysql#

Registrer here: …

January 20, 2014 By Severalnines

Alfresco is a popular collaboration tool available on the open-source market. It is Java based, and has a content repository, web application framework and web content management system. For critical large-scale implementations that require 24*7 uptime, a multi-node cluster would be appropriate. Since Alfresco depends on external components such as the database and the filesystem, clustering the Alfresco instances only would not be enough.

In this post, we are going to show you how to deploy an active-active Alfresco cluster with MySQL Galera Cluster (database), GlusterFS (filesystem) and HAproxy with Keepalived (load balancer) to achieve redundancy of all the required system components.

Please note that clustering of Alfresco instances is only available in the Alfresco Enterprise. Hazelcast is used …

MySQL's architecture and features make the database a great fit for cloud based deployments. If you are interested in using MySQL to deliver web-based applications and scale out, read the white paper MySQL, An Ideal Choice in the Cloud.

As a first step to using the MySQL database, take the MySQL for Beginners course. In this 4-day course, you learn to use the MySQL Server and tools while developing a knowledge of relational databases. You can take this course through the following delivery methods:

• Training-on-Demand: Start training within 24 hours of registering and train at your own pace.
• Live-Virtual Event: Follow a live …

Mon, 2014-01-20 09:00tomcallway

We’ve been busy at SkySQL these past few months! Now we’re proud to introduce MariaDB Enterprise Release 1.0 to our customers and to the MySQL ecosystem. This new product is a milestone for SkySQL’s product portfolio, delivering easy installation, configuration and management of sophisticated high availability solutions based on MariaDB and Galera Cluster to customers eager to leverage this technology, but put off by its inherent complexities.

MariaDB Enterprise has an API layer as its foundation. The GUI tool which you use to provision, monitor and manage your cluster does all of its work through calls to the RESTful API, including provisioning cluster nodes on bare metal Linux boxes or newly instantiated virtual machines or AMIs. By packaging up the product’s capabilities in this API, we’ve both made it easy to manage Galera Clusters through our GUI, and also provided a powerful tool to …