MariaDB - Community Developed. Feature Enhanced. Backward Compatible. A branch of the popular MySQL database, the project began in 2009 around a storage engine, but quickly evolved to being another database project, with two major releases in 2010. This session will introduce the project, and will help any DBA or developer get to grips with MariaDB.
Writing a complete plugin requires quite a bit of infrastructure work to get all the feature registration and build system aspects right. A code generator can take care of such tasks, allowing you to focus on the actual functionality you want to add without having to figure out all plugin API details up front. This can cut the time to create a simple plugin down from hours to minutes.
With contemporary web applications, data is never isolated to one store. Memcached has long been a partner to MySQL; now Membase, a persistent, replicated, clustered memcached-protocol-compatible datastore is used alongside MySQL for simple, fast key-value access. This session will dispel the idea of needing to choose between SQL or NoSQL, showing how you can be both rich and fast.
At Twitter, we have gone through many iterations of storage systems as we have coped with tremendous growth. We have been able to solve many general distributed storage problems in a framework named Gizzard. This has allowed us to quickly and safely develop specialized components for the parts of Twitter that can no longer handle the scale at which they are required to operate.
Moving rarely accessed data out of your main database can have a big impact on speed and cost. This session covers techniques to analyze the granularity of your data and implement an archival strategy that allows you to recall archived data on demand.
Apache Hadoop is a distributed, batch-processing system for large data sets. It can be used alongside relational databases to enable more effective reporting and injestion of large amounts of raw or unstructured data.
The Facebook database engineering team works with the community and on its own to make MySQL better for data center deployments. This work is visible in the Facebook patch, bugs fixed in official MySQL and features sponsored in other distributions. We will describe work to support a large number of large databases. We focus on backup, replication and quality of service.
Mixed SQL system environments are a reality for most organizations. MySQL and PostgreSQL are a natural combination -- both are open source, and they complement each other nicely. See how to improve data consolidation, increase confidence in query results, and analyze data across applications.
GitHub's history with MySQL and what we've built off of it.
Learn the right techniques to maximize your investment in MySQL by knowing the best practices for DBAs and Developers. Understand what subtle differences between MySQL and other RDBMS products are essential to understand in order to maximize the benefits and strengths of MySQL. We will be covering areas including the minimum MySQL configuration,ideal SQL, MySQL security and schema optimizations.
Too much for just one session, in Part 2 we continue with learning the right techniques to maximize your investment in MySQL by knowing the best practices for DBAs and Developers. Get ahead of finding and addressing architecture and performance by doing it right the first time.
This session will introduce you to new MySQL Cluster features, its performance in benchmarks, and shows how major mobile phone and web companies build highly available real time solutions based on MySQL Cluster. Sometimes even with SQL.
This Cluster Tutorial guides DBAs and other mere mortals into the world of MySQL Cluster. At the end of the session you will have started your own cluster on your laptop and be able to administer and manage it as needed. You will also be able to create and install new clusters at ease. More advanced topics such as performance tuning and common pitfalls and best practices will also be showcased.
MySQL's replication system has been a core feature often touted for scaling (sort of) and redundancy (sort of). I'll describe a client's extensive use of MySQL replication (they have more than 200 MySQL instances replicating to one another) as a reference for the many uses and misuses of replication.
A guide to migrating your database and application from MySQL to Drizzle at every layer, from schemas to connections and application modifications.
The “NoSQL” movement is typically related to key-value systems and, lacking a formal definition, can be interpreted many ways. NoSQL discussions that focus on availability and scalability highlight ACID issues but not really SQL.
The key-value systems can be built many ways and relational databases as a back end is a serious contender.
Amazon engineers share experiences managing a large fleet of MySQL databases.
We will examine the challenges faced by Zynga in running a large scale MySQL plant in EC2. Serving our social games to millions of players around the globe has required significant investment in automation and performance optimization to the thousands of MySQL instances that drive the games. Delivering high performance in the cloud requires a unique approach to support high CPU and I/O demands.
Security is often considered a waste of time given its tedious, painful and underestimated. This is where securich comes to the rescue helping you control users, privileges and enforce good passwords. User cloning, renaming, password complexity and much much more.
LAMP applications are used more and more to perform enterprise-critical tasks. Given by the creator of PHPUnit, this tutorial shows the audience how to efficiently test LAMP applications with PHPUnit and its DbUnit extension.
Database technology is seldom simple. Unless you are dealing with an embedded, self containing database such as SQLite, chances are that your data management requires a complex system involving one or more database servers. Whether you need to test new systems or benchmark existing scenarios, your common need is to isolate the system. This talk tells how to tame database systems into obedience.
Most of high scale web applications use memcached + MySQL or NoSQL. It is said that NoSQL performs better than MySQL for simple access patterns such as primary key lookups. But things are changing. DeNA recently developed HandlerSocket plugin, a MySQL plugin speaking NoSQL protocols. We got 750,000+ qps in our benchmarks and runs pretty well on our production. We'd like to share our experiences.