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 121 to 150 of 32955 Next 30 Older Entries
Orchestrator 1.0.5: refactoring masters, multi-master replication
+0 Vote Up -0Vote Down

Outbrain's orchestrator Version 1.0.5 is released.

Quick links: Orchestrator Manual, FAQ, Downloads

Orchestrator now supports refactoring of masters via master-master topologies. It now allows promoting slaves as co-masters and detachment of instances from a co-master topology, effectively allowing for replacing an active master.

Like this

Drag a master:

  [Read more...]
Logs and more logs, who has time to read them ?
+0 Vote Up -0Vote Down
While working on some new features in MariaDB 10.1, I noticed that a normal user couldn't disable the slow query log, which I thought was a bit silly.

While implementing and documenting this feature, I noticed that the information about the different logs is quite spread around and it's not that trivial to find out how to enable/disable the different logs.

To solve this, I created a new MariaDB kb entry, "Overview of the MariaDB logs that I hope MariaDB and MySQL users will be find useful.

Here follows a copy of the kb entry. If you have any comments or things that could be added, please do it in the kb entry so that it will benefit as many as possible!
Overview of MariaDB logsThere are many variables in






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

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

Release Notes Changelog What is MariaDB

  [Read more...]
We’d love to go to Paris for the OpenStack Summit - please vote for our talks!
+0 Vote Up -0Vote Down
August 6, 2014 By Severalnines

 

Well over a thousand sessions have been submitted for the OpenStack Summit and two of them includes our good selves! We’ve submitted two talks with partners of ours: 

 

… and would love it if the talks were included in the final agenda. For that to happen, we need a few

  [Read more...]
How To Use the MySQL Windows Forms Wizard
Employee +1 Vote Up -0Vote Down

MySQL for Visual Studio 1.2 introduces several new features:

  • Web Configuration support for MySQL Personalization Provider.
  • Web Configuration support for MySQL SiteMap Provider.
  • Web Configuration support for MySQL Simple Membership Provider.
  • MySQL ASP.NET MVC Project Wizard.
  • MySQL Windows Forms Project Wizard.

