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

Displaying posts with tag: mariadb (reset)

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 single row size must be
  • InnoDB:
  •   [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...]
    MariaDB Replication, MaxScale and the need for a binlog server
    +2 Vote Up -0Vote Down

    Introduction

    This is an introduction to MariaDB Replication and to why we need a binlogs server and what this is. The first part is an introduction to replication basics, and if you know this already, then you want want to skip past the first section or two.

    MariaDB Replication

    MySQL and MariaDB has a simple but very effective replication system built into it. The replication system is asynchronous and is based on a pull, instead of a push, system. What this means in short is that the Master keeps track of the DML operations and other things that might change the state of the master database and this is stored in what is called the binlog. The slave on the other hand is responsible for getting the relevant information from the master to keep up to speed. The binlogs consist of a number of files that the master generates, and the traditional
      [Read more...]
    Munin graphing of MySQL
    +0 Vote Up -0Vote Down

    While there are many graphing tools out there and we’ve used Munin for a while now.

    The MySQL plugin for Munin had fallen out of date and the show engine innodb status output changed in 5.5 making some bits of the plugin simply not work any more. Also the show global status has some extra variables so there was a need to create new graphs.

    All of these are now in the 2.1.8+ development releases of Munin.

    Here are samples of the new/updated graphs.

    Tables

      [Read more...]
    MaxScale 1.0-beta is out - Happy Birthday MaxScale!
    +2 Vote Up -0Vote Down
    It was a year ago, on a nice Sunday night of the English Summer (apologies for the oxymoron), that Mark Riddoch came to see me and together we headed to the Vansittart Arms, our local family pub round the corner. A pint of London Pride on one side and a Honey Dew on the other were the perfect add-on to Mark’s MacBook Pro, on which Mark was showing me the 0.1 version of MaxScale. It was the result of the joint efforts of Mark’s team, Massimiliano and Vilho, who had worked hard to bring to life the first version of something that I believe will be a natural addition to clusters of  [Read more...]
    ClusterControl Module for Puppet
    +0 Vote Up -0Vote Down
    July 7, 2014 By Severalnines

    If you are automating your infrastructure using Puppet, then this blog is for you. We are glad to announce the availability of a Puppet module for ClusterControl. For those using Chef, we already published Chef cookbooks for Galera Cluster and ClusterControl some time back.  

     

     

    ClusterControl on Puppet Forge

     

    The ClusterControl module initial release is available on Puppet Forge, installing the

      [Read more...]
    [Tuto] A real life Multi-Master use case with MariaDB
    +1 Vote Up -0Vote Down

    The goal of this tutorial is to show you how to use Multi-Master and aggregate databases with the same name but with different data from different masters.

    Example:

    • master1 => a French subsidiary
    • master2 => a British subsidiary

    Both have the same database (PRODUCTION) but the data are totally different:

    We will start with 3 servers (2 masters and 1 slave), you can add more master if needed.

    Informations
    •  10.10.16.231: first master (aka ”’master1”’) => a French subsidiary
    • 10.10.16.232: second master (aka ”’master2”’) => a British subsidiary
    • 10.10.16.233: slave (multi-master) (aka
      [Read more...]
    Compiling & Debugging MariaDB(and MySQL) in Eclipse from scratch - Part 5: "Profiling in Eclipse with OProfile"
    +1 Vote Up -0Vote Down

    Section 6: "Profile a real case"

    6.1 INTRODUCTION

    Profiling & Debugging is an argument that would require an entire book, the aim of this(and the others) posts of this series is to give you the basic knowledge on how to work with these tools and techniques withing Eclipse. For instance if you want to learn to profile with OProfile you should study on the abundant and separate resources, you may start from: http://OProfile.sourceforge.net

    6.2 ABOUT NAMING THE PROJECT

    read more

    New feature in MariaDB 10.1: ANALYZE statement
    +5 Vote Up -1Vote Down

    Last week, yours truly has pushed a new feature into MariaDB 10.1 tree: ANALYZE statement.

    The idea of this feature is to make it easy to compare query plan with query execution. ANALYZE statement will run the statement, and produce EXPLAIN-like output, where optimizer’s estimates are followed by numbers that were observed when running the query. The output looks like this:

    Here,

    • Next to rows there is r_rows column which shows how many records were read from the table.
    • Next to filtered there is r_filtered column which shows which fraction of records was left after the part of the WHERE condition attached to the table was checked.

    I think this should explain the feature. If

      [Read more...]
    Optimizations for derived tables in MySQL 5.6 and MariaDB 5.5+
    +5 Vote Up -1Vote Down

    I had been involved with subquery optimizations fairly closely, but last week I was surprised to find out that MySQL 5.6 does not support derived table merging. This feature was among the subquery features in the abandoned MySQL 6.0. In MariaDB, it was finished and released as part of MariaDB 5.3/5.5. As for MySQL, neither MySQL 5.6, nor MySQL 5.7 has this feature.

    So what is this “derived merge”? It’s simple to understand. When one writes complex queries, it is common to use FROM-clause subqueries as a way to structure the query:

    select
      sum(o_totalprice)
    from
      (select * from orders where o_orderpriority=’1-URGENT’) as high_prio_orders
    where
      o_orderdate between ‘1995-01-01′ and
      [Read more...]
    Debugging MariaDB stored procedures with the SQL Error Log
    +1 Vote Up -0Vote Down

    A very old version of the MySQL site contained a nice header: Speed, Power, Ease of Use. I don’t think that stored programs (routines, triggers, events) were supported, at that time. Now they are, and… developing them is amazingly hard.

    There are many problems, for example the language is not flexible and the execution is sloooow. But the biggest problem is that there is no debug API.

    In details, one of the biggest problems is that, if you have complex procedures (accessing multiple tables, having error handling, and/or calling other procedures) in practice you have no idea of what warnings occur within your procedures.

    MariaDB 10.0 makes things much easier by adding the

      [Read more...]
    Compiling & Debugging MariaDB(and MySQL) in Eclipse from scratch - Part 4: "Profiling in Eclipse - Preparation"
    +0 Vote Up -0Vote Down

    Section 5: "Prepare Eclipse for profiling"

    5.1 INTRODUCTION

    In this part we will prepare Eclipse to profile our recently compiled(see Part 3) MariaDB(or MySQL).
    Profiling means basically measuring where the time is spent by the application.
    You may be interested in knowing how much time is spent in a specific function execution,
    or you may want to know statistics about the dustribution of function calls, that is operating a data aggregation.

    read more

    MariaDB 10.0.12 Overview and Highlights
    +1 Vote Up -0Vote Down

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

    https://downloads.mariadb.org/mariadb/10.0.12/

    This is the third GA release of MariaDB 10.0, and 13th overall release of MariaDB 10.0.

    This is primarily a bug-fix release.

    Here are the main items of note:

  • Updated Spider storage engine to version 3.2.4.
  • Updated Connect engine.
  • Updated pcre to version 8.35.
  • Exists-to-In optimization is now enabled by default.
  •   [Read more...]
    PERFORMANCE_SCHEMA disabled in MariaDB 10.0.12
    +3 Vote Up -2Vote Down

    Astute readers of the release notes for MariaDB 10.0.12 will notice that there is a line that reads: performance_schema is now disabled by default.

    We didn’t come to this decision by accident. Recently at the SkySQL company meeting in Budapest, we did have some time to break out into our usual working teams to talk about our daily operations. Team MariaDB had a debate about PERFORMANCE_SCHEMA and how it was left on by mistake in 10.0 GA as there was a decision to turn it off. Personally, I don’t like introducing such changes in a GA release, and there was no archive of such a discussion, so the next best thing to do was to ask the MariaDB developers and users via a post to both

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

    Download MariaDB 10.0.12

    Release Notes Changelog What is MariaDB 10.0?

    MariaDB APT and YUM Repository Configuration Generator

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

    See the Release Notes and

      [Read more...]
    MyQuery 3.5.5 Released
    +0 Vote Up -0Vote Down
    I have just released version 3.5.5 of MyQuery, which is a minor feature, cleanup and bugfix release. If you don't know MyQuery since before, this is an Open-Source Windows based MySQL and MariaDB ad-hoc query tool. What makes MyQuery slightly different from all the other similar tools is that MyQuery has a focus on SQL-scripting, allowing statements in a script to be run one at the time, to restart a script where it left of in the case of an error and some other features like this. MyQuery features colour coded syntax as it uses Scintilla for editing, and this is highly configurable. Also, multiple editing tabs are supported. Another thing that makes MyQuery stand out a bit is that it is highly flexible. If you have SQL statements that you run often to monitor the state of the server or your application, then it is real easy to implement this  [Read more...]
    MariaDB 5.5.38 Overview and Highlights
    +0 Vote Up -0Vote Down

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

    https://downloads.mariadb.org/mariadb/5.5.38/

    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:

    • Includes all bugfixes and updates from 5.5.38

    read more

    MariaDB 5.5.38 Overview and Highlights
    +1 Vote Up -0Vote Down

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

    https://downloads.mariadb.org/mariadb/5.5.38/

    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...]
    MariaDB Galera Cluster 10.0.11 now available
    +0 Vote Up -0Vote Down

    The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.11. 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.11

    Release Notes

      [Read more...]
    Join Us at the European MariaDB Roadshow this Summer!
    +0 Vote Up -0Vote Down
    June 12, 2014 By Severalnines

    We’re delighted to be joining Team MariaDB at SkySQL with a talk on ‘Automation & Management of Database Clusters’ as they tour across several European regions in the coming weeks.

     

    Whether you’re a MariaDB enthusiast or newbie, a MySQL veteran or newbie, or even a MongoDB user who also happens to run MySQL or MariaDB databases: this roadshow is a good place to find out about the latest developments on the MariaDB database as well as related tools and technologies. 

     

    From our own perspective, we’ll be updating participants on how to

      [Read more...]
    On-disk/block-level encryption for MariaDB
    +3 Vote Up -0Vote Down

    I don’t normally quote The Register, but I was clearing tabs and found this article: 350 DBAs stare blankly when reminded super-users can pinch data. It is an interesting read, telling you that there are many Snowden’s in waiting, possibly even in your organisation. 

    From a MariaDB standpoint, you probably already read that column level encryption as well as block level encryption for some storage engines are likely to come to MariaBD 10.1 via a solution by Eperi. However with some recent breaking news, Google is also likely to do this – see this thread

      [Read more...]
    RHEL7 now with MariaDB
    +3 Vote Up -1Vote Down

    Congratulations to the entire team at Red Hat, for the release of Red Hat Enterprise Linux 7 (RHEL7). The release notes have something important, under Web Servers & Services:

    MariaDB 5.5

    MariaDB is the default implementation of MySQL in Red Hat Enterprise Linux 7. MariaDB is a community-developed fork of the MySQL database project, and provides a replacement for MySQL. MariaDB preserves API and ABI

      [Read more...]
    MariaDB is the default implementation of MySQL in Red Hat Enterprise Linux 7
    +8 Vote Up -2Vote Down

    It was announced that MariaDB is now the default implementation of MySQL in the newly released Red Hat Enterprise Linux 7.

    News of the Red Hat Enterprise Linux 7 can be found here.

    And mention of MariaDB replacing MySQL as the default implementation is referenced in their release notes here.

    The full change log entry reads:

    MariaDB 5.5

    • MariaDB is the default implementation of MySQL in Red Hat Enterprise Linux 7. MariaDB is a community-developed fork of the MySQL database project, and provides a replacement for MySQL. MariaDB preserves API and ABI
      [Read more...]
    MariaDB 5.5.38 now available
    +2 Vote Up -0Vote Down

    The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.38. 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.38

    Release Notes Changelog What is MariaDB

      [Read more...]
    MaxScale 0.7 Feature Highlights
    +2 Vote Up -0Vote Down

    The latest set of updates for MaxScale has just been released, among the highlights of this alpha release are improved Galera support, the introduction of the first phase of the filter API and server maintenance mode.

    Galera Support

    MaxScale has always supported Galera, at least since the earliest downloadable release, now it has the ability to use Galera in a different way.

    read more

    Downloading older releases of MariaDB
    +0 Vote Up -0Vote Down

    MariaDB has plenty of mirrors to download the latest versions of MariaDB. Typically mirrors carry the last couple of releases and the current release, but what if you wanted to access something much older?

    You have two resources for the complete archive:

  • http://archive.mariadb.org/ - this is the official archive, but from what I gather, it can be quite slow
  • http://downloads.skysql.com/files/MariaDB/ - SkySQL provides a complete mirror and it is very fast so I would use this instead. 
  • Current download archives stand at 337GB. But you can feel free to test older releases, see when things got

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