In November of this year, in Portland, USA, an
OpenSQL Camp conference was held on the open source DBMS.
Quite by chance I stumbled upon video reports and I hasten to share them. The overall level of the conference, it seemed to me, is quite high, so I advise you to take a look. Part of the video, unfortunately, in poor quality. All presentations, of course, in English.
Mysql
Many interesting reports related to MySQL
- How InnoDB works Explains 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 everything is in one place. Please note that the link is visible on youtube, and on the speaker’s blog, where in addition to the form you can see the presentation slides and slides.
- Speak HTTP to your Database - John David Duncan talks about the Apache module mod_ndb , which allows you to communicate with your MySQL database directly via HTTP using the REST API. Able to give data in JSON that can be convenient for AJAX applications.
- mk-query-digest - Baron Schwartz tells 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 should be the API for writing your own data storage engines 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 A 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 the author cites the invalidation of the cache from the table trigger as a case. Not so stupid if you think about it. Although I personally would have carried out such logic in the application code, and not in the database. But maybe someone will come in handy. Shooting just awful - no video, one sound. While lying, in the middle of the show you can see someone's chest and a badge ...
- Graph Engine for MySQ Antony Curtis - Interesting idea. OQGRAPH Engine is an attempt to make friends the data stored as a graph (category trees, friendships in social networks) and the relational approach to data sampling, at the level of the MySQL engine
Optimization
A couple of optimization reports
- Frankly, I find it difficult to correctly translate “Goal-Driven”. But in general, the essence of the report can be reduced to a simple, but not always obvious truth - you need to optimize the database based on the goals and priorities of your application. Examples of using this approach.
- Using Zaitsev Using Optimized Data Base Optimization of DBMS for more and more affordable SSD drives. Personally, my video does not show, there is only audio. But maybe someone will be interesting and relevant, even in this form.
')
Drizzle
A series of reports was devoted to a young but promising fork of MySQL -
Drizzle
- Drizzle Client Rewrite - Clark Boylan is not very interesting, for me personally, a 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 pagins for Drizzle
- Drizzle is Not MySQL with Changes - Brian Aker will explain why Drizzle is just MySQL with a couple of patches, but a fundamentally new product. Slides can be found here.
NoSQL
And of course, it was not without a fashionable trend - NoSQL
- MongoDB is another presentation about mongoDB. Adequately adequately talk about what it is and use cases. It also raises the topic when it is not worth using.
- 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 - a review of CouchDB. Unfortunately, the video is not very good - background noise is in the way.
- Comparing Non-Relational Databases: MongoDB, Tokyo Tyrant, CouchDB by Igal, Koshevoy of Pragmaticraft, an attempt to compare the capabilities of the three leading DBMS in this sector. Slides and source code available here.
- SQL vs. NoSQL Panel - hourly discussion between NoSQL supporters and RDBMS. It would be no different in the multitude of holivars divorced on the Internet, if not 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
miscellanea
Sorry, but I was not interested in the topics of the last four reports, so I will leave them without comment as I did not look.
And, of course, a lot of small introductory reports in the "5 minutes" format. One
piece long 54 minutes. 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, 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 the speeches - please write down in the comments.