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

Displaying posts with tag: connect (reset)

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...]
How MariaDB makes Stored Procedures usable
+4 Vote Up -0Vote Down

I already wrote how MariaDB makes the debug of stored procedures much easier via the SQL Error Log. But I recently found out that MariaDB provides a usable workaround for some big limitations of their procedural SQL.

First, SELECT is not the only SQL statement which returns a resultset. Other examples are DELETE RETURNING, CALL, SHOW, EXPLAIN and administrative commands like ANALYZE TABLE or CHECK TABLE. But these commands cannot be used in place of SELECT in the following contexts:

  • Subqueries, derived tables, JOINs,

  [Read more...]
Crunching XML files with MariaDB
+0 Vote Up -0Vote Down

In January I wrote my first post about node.js and MariaDB . In February I continued with a second post about using jQuery and some GIS calculations. Now it is time for the third and this time the main focus is not so much on GIS functionality, but instead on the capabilities MariaDB has for handling piles of unstructured data. In this case I’ll be focusing on crunching a pile of XML files without importing the XML data itself.

MariaDB 10.0, which had its GA launch in early April, includes the Connect engine. It has been developed to dynamically access all kinds of data sources,

  [Read more...]
MySQL Connect @ OpenWorld Call for Proposals Open
Employee_Team +3 Vote Up -0Vote Down

We announced yesterday that the call for proposals for MySQL Connect @ OpenWorld 2014 is now open!


Normal 0 false false false EN-GB X-NONE X-NONE


  [Read more...]
Update on the MySQL Connect 2014 Call for Papers
Employee_Team +3 Vote Up -0Vote Down

In January we encouraged you to prepare for the MySQL Connect Call for Papers, indicating how.


While dates are still subject to change, we wanted to let you know that the CFP (for MySQL Connect and Oracle OpenWorld overall) will likely open around March 18th. Remember to prepare your submissions in advance in order to swiftly submit them during the 4 to 5 weeks that the CFP will remain open!

Prepare Now for the MySQL Connect 2014 Call for Papers
Employee_Team +5 Vote Up -1Vote Down

As announced last month, MySQL Connect will this year be aligned with Oracle OpenWorld and run from Monday September 29 to Thursday October 2, 2014, in San Francisco.

The MySQL Connect and Oracle OpenWorld Calls for Papers will also open at the same time, and you will most likely be able to submit your sessions between March 4 and April 8 (dates subject to change).

While you will have 5 weeks or so to actually submit your talk proposals, you can already prepare your submissions NOW in order to be ready to submit then, and here is the key information you need to do so. In order to submit a session, you will need to provide:

  • Title
  • Conference session type: This can be either a conference session (1 hour), a Birds-of-a-Feather session (1

  [Read more...]
MySQL Connect 2014, Save The Date!
Employee_Team +7 Vote Up -0Vote Down

We're very pleased to announce that MySQL Connect will next year take place from Monday September 29 to Thursday October 2, 2014, in San Francisco. And there will be a welcome reception on Sunday September 28 evening.


  [Read more...]
MariaDB 10.0.5 storage engines – check the Linux packages
+3 Vote Up -1Vote Down

Today before Ivan’s tutorial, he told me that in the 10.0.5 virtual machine images he created, he couldn’t find the Cassandra storage engine. I told him it had to be installed separately, and this is true – you have to install some engines separately!

When you do a yum install MariaDB-server MariaDB-client like the installation instructions tell you to do, you don’t get all storage engines (so running SHOW ENGINES might have you wondering what happened to a bunch of engines). This can easily be seen by doing a yum search MariaDB. On a CentOS 6.4 server with the MariaDB 10.0 repository configured, you should see the following:

MariaDB-cassandra-engine.x86_64 : MariaDB: a very fast and robust SQL database server
MariaDB-client.x86_64 :
  [Read more...]
MySQL Connect Keynotes and News
Employee_Team +4 Vote Up -0Vote Down

The second edition of MySQL Connect took place just a few days ago, Sept 21-23, and was a great event. Thank you very much to all participants including speakers, sponsors, exhibitors and attendees! We hope you had a fantastic time and learned a lot.

The keynotes are now available for you to watch on demand (both highlights and full length), including:

The State of the Dolphin
Edward Screven, Chief Corporate Architect, Oracle
Tomas Ulin, Vice President of MySQL Engineering, Oracle





  [Read more...]
MySQL Connect in Only 4 Days! The BoFs
Employee_Team +2 Vote Up -0Vote Down

Not registered yet for MySQL Connect? Time is running out, Register Now if you want to save US$300 over the onsite price.

We'll have 6 Birds-of-a-Feather sessions at the conference. They offer you the opportunity to engage in lively, passionate and insightful discussions, as well as to influence the MySQL roadmap.

They will take place on Saturday from 5.30pm to 6.30pm, you will therefore be able to continue some of the discussions during the following MySQL Connect reception starting at 6.30pm.

The BoFs this year include:

MySQL Sharding, Replication, and HA
Imperial Ballroom A










  [Read more...]
Showing entries 1 to 10 of 63 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.