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 63 Next 30 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...]
MySQL Connect in 9 Days Only - Announcing New Keynote
Employee_Team +3 Vote Up -0Vote Down

It is our great pleasure to announce that Harrison Fisk will deliver a "MySQL at Facebook" keynote at MySQL Connect!

Our keynote lineup is now as follows:

Saturday, September 21, 9:00 a.m.–10:00 a.m.
The State of The Dolphin

Join Edward Screven, Oracle’s Chief Corporate Architect, and Tomas Ulin, Vice President of MySQL engineering, for the State of the Dolphin keynote address. Learn about Oracle’s MySQL strategy as well as the latest innovations and plans for MySQL.

  [Read more...]
MySQL Connect 11 Days Away, Hands-On Labs
Employee_Team +2 Vote Up -0Vote Down

Eight MySQL Connect Hands-on Labs will offer you the chance to get hands-on experience about various topics. They will all take place in room Franciscan A/B at the Hilton Union Square and here is the schedule:

MySQL’s EXPLAIN Command New Features - Evgeny Potemkin, Oracle
Saturday, 11.30am - 12.30pm

MySQL Replication Best Practices - Luis Soares, Oracle
Saturday, 1.00pm - 3.30pm

MySQL Cluster Monitoring: Availability and Performance -

  [Read more...]
Focus on the MySQL Connect Tutorials
Employee_Team +2 Vote Up -0Vote Down

We recently looked at InnoDB, Real-World Experiences and Performance Tuning sessions at MySQL Connect. Let's now focus on the MySQL tutorials. You indeed have this year the opportunity to add a third day of tutorials to your MySQL Connect registration. They will be held on Monday September 23 at Moscone South. Whether you are getting started with MySQL or an experienced user, you will get the chance to acquire in-depth knowledge, directly from the source.

Tutorials and Schedule:

  [Read more...]
Performance Tuning Sessions at MySQL Connect
Employee_Team +1 Vote Up -0Vote Down

MySQL Connect is only slightly over 2 weeks away! Many sessions at the conference will offer you the chance to learn how to improve performance using the new features and enhancements of MySQL 5.6. You can see all sessions in our content catalog and pre-enroll in them with Schedule Builder. While the below list may not be exhaustive, performance tuning sessions include:

50 Tips for Boosting MySQL Performance - Arnaud Adant,

  [Read more...]
MySQL Connect in 23 Days: Real-World Experiences Sessions
Employee_Team +1 Vote Up -0Vote Down

Following my blog on InnoDB sessions, let's focus today on what you will have the opportunity to learn from MySQL users sharing their real-world experiences along with best practices they've developed.

You should obviously not miss our exciting panel on "Current MySQL Usage Models and Future Developments" featuring Davi Arnaut from LinkedIn, Daniel Austin from PayPal, Mark Callaghan from Facebook and Calvin Sun from Twitter.

The conference sessions will include:

MySQL at Twitter - Calvin Sun and Liang Guo, Twitter
Saturday, 11.30 am, Imperial Ballroom A

  [Read more...]
MySQL Connect Only 25 Days Away, Focus On InnoDB Sessions
Employee_Team +2 Vote Up -0Vote Down

Time flies and MySQL Connect is just around the corner...Schedule Builder was launched last week to help you build your own schedule, selecting and pre-enrolling in sessions you plan to attend.

You can check out the program in our content catalog as well as via a new Focus on MySQL Connect document listing all sessions with time and location. If you’d like to expand your InnoDB knowledge, below are the sessions specifically focused on InnoDB

  [Read more...]
Schedule Builder is Live, Plan Your MySQL Connect Conference
Employee_Team +2 Vote Up -1Vote Down

Schedule Builder allows you to effectively plan your conference and pre-enroll in MySQL Connect sessions you want to attend. Go ahead and start building your schedule!

With keynotes and over 85 conference sessions, Hands-on Labs, Birds-of-a-Feather sessions and tutorials, MySQL Connect offers you a unique opportunity to boost your MySQL skills and meet the Oracle engineers driving MySQL innovation. You’ll learn how to build next-generation applications with the leading Web and cloud

  [Read more...]
Twitter: New Tweets per Second Record, and How
Employee_Team +7 Vote Up -0Vote Down

Raffi Krikorian, VP Platform Engineering at Twitter, blogged about Twitter's New Tweets per second record and how they achieved it:

"Recently, something remarkable happened on Twitter: On Saturday, August 3 in Japan, people watched an airing of Castle in the Sky, and at one moment they took to Twitter so much that we hit a one-second peak of 143,199 Tweets per second...To give you some context of how that compares to typical numbers, we normally take in more than 500 million Tweets a day which means about 5,700 Tweets a second, on average. This particular spike was around 25 times greater than our steady state."


  [Read more...]
Speaking about security and 5.6 on MySQL Connect 13
Employee +4 Vote Up -0Vote Down

I will be presenting on both MySQL Connect 2013 and on Oracle OpenWorld 2013. So if you happen to be attending the conferences please come and see what's new in MySQL 5.6 security and even play with it during the hands on lab I'll be doing.

I will be delivering a

  [Read more...]
MySQL Connect Attendee Toolkit
Employee_Team +1 Vote Up -0Vote Down

Are you speaking at MySQL Connect? Attending the conference? Resources such as sample e-mail copies, banners and buttons are at your disposal in our attendee toolkit. Some examples below:

