Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 61 to 90 of 714 Next 30 Older Entries

Displaying posts with tag: mariadb (reset)

MariaDB Enterprise 1.0 is Here
+1 Vote Up -0Vote Down

I know it was officially announced Monday, but I just wanted to take a moment and let everyone know MariaDB Enterprise 1.0 is now available, in case you missed the previous article.

What does MariaDB Enterprise consist of?

“MariaDB Enterprise is composed of several components including MariaDB Manager, which is a set of management tools and an API with which you can easily provision, monitor, and manage a highly available MariaDB Galera Cluster for multi-master, synchronous replication. Galera is a powerful technology that can eliminate single points of failure for your database infrastructure, but it is relatively new and can be a challenge to configure for administrators who aren’t familiar with it.”

  [Read more...]
Webinar Replay & Slides: Repair & Recovery for Your MySQL, MariaDB & MongoDB / TokuMX Clusters
+0 Vote Up -0Vote Down
January 23, 2014 By Severalnines


Thanks to everyone who attended this week’s webinar; if you missed the sessions or would like to watch the webinar again and browse through the slides, they are now available online.


Special thanks to Seppo Jaakola from Codership, the creators of Galera Cluster, for walking us through the various scenarios of Galera recovery. 


Webinar topics discussed: 

  • Redundancy models for Galera, NDB and MongoDB / TokuMX
  • Failover & Recovery (Automatic vs Manual)
  [Read more...]
More on 40% better single-threaded performance in MariaDB
+1 Vote Up -0Vote Down

In my previous post I wrote about how I achived a >40% speedup on sysbench read-only using profile-guided optimisation (PGO). While this is a preliminary result, I though it was so interesting that it deserved early mention. The fact that any benchmark can be improved that much shows clearly that PGO is something worth looking into. Even if we will probably not improve all workloads by 40%, it seems highly likely that we can obtain significant gains also for many real workloads.

I had one or two interesting comments on the post that raise valid concerns, so I wanted to write a follow-up here, explaining some of the points in more details and going deeper into the performance counter measurements. As I wrote before, actual observations and measurements are crucial to fully understand performance of

  [Read more...]
January 28 Webinar: Get More Out of MySQL with TokuDB
+0 Vote Up -0Vote Down

You love MySQL and MariaDB for its ease of deployment, but what if you could increase performance and save significant time and money when your application starts to scale without having to change your applications?
Register Now!

SPEAKER: Tim Callaghan, VP of Engineering at Tokutek
DATE: Tuesday, January 28th
TIME: 1pm ET

Join this interactive webinar with Tokutek’s VP of Engineering, Tim Callaghan, as he walks through the potential pitfalls when using MySQL or MariaDB for Big Data applications, and how to effectively use TokuDB to increase performance, reduce database size and achieve true schema agility.

