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 810 Next 30 Older Entries

Displaying posts with tag: mariadb (reset)

Moving On
+0 Vote Up -0Vote Down
I have a difficult task of making this post interesting, helpful and personal at the same time. I think the main goal is to balance these aspects, and I really appreciate your comments and suggestions that I will add here.For the busy readers who may be put off by the length of this post, here is a very short summary: I spent 4 wonderful years, first as the head of Field Services, then as a CTO, I believe it is now time for a change, so I am leaving SkySQL. I am leaving behind a great company and very good friends, but I am not disappearing completely, and I will continue supporting the work I started and the projects I created with the help of such great people.For many, leaving a company is not easy, and it is extremely difficult if you have contributed to its creation and development since the beginning. Even more difficult is to depart  [Read more...]
How to Manage All Your MySQL or MariaDB Databases
+0 Vote Up -0Vote Down
September 1, 2014 By Severalnines

According to Forrester, a DBA in a large enterprise manages between 8 and 275 databases, with the industry average being 40 databases to a DBA. Larger databases usually require extra effort around tuning, backup, recovery and upgrade. Cloud, as well as automation and management tools can help improve the number of databases managed by one DBA.  

 

With that background, we were pretty excited to introduce support for management of single-instance MySQL and MariaDB databases in

  [Read more...]
Resources for Database Clusters: Performance Tuning for HAProxy, Support for MariaDB 10, Technical Blogs & More
+0 Vote Up -0Vote Down
August 28, 2014 By Severalnines

Check Out Our Latest Resources for MySQL, MariaDB & MongoDB Clusters

 

Here is a summary of resources & tools that we’ve made available to you in the past weeks. If you have any questions on these, feel free to contact us!

 

New Technical Webinars

 

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