Events/Sardinia2011/Sessions
From OpenSQLCamp
The sessions will be chosen in an un-conference style on the day of the event, but session topics should be posted here to give other people an idea of what to expect. If you would like to lead a session, please describe it here. This may be a more formal presentation with slides, or possibly just leading a group discussion on a hot topic. Also feel free to toss ideas out to the mailing list to get feedback in case you are not sure. We want to encourage people from all levels to lead sessions, share your thoughts!
How to add a proposed session
Copy and paste the "Title - Presenter" template just under this text and put the name of the title and presenter(s) in the heading, and the description in the body.
Title - Presenter
Description goes here; just a few sentences to illustrate the idea.
List of Sessions
BlackRay: A closer look on high performance search - Felix Schupp
BlackRay is an in-memory database with SQL and API frontends, designed for high performance and relational/fulltext hybrid applications. Originally designed as a search backend for a large phone directory, BlackRay has evolved into a more general purpose database, implementing a reasonable subset of SQL92, basic transaction support and quick indexing. This session is designed to familiarize you with current features and what BlackRay can be used for best.
State of MariaDB - Colin Charles
MariaDB made two releases in 2010. We're about to make our 5.3 release by about the time we have Open Database Camp Sardinia, so we might have two releases in 2011. What have we been working on? How have we been improving MariaDB? How much does it differ from MySQL? This session is designed to provide an update on the state of MariaDB to all developers and DBAs who are using or considering MariaDB.
Using Buildbot in the EC2 cloud to build your own MySQL variant - Henrik Ingo
Experiences from my paternity leave project: building your favorite MySQL variant using Buildbot and 1) in the Amazon cloud and 2) to build a MySQL branch nobody has built before (the Facebook MySQL branch) 3) Using EC2LatentBuildSlave class to launch slaves on demand, and 4) Loitsut scripts to configure the slave instances on boot. My MepSQL project was based on the MariaDB build system, which I generalized so that it can be sued in ec2 and for any MySQL fork.
How to make MySQL cool again - Henrik Ingo
Based on popular demand, if there is interest I can present this topic originally started by a Jonathan Levin in a blog post, followed up by myself: http://openlife.cc/blogs/2011/april/how-make-mysql-cool-again If you're into NoSQL-with-MySQL, advanced replication, transparent sharding and stuff, we can talk about it here.
Xtrabackup Manager - Henrik Ingo
http://code.google.com/p/xtrabackup-manager/ This is a new project started by MySQL AB alumni Lachlan Mulcahy. It is still very new, but near-usable for basic use cases if you don't mind the lack of a GUI. Xtrabackup Manager allows you to manage your backup scheduling and locations, launching the backups from and storging to a central server.
Advanced MySQL replication for the masses - Giuseppe Maxia
Gone are the times when replication beyond a simple master/slave topology required creativity and wizardry. With the advanced tools created around MySQL, anyone can deploy and manage advanced replication topologies. This practical session will demo multiple sites and multiple source replication, combined with parallel apply and seamless failover.
Multi-Master Melee - Robert Hodges
Everybody wants multi-master. In this session I will talk about the multi-master problem we are solving with Tungsten, demo how we solve it, then throw out some ideas about what we hope to do next. I hope we can start a free-for-all discussion about multi-master replication that comprehends ideas from traditional SQL approaches to eventual consistency to new research projects like Bloom.
SQL to NoSQL Replication Hackathon - Robert Hodges
SQL and NoSQL databases currently are completely isolated silos. Is this the future? How long can such a state of affairs be borne? Let's hack Tungsten Replicator to move transactions from MySQL to a popular NoSQL store like MongoDB. We'll start with beer on Friday night and a simple design. On Saturday after breakfast, we can set up MySQL and your favorite NoSQL store. By dinner time we will create a NoSQL applier in Java to move inserts, updates, and deletes between stores. On Sunday morning we'll test it out. We will present our results to the admiring masses before the conference ends. To do this we need somebody who knows how to setup MongoDB and add data through Java APIs. Please add your name to the talk if you can help. If not MongoDB, please suggest something else.
The SkySQL Reference Architecture - Kaj Arnö
The immediate surroundings of MySQL is no longer merely the LAMP stack. It's about replication, high availability, tools and even standardised apps such as CMSes and CRMs. The SkySQL Reference Architecture aims at simplifying the landscape for the DBA. The simplification focuses not just at the selection of the components, but also provisioning and configuration.
This session presents the framework and asks for feedback from partners, DBAs, customers - potential and existing. OpenSQLCamp attendees are suggested to test the current alpha version of the SkySQL Reference Architecture provisioning system by filling out the screens at http://config.skysql.com/ - I will be collecting your feedback before, during and after the session.
An Information Lifecycle Architecture - Kaj Arnö
Many OpenSQLCamp attendees spend lots of time communicating about our SQL projects, internally and externally. We spend lots of time architecting database systems, and managing the lifecycle of products. We do little to implement a proper architecture for the non-database information we create and manage, in business and privately. We drown in emails, digital pictures, versions of downloaded PDF documents, video snippets, and attachments sent by colleagues, partners and private friends. Chaos ensues. Disorder and low productivity are inevitable unless we are very disciplined in following some basic rules for keeping order on our hard disks, pods and pads. But what are those basic rules? And what tools can implement them? I don't sit in with more than a rough first sketch of "an Information Lifecycle Architecture", but I'd like to share ideas, thoughts and attitudes with my fellow OpenSQLCamp attendees. I'll present some slides and guidelines, and will make an attempt at collecting your thoughts into a summary afterwards!
MySQL Plugins, What Are They? - Sergei Golubchik
You have heard about "MySQL Plugins", but do not know what that means ?
This technology is GA for more than two years, still surprisingly few users know about it, even though it can help to advance their applications in most drastic ways.
This talk will look at MySQL plugins from the end user point of view. What are they, what can they do, how can you use them, what plugins are available - these are the topics of the talk.
Mongodb, The When, Why and What - Flavio [FlaPer87] Percoco Premoli
MongoDB (from "humongous") is a scalable, high-performance, open source, document-oriented database. Written in C++ - http://www.mongodb.org
I've been using mongodb for 2 years and many times I've faced myself asking "why should I use it for this?" or "when should I really use Mongodb?" and many other times "What did I do wrong?". Experiences, examples and real use cases many times say things that benchmarks or technical documentation don't, that for, I'll be presenting the When, Why and What of mongodb. For real, that's what really matters.
Database: the legal layer - Giovanni Battista Gallus
Creating and managing a database inevitably triggers the application of different laws, from copyright (for the content and the database itself) to privacy law, This sessions aims at providing a broad overview of the "legalia" relevant for the DB world, having special regard to cloud environments and open database licenses.
Real-time replication from PostgreSQL to MySQL - Linas Virbalas
With an advent of advanced logical replication in PostgreSQL new possibilities open up. One of them is replication out to different DBMS types, including MySQL. I invite you for a fresh hands-on console-oriented experience on how to setup a real-time heterogenous PostgreSQL to MySQL replication.
Hands-on introduction to JDBC - Sandro Pinna
This is a practical session that explores JDBC application developement. We will write simple programs that use JDBC for retrieving and manipulating data of different level of complexity from any relational database.
MongoDB for dummies - Massimiliano Dessì
How to understand the differences from the well know sql world and the document world of MongoDB. How to think in the document world. How to use from Java and Scala apps.
