Many years ago, I wrote about importing XML data into MySQL using ExtractValue(). The reason I'm revisiting the subject now is that I recently received an email request in relation to my old blog post:

I came across one of your blogs on importing XML data to MySQL using ExtractData() and I am trying to do the same using MySQL (5.5) database. However, I am new to this kind of method and would like to seek your expertise on this.

I have an XML file that looks like this:

<?xml version="1.0" encoding="UTF-8"?>
 <wovoml xmlns="http://www.wovodat.org"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 version="1.1.0" xsi:schemaLocation="http://www.wovodat.org phread2.xsd">
 <Data>
 <Seismic>
 <SingleStationEventDataset>
  <SingleStationEvent code="VTAG_20160405000000" owner1="169" …

A friend of mine asked me how they could automatically follow and unfollow people on Twitter. But they didn’t want to follow just anyone and everyone. He had a Twitter account which they used for recruiting in a very narrow construction industry. He wanted to find people in the same industry and follow them – hoping they would follow him back and learn about his open jobs. When I joined Twitter back in 2008, I wrote a similar program to automatically follow/unfollow users, but the Twitter API has changed quite a bit since then. So I decided to re-write the program with the latest Perl-Twitter API – Net::Twitter::Lite::WithAPIv1_1.

Before you attempt to use these scripts, you will need to register your application with twitter via apps.twitter.com, and obtain the following:

consumer_key
consumer_secret
access_token …

Information Age today unveiled the inaugural list of the UK’s top 50 data leaders and influencers

“Very strong on product and technical development of open-source databases, Vinay has helped global and UK businesses like BT, AutoTrader Group and Ping Identity to scale, manage and develop (data) cloud operations.” - as just announced by Information Age.

Congratulations to all the nominees and thanks to the selection committee at Information Age for this distinction!

Vinay is a passionate advocate of open source databases for mission-critical business. Prior to co-founding Severalnines, Vinay served as VP EMEA at Pentaho Corporation and held senior management roles at MySQL / Sun Microsystems / Oracle and Ericsson.

As our CEO, Vinay steers all …

We proudly announce General Availability (GA) of MySQL 5.7. Download now! MySQL 5.7.9 is an extremely exciting new version of the world’s most popular open source database that is 3x faster than MySQL 5.6, while also improving usability, manageability, and security. …

MariaDB TokuDB benchmark on FusionIO ,Compare TokuDB and InnoDB engines.

read: TokuDB_benchmark

Our friends at Datadog just published an insanely great three part series on monitoring Amazon RDS for MySQL using Datadog. You should go read that now.

Full disclosure, I helped review a couple of the drafts. (We don’t have any formal relationship, we’re just friends–although we do integrate VividCortex with Datadog for our customers).

My only suggestion for monitoring RDS+MySQL above and beyond what Datadog wrote is that query monitoring is vital. Your databases exist to run queries, so you really ought to monitor their performance! However that doesn’t really make sense for Datadog, since it isn’t a query centric monitoring platform. …

Many of you are coming to San Francisco next week for Oracle OpenWorld 2015 and many of you have already booked time on your calendars on Wednesday evening before the appreciation event. You are right — the Annual Oracle Bloggers Meetup, one of your favorite events of the OpenWorld, is happening at usual place and time!

What: Oracle Bloggers Meetup 2015.

When: Wed, 28-Oct-2015, 5:30pm.

Where: Main Dining Room, Jillian’s Billiards @ Metreon, 101 Fourth Street, San Francisco, CA 94103 ( …

MariaDB 10.1 shipped a few days ago, so it’s now a good time to focus on another important event. Last week we had a three day MariaDB developers meeting. It took place in Amsterdam (Oct 13-15). Meetings like this tend to have a great impact on the roadmap of the product. Booking.com was very kind […]

The post Developer meeting & community meetup summary appeared first on MariaDB.org.

Oracle OpenWorld can be pretty intimidating. Besides the extra fifty thousand bodies in an around Moscone Center in San Francisco, there is an overload of amazing information that bombards you from all directions. And then comes the really hard decision of which sessions to attend. This year MySQL has three rooms being used for sessions.

The Catalog of sessions shows over 1800 session and MySQL is the subject of fifty three of those. The problem is that you can not be in three places at once!

For example on Monday morning there are two tutorials and a great session at the same time.

• MySQL Essentials—Getting Started with MySQL [TUT2356]
  Ligaya Isler-turmelle, Principle Technical Support Engineer, Oracle
  Jeremy Smyth, Course/Curriculum Developer, Oracle
  …

I love graphs. They just make things easier when it comes to finding patterns. I also love visibility. Having the ability to known what is going on inside the database is priceless. How about having visibility of the slow queries execution time on a graph? Let’s do it.

We’ve already described how to get query digest using performance schema. Since the MySQL server is already doing the heavy lifting for you with little-to-no overhead, this information is available practically at will. So let’s make some graphs with that data.

To accomplish this I will use the well-known tool Graphite to store and render time-series data. For those who are not familiar with Graphite, it’s actually a 3-piece tool, consisting of:

• The …