Video from OpenSQL Camp o MySQL and more

In November this year, in Portland, USA, the OpenSQL Camp conference was held on the open source DBMS.
Quite by chance I came across video reports and I hasten to share them. The general level of the conference, it seemed to me, is quite high, so I advise you to look. Part of the video, unfortunately, is of poor quality. All presentations, of course, are in English.

MySQL

Many interesting reports related to MySQL

• How InnoDB works Vividly and in detail about how to interpret the output of SHOW ENGINE INNODB STATUS. Of course, there is a lot of information on the Internet on this topic, but here everything is in one place. Please note that the link is seen on on youtube, and on the speaker’s blog, where in addition to the form you can view and slide the presentation.
• Speak HTTP to your Database - John David Duncan talks about the Apache mod_ndb module , which allows you to communicate with your MySQL database directly through HTTP using the REST API. Able to submit data in JSON, which can be convenient for AJAX applications.
• mk-query-digest - Baron Schwartz talks about mk-query-digest , a tool for analyzing data from the slow query log and PROCESSLIST MySQL.
• Storage Engine API - Bradley Kuszmaul will share his ideas on what an API should be for writing your own engines for storing data in MySQL. Who knows - maybe we'll see it all in 6.5 or 7.0.
• Xtrabackup tricks - Peter Zaitsev XtraBackup is a free tool for backing up InnoDB databases. Showing use cases and various tricks.
• State of MariaDB - Monty Widenius Report on the Maria engine , which plans to replace MyISAM
• Memcached functions in MySQ L talks about a set of UDFs that implement a standard set of functions for working with ... memcached! Yes, I also thought at first that this is a special kind of perversion, working with memcached from MySQL. But as a case, the author cites cache invalidation from the table trigger. Not so stupid if you think about it. Although, personally, I would put out such logic in the application code, and not in the database. But maybe someone will come in handy. The shooting is just awful - there is no video, one sound. Although I’m lying, in the middle of the performance you can see someone’s chest and badge ...
• Graph Engine for MySQ Antony Curtis - Interesting idea. OQGRAPH Engine is an attempt to make friends of data stored in the form of a graph (category trees, friendships in social networks) and a relational approach to data selection, at the level of the MySQL engine

Optimizations

A couple of optimization reports

• Goal-Driven Performance Peter Zaitsev Honestly, I find it difficult to correctly translate “Goal-Driven” But in general, the essence of the report can be reduced to simple but not always obvious truths - you need to optimize the database based on the goals and priorities facing your application. Examples of using this approach.
• Using and Optimizing Data bases on Flash by Peter Zaitsev Optimizing the DBMS for more and more accessible SSD drives. Personally, my video does not show, there is only audio. But maybe someone will be interested and relevant even in this form.

Drivenzzle

A number of reports were devoted to a young but promising fork of MySQL - Drizzle

• Drizzle Client Rewrite - Clark Boylan is a little interesting, for me personally, story about the reasons and the process of creating a client for Drizzle
• Drizzle Plugin Hacking - a more interesting, from a practical point of view, report on how to write plugins for Drizzle
• Drizzle is Not MySQL with Changes - Brian Aker will explain why Drizzle is just MySQL with a couple of patches, and a brand new product. Slides can be found here.

NoSQL

And of course, there was a fashion trend - NoSQL

• MongoDB is another presentation about mongoDB. They adequately talk about what these are and use cases. The topic also arises when it is not worth using it.
• Intro to Cassandra Almost the same as the previous video but for Apache Cassandra
• An Intro to CouchDB: What caught Ubuntu's eye by Mike Miller (Cloudant) And at the end of the cycle is an overview of CouchDB. Unfortunately, the video is not very good - the background noise interferes greatly.
• Comparing Non-Relational Databases: MongoDB, Tokyo Tyrant, CouchDB by Igal Koshevoy of Pragmaticraft attempt to compare the capabilities of the three leading DBMS in this sector. Slides and source code are available here.
• SQL vs. NoSQL Panel - an hour-long discussion between supporters of NoSQL and RDBMS. It would not be different in the many holivars bred on the Internet, if not for the participants:
  
  • Brian Aker - Drizzle
  • Monty Widenius - MariaDB
  • Selena Deckelmann - PostgreSQL
  • Eric Evans - Cassandra
  • Mike Dirolf - MongoDB
  • Mike Miller - CouchDB
  
  If you google it, it becomes clear that each of them is well versed in the presented product. So it will be interesting to listen

Miscellaneous

Sorry, but the topics of the last four reports did not interest me much, so I will leave them without comment because I did not watch them.

• SQL For the Insane - Dan Colish is an overwhelming talk about using PG / SQL for ... drawing ASCII pictures like these . In real life, the thing is useless, but who will now say that SQL is not an art !?
• PBMS, BLOB, S3 Storage and backup with Barry Leslie of Primebase talks about PBMS, BLOB, S3 Storage and backup with the PBMS Daemon.
• Operations Aspects to Running DBs in the Cloud - Joe Williams from Cloudant talks about: automation (config management, dynamically adding nodes) performance (adding nodes to increase performance, disk tuning) and availability (what if a node goes down?)
• Fractal Trees - by Bradley Kuszmaul of Tokutek
• Geographic Operators in SQL (PostGIS) by Webb Sprague

And, of course, a bunch of small fact-finding reports in the “5 minutes” format. In one piece 54 minutes long. The list of topics for mini presentations:

• The Grap h Engine (Antony Curtis)
• Cluster / J, a new set of Java APIs to MySQL Cluster 5.1 (John David Duncan)
• Sphinx, the fulltext storage engine (Peter Zaitsev)
• iiBench, the Indexed Insertion Benchmark (Bradley Kuszmaul of Tokutek)
• JJtree in Coco
• Integrating OSS wit h Windows (Tom Hanrahan of Microsoft)
• Trainwreck, an agent for MySQL replication (Domas Mituzas)
• Column Stores (David Lutz of Infobright)
• I Play With Data, about doing real statistical calculations of data, when SQL gets in the way
• Your Guide to NoSQL (Brian Aker)
• PL / Parrot The call for PL / Parrot in Postgres is put out there (Jonathan “Duke” Leto)

PS If someone knows where to find the missing slides for performances - please write in the comments.