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 31 to 60 of 807 Next 30 Older Entries

Displaying posts with tag: mariadb (reset)

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
      [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...]
    MariaDB 10 is a Sandbox killjoy?
    +0 Vote Up -0Vote Down

    Using MySQL Sandbox I can install multiple instances of MySQL. It is not uncommon for me to run 5 or 6 instances at once, and in some occasions, I get to have even 10 of them. It is usually not a problem. But today I had an issue while testing MariaDB, for which I needed 5 instances, and I the installation failed after the 4th one. To make sure that the host could run that many servers, I tried installing 10 instances of MySQL 5.6 and 5.7. All at once, for a grand total of 20 instances:

    $ make_multiple_sandbox --how_many_nodes=10 5.6.14
    installing node 1
    installing node 2
    installing node 3
    installing node 4
    installing node 5
    installing node 6
    installing node 7
    installing node 8
    installing node 9
    installing node 10
    group directory installed in










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

    Introduction:

    To run MariaDB from Eclipse we will actually create and install the tar.gz package resulting from compilation(See Part 2) in a separate directory, this will allow us to have MariaDB cleanly installed on a separate location and so it will be also easily possible to run it independently from Eclipse.

    In these Blog posts series we assume:

    
    yoda							as developer user
     

    read more

    MariaDB 10.0.11 Overview and Highlights
    +5 Vote Up -0Vote Down

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

    https://downloads.mariadb.org/mariadb/10.0.11/

    This is the second GA release of MariaDB 10.0, and 12th overall release of MariaDB 10.0.

    This is primarily a bug-fix release.

    Here are the main items of note:

  • Updated TokuDB engine to version 7.1.6
  • Updated Spider storage engine to version 3.2 (now Gamma)
  • Updated XtraDB storage engine to version 5.6.17-65.0
  • Updated InnoDB storage engine to version 5.6.17
  • Updated
  •   [Read more...]
    Compiling & Debugging MariaDB(and MySQL) in Eclipse from scratch - Part 2: "Compile in Eclipse"
    +2 Vote Up -0Vote Down

    Section 2: "COMPILE MARIADB IN ECLIPSE"



    2.1 Download and prepare sources folder

    We will need a directory to use as our playground, if you create the user yoda in Section 1:

    $ su - yoda
    $ mkdir -p ~/playground

    Download latest MariaDB 10 sources tar.gz and copy the archive into the above directory, you can latest sources from:

    read more

    MariaDB moves development to Github
    +0 Vote Up -0Vote Down

    Today marks a milestone in terms of the MariaDB project – going forward, the MariaDB project plans to use Github and git for source code management. The migration happens from Launchpad and the bzr tool.

    The 10.1 server development (under heavy development now) will happen on Github. You can check it out here: https://github.com/MariaDB/server. Feel free to watch, star or even fork the code, and send us contributions!

    Previous maria-captains should now provide their Github IDs so that they can be accorded similar status. Send the IDs to the maria-developers mailing list.

    The project eventually wants to move the 10.0, 5.5, 5.3, 5.2, and

      [Read more...]
    Compiling & Debugging MariaDB(and MySQL) in Eclipse from scratch - Part 1: "Setup the building environment"
    +0 Vote Up -0Vote Down
    This guide will help you in compiling and debugging MariaDB (MySQL, Percona) within the Eclipse IDE on Linux and using cmake for source project preparation. It will be split in parts to keep each post lightweight and with a finite objective. At the end of reading this series of blog posts you should be able to:
  • Prepare for compilation any MariaDB (MySQL, Percona) source release based on cmake framework.
  • read more

    Previous 30 Newer Entries Showing entries 31 to 60 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.