Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 61 to 70 of 863 10 Older Entries

Displaying posts with tag: Uncategorized (reset)

Colorado MySQL Meetup Group November 11th
Employee +2 Vote Up -0Vote Down

The Colorado MySQL meetup is getting together on November 11th.

Location: Oracle 500 Eldorado Boulevard, Broomfield, CO

All MySQL users and interested parties are invited to participate and attend the following activities! 

Monday, November 11, 2013

From 6:00PM to 8:30PM

  • Oracle Broomfield Office
    Building 1 – Demo 1127 Conference Room
    500 Eldorado Blvd
    Broomfield, CO 80021

    Schedule:
    6PM Meet, Greet, and Eat
    6:30-45 – Intro’s/Updates
    6:45-7:30 – Session 1 – MySQL 5.6 and Cluster Update – Lee Stigile, Oracle
    7:30-8:15 – Session 2 – MySQL and Hadoop Integration – Dave Smelker, ADURANT Technologies
    8:15-8:30 – Closing
    For further information, please contact:
    George Trujillo
    Email: [masked]
    Cell: [masked]













  [Read more...]
A chance for Cassandra Storage Engine
+2 Vote Up -1Vote Down

Short version: It looks like DataStax has released an official C++ driver for their new CQL native protocol. This makes it possible to update MariaDB’s Cassandra Storage Engine to work with all column families in Cassandra 1.2 and up.

Long version: In case the above didn’t make any sense to you, here’s some background:

  • Cassandra Storage Engine was developed against Cassandra 1.1
  • Cassandra 1.1 had a client-server protocol based on Thrift API. It had a number of limitations, the most important was lack of support for streaming. These translated into limitations in Cassandra storage engine, for example, I could not support secondary indexes.
  • Cassandra 1.2 was released in February, and it had
  [Read more...]
Luxbet, MariaDB and Melbourne Cup
+0 Vote Up -0Vote Down

Yesterday was Melbourne Cup day in Australia – the biggest annual horse race event in the country, and in the state of Victoria it’s even a public holiday.

Open Query does work for Luxbet (part of Tabcorp), and Melbourne Cup day is by far their biggest day of the year in terms of traffic. It’s not just a big spike, there’s orders of magnitude difference so you can really say that the rest of the year is downright quiet (in relative terms). So, a very interesting load pattern.

Since last year Luxbet has upgraded from stock MySQL to MariaDB, and with our input made some other infrastructure modifications including moving to a pure solid state storage (FusionIO) solution as a SAN just won’t deliver the resilience and performance required. This

  [Read more...]
MySQL yum repositories
Employee_Team +14 Vote Up -0Vote Down

I think most people will agree that downloading RPMs from a website is kind of old fashioned when there are yum repos. After a number of user requests, we have now launched the official yum repos for MySQL.

