Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 61 to 70 of 33112 10 Older Entries
WEBINAR: MariaDB + Red Hat: How Persistence Pays Off For OpenStack And You!
+0 Vote Up -0Vote Down
Fri, 2014-09-05 19:57Marc Sherwood

We all know that persistence is a virtue. But with databases, persistence is everything! Thats why Red Hat and MariaDB have teamed up to embed MariaDB at the heart of OpenStack.

Sign up now for your seat at the webinar!

Tuesday, September 9 at 15:00 UTC
(8am Los Angeles, 11am New York, 5pm Paris)

The power of MariaDB, coupled with highly-available Galera multi-master, synchronous, clustering is an unbeatable foundation on which to build OpenStack. That’s why Red Hat Enterprise Linux OpenStack Platform leverages MariaDB and Galera as a building-block for all of its

  [Read more...]
Percona XtraDB Cluster 5.5.39-25.11 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the new release of Percona XtraDB Cluster 5.5 on September 5th 2014. Binaries are available from downloads area or from our software repositories.

Based on Percona Server 5.5.39-36.0 including all the bug fixes in it, Galera Replicator

  [Read more...]
Proposed changes to user management in MySQL 5.7
Employee +4 Vote Up -0Vote Down

In May we proposed deprecating and removing the old password format in MySQL 5.7. I am happy to report, that this proposal has gone ahead, and can already be seen in the 5.7 DMR5 release notes!

With old passwords removed, and with recent versions of MySQL also offering new options for authenticating to MySQL, today I wanted to write about three additional proposed changes that follow suit:

  • Deprecate the PASSWORD() function

    As we already support multiple authentication methods (and may desire additional in the future), calling the PASSWORD() function to generate a password hash has a strange user experience.

    What I mean by this, is that PASSWORD() is

  •   [Read more...]
    Selective Restore of InnoDB Tables with MySQL Enterprise Backup 3.11
    Employee +1 Vote Up -0Vote Down


    Sometimes the best way to repair data issues and problems within a MySQL database is to restore only some of the tables from a backup. For example, suppose that some data was accidentally deleted from one table due to a software error, then the easiest way to recover the lost data might be to restore only one table from a backup. Previously this kind of partial restore was not supported by MySQL Enterprise Backup (MEB). However, MEB 3.11 introduces support for selective restore from backups created with the --use-tts option (or TTS backups).

    TTS backups are backups that are created with the transportable tablespaces

      [Read more...]
    Using MySQL 5.6 Global Transaction IDs (GTIDs) in production: Q&A
    +1 Vote Up -0Vote Down

    Thank you to all of you who attended my webinar last week about Global Transaction IDs (GTIDs), which were introduced in MySQL 5.6 to make the reconfiguration of replication straightforward. If you missed my webinar, you can still listen to the recording and download the sides (free). We had a lot of questions during the webinar, so let me try to answer them here. Please let me know in the comments if additional

      [Read more...]
    Better Performance for JOINs Not Using Indexes
    Employee_Team +1 Vote Up -0Vote Down

    In some cases it is not possible to use an index to optimize a JOIN. This may for example happen when you query the Performance Schema. As a result these kind of queries can be very slow; however in MySQL 5.6 and later you can use a trick to improve the performance considerably.

    As a working example in this post, I will use the schema_table_statistics view in the sys schema. Since the view involves the schema, I will create a reasonable large number of databases and tables for the test:

    shell$ for ((i=0; i<100; i++)); do
    >    echo "Database ${i}"
    >    mysql -e "CREATE DATABASE db${i}"
    >    for ((j=0; j<100; j++)); do
    >        mysql -e "CREATE TABLE
      [Read more...]
    Tracing down a problem, finding sloppy code
    +0 Vote Up -0Vote Down

    Daniel was tracking down what appeared to be a networking problem….

    • server reported 113 (No route to host)
    • However, an strace did not reveal the networking stack ever returning that.
    • On the other side, IP packets were actually received.
    • When confronted with mysteries like this, I get suspicious – mainly of (fellow) programmers.
    • I suggested a grep through the source code, which revealed  return -EHOSTUNREACH;
    • Mystery solved, which allowed us to find what was actually going on.


  • Don’t just believe or presume the supposed origin of an error.
  • Programmers often take shortcuts that cause grief later. I fully appreciate how the above code came about, but I still think it was wrong. Mapping a
  •   [Read more...]
    Replicating from MySQL to Amazon Redshift
    +0 Vote Up -1Vote Down
    Continuent is delighted to announce an exciting Continuent Tungsten feature addition for MySQL users: replication in real-time from MySQL into Amazon RedShift.   In this webinar-on-demand we survey Continuent Tungsten capabilities for data warehouse loading, then zero in on practical details of setting up replication from MySQL into RedShift.  We cover: Introduction to real-time movement
    MySQL Proxy 0.8
    +3 Vote Up -0Vote Down
    MySQL Proxy 0.8 (0.8.5 alpha, published on Friday, 05 Sep 2014)
    Storage Engine Vendors Meeting
    Employee +2 Vote Up -0Vote Down

    In keeping with a MySQL tradition, we will be holding a storage engine vendors meeting to coincide with MySQL Central @ Open World this year.

    The day and venue is TBD, but will be in the San Francisco/Bay Area week of 29th September - October 3rd.

    For an invitation, please send me an email!

    10 Newer Entries Showing entries 61 to 70 of 33112 10 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.