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 中文
Showing entries 1 to 30 of 807 Next 30 Older Entries

Displaying posts with tag: mariadb (reset)

9 Tips for Going in Production with Galera Cluster for MySQL
+0 Vote Up -0Vote Down
August 25, 2014 By Severalnines

Are you going in production with Galera Cluster for MySQL? Here are 9 tips to consider before going live. These are applicable to all 3 Galera versions (Codership, Percona XtraDB Cluster and MariaDB Galera Cluster). 

 

1. Galera strengths and weaknesses

 

There are multiple types of replication and cluster technologies for MySQL, make sure you understand how Galera works so you set the right expectations.

  [Read more...]
MariaDB Galera Cluster 5.5.39 now available
+1 Vote Up -0Vote Down

Download MariaDB Galera Cluster 5.5.39

Release Notes Changelog What is MariaDB Galera Cluster?

MariaDB APT and YUM Repository Configuration Generator

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.39. This is a Stable (GA) release.

See the

  [Read more...]
Automation & Management of MariaDB Galera Clusters: New European Webinars with SkySQL - The MariaDB Company
+0 Vote Up -0Vote Down
August 21, 2014 By Severalnines

MariaDB Galera Cluster involves more effort and resource to administer than standalone MariaDB systems. If you would like to learn how to better manage your MariaDB cluster, then this webinar series is for you. 

 

We will give you practical advice on how to introduce clusters into your MariaDB / MySQL  environment, automate deployment and make it easier for operational staff to manage and monitor the cluster using ClusterControl.

 

Language, Date & Time: 

 

English - Tuesday, September 30th @ 11am CEST:

  [Read more...]
How to Install ClusterControl on Servers without Internet Access
+0 Vote Up -0Vote Down
August 18, 2014 By Severalnines

There are several ways to get ClusterControl installed on your database infrastructure, as described in the ClusterControl Quick Start Guide. One simple way is to use an installation script, install-cc.sh. This script automates the whole process, and is executed on the host where you want to install ClusterControl. By default, it assumes the host has internet connectivity during the installation process.

 

For users who are not able to have their

  [Read more...]
We’re Hiring! And Looking to Add More 9s to the Severalnines Team!
+1 Vote Up -0Vote Down
August 15, 2014 By Severalnines

 

 

We're looking for an energetic and talented web developer to join our small but agile web team. This position is full-time and pay is negotiable. The hours are flexible and work can be done remotely.

 

Severalnines is a self-funded startup with a dozen employees; headquartered in Stockholm, Sweden and with a globally distributed, home-office based team. We provide automation and

  [Read more...]
Script to manage MaxScale
+1 Vote Up -0Vote Down
MaxScale 1.0 from SkySQL is now in Beta and there are some cool features in it, I guess some adventurous people has already put it into production. There are still some rough edges and stuff to be fixed, but it is clearly close to GA. One thing missing though are something to manage starting and stopping MaxScale in a somewhat controlled way, which is what this blog is all about.

I have developed two simple scripts that should help you manage MaxScale in a reasonable way, but before we go into the actual scripts, there are a few things I need to tell you. To begin with, if you haven't yet downloaded MaxScale 1.0 beta, you can get it from MariaDB.com, just go to Resources->MaxScale and to get to the downloads you first need to register (which is free). Here are downloads to

  [Read more...]
New Webinar: Performance Tuning of HAProxy for Database Load Balancing
+1 Vote Up -0Vote Down
August 13, 2014 By Severalnines

 

New Webinar: Performance Tuning of HAProxy for Database Load Balancing

As a follow-up to our previous webinar on MySQL Load Balancing and HAProxy, we are glad to organize a new webinar on Performance Tuning of HAProxy. Tuning your HAProxy instances can significantly increase the performance of your application and decrease response times. Joint us for this special session to find out more!   [Read more...]
MariaDB 10.0.13 Overview and Highlights
+0 Vote Up -0Vote Down

MariaDB 10.0.13 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10.0.13/

This is the fourth GA release of MariaDB 10.0, and 14th overall release of MariaDB 10.0.

This is primarily a bug-fix release.