Would you like to help promote MySQL Connect? Here are others you can also use:

  [Read more...]
Top 10 Reasons to Attend MySQL Connect
Employee_Team +2 Vote Up -0Vote Down

MySQL Connect is taking place in San Francisco September 21-23; Counting over 85 sessions and tutorials, the event represents a unique opportunity to boost your MySQL skills and hear from Oracle's MySQL engineers along with customers, partners and MySQL community members.

  [Read more...]
MySQL Connect: Two More Weeks to Save US$500
Employee_Team +3 Vote Up -0Vote Down

The Early Bird rate for MySQL Connect has been extended for two weeks. Register by August 2 to save US$500 over the onsite price!

MySQL Connect will be held on September 21 - 23 in San Francisco, California. The conference will start on Saturday with "The State of The Dolphin" keynote presented by Oracle's Chief Corporate Architect, Edward Screven, and Vice President of MySQL Engineering, Tomas Ulin, followed by a panel to discuss "Current MySQL Usage Models and Future Developments", with panelists from renowned web properties including Facebook, Twitter, LinkedIn

  [Read more...]
MySQL Connect: Only a Few Days Left to Register and Save US$500
Employee_Team +2 Vote Up -0Vote Down

The Early Bird pricing for MySQL Connect will end on July 19, 2013; you only have a few days left to register and save US$500.

MySQL Connect will take place in San Francisco September 21-23. The program includes exciting keynotes, 66 conference sessions, 6 Birds-of-a-Feather sessions, 8 Hands-On Labs, demo pods, fun receptions and more. Some of the presentations you will be able to attend are:

  [Read more...]
Thank You MySQL Connect Content Committee Members
Employee_Team +4 Vote Up -0Vote Down

Yesterday we announced the publication of the MySQL Connect Content Catalog.

We would like today to thank the MySQL Connect Content Committee members, and especially our external members, for their efforts helping us to build the best possible MySQL Connect program. The Call for Papers had generated a large number of great submissions (thank you all for that!) and it was indeed a tough job to select sessions among those.

So thank you very much, Sheeri, Erin, Giuseppe, Calvin and Yoshinori! Your input has been invaluable.

Learn more about MySQL Connect (San Francisco Sept 21-23).

  [Read more...]
Discover the MySQL Connect Content Catalog!
Employee_Team +8 Vote Up -1Vote Down
The MySQL Connect content catalog is now live! MySQL Connect, taking place in San Francisco Sept 21-23, offers you a unique opportunity to attend:

Keynotes including:
  • "The State of the Dolphin", by Oracle's Chief Corporate Architect Edward Screven and VP of MySQL Engineering Tomas Ulin.
  • An exciting panel on

  [Read more...]
MySQL Connect Tutorials
Employee_Team +3 Vote Up -0Vote Down
MySQL Connect 2013 will be bigger and even better. In addition to the keynotes, conference sessions, Birds-of-a-Feather sessions, and hands-on labs, you have the opportunity to include an additional day of tutorials on Monday, September 23.

Whether you are getting started with MySQL or an experienced user, the following tutorials will allow you to acquire in-depth knowledge, directly from Oracle's MySQL Engineers:

  • Getting Started with MySQL: Learn the Essentials
  • Enhancing Productivity with MySQL 5.6 New Features
  • How to Analyze and Tune SQL Queries for Better Performance
  • MySQL 5.6 Replication Tips and Tricks
  • MySQL 5.6 Performance Tuning and Best Practices
  • Getting Started with MySQL Cluster

  [Read more...]
MariaDB CONNECT Storage Engine and engine condition pushdown
+3 Vote Up -0Vote Down

Engine condition pushdown is a MySQL internal mechanism that is intended to avoid to send non matching rows from the storage engine to the SQL layer. This is very important when the storage engine involves traffic over the network. This mechanism was initially created to optimize MySQL Cluster (NDB) behavior. For the NDB storage engine [...]

The MySQL Connect 2013 Call for Papers is Open!
Employee_Team +10 Vote Up -0Vote Down
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

Following the success of its first MySQL Connect edition, Oracle will hold MySQL Connect 2013 on September 21-23 in San Francisco.

The Call for Papers is now open, and will be running until April 12. We highly encourage MySQL users, customers, partners and community members to submit session proposals now.

  [Read more...]
MySQL Connect Keynotes and Presentations Available Online
Employee_Team +3 Vote Up -1Vote Down
72 1024x768 Normal 0 false false false EN-US X-NONE X-NONE

Following the tremendous success of MySQL Connect, you can now watch some of the keynotes online:

The State of the Dolphin – by Oracle Chief

  [Read more...]
MySQL Connect Conference: My Experience
Employee +0 Vote Up -0Vote Down
It was a great experience to attend the MySQL Connect Conference for the first time ever. Personally I was very much enthralled to present about "How to make MySQL Backups" besides attending different sessions to absorb more knowledge about the technical prospects of MySQL. One of the agenda items in my presentation was "MySQL Enterprise Backup" functionality and features. There were total of 40 attendees in the session, who were very much interested about the MySQL Enterprise Backup product and gave positive feedback as well as areas of improvements on our product. Some of our features brought lot of  [Read more...]
Showing entries 1 to 30 of 63 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.