Can’t wait? Neither can I. On a fresh install:

  • Download a setup package for your distribution from http://dev.mysql.com/downloads/repo
  • yum localinstall mysql-community-release-distro-release.noarch.rpm
  • yum update
  • yum install mysql-community-server
  • This works for fresh installs. If you’re upgrading from an older version, read about upgrading first.

    What’s in the repo?


      [Read more...]
    MySQL 5.6: no testcases for non-crashing bugs, either (and an incomplete bugfix)
    +5 Vote Up -2Vote Down

    I normally don’t write such posts, but this time I’ll do a little whining. I was looking at MySQL’s Bug#69581, which was also filed against MariaDB as MDEV-5102. With some effort (little for this particular bug), one can find out that Bug#69581’s counterpart in Oracle’s internal bug database is Bug#16862316, and the fix is in revision 5366 in MySQL 5.6.14.

    There are two problems, though:

    • The fix doesn’t include a testcase. We know, Oracle doesn’t publish testcases for crashing bugs, with a justification that it’s for security reasons. However, this bug is not a crashing
      [Read more...]
    Studying for the New MySQL 5.6 DBA Exam
    Employee +1 Vote Up -0Vote Down

    I have have been receiving a lot of questions about the new MySQL 5.6 DBA exam. Sadly I can not answer a lot of the questions until after my exam in early November. However I do know some good things about the new exams.

    First — No True or False questions. Oracle has set the standards on that policy and I had to update the ol’ 5.0 exams to make certain there the T/F questions were removed. Why is this important? Don’t you have a fifty/fifty chance on T/F questions? The trouble is that some of these questions were a wee bit tricky and needed parsing plus a full understanding of the subject to get them right. For fairness, it is easy to do without the T/F questions.

    Second — No more pick up to N answers. Once again, for fairness.

    Third — One exam for the certification. In the past the

      [Read more...]
    EXPLAIN UPDATE/DELETE/INSERT in MySQL and MariaDB
    +1 Vote Up -0Vote Down

    MySQL 5.6 added support for EXPLAIN INSERT/UPDATE/DELETE. MySQL 5.7 made some improvements to EXPLAIN code. Also, 5.7 added support for EXPLAIN FOR CONNECTION, which looks very similar to MariaDB’s SHOW EXPLAIN. I was working on putting EXPLAIN INSERT/UPDATE/DELETE into MariaDB 10.0, so I’ve dug up some details and thought I’d share them:

    EXPLAIN UPDATE/DELETE

    EXPLAIN UPDATE looks like regular EXPLAIN SELECT:

    MySQL [dbt3sf1]> explain update orders set o_orderpriority='1-URGENT' where o_orderDATE='1998-07-21';
    +----+-------------+--------+-------+---------------+---------------+---------+-------+------+-------------+
    | id | select_type | table  | type  | possible_keys | key           | key_len | ref   | rows | Extra       |
    +----+-------------+--------+-------+---------------+---------------+---------+-------+------+-------------+
    |  1 | SIMPLE      | orders | range |
      [Read more...]
    MEM 3.0: Getting started
    Employee +1 Vote Up -0Vote Down

    Time to install MEM 3.0, and get its built-in agent working.

    [ If you want some tips on What's New, have a look here. ]

    I’ve downloaded the Monitor Server and the agent zipped s/w for Linux & Win from http://edelivery.oracle.com:

    mysqlmonitor-3.0.0.2887-linux-x86-installer.bin
    mysqlmonitoragent-3.0.0.2887-linux-glibc2.3-x86-32bit-installer.bin
    mysqlmonitoragent-3.0.0.2887-windows-installer.exe
    

    The Monitor install

    So, on my Oracle Linux machine:

    ./mysqlmonitor-3.0.0.2887-linux-x86-installer.bin

    It all installs fine. No issues, if you’re used to MEM 2.3.

    Double check your configuration_report.txt :

    MySQL
      [Read more...]
    MEM 3.0: Getting started
    Employee +0 Vote Up -0Vote Down

    Time to install MEM 3.0, and get its built-in agent working.

    [ If you want some tips on What's New, have a look here. ]

    I’ve downloaded the Monitor Server and the agent zipped s/w for Linux & Win from http://edelivery.oracle.com:

    mysqlmonitor-3.0.0.2887-linux-x86-installer.bin
    mysqlmonitoragent-3.0.0.2887-linux-glibc2.3-x86-32bit-installer.bin
    mysqlmonitoragent-3.0.0.2887-windows-installer.exe
    

    The Monitor install

    So, on my Oracle Linux machine:

    ./mysqlmonitor-3.0.0.2887-linux-x86-installer.bin

    It all installs fine. No issues, if you’re used to MEM 2.3.

    Double check your configuration_report.txt :

    MySQL
      [Read more...]
    MySQL Tech Tour @Barcelona, 7th Nov.
    Employee +0 Vote Up -0Vote Down

    We’re on the move again. Come and join us on the 7th of November at the Oracle office in Barcelona. Find out more details about what was announced at MySQL Connect, as well as what’s next…

    For more information about this event please visit the link below:

    http://www.oracle.com/us/dm/29173-emeafm13045970mpp010-oem-2020763-es.html


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