Time-series databases are of particular interest to me these days. Not only is VividCortex working with large-scale time-series data, but it’s a growing trend in the technology world in general. What’s perhaps most surprising is the dearth of native time-series databases, either commercial or opensource.

The World is Time-Series

The data we gather is increasingly timestamped and dealt with in time-series ways. For the last 10 years, I’ve worked with “roll-up” or “summary” tables almost constantly. I built, and saw others build, the same types of solutions over and over. For example, I probably consulted with over a dozen companies who do search-engine marketing and advertising. Cost tables are a given, and there’s usually cost-per-ad-per-day and half a dozen other summary tables. In my case I saw these things in the MySQL context, but you can pick your technology …

Time-series databases are of particular interest to me these days. Not only is VividCortex working with large-scale time-series data, but it’s a growing trend in the technology world in general. What’s perhaps most surprising is the dearth of native time-series databases, either commercial or opensource.

The World is Time-Series

The data we gather is increasingly timestamped and dealt with in time-series ways. For the last 10 years, I’ve worked with “roll-up” or “summary” tables almost constantly. I built, and saw others build, the same types of solutions over and over. For example, I probably consulted with over a dozen companies who do search-engine marketing and advertising. Cost tables are a given, and there’s usually cost-per-ad-per-day and half a dozen other summary tables. In my case I saw these things in the MySQL context, but you can pick your technology …

We had a great webinar on Thursday about replicating from MySQL to Hadoop (watch the whole thing). It was great, but one of the questions at the end was ‘is there an easy way to test’.

Sadly we can’t go giving out convenient ready-to-run downloads of these things because of licensing and and other complexities, so I want to try and make it as simple and straightforward as possible by giving you the directions to complete. I’m going to be point to the Continuent Documentation every now and then so this is not too crowded, but we should get through it pretty easily.

Major Decisions

For this to work: 

• We’ll setup two VMs, one the master (running MySQL), the other the slave (Running Cloudera) …

Under Parallel Network Query, servers are numbered according to the table join
order of query (forming server pipeline) and each server processes its own
tables.  Query result is generated by concatenating processed tables of each
server along the server pipeline.

Parallel Network Query may also be used to speed up slow server by distributing
tables of the query to multiple servers for processing which effectively
aggregates server resources (such as disk I/O bandwidth and CPU/cores).

See Technology and Benchmarks page.

Few weeks ago I asked my friends who speak both English and Russian if it is worth translating slides about Performance Schema which I prepared for a seminar at Devconf 2013. They said it is. Today I finished translation and uploaded slides to SlideShare.

Strictly speaking simple translation of slides is not enough, because they were created for the seminar where I was going to explain what they mean. I think I need to repeat same seminar, this time in English language. But if you have rough imagination about what Performance Schema is and need hints for practical use you will find such suggestions in the slides. You will also find ready-to-use queries which you can use to troubleshoot most frequent performance issues.

Enjoy!

Madrid MySQL Users Group will have its next meeting on 20th March. Details can be found on the group’s Meetup page.

I will be giving a presentation on MySQL replication hopefully aimed at all levels, but covering some details relevant to larger setups. The meeting will be in Spanish.

Look forward to seeing you there.

La próxima reunión de Madrid MySQL Users Group tendrá lugar el jueves 20 de marzo. Se puede encontrar más detalles en la página del grupo.  Ofreceré una presentación sobre replicación de MySQL dirigido a gente de todos los niveles, pero incluirá información relevante a entornos más grandes.  La presentación será en español.

Espero veros allí.

MySQL software developers are under pressure to do more in less time and create applications that adapt to ever-changing requirements. And it’s true that some of a developer’s time is wasted when his or her method of optimizing involves trying every combination of code and index definition.

There is a better way. And next Wednesday at 10 a.m. Pacific time, I’ll show you how. In my webinar, “How to Avoid Common (but Deadly) MySQL Development Mistakes,” you’ll lean:

• How to find out which indexes are the best fit for your MySQL application
• How to protect yourself from the number one MySQL database security vulnerability on the web
• How to decide when …

We are pleased to announce that MySQL Enterprise Monitor 3.0.7 is now available for download on the My Oracle Support (MOS) web site. It will also be available via the Oracle Software Delivery Cloud in about 1 week. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log.

You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet.

You will also find the binaries on the Oracle Software Delivery Cloud in approximately 1 week. Choose "MySQL Database" as the Product Pack and …

Last week several people from the MariaDB and SkySQL team headed down to Los Angeles to attend SCALE12x. This is our fourth year at this great event, and this year it seemed even bigger and better than in the previous years (and those were no slouches by any means).

Colin Charles, MariaDB's Chief Evangelist, had two talks this year. The first was about MySQL and MHA, and the second was about MariaDB as a viable alternative to MySQL. Both of these talks were well attended. The database track as a whole was outstanding.

read more

MySQL is very popular and growing on the Windows platform. As a consequence we want to further staff our Windows efforts with a full time Windows performance architect. The Windows performance architect will be an integral part of the MySQL Server development team and also work closely with our Windows Experience team. Work will be centered around profiling and tuning large multi-threaded service applications on the Windows platform, debug and remove limitations and develop new code.

Key qualifications are:

• 5+ years C/C++ software development experience on Windows platform
• Ability to understand large pieces of code fast
• Strong understanding of long running programs (for example Operating System Kernels, Filesystems, high end networking equipment)
• Strong understanding of multi-threaded service applications
• Proven skills in designing and coding complex environments
…