Attend this webinar to learn:

  • How easy it is to install and configure TokuDB with MySQL or MariaDB
  • How to dramatically increase performance without having to rewrite code

  •   [Read more...]
    OpenBSD Foundation raising funds
    +0 Vote Up -0Vote Down

    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

      [Read more...]
    Node.js, MariaDB and GIS
    +1 Vote Up -0Vote Down

    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 non-blocking
      [Read more...]
    FOSDEM MySQL & Friends Devroom – signup for dinner
    +1 Vote Up -0Vote Down

    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,

      [Read more...]
    40% better single-threaded performance in MariaDB
    +5 Vote Up -0Vote Down

    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

      [Read more...]
    Active-active Alfresco cluster with MySQL Galera and GlusterFS
    +1 Vote Up -0Vote Down
    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)

      [Read more...]
    MariaDB 10: Performing fast & inaccurate statistics
    +0 Vote Up -0Vote Down

    As I already wrote, COUNT(*) can be expensive in InnoDB, because this value is not stored in indexes. Some other storage engines may not store that value. Also, COUNT(), MAX(), MIN() are immediate only if executed on an indexed column. But we don’t want too many indexes, and some exotic storage engines do not support indexes – thus, we may need to execute an aggregate function on a non-indexed column.

    Now, the question is: do you really need such values to be exact? If you need to report statistical values from your database, probably an error is acceptable. In this case, MariaDB 10 provides a solution:

      [Read more...]
    What do you want to see in MariaDB 10.1?
    +2 Vote Up -0Vote Down

    Last night, after my previous blog post, everyone in attendance at the SkySQL developer meeting in Barcelona gathered for dinner at El Cangrejo Loco, which, if my High School Spanish is working, translates as The Crazy Crab. After the excellent food, the tradition of singing at MySQL/MariaDB developer meetings was preserved.

    Today the MariaDB developers in attendance at the SkySQL developer meeting in Barcelona got together to work on plans for MariaDB 10.1. We also paused for a group photo:

    Many tasks have been identified for possible inclusion in 10.1. Some have already been marked as such in JIRA. A summary is

      [Read more...]
    MariaDB Developers at the SkySQL Engineering Meeting
    +3 Vote Up -0Vote Down

    Several MariaDB developers are attending SkySQL’s annual engineering meeting being held this week in Barcelona. While some of the discussions are SkySQL-specific (customers, internal projects, and so on), there are, naturally, lots of MariaDB discussions happening.

    Patrik Sallner, CEO of SkySQL, opened the meeting this morning with a short presentation about SkySQL’s goals for 2014. While the plan includes standard business-like things that include growing the company and sales goals, the top two goals for 2014 are:

  • Help make MariaDB into the leading open source database

  • Help increase awareness and adoption of MariaDB

  • Looking back at 2013, it was an excellent year for MariaDB. It is now the default database in

      [Read more...]
    MariaDB in Japan
    +3 Vote Up -1Vote Down

    MariaDB is in Debian/unstable now, and its great to see that we already have a Japanese po-debconf translation (in under a month!). The last time I was in Tokyo, Japan we seemed to have great interest in MariaDB, especially with the backing of MariaDB.com/SkySQL investment dollars and the MariaDB Foundation to keep things real.

    For me, I’m happy to go back to Tokyo to talk to users about MariaDB. If you’re in the area on Tuesday, 18

      [Read more...]
    My lca2014 talk video: Past, Present and Future of MySQL and variants
    +0 Vote Up -0Vote Down

    On last Wednesday morning I gave my talk at linux.conf.au 2014. You can now view and download the recording of it here:


    (hopefully more free formats will come soon, the all volunteer AV team has been absolutely amazing getting things up this quickly).

    A Close Encounter with MaxScale
    +1 Vote Up -0Vote Down

    MaxScale is the new proxy server from the SkySQL/MariaDB team. It provides Connection Load Balancing (CLB) and Statement Load Balancing (SLB) out of the box. This post is a [relatively] quick “how to” install, configure and test SLB with the read/write splitting module.

    Step 1 - Server preparation

    If you do not have many HW resources, you may run everything on a single Linux instance, but the best way to test MaxScale is to use at least 4 servers: one for MaxScale and for the client apps, one as Master and two as slaves - so, 4 in total. In this post I am going a bit further, I will use 5 servers:
    Max 0 - For client apps (
    Max 1 - The master server (
    Max 2 - The first slave (
    Max 3 - The second slave (
    Max 4 - The third slave (
    Max 6 - The MaxScale

      [Read more...]
    Deploying an Active-Active FreeRadius Cluster with MySQL NDB or Galera
    +0 Vote Up -0Vote Down
    January 6, 2014 By Severalnines

    MySQL Cluster is a popular backend for FreeRADIUS, as it provides a scalable backend to store user and accounting data. However, there are situations when the backend database becomes a centralized datastore for additional applications and services, and needs to take a more general-purpose role. NDB usually works very well for FreeRADIUS data, but for wider use cases and reporting type applications, InnoDB can be a better storage engine. For users who need to keep their data in InnoDB and still benefit from a highly available clustered datastore, Galera Cluster can be an appropriate alternative.

    In this post, we will show you how to deploy FreeRadius both with MySQL Cluster and Galera Cluster to store

      [Read more...]
    It can be a bright 2014
    +1 Vote Up -0Vote Down

    In many parts of the MySQL world, whether you have users, developers or administrators of MySQL, the season holidays are for family, relax, prayers, travel, or they are simply a moment where you can enjoy what you like or care most about.

    For me, this time is dedicated to my family, but also to deeper thoughts around the strategies to adopt in short and long term. My work nowadays, as the work of many others, is ruled by quick decisions, by the "time to market” - whatever “market" means in a specific context. Decisions must be made in meetings that are time-boxed in one hour or even less. In the end, you accumulate so much work and high priority tasks that you do not have enough time to prepare the topics adequately.

    I thought I could summarise my thoughts for the past year and for the near future, from a technical and from a business perspective.

      [Read more...]
    Mroonga and me and MariaDB
    +1 Vote Up -0Vote Down

    Chinese and Japanese and Korean (CJK) text usually has no spaces between words. Conventional full-text search does its tokenizing by looking for spaces. Therefore conventional full-text search will fail for CJK.

    One workaround is bigrams. Suppose the text is


    There should be three index keys, one for each two-character sequence:

    册免, 免从, and 从冘.

    Now, in a search like

    SELECT * FROM t WHERE MATCH(text_column) AGAINST ('免从');

    a bigram-supporting full-text index will have a chance. It's wasteful and there will be false hits whenever the bigram isn't really a "word", but the folks in CJK-land have found that bigrams (or the three-character counterpart, trigrams) actually work.

    One way to get bigrams for MySQL or MariaDB is to get mroonga.

    Why care about Yet Another Storage Engine)?

      [Read more...]
    MariaDB 10.0.7 now available
    +1 Vote Up -0Vote Down

    The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.7. This is a Beta release. See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 10.0? page in the MariaDB Knowledge Base for general information about the MariaDB 10.0 series.

    Download MariaDB 10.0.7

    Release Notes Changelog

      [Read more...]
    MariaDB & distributions update, Dec 2013
    +1 Vote Up -0Vote Down

    A few things to note recently, amongst MariaDB in distributions. 

  • Ubuntu keeps MySQL 5.5 despite MariaDB’s success. There’s a lot of reasons for this, but remember the key takeaway here is MySQL 5.5 & the fact that MariaDB wasn’t even in Debian yet when the decision was made.
  • MariaDB is now inside of Debian/sid – check out the packages.
  • RHEL 7 comes with MariaDB 5.5 as a default; this is a good thing.
  • Now, from a distribution standpoint, we’re looking at starting to ship

      [Read more...]
    Online Schema Upgrade in MySQL Galera Cluster using RSU Method
    +1 Vote Up -0Vote Down
    December 23, 2013 By Severalnines

    This post is a continuation of our previous post on Online Schema Upgrade in Galera using TOI method. We will now show you how to perform a schema upgrade using the Rolling Schema Upgrade (RSU) method. This requires that the new schema is backward compatible with the old schema, so it requires a bit more planning than the TOI method. In some cases, you might need to turn off any connections to the target node. 


    If you are using non-uniform hardware across your Galera cluster, RSU might be preferable as the more predictable process. RSU does not slow down your

      [Read more...]
    New Webinar: Repair and Recovery for your MySQL, MariaDB and MongoDB/TokuMX Clusters
    +1 Vote Up -0Vote Down
    December 19, 2013 By Severalnines

    Database clusters are pretty sophisticated distributed systems with complex dependencies between nodes. The failure of a node will generally impact the overall cluster, as the remaining nodes need to reconfigure themselves to continue to operate without the failed node. Since re-introducing a node will also affect the existing cluster, the timing could therefore be dependent on the state of the other nodes in the cluster. Repair and restarts often needs to be performed

      [Read more...]
    How to install MySQL 10.0.6-MariaDB and to compile lib_mysqludf_preg on CentOS 6.4
    +0 Vote Up -0Vote Down

    In short, during an optimization or a MySQL query involving a lot of replace(replace(replace…))) I decided to compile PREG as lib_mysqludf_preg from UDF Repository for MySQL in a view to use PCRE functions directly in MySQL.

    Too bad MySQL still cant not use functions for index creation, but this is not the theme of this post.

    So, fist install MariaDB 10.0.6:
    set the MariaDB 10.0.6 repo, I used the ftp mirror at ftp.ulak.net.tr

    root@seik-centos-01:[Wed Dec 18 23:55:12][/tmp]$ cat /etc/yum.repos.d/MariaDB.repo 
    # MariaDB 10.0 CentOS repository list - created 2013-12-18 18:07 UTC
    # http://mariadb.org/mariadb/repositories/
    name = MariaDB
    #baseurl = http://yum.mariadb.org/10.0/centos6-amd64
    baseurl =

      [Read more...]
    Upgrading from MySQL 5.1 to MariaDB 5.5
    +2 Vote Up -0Vote Down

    In my last post, a tale of two MySQL upgrades, a few folks asked if I would outline the process we used to upgrade, and what kind of downtime we had.

    Well, the processes were different for each upgrade, so I will tackle them in separate blog posts. The first step was to upgrade all our MySQL 5.1 machines to MariaDB 5.5. As mentioned in the previous post, MariaDB’s superior performance for subqueries is why we switched – and we switched back to MySQL for 5.6 to take full advantage of the performance_schema.

    It is not difficult to blog about our procedure, as we have documentation on each process. My first tip would be to do that in your own environment. This also enables other folks to help, even if they are sysadmins and not normally DBAs. You may notice the steps

      [Read more...]
    Online Schema Upgrade in MySQL Galera Cluster using TOI Method
    +0 Vote Up -0Vote Down
    December 10, 2013 By Severalnines

    As a follow-up to the Webinar on Zero Downtime Schema Changes in Galera Cluster, we’ll now walk you through the detailed steps on how to update your schema. The two methods (TOI and RSU) have both their pros and cons, and given parameters like table size, indexes, key_buffer_size, disk speed, etc., it is possible to estimate the time taken for the schema to be upgraded. Also, please note that a schema change is non-transactional so it would not be possible to rollback the DDL if it fails midway. Therefore, it is always recommended to test the schema changes and ensure

      [Read more...]
    Old and new MySQL verbosity
    +0 Vote Up -0Vote Down

    I was pleased to see Morgan’s announcement about a fix to an old problem of mine. In March 2012 I complained about MySQL verbosity during installation.

    In MySQL 5.7.3, this behavior was changed. While the default is still as loud as it can, you can now add an option (log_error_verbosity) to send only errors to STDERR, which allows you to hide the output of mysql_install_db, and still get the errors, if they occur.

    Well done!

    However, the same obnoxious verbosity is also in MariaDB 10.0.x. Since I discussed this specific bug with a few MariaDB developers early in 2012, I was disappointed to see this same output when running mysql_install_db with MariaDB.

      [Read more...]
    Dynamic replication filters — our wheel will be square!
    +1 Vote Up -1Vote Down

    This is both hilarious and sad. The new MySQL 5.7 milestone release presents a new feature — replication filters are now dynamic. This is a great and long awaited feature, no doubt about it.

    In short, for years MySQL slaves could filter the incoming stream of replication events based on the database or table name these events were applicable to. These filters were configured using the my.cnf file (or command-line), in particular with the following variables:


    Naturally, users wanted to be able to change the values of these options without having to restart the server. And eventually Davi Arnaut

      [Read more...]
    MariaDB CONNECT Storage Engine access to Oracle 11GR2
    +1 Vote Up -0Vote Down

    MariaDB CONNECT Storage Engine allows to access heterogeneous datasourses. This includes various file formats. But this also includes ODBC accessible datasources The CONNECT Storage Engine ODBC table type allows to access SQLite, Excel, SQL Server or Oracle databases. Some nice features of the ODBC CONNECT table type are: - Auto discovery of table structure. This [...]

    Webinar Replay & Slides: Galera Cluster Best Practices - Zero Downtime Schema Changes
    +4 Vote Up -0Vote Down
    December 5, 2013 By Severalnines


    Thanks to everyone who attended yesterday’s webinar; if you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.


    Thanks again to our speaker, Seppo Jaakola from Codership, the creators of Galera Cluster, for this in-depth talk on Galera Cluster Best Practices - Zero Downtime Schema

      [Read more...]
    High-Availability Openstack on a shoestring budget: Deploying a Minimal 3-node Cluster
    +0 Vote Up -0Vote Down
    December 4, 2013 By Severalnines

    As OpenStack deployments mature from evaluation/development to production environments supporting apps and services, high-availability becomes a key requirement. In a previous post, we showed you how to cluster the database backend - which is central to the operation of OpenStack. In that setup, you would have two controllers, while placing a 3-node Galera cluster on separate hosts. Now, it can be quite a leap to go from one VM with all services running on it, to a fully distributed setup with 5 VMs. The good news is that you can have a highly available setup starting with just 3 VMs.


      [Read more...]
    Previous 30 Newer Entries Showing entries 61 to 90 of 714 Next 30 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.