Here are the main items of note:

  • InnoDB upgraded to 5.6.19.
  • XtraDB upgraded to
  •   [Read more...]
    Clustering Moodle on Multiple Servers for High Availability and Scalability
    +0 Vote Up -0Vote Down
    August 12, 2014 By Severalnines

    Moodle is an open-source e-learning platform (aka Learning Management System) that is widely adopted by educational institutions to create and administer online courses. For larger student bodies and higher volumes of instruction, moodle must be robust enough to serve thousands of learners, administrators, content builders and instructors simultaneously. Availability and scalability are key requirements as moodle becomes a critical application for course providers. In this blog, we will show you how to deploy and cluster moodle/web, database and file-system components on multiple servers to achieve both high availability and scalability. 

      [Read more...]
    MySQLNoSQLCloud 2014 – Edition #3
    +0 Vote Up -0Vote Down

    I’ve enjoyed visiting Buenos Aires once a year for the MySQLNoSQLCloud event, put together by the awesome people at Binlogic (in particular, their proprietor Santiago Lertora). It’s happening again in 2014, which by my count is the third edition, and there’s a twist: Buenos Aires on 13 & 14 November, and Cordoba on 17 November. It’s never been held in Cordoba before (like an annex event), so I think this could be extremely exciting.

    If you’re looking to speak, send Santiago a note at events@binlogic.com (or leave a message here). I’ll put you in touch with him. If you’re looking to sponsor, you get attendees from all over Latin

      [Read more...]
    How-to and Performance Impact of SSL-Encrypted Replication Traffic in Galera Cluster for MySQL
    +0 Vote Up -0Vote Down
    August 7, 2014 By Severalnines

     

    Deploying Galera Clusters across WAN environments might lead to concerns around data privacy and security - especially as more organisations are having to comply with national and international regulations. You would not want hackers eavesdropping or intercepting replication traffic. Encrypted replication hides what is sent between the Galera nodes, and makes sure each node is only communicating to the ones it trusts. But how expensive is encryption?

     

    In this blog, we will show you how to encrypt the replication traffic between your Galera nodes. We will also look into the performance impact of this

      [Read more...]
    MariaDB 10.0 upgrade goes smoothly
    +0 Vote Up -0Vote Down

    I have been meaning to update some systems to MariaDB 10.0 and finally had a bit of time to get around to that.  The documentation of specifics of what’s needed to go from MariaDB 5.5 to 10.0 can be found here and while it’s not very long it seems there’s little to actually do.

    Having already upgraded some servers from MySQL 5.5 to 5.6 the process and appropriate configuration changes were very similar so all in all a rather non event.

    One thing which is always a concern if systems can not be down for long is the time to do the upgrade. While you see many blog posts talking about taking a backup via mysqldump and then loading it all back this is not really an option on many systems I manage and a replacement

      [Read more...]
    An Updated Description of Clustering Keys for TokuDB
    +0 Vote Up -0Vote Down

    Covering indexes can result in orders of magnitude performance improvements for queries. Bradley’s presentation on covering indexes describes what a covering index is, how it can effect performance, and why it works. However, the definition of a covering index can get cumbersome since MySQL limits the number of columns in a key to 16 (32 on MariaDB).

    Tokutek introduced multiple clustering indexes into MySQL to address these problems. Zardosht describes the multiple clustering indexes feature and how clustering indexes differ from covering indexes. Zardosht

      [Read more...]
    MariaDB 5.5.39 Overview and Highlights
    +0 Vote Up -0Vote Down

    MariaDB 5.5.39 was recently released (it is the latest MariaDB 5.5), and is available for download here:

    https://downloads.mariadb.org/mariadb/5.5.39/

    This is a maintenance release, and so there are not too many big changes of note, just a number of normal bug fixes. However, there are a few items worth mentioning:

      [Read more...]
    MySQL 5.6.20 Overview and Highlights
    +0 Vote Up -0Vote Down

    MySQL 5.6.20 was recently released (it is the latest MySQL 5.6, is GA), and is available for download here.

    For this release, there is 1 “Security Fix”, 1 “InnoDB Important Change”, and 7 “Functionality Added or Changed” fixes, all of which should be read in case they might affect you (though for this release, these mostly appear to be minor – some [default] changes, build notes/changes, and deprecations):

  • Security Fix: The linked OpenSSL library for the MySQL 5.6 Commercial Server has been updated from version 1.0.1g to version 1.0.1h. Versions of OpenSSL prior to and including 1.0.1g are reported to be vulnerable to CVE-2014-0224. This
  •   [Read more...]
    Percona Live London Call for Presentations
    +0 Vote Up -0Vote Down

    Europe traditionally doesn’t have many MySQL-dedicated conferences, which is why I personally enjoy Percona Live London, now in its 2014 Edition. This year it happens November 3-4, and the call for presentations is still open — till August 17th.

    The topic list is growing as the MySQL ecosystem matures: DevOps, cloud, security, case studies and what’s new are things you don’t often see. Tutorials are also welcome, of course.

    Location-wise, London can’t be beat. And happening at Gloucester Road, you’re on the District/Circle/Picadilly lines to go to many

      [Read more...]
    What is HandlerSocket? And why would you use it? Part 1
    +0 Vote Up -0Vote Down
    HandlerSocket is included with MariaDB and acts like a simple NoSQL interface to InnoDB, XtraDB and Spider and I will describe it a bit more in this and a few upcoming blogs.

    So, what is HandlerSocket? Adam Donnison wrote a great blog on how to get started with it, but if you are developing MariaDB applications using C, C++, PHP or Java what good does HandlerSocket do you?

    HandlerSocket in itself is a MariaDB plugin, of a type that is not that common as is is a daemon plugin. Adam shows in his blog how to enable it and install it, so I will not cover that here. Instead I will describe what it does, and doesn't do.

    A daemon plugin is a process that runs





      [Read more...]
    MariaDB and Stored Procedures: errata & repository
    +1 Vote Up -0Vote Down

    In the article How MariaDB makes Stored Procedures usable I explained how to use the MariaDB CONNECT Storage Engine to workaround Stored Procedures limitations. Please read that article, if you didn’t, for details.

    Since the technique to workaround such limitations is verbose and error-proof, I also proposed a procedure which makes it easy and convenient. Even thought this is a simple country blog, I have immediately received positive feedback after that article. But then, people started to write me: “Hey, doesn’t work!”. The reason is… MariaDB/MySQL bugs. While investigating these problems, I was able to report

      [Read more...]
    Troubleshooting TokuDB Corruption
    +1 Vote Up -0Vote Down

    I recently ran across some TokuDB table corruption, which was not easily identifiable at first, and the error log entry was not too verbose either, so I wanted to share that experience here.

    Basically, TokuDB crashed, and then mysqld had problems restarting afterward. Just for reference, the error log had the following in the stack trace:

    /usr/lib64/mysql/plugin/ha_tokudb.so(+0x71c48)[0x7fb25be75c48]
    /usr/lib64/mysql/plugin/ha_tokudb.so(+0x71cbd)[0x7fb25be75cbd]
    /usr/lib64/mysql/plugin/ha_tokudb.so(_Z29toku_deserialize_bp_from_disk...
    /usr/lib64/mysql/plugin/ha_tokudb.so(_Z23toku_ftnode_pf_callback...
    /usr/lib64/mysql/plugin/ha_tokudb.so(_Z30toku_cachetable_pf_pinned_pair..
    /usr/lib64/mysql/plugin/ha_tokudb.so(_Z24toku_ft_flush_some_child...
    /usr/lib64/mysql/plugin/ha_tokudb.so(_Z28toku_ftnode_cleaner_callback...
      [Read more...]
    Troubleshooting TokuDB ERROR 1126 – API Version Mismatch or bitmap_free
    +1 Vote Up -0Vote Down

    When setting up TokuDB, you may encounter error 1126.

    I’ve seen 2 recent invocations of it, so I wanted to share them both here in case you run into this issue:

    MariaDB [(none)]> install soname 'ha_tokudb';
    ERROR 1126 (HY000): Can't open shared library
    '/usr/lib/mysql/plugin/ha_tokudb.so' (errno: 2, undefined symbol: bitmap_free)
    MariaDB [(none)]> install soname 'ha_tokudb';
    ERROR 1126 (HY000): Can't open shared library 'ha_tokudb.so'
    (errno: 8, API version for STORAGE ENGINE plugin TokuDB not
    supported by this version of the server)
    

    The latter is a bit more descriptive, but the former is fairly cryptic.

    Given the latter, as you may have guessed it, if you run into either of these, you have the wrong version of ha_tokudb.so in your plugin directory – that is, it is not the correct version

      [Read more...]
    Disabling Transparent Hugepages for TokuDB
    +0 Vote Up -0Vote Down

    If you want to use TokuDB with MariaDB, MySQL, or Percona Server, you will need to disable support for transparent hugepages in Linux.

    Fortunately, this is very easy to check, and to change.

    An easy way to check is with:

    cat /sys/kernel/mm/transparent_hugepage/enabled

    This will return something like:

    [always] madvise never

    Note the word surrounded by “[]” is what this option is set to. So the above is set to “always”. To disable it, we want it set to “never”.

    I’ve found the easiest way to change/set this is to add the below to your /etc/rc.local file (and then reboot your system):

    if test -f /sys/kernel/mm/transparent_hugepage/enabled; then
       echo never >
      [Read more...]
    Enabling TokuDB in MariaDB is a Breeze
    +0 Vote Up -0Vote Down

    TokuDB is gaining more and more popularity and many people are finding it very helpful for certain cases.

    Using/enabling it in some distributions can be quite a pain, but enabling it in MariaDB is easy as 1-2-…, well, only 1-2, since that’s all there is to it!

    1. Ensure you have the correct MariaDB version:

    • MariaDB 5.5.36+
    • MariaDB 10.0.9+
    • Note: Linux 64-bit systems only – specific packages include: Ubuntu, Debian, Fedora, CentOS, Red Hat
    • Note: If using the Linux tarball – it must be the version built with glibc 2.14+

    2. Run this command:

    INSTALL SONAME 'ha_tokudb';

    or update my.cnf file with:

    [mysqld]
    plugin-load=ha_tokudb

    There is one requirement from

      [Read more...]
    MySQL 5.5.39 Overview and Highlights
    +1 Vote Up -0Vote Down

    MySQL 5.5.39 was recently released (it is the latest MySQL 5.5, is GA), and is available for download here:

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

    This release, similar to the last 5.5 release, is mostly uneventful.

    There were two “Functionality Added or Changed” and 24 bugs fixed.

    The “Functionality Added or Changed” changes are:

    • CMake support was updated to handle CMake version 3.
    • The timed_mutexes system variable has no effect and is deprecated.

    Out of the 24 bugs, most seemed rather minor or obscure, but here are the ones I think are worth noting (crashing, security, wrong results, deadlock):

    • InnoDB: Opening a parent table that has thousands of child tables could
      [Read more...]
    MariaDB: Selective binary logs events
    +0 Vote Up -0Vote Down

    In the first post in a series on MariaDB features we find interesting, we begin with selectively skipping replication of binlog events. This feature is available on MariaDB 5.5 and 10.

    By default when using MySQL’s standard replication, all events are logged in the binary log and those binary log events are replicated to all slaves (it’s possible to filter out some schema). But with this feature, it’s also possible to bypass some events to be replicated on the slave(s) even if they are written in the binary log. Having those event in the binary logs is always useful for point-in-time recovery.

    Indeed, usually when we need to not replicate an

      [Read more...]
    Galera Cluster using GTID: MySQL vs. MariaDB
    +0 Vote Up -0Vote Down

    Using GTID to attach an asynchronous Slave sounds promising. Lets have a look at the two existing GTID implementations and their integration with Galera.

    GTID@MariaDB

    There is one GTID used by the cluster and every node increments the common seqno by itself. This works well as long all transactions are replicated by Galera (simplified InnoDB). Because Galera takes care of the Commit Order of the transactions on all nodes. So having identical GTID/seqno from the start there are no problems.

      node1> show global variables like 'gtid_binlog_pos';
      +-----------------+---------+
      | Variable_name   | Value   |
      +-----------------+---------+
      | gtid_binlog_pos | 0-1-504 |
      +-----------------+---------+
    
      node2> show global variables like 'gtid_binlog_pos';
      +-----------------+---------+
      |
      [Read more...]
    MariadB Galera: Attaching an asynchronous Slave using GTID
    +0 Vote Up -0Vote Down

    Galera the synchronous Master-Master replication is quite popular. It is used by Percona XtraDB Cluster, MariaDB Galera Cluster and even patched MySQL binaries exist. Quite often you want to add a slave to a Galera Cluster. This is going to work quite well. All you need is at least configure log_bin, log_slave_updates and server_id on the designated Masters and attach your Slave.

    GTID@MariaDB

    Even you can use traditional (non GTID) replication. Using non GTID replication is a hassle. As you need to search for the right offset on the new Master to attach your Slave on.

    Using GTID promises to be easier. As you simply switch to the new Master and the replication framework finds the new position based on the GTiD automatically.

    As a fact we have two GTID


      [Read more...]
    How MariaDB makes Stored Procedures usable
    +4 Vote Up -0Vote Down

    I already wrote how MariaDB makes the debug of stored procedures much easier via the SQL Error Log. But I recently found out that MariaDB provides a usable workaround for some big limitations of their procedural SQL.

    First, SELECT is not the only SQL statement which returns a resultset. Other examples are DELETE RETURNING, CALL, SHOW, EXPLAIN and administrative commands like ANALYZE TABLE or CHECK TABLE. But these commands cannot be used in place of SELECT in the following contexts:

    • Subqueries, derived tables, JOINs,

      [Read more...]
    Announcing ClusterControl Support for MariaDB 10
    +0 Vote Up -0Vote Down
    July 22, 2014 By Severalnines

    We just wanted to make it official: Severalnines ClusterControl now supports MariaDB 10!

     

    As most of you know will know by now, MariaDB 10 is the newest and most advanced version of the popular MariaDB relational database system. Whilst remaining application-compatible with the MySQL database, it adds many new capabilities to address the most challenging web and enterprise application use cases. Cluster deployments would be based on MariaDB Galera Cluster 10, which is a complete merge of MariaDB 10.0.12 and Galera Cluster. 

     

    ClusterControl for MariaDB Clusters

     

      [Read more...]
    MariaDB 10.1.0 Overview and Highlights
    +0 Vote Up -0Vote Down

    MariaDB 10.1.0 was recently released, and is available for download here:

    https://downloads.mariadb.org/mariadb/10.1.0/

    This is the first alpha release of MariaDB 10.1, so there are a lot of new changes and functionalities added, which cover a wide variety of areas such as: Performance, InnoDB/XtraDB, WebScaleSQL, Optimizer, Security, Storage Engine functionality, & Administration Improvements.

    These are 9 of the most notable changes in MariaDB 10.1.0 (but do check out the release notes and changelogs below for the full list of changes):

  • InnoDB: Allow > 16K pages on InnoDB – InnoDB now allows page size to be configured as 16K, 32K and 64K. Note that
  •   [Read more...]
    Priority queue optimization for filesort is now visible in MariaDB 10.0
    +1 Vote Up -0Vote Down

    TL;DR: Priority queue optimization for filesort with small LIMIT is now visible in MariaDB: there is a status variable and you can also see it in the slow query log (KB page link).

    A longer variant:
    One of the new optimizations in MySQL 5.6 is ability to use a priority queue instead of sorting for ORDER BY … LIMIT queries. The optimization was ported into MariaDB 10.0 long ago, but we still get questions if/when it will be ported. I guess, the reason for this is that, besides the query speed, you can’t see this optimization. Neither EXPLAIN, nor EXPLAIN FORMAT=JSON or PERFORMANCE_SCHEMA or status variables give any indication whether filesort used priority queue or the regular quicksort+merge algorithm.

    MySQL 5.6 has


      [Read more...]
    Showing entries 1 to 30 of 807 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.