In this post we are going to see the last one, The MySQL Windows Forms Project Wizard, in action.

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...]
    Changes in MySQL 5.6.20
    Employee +1 Vote Up -0Vote Down

    The MySQL Release Notes should be part of any DBA’s regular reading list. The Changes in MySQL 5.6.20 came out last week and there are some interesting goodies.

    • MySQL now includes DTrace support on Oracle Linux 6 or higher with UEK kernel.
    • A new system variable binlog_impossible_mode controls what happens if the server cannot write to the binary log, for example, due to a file error.
    • The mysqlhotcopy utility is now deprecated and will be removed in a future version of MySQL

    5.6.20 has a slew of bug fixes, functionality changes, and notes.

    So why should you be reading the changes on a regular basis? There isa goldmine of information in them. For instance, if you use

      [Read more...]
    New in Percona Replication Manager: Slave resync, Async stop
    +1 Vote Up -0Vote Down

    Percona Replication Manager (PRM) continues to evolve and improve, I want to introduce two new features: Slave resync and Async stop.

    Slave resync

    This behavior is for regular non-gtid replication.  When a master crashes and is no longer available, how do we make sure all the slaves are in a consistent state. It is easy to find the most up to date slave and promote it to be the new master based on the master execution position, the PRM agent already does that but how do we apply the missing transactions to the other slaves.

    In order to solve that problem, I modified a tool originally written by Yelp, that outputs the MD5 sums of the payload (XID boundaries) and the commit positions of a binlog file. It produces an output like:

    root@yves-desktop:/home/yves/src/PRM/percona-pacemaker-agents/tools/prm_binlog_parser# ./prm_binlog_parser.static.x86_64
      [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...]
    #DBHangOps 08/07/14 -- Spatial Indexes, GTID, and more!
    +0 Vote Up -0Vote Down
    #DBHangOps 08/07/14 -- Spatial Indexes, GTID, and more!

    If you missed the hangout, check out the recording below:

    Hello everybody!

    Join us at #DBHangOps this Thursday, August, 07, 2014 at 11:00am pacific (18:00 GMT), to participate in the discussion about:

    • Spatial Indexes with Matt Lord
      • What they are
      • How they work
      • When to use them
    • GTIDs in MariaDB
    • Upcoming InnoDB Data Dictionary changes

    Be sure to check out the #DBHangOps twitter search, the @DBHangOps twitter feed, or this blog post to get a link for the google hangout on Thursday!

    See all of you on Thursday!

    Show notes

    Spatial Indexes

        [Read more...]
      Continuent Tungsten 2.0.3 Release Notification
      +0 Vote Up -0Vote Down
      We are pleased to inform you that the new Continuent Tungsten 2.0.3 is now available. This is a recommended release for all Continuent Tungsten clustering customers as it contains important updates and improvements to the stability of the manager component, specifically with respect to possible stalls and memory usage that would cause manager failures: A number of fixes to the Manager
      Q&A: Putting MySQL Fabric to use
      +1 Vote Up -0Vote Down

      Martin Arrieta and I gave an online presentation last week on “Putting MySQL Fabric To Use.” If you missed it, you can find a recording and the slides here, and the vagrant environment we used plus a transcript of the commands we ran here (be sure to check out the ‘sharding’ branch, as that’s what we used during the webinar).

      Thank you all for attending and asking interesting questions. We were unable to answer all of them in the scheduled time, so here are our replies

        [Read more...]
      MySQL Fabric/MySQL Utilities 1.4.4 released
      Employee +2 Vote Up -0Vote Down

      The binary and source versions of MySQL Utilities/MySQL Fabric have now been made available at http://dev.mysql.com/downloads/utilities/.

      This release contains bug fixes and minor enhancements – full details can be found in the MySQL Fabric/MySQL Utilities release notes.

      Advanced MySQL Query Tuning (Aug. 6) and MySQL 5.6 Performance Schema (Aug. 13) webinars
      +0 Vote Up -0Vote Down

      I will be presenting two webinars in August:

      This Wednesday’s webinar on advanced MySQL query tuning will be focused on tuning the “usual suspects”: queries with “Group By”, “Order By” and subqueries; those query types are usually perform bad in MySQL and add an additional load as MySQL may need to create a temporary table(s) or perform a filesort.

        [Read more...]
      Upgrading MySQL 5.1 to MariaDB 10.0 on CentOS 6
      +0 Vote Up -0Vote Down
      Mon, 2014-08-04 13:00benstillman

      Today we're going to cover how to upgrade MySQL 5.1 to MariaDB 10 on Centos 6 in place. This tutorial is a general outline, and the steps were performed on an out-of-the-box install of MySQL 5.1. Do be careful to check your configuration file(s) when completed.

      Information on variables and other changes:
      http://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html
      http://dev.mysql.com/doc/refman/5.6/en/upgrading-from-previous-series.html



        [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...]
      Handling Error Messages and Warnings with MySQL
      Employee_Team +1 Vote Up -0Vote Down

      To ensure that your MySQL Database works as efficiently as possible, it is important to know how to handle error messages and warnings.

      Error messages have three components:

      • A MySQL-specific error code, such as 1146
      • A SQLSTATE error code. These codes are defined by standard SQL and the ODBC standard.
      • A text message that describes the problem

      MySQL Server generates a warning when it is not fully able to comply with a request or when an action has possibly unintended side effects. You can display these warnings with the SHOW WARNINGS statement.

      To learn about handling error messages and warnings along with other developer topics, consider taking the

        [Read more...]
      Recover Corrupt MySQL Database
      +2 Vote Up -0Vote Down

      The unDROP for InnoDB tool can used to recover corrupt MySQL database. In this post we will show how to repair MySQL database if its files became corrupted and even innodb_force_recovery=6 doesn’t help.

      The corruption of InnoDB tablespace may be caused by many reasons. A dying hard drive can write garbage, thus page checksum will be wrong. InnoDB then reports to the error log:

      InnoDB: Database page corruption on disk or a failed
      InnoDB: file read of page 4.

      MySQL is well know for poor start-up script. A simple upgrade procedure may end up with two mysqld processes writing

        [Read more...]
      Sessions Restore in dbForge Query Builder for MySQL, v3.2!
      +0 Vote Up -0Vote Down

      We are glad to announce that the range of supported servers in Devart dbForge products continues expanding. Now dbForge Query Builder for MySQL, v3.2 supports Percona server and still gives you great opportunities in building queries visually.

      Sessions Restore in dbForge Query Builder for MySQL, v3.2!
      +0 Vote Up -0Vote Down

      We are glad to announce that the range of supported servers in Devart dbForge products continues expanding. Now dbForge Query Builder for MySQL, v3.2 supports Percona server and still gives you great opportunities in building queries visually.

      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...]
      DBD::mysql 4.028 Released
      +1 Vote Up -0Vote Down

      Dear Perl and MySQL community,

      I'm pleased to announce the release of DBD::mysql 4.028. This release includes several fixes, per change log:

      • Fixed bug in mysql.xs where dbh was being used as error code
      • RT #97570: fix wrong salloc free in mysql_st_internal_execute - (Reini Urban, cPanel)
      • Fix RT #97625 use-after-free in mysql_dr_error, and #86153 - (Reini Urban, cPanel)
      • find mysql.h for MariaDB on Win32 (Graham Ollis)
      • Update mysql.pm to work with ipv6 and ipv4 addresses (katyavoid)

      I want to thank Reini Urban, Graham Ollis, and Katyavoid for their pull requests and contributions to DBD::mysql!

      Please feel free to visit:

      CPAN DBD-mysql-4.028

      And as always:

      Github repo

      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...]
      Upgrade MySQL to a new version with a fresh installation & use shell scripts and mysqldump to reload your data
      +0 Vote Up -0Vote Down

      There are several ways to upgrade MySQL (http://mysql.com). In this post, we will use a combination of shell scripts and the mysqldump application to export our MySQL (http://mysql.com) data, and then re-import it back into the upgraded version of MySQL (http://mysql.com).

      In this example, we will be doing a minor version upgrade. We will be going from 5.6.17 to 5.6.19. This method may not work if you are upgrading from one major release to another – from 5.1 to 5.5, or 5.5 to 5.6. You will want to check each version and review the new features/functions and also what features/functions have been deprecated. We are also assuming that no one will be using the database during the time it takes

        [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...]
      New! MySQL Utilities release-1.4.4 GA
      Employee_Team +0 Vote Up -0Vote Down

      The MySQL Utilities Team is pleased to announce the latest GA release of MySQL Utilities, release-1.4.4. This release includes improvements in terms of usability, stability, security and an overall improvement regarding the comprehensibility of the provided error messages.

      Improvements

      The following highlights a few of the more significant improvements.

      • mysqlrpladmin errant transactions for switchover have been improved. Note : The errant transactions check requires all servers in the topology to have GTID’s enabled.
      • Failed MySQL server connection error messages now display the actual error returned from the failed connection.
      • Error messages that occur during automatic slave discovery (–discover-slaves-login) have been improved. Now the –verbose option generates specific information for each slave, including their
        [Read more...]
      OurSQL Episode 195: Common Schema, part 5
      +0 Vote Up -0Vote Down
      PodcastsGeneral

      This week we complete our series on Common Schema by talking about QueryScript. Special guest co-host Jon Day of SkySQL joins us. Ear Candy is some MySQL security tips and At the Movies is a humorous look at value chain mapping.

      Previous 30 Newer Entries Showing entries 121 to 150 of 32955 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.