|
FOSDEM_2012_MySQL_and_Friends_proposals
Proposals for FOSDEM - MYSQL & Friends devroom
Featured
FOSDEM 2012 - MySQL & Friends room proposalsVote for your favorite proposalsThere is a MySQL and Friends developers room at FOSDEM 2012. This is the list of proposals received until December 26th, 2011. This is your chance to vote for your favorite proposals: you can vote either publicly, using Twitter, or privately, by sending an email. Each talk proposal will be referred by the number immediately after the title in this page. This number indicates the order in which the proposals were received. A missing number in the sequence means that there was a garbled or somewhat invalid proposal at that number.
In both cases, votes for your preferences will result in 1 point for each talk. In case of equal voting, we will assign 12 points to the first in the list, 11 to the second, and so on. We'll do the tally, and choose the most popular ones. Anonymous votes either by Twitter or email won't be counted. If you want your vote to count, make sure your twitter account has a recognized name (or known nick) on it. If your email address doesn't spell your name, please sign the message with your real one. DEADLINE: Your votes must be entered by January 8th, 2011. Galera 2.0 - new and improved (1)(1) "Galera synchronous multi-master replication for MySQL has progressed greatly in the past year going through two major version upgrades. Among new features: • Support for MySQL 5.5 • Incremental State Transfer (fast node recovery) • Rolling Schema Upgrades and a host of other performance and usability improvements. In this session we will present the current state of Galera replication and discuss various aspects of its use." Alexey Yurchenko I'm a founder and a lead developer (one of) at Codership Oy, developers of Galera replication. The usual stuff. Case Study: Particulier à Particulier’s Migration from MySQL to MariaDB (2)(2) "Particulier à Particulier (pap.fr) is the leading property sales magazine and now web site in France with over 100,000 properties list and over 80,000,000 page views per month. Based on a MySQL scale out architecture, the challenge for the home-made SQL-based search engine was that it required permanent latency monitoring of the worst case scenarios. While the traditional MySQL cost based optimizer was able to support the workload, enhancements introduced in the MySQL branch MariaDB provided dramatic improvements in the performance of the PAP application. During this case study presentation, we’ll discuss those enhancements and how PAP benefited from migrating from MySQL to MariaDB. " Stéphane Varoqui "Current: Principal Consultant at SkySQL AB Past: PS MySQL local manager at Oracle PSD Architect at Sun Microsystems Principal Consultant at MySQL AB Skills: Expert in database performance tuning Expert in LAMP architecture Expert in high availability systems Specialties Database performance tuning, architecture and design, DW, migration. Java , C++ " Case Study: La Poste - Real Time, High Volume Data Warehousing Using MySQL & InfiniDB (3)(3) "La Poste, the French Post Office, process 50,000,000 items of mail per day with each item producing multiple footprints. This data is stored in a database that allows for efficient organization and routing of mail, ensuring delivery to the correct address. La Poste faced the challenge of how to centralize this data whilst still being able to get real time access to routing and delivery statistics. Traditional OLTP oriented databases alone did not provide the solution. Working with SkySQL, La Poste implemented a hybrid solution that was deployed using MySQL and a columnar data store based on the MySQL core (InfiniDB). This is the case study presentation will cover how using this agile methodology, a working solution based on MySQL and InfiniDB was created for this big data challenge. We will explore some of the key issues that had to be resolved to bring performance times down from over several minutes to mere seconds. " Stéphane Varoqui Build simple and complex replication clusters with Tungsten Replicator (4)(4) "Tired of the intricacies of circular replication? Dreaming of real multiple masters solutions for MySQL replication? Dream no more. Tungsten Replicator, a free and open source replacement for MySQL replication, can build clusters of asynchronous nodes in a matter of minutes. This workshop will explain the basics of Tungsten Replicator, and it will show how to start your multiple master cluster in a few minutes. There will be examples of several topologies: from the simplest bi-directional replication to the ambitious all-to-all (every node is a master), fan-in (multiple masters to a single slave), the star (a central hub connected to several bi-directional masters)." Giuseppe Maxia "QA Director at Continuent I am an active member of the MySQL community and long timer open source enthusiast. During the past decades I have worked in various IT related fields, with focus on databases, object oriented programming, system administration. Fluent in Italian, English, Perl, Python, SQL, Lua, C, Bash, and good speaker of C , French, Spanish, Java. I work in cyberspace, with a virtual team." Testing MySQL creatively in a sandbox (5)(5) "Problem: you want to test many different builds of MySQL. There is a proliferation of MySQL versions and builds. Working as a DBA or as a consultant, you will find large installations of MySQL 5.0 to 5.5, with subtle variations among them. In the same company there may several versions of MySQL 5.1, or you may find a mix of vanilla MySQL and Percona or MariaDB builds. For all these version, you often need to reproduce a problem using the same version being used in production, and often you need to install several test servers in the same host for this purpose. Then there are the work-in-progress versions that Oracle and other companies are producing. And you want to test them before adopting them. For all the above needs, there is MySQL Sandbox, a versatile tool that allows you to install multiple servers in the same host, no matter if they are the same version or different ones. This workshop will explain quickly how MySQL Sandbox works, and then show with practical examples how to test several combinations of servers in a single host quickly and painlessly. It will also show examples of how to use MySQL Sandbox to solve practical administration tasks, such as re-playing binary logs or producing a filtered binlog." Giuseppe Maxia MySQL Replication 101 (6)(6) "MySQL replication is the backbone of the web economy. Its usage has allowed tiny startup companies to become internet giants without huge investments in hardware and licenses. This tutorial will introduce MySQL replication from the ground up. It will cover the basics of how replication works before explaining how to set replication and extend your cluster of servers. Attendees will learn: How to instantiate simple master/slave system; How to start, stop, inspect, and monitor replication nodes; How to add a new slave; Common mistakes to avoid; How to use replication to help taking a backup; How to set replication filters; Useful tools for replication" Giuseppe Maxia Sphinx performance top secrets (7)(7) Targeted to advanced developers and DBA’s this talk is about Sphinx performance tips and tricks. We’ll cover Full-text searching tricks and optimizations and general Sphinx tuning for both on-disk and Real-Time engines. Additionally we will talk about scaling Sphinx instance within a box and to one box to the search cluster. And of course there will be war stores! Vladimir Fedorkov Vladimir Fedorkov is a Director of Support and Consulting at Sphinx Technologies. In his day-to-day work he's helping people to grow their websites by scaling and optimizing them and eliminating performance bottlenecks on a different levels. In the past he was worked with high-performance systems as a developer and team leader. Before joining Sphinx he was worked at Percona. In off-duty time he's enjoying travel, bicycling and photography. Building your own search with blackjack (8)(8) This talk is for developers who’d like to improve search on their website. We’ll see how to play with relevance and do custom document weighting, we’ll walk through the different integration methods with MySQL. We’ll talk about services implementation using Sphinx including misspells correction, “also search for” and related products list and will learn how to let user to refine search results with faceted search. Vladimir Fedorkov How to offload MySQL server with Sphinx (9)(9) We’ll take close look on how to offload MySQL server with queries which might be efficiently handled on the Sphinx side. Real-world examples for handling non-Full-Text queries including geodistance search, time segments implementation, using multi-value attributes and more. We’ll also learn how to keep massive text collections away from MySQL databases and how to utilize power of Sphinx on Full-text queries. Vladimir Fedorkov Optimising SQL applications by using client side tools (10)(10) "Much is discussed regarding query optimisers within database server, attention is not always paid however to the actual queries that are passed to a database server to execute and the value of those queries within an application context. No matter how good a query optimiser is it can not match the performance improvement that can be gained by not running a particular query at all, retrieving smaller result sets or running queries less frequently. We will discuss some methods to investigate the SQL your application is sending to your MySQL server, and examine some techniques to visualise the cost of the interactions your application has with the MySQL database." Mark Riddoch Mark has worked in the computer industry for almost 30 years, this has included many roles in various software companies developing network and imaging applications. Prior to joining SkySQL he worked at Sybase as chief designer and project leader for the database kernel development team. Managing MySQL with Percona Toolkit (11)(11) "Percona Toolkit is an indispensable set of opensource command-line tools for managing and administering MySQL servers. This session will introduce the toolkit and the available tools, then demonstrate how to use some of the tools to manage replication, analyze queries, perform common DBA tasks, analyze disk I/O usage, and more. " Frédéric Descamps Frédéric is an experienced Open Source consultant with expertise in infrastructure projects as well in development tracks and database administration. Frédéric is a believer of devops culture. High Availability with Percona-PRM (12)(12) Percona engineers have built a Pacemaker and replication-based system that detects MySQL master failure, chooses a new master, promotes it, and re-attaches slaves in a safe and swift manner. This system, Percona Replication Manager (Percona-PRM), is painless to implement and straightforward to administer. This talk will cover the setup and administration of Percona-PRM as well as providing attendees with sufficient knowledge of it's inner workings to allow them successful deployment in their production environments. Frédéric Descamps MySQL Partitioning: The Spider Solution benchmarked (13)(13) "This talk is about partitioning on different mysql server using Spider engine. During the talk I will show some numbers to explain what can be expected of such setup. And I will compare it against traditional partioning." Frédéric Descamps Virtualized Databases? (14)(14) Let's have a look at the why and how of virtualization and see how it impacts applications with a big hunger for resources. We will run through the different layers of a virtualized environment and examine their impact. Can we tune MySQL to be better adapted to a virtual environment? Liz van Dijk Liz is a researcher and technical advisor in the employ of Sizing Servers, a government-backed research lab operating from Howest. She tumbled into performance optimization research from a background of custom stress tests applications and never looked back... Sphinx User stories (15)(15) Different users stories like delcampe and Pierre & vacances Stéphane Varoqui common_schema: DBA's framework for MySQL (16)(16) "This talk presents common_schema: an open source framework for MySQL server administration. common_schema is a composition of query scripting, analysis & informational views and a function library, allowing for easier administration and diagnostics for MySQL. In this session we will learn how we can utilize common_schema to: - Write server side scripts - Analyze table schema and dimentions - Get easy approach to grants and privileges - Identify and filter proceess users - Analyze transactions and locks " Shlomi Noach Shlomi is a software developer and a DBA. He combines his passion for both by authoring free and open source solutions for MySQL. Shlomi frequently blogs and publicly speaks about MySQL. He is an experienced consultant and instructor. He won the MySQL Community Member of the Year and Oracle ACE awards. MySQL Cluster Internals (17)(17) This talk will go through the components of the MySQL Cluster architecture. How MySQL Cluster fits into the standard MySQL through the storage engine interface, as well as the different node types in the MySQL Cluster and how they work internally to guarantee high availability. We will also take a look at the resource utilisation within the nodes and how that is managed and configured. Ralf Gebhardt "Ralf Gebhardt, SkySQL, Principal Sales Engineer After spending more than 10 years in various Software Development, Support, Training, and Consulting roles, Ralf Gerbhardt joined MySQL in 2002 as a Sales Engineer. He continued in this capacity after MySQL’s acquisition by Sun Microsystems in 2008, and later, Sun’s acquisition by Oracle in 2010. Currently, Ralf serves as SkySQL's Principal Sales Engineer for EMEA. Ralf holds a masters degree in Computer Engineering from the University of Cooperative Education (in cooperation with IBM Deutschland), and is a frequent speaker at open source industry events." All you need to know about migrations and you never dared to ask (18)(18) How easy is a migration to MySQL? How long does a migration take? These are typical questions when you plan a migration to MySQL. And there is not really an answer for that without evaluating the database application you want to migrate. In this presentation we want to highlight the topics you need to take into account for evaluating a migration to MySQL. We will cover the migration tasks in general, will discuss what you need to know about your application itself and will give you some ideas how to migrate functionalities, which are not directly supported in MySQL. Ralf Gebhardt
Practical MySQL indexing guidelines (19)(19) "In many production systems, indexes are designed empirically and without instrumentation to check their efficiency, resulting in poor performance and increased hardware needs. Learn in this talk the fundamental ideas behind indexing, the errors you should avoid and the tools that can help you harness the full power of indexes. The following topics will be covered: - strengths and limitations of indexes in MySQL - performance degradation caused by bad indexes - guidelines to design efficient indexes - tools and methods to identify and remove unnecessary indexes" Stéphane Combaudon Stéphane is a MySQL DBA at Dailymotion, one of the leading video-sharing websites in the world. He has been using the LAMP platform for almost 10 years in various companies and is particularly enthusiastic about MySQL. He is a regular speaker at conferences on MySQL and on free software. How not to build an efficient MySQL application (20)(20) Building a robust and high-performance MySQL application is a combination of using the right techniques and avoiding the wrong ones. Unlike many sessions that are focused on what you should do to get the most of your MySQL database, learn in this presentation the most common traps that lead to bad performance when you are designing or running a MySQL application. Among the topics, we will cover schema and indexes, queries, scale out, hardware, backups and instrumentation. Stéphane Combaudon
Preventing downtime in production MySQL servers (21)(21) "Everyone wants to prevent database downtime by being proactive, but how effective are the common measures such as inspecting logs and analyzing SQL? To be truly proactive, one must prevent problems, which requires studying and understanding the reasons for downtime. We have analyzed a selection of emergency issues that we have solved, to better understand what types of problems really occur in production environments. The results are somewhat surprising and will be detailed in this talk. " Espen Braekken "Espen is the VP of Global Services at Percona. He has worked in the database industry for more than 20 years, managing consultants at Oracle and developers at Amadeus (e-Travel). He has also served as consulting manager at several smaller companies. " Choosing Hardware for MySQL (22)(22) "In this session you'll learn how to choose hardware that helps MySQL execute queries the most quickly, while providing the best price-to-performance ratio. This includes choosing and configuring CPUs, RAM, network, and storage systems. We'll also discuss what performance you can expect from various Amazon EC2 instance sizes, including EBS volumes and Amazon's RDS service for MySQL. " Kenny Gryp Utilise your Hardware (23)(23) "Nowadays you get powerful hardware much to big for a lot of installations. So people tend to use the hardware for more than one project. This Talk will present and explain typical ways to utilise the hardware under the aspect of resource management. Starting from simply putting a lot of schemas into one instance or using mysqld_multi. Even if mysqld_multi provides a better resource managment/isolation it still lacks. While paravirtualized wast a lot of resources themselves. We end up in a solution using LXC/cgroups. You will see how to create and start a fully isolated MySQL-instance in less than 3 seconds. In the end I would like to discuss about any other solution i.e. amazon rds etc." Erkan Yanar "Erkan Yanar is a freelancer and working with MySQL since the last century. Most of the time he is a contractor for the Deutsche Telekom, where he implements a lot of funny MySQL solutions. You can see him also on a lot of Linux-conferences talking also about other things than MySQL. " MySQL synchronous replication in practice with Galera (24)(24) "Everywhere here and there you hear about MySQL synchronous Replication with Galera as a replacement for MySQL Master-Master Replication. But nobody has seen it yet in practice. In this talk we look at the architecture, the installation, the configuration and the pitfalls you have to expect with synchronous Galera Replication for MySQL during operation." Oli Sennhauser Oli is Senior MySQL Consultant and founder of FromDual GmbH. He works with databases since the 2nd half of the Ninety's. Most of the time as consultant. Since 2006 he works as MySQL consultant for many customers mostly in Europe. He likes solving customers problems in various areas like MySQL operations, MySQL Cluster, Performance Tuning, Architecture and Design etc. MySQL and Shared Hosting (25)(25) MySQL is often used as part of a shared hosting solution. In this talk will highlight some of the issues which can arise and a few best practices and workarounds. I will also talk about how MySQL forks like MariaDB, Drizzle and Percona Server can be used to solve some of these issues. Daniël van Eeden I'm a consultant working for Snow B.V. in the Netherlands. I've been working for customers in health care and financial industries and for a number of ISP's in the Netherlands. New Features in MySQL 5.6 (26)(26) "Many MySQL users have already put MySQL 5.5 in place and soon (2012) MySQL 5.6 will be GA! In this talk we will have a look at the New MySQL 5.6 Features which will come: InnoDB enhancements, Partitioning, Performance Schema and the new even more stable binary logging..." Oli Sennhauser
MyEnv a MySQL Environment instead of virtualization? (27)(27) "Running 1 MySQL instance per server is not too complicated. But if you decide to run several MySQL instances per server instead of virtualization life could be easier than it currently is. In this talk we show how we run several MySQL instances on one machine and what methods we used to make our life easier. Because we know that there are several approaches out there we explicitly invite those people for discussing how to make MySQL operation easier..." Oli Sennhauser
Replication features of 2011: what they were, how to get and how to use them (28)(28) "The year 2011 saw a lot of work being done on replication in MySQL world. Different implementations of the same feature were produced, compared, and put into releases. This talk present an easy-to-understand summary of the results: - What exactly are the new features - Where they have/will be released - What are the differences between implementations in various MySQL branches We will also discuss how the new improvements relate to alternative replication solutions like Galera or Tungsten. " Sergei Petrunia "Sergei Petrunia has been working on MySQL codebase since 2003. His primary area of expertise is query optimizer, where he has developed code for features like Table Elimination (MariaDB) index_merge, partition pruning (MySQL), index/engine condition pushdown, and subquery optimizations (MySQL and MariaDB) He has also done smaller improvements in other parts of the server. He has a blog at http://s.petrunia.net/blog/" MariaDB 5.3's query optimizer: taking the dolphin to where he's never been before (29)(29) "MariaDB 5.3 is getting stable: 5.3.3 Release Candidate has been released in December, and one can expect another, almost stable release in January or February. A typical recent version of a MySQL-based product focuses on letting you run the same queries on more CPU cores, or having better replication. MariaDB 5.3 is very different: its focus is the new query optimizer features that let you run queries that were traditionally considered off-limits for MySQL. This talk will show: - What kinds of traditionally no-no queries are now okay to run, - What optimizations are used to execute them, - How the new optimizations behave for typical kinds queries and popular benchmark suites. In conclusion, we will discuss relationship with other MySQL branches: which of these new optimizations will also be in MySQL 5.6, what are the differences between MySQL and MariaDB variants, and what one can expect to see in Percona server. " Sergei Petrunia
MySQL HA reloaded - old tricks and cool new tools to guarantee high availability to your MySQL Servers (30)(30) Do you think that High Availability is all about MySQL Replication? Have you tried to alter your tables to NDB to drink at the holy grail of the shared nothing architectures? High Availability is #1 request for MySQL Servers, even more popular than scalability and performance. In this presentation we will talk about old and new tools to provide HA, automatic failover and disaster recovery for MySQL - there is a solution for every need. Ivan Zoratti "With 25 years of experience in computer science and IT, Ivan started his career at Digital Equipment Corporation, following his passion for the kernel of the PdP 11 machines, RSX and VMS Macro programming. Entrepreneur since 1988, he set up and managed IT companies in Europe. He has been an independent journalist and author of technical books for 15 years. Ivan has worked on Data Warehouse and BI projects since the early 90s, with DEC RDB, Informix, Oracle, SQLServer and later MySQL. In 1997, he joined MicroStrategy as Director of Professional Services and Advanced Solutions in Europe, where he has been directly involved in the architecture and development of some of the largest DW on the planet. Ivan joined MySQL in 2005 and led the European Pre-Sales team for the Software Infrastructure Group at Sun Microsystems. At SkySQL, Ivan is responsible for the Field Services team in Europe. A native of Italy, Ivan has lived in Windsor, UK since 2000." Data Warehousing with MySQL (31)(31) MySQL is primarily used as the front end database for online applications, but today, new features in the standard storage engines and new storage engines specifically designed to manage a large amount of data and complex queries, make MySQL a great database for data warehousing and business intelligence. In this presentation we will talk about the technologies available today to create a data warehouse system based on MySQL, how to use them, what to expect from them and how to avoid headaches. Ivan Zoratti
Open source real-time replication from MySQL to Oracle (32)(32) In this talk we describe how Tungsten Replicator works, then walk you through setup of heterogeneous replication, including special issues like data type translation, column and dataset renaming, DDL handling, timezones, and character sets. We demo MySQL to Oracle replication and some of the neat tricks you can play when you have the power of both databases working on the same data. Linas Virbalas Linas has extensive experience in developing heterogeneous replication solutions between MySQL, Oracle and PostgreSQL. Implemented support of MySQL to Oracle/PostgreSQL/Greenplum and, also, replication POC from PostgreSQL to other DBMS. In addition, he is responsible for PostgreSQL clustering at Continuent: Linas has implemented Tungsten support for PostgreSQL 8 and 9, including management of replicas using log streaming. Before joining Continuent, Linas was Head of IT at FBC "Finasta". MySQL NDB Cluster Architecture (33)(33) "The talk will describe what is MySQL Cluster, what type of nodes are part of a Cluster, and how it achieves high availability and high performance. Will be provided a description of core concepts like shared-nothing architecture, replicas, node groups, partitioning, synchronous replication, local checkpoint, global checkpoint, disk data tables, and known limitations." René Cannaò René has over 10 years of experience as System, Network and Database Administrator mainly on Linux/Unix platforms, and recently focused mainly on MySQL. He built an analytic and problem solving mindset and he is always eager to take on new challenges, especially if they are related to high performance. MySQL Update (34)(34) MySQL 5.5 was released in late 2010 and is one of the most successful releases of MySQL ever. Since then lots of work was put in the successor MySQL 5.6 where the first preview releases are available. In this session you can learn about the latest addition to MySQL 5.6 like InnoDB Fulltext search, replication improvements or the new Memcache API. The talk will also cover MySQL Cluster 7.2 with a ne adaptive query localization aka. pushdown joins and lots of other improvements for increasing performance and scalability of MySQL and MySQL Cluster. Johannes Schlüter Johannes Schlüter is an engineer in Oracle's MySQL Engineering team. Living in Munich, Germany, he is a longterm contributor to Open Source and is serving as release master for PHP 5.3. PHP and MySQL Update (35)(35) PHP and MySQL form the foundation of the so called LAMP Stack, probably the most commonly used platform for building and deploying web-based applications. In this session you will learn about the latest improvements in PHP's MySQL support. Starting with an introduction to mysqlnd - the MySQL native driver for PHP - it will cover different capabilities to improve the performance and scalability of PHP applicaitosn transparently by the usage of open source plugins to PHP and myslqnd. Johannes Schlüter MySQL for Developers - An Overview (36)(36) A database like MySQL lives from being accessible by different applications. It has to work for applications from the supermarket's shelves as well as for hand-tailored custom made applications. Fortunately MySQL Connectors for many languages and application environments exist. In this session Johannes Schlüter from the MySQL Connectors engineering team will provide an overview on the different ways for talking to MySQL. From ODBC to PHP and from .Net to Python. The session will cover both an overview as well as point out possible hidden gems. Johannes Schlüter Optimizing your innodb buffer pool usage (37)(37) Many of the MySQL servers now support inspection of the InnoDB buffer pool contents. Since effective usage of the InnoDB buffer pool is critical to good MySQL performance, a look into what is in your buffer pool is an effective tool to optimize your table layout and index usage for optimal performance. The presentation shows how to use this information to create efficient tables and indexes by looking at your buffer pool contents. Steve Hardy Steve Hardy is CTO at Zarafa and has been working on MySQL and MySQL applications for over ten years. His primary interests are low-level programming, performance and the odd bit of GPU/3D programming. ResultsHere are the results of the votes, the first 16th have a slot in the schedule :
ScheduleYou can find the schedule on this page : http://fosdem.org/2012/schedule/track/mysql_and_friends_devroom MySQL & Friends MeetupLike every year now, we organize a MySQL & Firends meetup during Fosdem and like every year it will be in the Italian (sorry @datacharmer) restaurant Sogno d'Italia. Everybody is invited to come to the dinner. Just register here so we have an idea how many reservations we should make. The maximum capacity is about 40 people. We'll plan to meet at 19:00 on Saturday Feb 4th, under the big tree in front of the AW building. Then we walk to the restaurant, which is about 5-10 minutes walking distance. You can register on this page: http://mysqlfosdem2012-estw.eventbrite.com/ (the registration is Free but you need to pay your dinner ;-) ) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
► Sign in to add a comment
I vote for 31 done by Ivan Zoratti.
12, 13
11
9, 7, 8 & 22 gr Jayme
11, 12
and results ?