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

Displaying posts with tag: Technical (reset)

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:


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

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


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

Compiling & Debugging MariaDB(and MySQL) in Eclipse from scratch - Part 2: "Compile in Eclipse"
+2 Vote Up -0Vote Down


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

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

    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

    Resolving Error 1918, System Error Code 126, When Installing MySQL ODBC Driver
    +0 Vote Up -0Vote Down

    If you are installing MySQL ODBC Driver and encounter the following error:

    Error 1918. Error installing ODBC driver MySQL ODBC 5.1 Driver, 
    ODBC error 13: The setup routines for the MySQL ODBC 5.1 Driver 
    could not be loaded due to system error code 126: 
    The specified module could not be found. 
    ...\myodbc5S.dll).. Verify...

    Then you will need to install the Microsoft Visual C++ 2010 Redistributable Package (select the appropriate one for your OS architecture below):

    64-bit version:

    read more

    Improve your Stored Procedure Error Handling with GET DIAGNOSTICS
    +0 Vote Up -0Vote Down

    In a previous post, I discussed debugging stored procedures with RESIGNAL, which is of great value when troubleshooting errors raised by your stored procedures, functions, triggers, and events as of MySQL/MariaDB 5.5.

    However, as of MySQL 5.6 and MariaDB 10.0, there is GET DIAGNOSTICS, which can be used to get the exact error details as well.

    RESIGNAL just outputs the error, as it comes from the server, for instance:

    ERROR 1146 (42S02): Table 'db1.t1' doesn't exist

    read more

    Quickly Debugging Stored Procedures, Functions, Triggers, and Events with RESIGNAL
    +0 Vote Up -0Vote Down

    I was recently debugging a stored procedure and could not easily identify the underlying reason for why it was failing.

    It had a standard exit handler catch-all for SQLEXCEPTION, which was:

    SELECT ...;

    When there was an error, it didn't really output anything useful.

    As of MySQL 5.5, there is RESIGNAL:

    "RESIGNAL passes on the error condition information that is available during execution of a condition handler within a compound statement inside a stored procedure or function, trigger, or event."

    read more

    MariaDB 10 GTID Explained
    +1 Vote Up -0Vote Down

    MariaDB replication in general works as follows: on a master server, all updates to the database are written into the binary log as binlog events, a slave server connects to the master and reads the binlog events and applies the events locally to replicate the same changes as done on the master. A server can be both a master and a slave at the same time, it is thus possible for binlog events to replicated through multiple levels of servers.

    read more

    InnoDB Primary Key versus Secondary Index: An Interesting Lesson from EXPLAIN
    +1 Vote Up -0Vote Down

    I ran into an interesting issue today, while examining some EXPLAIN outputs, and wanted to share the findings, as some of this is undocumented.

    Basically, you can start with a very simple InnoDB table - 2 INT columns, Primary Key (PK) on the 1st column, regular index on the 2nd:

    CREATE TABLE `t1` (
      `id1` int(10) unsigned NOT NULL,
      `id2` int(10) unsigned DEFAULT NULL,
      PRIMARY KEY (`id1`),
      KEY `id2` (`id2`)
    ) ENGINE=InnoDB;

    The query is:

    SELECT id1 FROM t1;

    This is a straight-forward query with no WHERE clause.

    read more

    MySQL to MariaDB migration: handling privilege table differences when using mysqldump
    +0 Vote Up -0Vote Down

    Migrating from MySQL to MariaDB is generally a straightforward procedure: you can shut down MySQL, install MariaDB, and start it up with a very good chance of success. When upgrading/crossgrading/migrating from one release of MySQL or MariaDB to another, it is important to run mysql_upgrade. The same is true when migrating from MySQL to MariaDB, in part because MariaDB has some different definitions for certain privilege tables. This means that the structures of the MySQL tables are not valid for MariaDB, a problem easily fixed by mysql_upgrade, unless you are trying to import an SQL dump from MySQL that creates tables using the old-style structures and tries to interact with them before it is possible to run mysql_upgrade. Let's take a look at why this is a problem and how to solve

      [Read more...]
    MariaDB 10.0.8 Overview and Highlights
    +3 Vote Up -2Vote Down

    MariaDB 10.0.8 was recently released as RC ("Release Candidate"), and is available for download here:


    This is the first RC release of MariaDB 10.0. It is primarily a bug-fix and polishing release, and all features planned for MariaDB 10.0 GA are included in this release.

    There were 6 notable changes in MariaDB 10.0.8:

  • InnoDB upgraded to version 5.6.14
  • read more

    MaxScale - We'd Love to Know Your Thoughts
    +0 Vote Up -0Vote Down

    As you've heard, MaxScale was recently released, and we'd love for you to try it out and let us know your thoughts.

    Anders Karlsson and Ivan Zoratti have written some excellent posts on downloading and setting it up, so if you're intersted in that, please see their respective posts for quick, detailed instructions.

    read more

    MaxScale - Do we need another MySQL proxy?
    +2 Vote Up -0Vote Down

    I have spent some time thinking about and working on a project that went public on GitHub at the beginning of this year. That project is called MaxScale and is primarily a proxy server for MySQL/MariaDB databases, although it can be something much more than this. The obvious and often asked question is why do we need another proxy? I want to try to give you a flavor for what MaxScale is and why I think there is a need for a tool like MaxScale.

    The architecture of MaxScale makes it different from your average proxy

    • MaxScale has awareness of the content it is shipping.

    read more

    Activating Auditing for MariaDB and MySQL in 5 Minutes
    +0 Vote Up -0Vote Down

    Do you want to learn more about the MariaDB Audit-Plugin? Join Ralf Gebhardt on 5.12.2013 for his live webcast: http://www.skysql.com/why-skysql/webinars/mariadb-audit-plugin-overview


    read more

    High Availability for Drupal Part 1 - Investigating the Issues
    +0 Vote Up -0Vote Down

    Drupal is one of the most popular Content Management Systems (CMS) and is used increasingly in high-visibility sites, such as www.whitehouse.gov. This has brought a lot of attention on how to get the most performance out of Drupal and how to improve the availability of such sites. In this blog series I'll take you through the basics and on through to designing your own HA Drupal site.

    But first, we need to understand what the challenges are in getting Drupal (or indeed any CMS) working on multiple servers in such a way as to ensure high availability and performance.

    read more

    Google Docs sharing and its cloudy usability
    +0 Vote Up -0Vote Down

    Background: SkySQL is a distributed company. Nearly all of us work from home. To be productive, we need to emulate the best aspects of collaborating as if we were working next to one another. Given that nearly all of us had worked under similar distributed conditions at MySQL AB, we knew what we were getting into when we were founded. Obviously, we wanted to learn from our past experiences when making our choices for tools and processes.

    read more

    How Galera does Rolling Schema Upgrade, really
    +3 Vote Up -1Vote Down

    This post is about a fairly technical detail of how Galera works. I'm writing it down in preparation for testing this feature so that I can agree with Alex whether to file a bug or not. I'm sharing it on my blog just in case someone else might benefit from learning this.

    Galera 2.0 introduces rolling schema upgrades. This is a new way to do non-blocking schema changes in MySQL.

    As the name suggests, it is done as a rolling upgrade. Having seen clusters doing rolling upgrades before, I assumed this is what happens:

    • Execute alter table on Node 1.
    • Node 1 is removed from the cluster and stops processing transactions.
    • Node 1 completes alter table.
    • Node 1 re-joins cluster and catches up so that it is in sync.

    read more

    Now available: Slides from Percona Live and Linuxcon Europe
    +0 Vote Up -1Vote Down

    The slides from last week’s talks I (co-)presented at Percona Live and Linuxcon Europe are now available from our web site.

      [Read more...]
    LINBIT Technical Guides now available on our web site
    +2 Vote Up -1Vote Down

    If you run (or plan to deploy) high availability clusters — with or without DRBD — you might find a new section on our web site handy. Our Technical Guides collection is a compilation of LINBIT expert HA knowledge, which we’re opening up to everyone.

    Yes, this also includes PDF versions of the DRBD User’s Guide and the Linux-HA User’s Guide.

    More Technical Guides will be added as we go along. LINBIT Cluster Stack support customers will receive new Tech Guides approximately

      [Read more...]
    10 Steps: MySQL Monitoring through Nagios: Install & Configure
    +2 Vote Up -0Vote Down
    Nagios is a powerful monitoring system and here we will learn how to monitor MySQL through Nagios. We will be installing Nagios, required plugins and configuring it to monitor MySQL Database Server. Let’s unleash the power step by step: Installing and configuring Nagios Step-1 : Install required stuff: yum install httpd yum install gcc yum […]
    DRBD != fsck != DIX
    +1 Vote Up -0Vote Down

    Every once in a while, we hear of users with corruption in a file system that sits on top of DRBD. That may be easy or tricky to resolve. If you’re lucky, a simple fsck will resolve the corruption. If you’re not quite that lucky, you may have to get out your backups.

    But that’s typically not DRBD’s fault. Typically not at all, not in the least bit. DRBD is a block device, and as such it has no idea what rests on top of it. It has no concept of a filesystem, let alone its integrity. That of course is true for any other block device as well. If you have, say, RAID-1, and something corrupts the file system on top of it, then of course that corruption will be happily replicated across both component devices. DRBD is no different, except that its component devices are stored across distinct physical nodes.

    And even if everything about your filesystem

      [Read more...]
    LinuxTag presentation now available for download
    +0 Vote Up -0Vote Down

    A live recording of my LinuxTag 2010 presentation entitled Storage Done Right: Building a Resilient, Distributed, Highly Available Open Source iSCSI SAN is now available from our web site. If you want to find out how to build a complete SAN from 100% open source, do take a look!

    I do apologize for the less-than-optimal sound quality. I did the recording myself with my laptop mike, so unfortunately there’s quite a bit of clipping in the audio track. I hope my ramblings are still somewhat audible.

      [Read more...]
    In case you haven’t noticed, we no longer manage clusters with XML
    +0 Vote Up -0Vote Down

    While Yves presents a valid approach for managing NDB with Pacemaker and the anything Linux-HA resource agent (a generic wrapper for any daemon based application), the XML configuration shown is likely to have people running away screaming. This is how we had to do things back in the Heartbeat 2 days, which meant that as a cluster admin you would permanently run around with a loaded cocked shotgun with the muzzle pressed firmly against your foot.

    Those days are long gone. Please don’t do this anymore. You also no longer need to use the low-level tools such as cibadmin or crm_attribute.

      [Read more...]
    MySQL related file types and basic information
    +0 Vote Up -0Vote Down
    This post covers the basic information of files that MySQL Server uses / creates for various tasks. my.cnf : It is the main configuration file for MySQL. You may find it under base directory in windows or under /etc/. .sock : mysqld creates a socket for programs to connect to and notes in this file. […]
    SQL syntax with /*! c-style comments in MySQLdump
    +1 Vote Up -0Vote Down
    In mysql we have — , /* and /*! comments.  This post is mainly about very basic c-style comments. /*! : C-Style comments in MySQL We normally see comments in MySQLdump as follows: /*!40000 ALTER TABLE `a` DISABLE KEYS */; Or /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ These are actually C-Style comments which has embeded […]
    Ideas for select all columns but one mysql stored procedure
    +0 Vote Up -0Vote Down
    Assume we’ve a table with 100 rows and we need to select all columns but one. The problem is headache of actually typing out all 99 required columns!! Solutions / Ideas to above problem are: Ignorance is bliss. Select all(*) and ignore the column. Manually type column names or manage it with copy paste! Create […]
    5 useful MySQL Command Options-pager-prompt-rehash-tee-system
    +0 Vote Up -0Vote Down
    There are set of commands that MySQL itself interprets. You may use “help” or “\h” at the mysql> prompt to list them. Below are the 5 most useful MySQL Command Options. 1. \# OR rehash: Enable automatic rehashing. Do you have long table names, you find it difficult to remember tablenames or you’re just as […]
    MyDumpSplitter-Extract tables from mysqldump | MySQL dump splitter – shell script
    +2 Vote Up -0Vote Down
    A lot of articles have been written on splitting mysqldump (mysql dump splitter) and grab required tables. Long back when Shlomi had suggested a “sed” way, I actually shell scripted it, and now publishing. This shell script will be grabbing the tables you want and pass it to tablename.sql. It’s capable to understand regular expressions […]
    Stored procedure to add-remove prefix by rename table mysql
    +1 Vote Up -0Vote Down
    Here is one more procedure – (this time) for mass renaming of table. Adding and Removing table-name prefixes A friend of mine was renaming 100+ tables by using replace methods in notepad. I showed em a bit better editor: Editplus and then I thought of rescue rest of those who are still interested in some […]
    Showing entries 1 to 30 of 66 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.