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

Displaying posts with tag: mariadb (reset)

How to Setup Centralized Authentication of ClusterControl Users with LDAP
+0 Vote Up -0Vote Down
April 24, 2014 By Severalnines

ClusterControl 1.2.6 introduces integration with Active Directory and LDAP authentication. This allows users to log into ClusterControl by using their corporate credentials instead of a separate password. LDAP groups can be mapped onto ClusterControl user groups to apply roles to the entire group, so it is very convenient for larger organizations who have a centralized LDAP-compliant authentication system. This blog shows you how to configure LDAP authentication in ClusterControl, and allow users to use their Active Directory or LDAP username and password to log in to ClusterControl. 

  [Read more...]
MariaDB 10.0.10 uploaded to Debian experimental
+1 Vote Up -0Vote Down

If you’re watching the NEW queue, you’ll notice that MariaDB 10.0.10 has been uploaded targeting Debian/experimental. Package description, and to think the bug was only opened on April 2nd – pretty quick turnaround.

Related posts:

  • MariaDB in Debian unstable
  • Debian releases Lenny, MySQL 5.1 soon
  • MariaDB in Gentoo; updates for Solaris/Debian SPARC
  • MariaDB 5.5.37 Overview and Highlights
    +0 Vote Up -0Vote Down

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


    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

    Ubuntu 14.04 – some MySQL ecosystem notes
    +1 Vote Up -0Vote Down

    Following my previous post on the launch, I just rolled Ubuntu 14.04 LTS on an Amazon EC2 t1.micro instance (not something you expect to run a database server on, for sure – 1 vCPU, 0.613GiB RAM). If you do an apt-cache search mysql you get 435 return result sets with the default configuration (trusty: main & universe).

    If you do apt-get install mysql-server, you get MySQL 5.5. You enter the password of choice, and before you know it, MySQL is installed (a SELECT VERSION() will return 5.5.35-1ubuntu1).

    Next you decide to install MariaDB. I run an apt-get install mariadb-server. It pulls in libjemalloc (for TokuDB) and I expect future releases to ship this engine by default. You enter the password, and

      [Read more...]
    MySQL Community Awards: Community Contributor of the Year 2014
    +1 Vote Up -0Vote Down

    As one decompresses from the active month that April brings to the MySQL ecosystem, its worth noting that I received a MySQL Community Award – Community Contributor of the Year 2014 award at the Percona Live MySQL Conference & Expo 2014 in Santa Clara. I was extremely happy and thankful to receive such an award and I still am. Thank you MySQL Community.

    My reason for winning, now immortalised:

    Colin’s list of service to the MySQL Community goes back almost 10

      [Read more...]
    ClusterControl 1.2.6 Released
    +0 Vote Up -0Vote Down
    April 22, 2014 By Severalnines

    The Severalnines team is pleased to announce the release of ClusterControl 1.2.6. This release contains key new features along with performance improvements and bug fixes. We have outlined some of the key features below. 

    Highlights of ClusterControl 1.2.6 include:

    • Centralized Authentication using LDAP or Active Directory
    • Role-Based Access Control 
    • OpenStack: Galera Deployment Automation
    • Hybrid setups with Galera and Asynchronous MySQL Replication
    • Manage multiple Galera Clusters with single Controller
      [Read more...]
    MariaDB Galera Cluster 10.0.10 now available
    +0 Vote Up -0Vote Down

    The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.10. This is a Beta release.

    See the Release Notes and Changelog for detailed information on this release and the What is MariaDB Galera Cluster? page in the MariaDB Knowledge Base for general information about MariaDB Galera Cluster.

    Download MariaDB Galera Cluster 10.0.10

    Release Notes

      [Read more...]
    If you use MySQL in the Amazon cloud, you need to ask yourself this question
    +0 Vote Up -0Vote Down
    Join 25,000 others and follow Sean Hull on twitter @hullsean. Are you serious about backups? If you’re just using Amazon EBS snapshots, that may not be sufficient. There’s a good chance it won’t protect you against your next data loss. That’s why I like to have a few different types of backups Also: 5 more […]
    Congratulations Ubuntu, for the wide choice!
    +1 Vote Up -0Vote Down

    Inspired by Yngve Svendsen’s post, I too think it makes absolute sense to congratulate Ubuntu on the 14.04 LTS release (some server notes - MySQL has a section dedicated to it). Ubuntu users have a lot of server choice today (that’s from all major MySQL ecosystem vendors):

    • MySQL 5.5.35 ships in main. It is the default MySQL. Oracle has committed to providing updates to 5.5 throughout the LTS release cycle of Ubuntu (which is longer than the planned EOL for 5.5). This is why the grant of a
      [Read more...]
    SSL and MariaDB/MySQL
    +1 Vote Up -0Vote Down

    With the recent Heartbleed bug, people are clearly more interested in their MariaDB/MySQL running with SSL and if they have problems. First up, you should read the advisory notes: MariaDB, Percona Server (blog), and MySQL (blog).

    Next, when you install MariaDB (or a variant) you are usually dynamically linked to the OpenSSL library that the system provides. Typically on startup

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

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

    See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 5.5? page in the MariaDB Knowledge Base for general information about the MariaDB 5.5 series.

    Download MariaDB 5.5.37

    Release Notes Changelog What is MariaDB

      [Read more...]
    Dotdeb repository problems with MariaDB 5.5 (solution)
    +0 Vote Up -0Vote Down

    Dotdeb is a repository currently targeting Debian and Ubuntu, providing a nice set of packages for LAMP servers.

    Recently, MySQL 5.6 was added to the dotdeb repository. On the surface, this is a very harmless addition. MariaDB is a replacement for MySQL and it should be possible for applications designed for MySQL to easily switch to MariaDB. Therefore MariaDB also includes the libraries that applications using MySQL depend upon, such as libmysqlclient18 and mysql-common. The dpkg package manager looks at the MySQL 5.6 packages in dotdeb and assumes that 5.6 is a higher version than 5.5, which results in it removing or replacing libraries during normal apt-get installation and upgrade procedures.

    The problems appear in the following scenarios:

      [Read more...]
    Korean MySQL Power User Group
    +1 Vote Up -0Vote Down

    If you are a MySQL power user in Korea, its well worth joining the Korean MySQL Power User Group. This is a group led by senior DBAs at many Korean companies. From what I gather, there is experience there using MySQL, MariaDB, Percona Server and Galera Cluster (many on various 5.5, some on 5.6, and quite a few testing 10.0). No one is using WebScaleSQL (yet?). The discussion group is rather active, and I’ve got a profile there (I get questions translated for me).

    This is just a natural evolution of the DBA Dinners that were held once every quarter. Organised by OSS Korea, and

      [Read more...]
    Amazon EC2 Linux AMIs
    +1 Vote Up -0Vote Down

    If you use Amazon Elastic Compute Cloud (EC2), you are always given choices of AMIs (by default; there are plenty of other AMIs available for your base-os): Amazon Linux AMI, Red Hat Enterprise Linux, SUSE Enterprise Server and Ubuntu. In terms of cost, the Amazon Linux AMI is the cheapest, followed by SUSE then RHEL. 

    I use EC2 a lot for testing, and recently had to pay a “RHEL tax” as I needed to run a RHEL environment. For most uses I’m sure you can be satisfied by the Amazon Linux AMI. The last numbers suggest Amazon Linux is #2 in terms of usage on EC2.

    Anyway, recently Amazon Linux AMI came out with the 2014.03 release (see release

      [Read more...]
    Heartbleed OpenSSL Bug: Impact on ClusterControl Users & Recommendations on How to Protect your Systems
    +0 Vote Up -0Vote Down
    April 10, 2014 By Severalnines


    In the wake of recent concerns and debates raised around the Heartbleed bug, we wanted to update Severalnines ClusterControl users on any impact this bug might have on ClusterControl & associated databases and/or applications.




    If your ClusterControl's web application has been accessible on the internet, then most likely you have also been exposed to the Heartbleed OpenSSL security bug, see: http://heartbleed.com for more details. 

    By default, our database deployment script enables SSL encryption for the

      [Read more...]
    Book in Korean: Real MariaDB
    +1 Vote Up -0Vote Down

    For some months now, there have been some back & forth emails with Matt, one of the senior DBAs behind the popular messaging service, KakaoTalk (yes, they are powered by MariaDB). Today I got some positive information: the book published entirely in the Korean language, titled Real MariaDB is now available.

    It covers MariaDB 10.0. Where appropriate, there are also notes on MySQL 5.6 (especially with regards to differences). This is Matt’s fourth MySQL-related book, and

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

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


    This is the first GA ("Generally Availability", aka "recommended for production systems") release of MariaDB 10.0, and 11th overall release of MariaDB 10.0.

    Since this is the initial 10.0 GA release, this is primarily a bug-fix and polishing release.

    Here are the main items of note:

    read more

    MariaDB 10.0 reference card: plugins in packages
    +0 Vote Up -0Vote Down

    MariaDB 10.0 comes with ~50 engines and plugins; and it comes in 35 package sets (34 binary ones and a source tarball).

    Every day people come asking on #maria IRC whether a package X contains an engine Y, or saying that it doesn’t, or wondering if it should. Remembering all combinations isn’t easy, and it became impractical to study build logs or package contents every time, so I ended up with a cheat sheet for 10.0.10 GA. At the very least it should help me to answer those questions; even better if somebody else finds it useful.

    The tables below refer to contents of packages provided at downloads.mariadb.org or at MariaDB repository mirrors. Packages built by distributions might have different contents and are not covered here.


    — built-in (also known as static):
    the plugin comes as a part of the server binary. It

      [Read more...]
    When the Innovator's Dilemma hit the MySQL World
    +2 Vote Up -5Vote Down
    What’s the connection between databases and fruit flies?
    Some of you may be familiar with the bestseller in business literature The Innovator's Dilemma: When New Technologies Cause Great Firms to Fail, by Harvard professor Clayton Christensen. In his book, Prof. Christensen compared disk drives to fruit flies. The comparison relates to the rapid changes that disrupted the disk drive industry for decades. That disruption is compared to the rapid changes that take place to fruit flies that live only for few hours, and for this reason researchers can study and analyse their behaviour.

    In the software business, you can replace disk drives with databases. Obviously, databases live longer than fruit flies, but it is an industry that sometimes shows schizophrenic changes. Whilst it is true that relational databases have being dominated the

      [Read more...]
    Compile at CentOS 6.5 the new MySQL webscalesql-5.6.17 branch by Facebook, Google, LinkedIn, and Twitter
    +1 Vote Up -0Vote Down


    yeah , big buzz around that one :)

    So I decided to check the install process:

    1. Clone the repo from

    root@webscalesql-5.6.clean:[Mon Mar 31 11:37:11][~]$ cd /opt/
    root@webscalesql-5.6.clean:[Mon Mar 31 11:37:15][/opt]$ mkdir installs
    root@webscalesql-5.6.clean:[Mon Mar 31 11:37:17][/opt]$ cd installs/
    root@webscalesql-5.6.clean:[Mon Mar 31 11:37:19][/opt/installs]$ git clone https://github.com/webscalesql/webscalesql-5.6.git
    Initialized empty Git repository in /opt/installs/webscalesql-5.6/.git/
    remote: Counting objects: 30397, done.
    remote: Compressing objects: 100% (12678/12678), done.
    remote: Total 30397 (delta 18716), reused
      [Read more...]
    The MariaDB Foundation Announces General Availability of MariaDB 10
    +3 Vote Up -0Vote Down

    Best MariaDB ever hits the streets – MariaDB 10 innovations developed with Google, SkySQL & Fusion-IO

    London, United Kingdom – 31 March 2014 – The MariaDB Foundation, an independent body which promotes the popular open source database MariaDB, today announced the much-anticipated general availability of MariaDB 10, providing today’s generation of application developers with enhanced performance and functionality.

    Since its launch in 2009, MariaDB has built an active and vibrant open source community and has led the way in database innovation. In 2013, Wikimedia Foundation, the people behind Wikipedia, announced the migration of many of its production MySQL systems over to MariaDB and Google confirmed it aims to move its thousand-plus MySQL instances over to MariaDB technology.

      [Read more...]
    How to Migrate Your Application to Amazon Virtual Private Cloud without Downtime
    +0 Vote Up -0Vote Down
    March 27, 2014 By Severalnines

    With datacenters being stretched by resource-intensive applications, more and more businesses are outgrowing their existing in-house capacity and having to reconfigure their IT operations. But how do you migrate a busy application to a totally new data center without downtime? How will the application scale in a virtualized cloud environment? And how do you guard against cloud server failures and keep a high level of uptime?



    In this example, we will show you how to migrate a Web application (Wordpress) from a local data center to a AWS VPC. Without downtime even! 


    Main steps:

        [Read more...]
      innodb_flush_logs_on_trx_commit and Galera Cluster
      +0 Vote Up -0Vote Down

      We deploy Galera Cluster (in MariaDB) for some clients, and innodb_flush_logs_on_trx_commit is one of the settings we’ve been playing with. The options according to the manual:

      • =0 don’t write or flush at commit, write and flush once per second
      • =1 write and flush at trx commit
      • =2 write log, but only flush once per second

      The flush (fsync) refers to the mechanism the filesystem uses to try and guarantee that written data is actually on the physical medium/device and not just in a buffer (of course cached RAID controllers, SANs and other devices use some different logic there, but it’s definitely written beyond the OS space).

      In a non-cluster setup, you’d always want it to be =1 in order to be ACID compliant and that’s also InnoDB’s default. So far so good. For cluster setups,

        [Read more...]
      Merging 5.6 test cases and thoughts on feature deprecation in MariaDB 10.0
      +1 Vote Up -0Vote Down

      MariaDB 10 is nearing GA, and it makes sense to make sure that the test suite from MySQL 5.6 is merged into MariaDB 10. Svoj is doing a lot of this work, and then we like to look at features, especially ones that are deprecated upstream. We don’t do that on blogs, but on the maria-developers mailing list.

      I bring to your attention: Intermediate status for test cases merge. We see that INSERT DELAYED and SHOW PROFILE for example are deprecated in MySQL 5.6. The only way for feedback to the MySQL team seems to be comments on Morgan’s blog. However with MariaDB, especially with the feedback plugin enabled, we

        [Read more...]
      Install MySQL fork MariaDB 10.0.9 on CentOS release 6.5 with server_audit-1.1.5 and oqgraph-engine
      +0 Vote Up -0Vote Down

      I needed to test the new server audit plug-in on latest MariaDB 10.0.9
      More info about that handy plug in you may find here : http://www.skysql.com/downloads/mariadb-audit-plugin
      Take a moment to read the info, along with that nice blog : http://www.skysql.com/blogs/ralf-gebhardt/activating-auditing-mariadb-and-mysql-5-minutes

      In short:

      root@mariadb-10.0.9:[Mon Mar 24 07:51:54][/tmp/]$ lftp http://ftp.igh.cnrs.fr/pub/mariadb/mariadb-10.0.9/yum/
      cd ok, cwd=/pub/mariadb/mariadb-10.0.9/yum                                   
      lftp ftp.igh.cnrs.fr:/pub/mariadb/mariadb-10.0.9/yum> bookmark add mariadb-10.0.9

        [Read more...]
      [MySQL][Spider][VP]Spider-3.2 VP-1.1 released
      +0 Vote Up -0Vote Down
      I'm pleased to announce the release of Spider storage engine version 3.2(rc) and Vertical Partitioning storage engine version 1.1(beta).
      Spider is a Storage Engine for database sharding.
      Vertical Partitioning is a Storage Engine for vertical partitioning for a table.

      Please use the following for downloading binary file.

      The main changes in this version are following.
      - Add server parameter "spider_log_result_error_with_sql", "spider_version", "spider_internal_xa_id_type", "spider_casual_read", "spider_dry_access" and "spider_delete_all_rows_type".
      - Add table parameter

        [Read more...]
      MariaDB Eventually Consistent?
      +0 Vote Up -0Vote Down

      Eventual consistency is a consistency model used in many large distributed databases which requires that all changes to a replicated piece of data eventually reach all affected replicas; conflict resolution is not handled and responsibility is pushed up to the application author in the event of conflicting updates [13].

      Eventual consistency is a specific form of weak consistency; the storage system guarantees that if no new updates are made to the object, eventually all accesses will return the last updated value [14]. If no failures occur, the maximum size of the inconsistency window can be determined based on factors such as communication delays, the load on the system, and the number of replicas involved in the replication scheme [3].

      A few examples of eventually consistent systems:

      • DNS
      • Asynchronous master/slave replication on an RDBMS e.g.
        [Read more...]
      Clustering SugarCRM with MySQL Galera for High Availability and Performance
      +1 Vote Up -0Vote Down
      March 20, 2014 By Severalnines

      SugarCRM is the leader in open source CRM systems, and has been adopted by some of the largest firms, including IBM. The CRM software includes all sales, marketing and support tools out of the box, and can also be extended to integrate social media sources. For those depending on SugarCRM, especially when deploying in cloud environments with lower SLAs, having a high availability architecture can make a lot of sense. 

      In this blog post, we will show you how to cluster SugarCRM Community Edition

        [Read more...]
      Installing MariaDB Galera Cluster on Debian/Ubuntu
      +1 Vote Up -0Vote Down

      A MariaDB Howto authored by: Erkan Yanar.

      This is a Howto about installing MariaDB Galera Cluster on Debian/Ubuntu. Because a lot of people were having problems installing MariaDB Galera Cluster, elenst from #maria on freenode forced me to write this Howto

      Installing MariaDB Galera Cluster is in fact quite easy and actually kind of boring in the end. This Howto is written for (and tested on) on Debian 7.1 (Wheezy) and Ubuntu 12.04 (Precise).

      What we need

      In our setup we assume 3 nodes (node01, node02, node03) with one interface each. We assume following IP addresses:,, and We need three packages installed on all nodes:

      • rsync
      • galera
      • mariadb-galera-server

      As Galera

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

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


      This is the second RC (“Release Candidate”) release of MariaDB 10.0, and 10th overall release of 10.0. All features planned for MariaDB 10.0 GA are included in this release.

      There were 6 notable changes in MariaDB 10.0.9:

    • InnoDB upgraded to version 5.6.15
    • Extended-keys optimization is now enabled by default.
    • MariaDB can be compiled to use the system’s PCRE library.
    • Added MASTER_GTID_WAIT() and
    •   [Read more...]
      Showing entries 1 to 30 of 725 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.