Personal schedule for Roland Bouman
Download or
subscribe to Roland Bouman's
schedule.
This tutorial focuses on the diagnostic tools you can turn to when confronted with an unexplained performance problem. Tools explained include iostat, vmstat, and mk-query-digest. The emphasis is on practical usage under pressure, and less on performance theory.
Read more.
Scaling Applications with Caching, Sharding and Replication
Read more.
Join Edward Screven, Oracle’s Chief Corporate Architect and leader of the MySQL business, as he discusses the current and future state of MySQL, now part of the Oracle family of products. The presentation also covers Oracle’s investment in MySQL technology and community; and the role that open source in general is playing within heterogeneous customer environments around the world.
Read more.
Tim returns to share insights into the world of emerging technology, presenting his take on what matters most-and what will be most disruptive-to the tech community.
Read more.
Many things happen when MySQL is part of the core technology used to
scale a rapidly growing social networking service. Mark will share
stories and details about the MySQL deployment at Facebook.
Read more.
In this session, recent query acceleration trends in data warehouse workloads including column stores, disk filtering, hardware acceleration, SSD, MPP and SQL coprocessors will be compared. We’ll describe in detail Kickfire’s dataflow hardware acceleration and provide real-world examples from our enterprise customers.
Read more.
Performance Schema is a major new MySQL Server feature which shows where we're going with monitoring and performance measurement.
Read more.
Einstein was wrong, you can make time stand still (or at least make it appear to when building your next BI application). Traditional business intelligence technologies have limited the development of BI applications to the classic waterfall model. With the release of Pentaho Data Integration / Kettle 4.0, the first integrated ETL, data modeling and visualization development environment...
Read more.
This talk introduces Sqoop, the open source SQL-to-Hadoop tool. Sqoop helps users perform efficient imports of data from MySQL and other databases to Hadoop's distributed file system, where it can be processed in concert with other data sources. Sqoop also allows users to export Hadoop-generated results back to MySQL and other systems for use with other data pipelines.
Read more.
Learn how Infobright's columnar analytic database delivers very fast query response against large volumes of data without indexes, data partitioning or other DBA effort. Includes case studies on the leading mobile analytics company who saw query response time reduced from many minutes to just seconds and a large energy company who had data compression of 98% and implemented a data mart in weeks.
Read more.
This presentation provides an overview of Pentaho Data Integration (a.k.a. Kettle) with a focus on how it can help you to work with MySQL databases.
Read more.
After a short introduction this talk will describe new features in the plugin API - new plugin types, with use cases and examples, and Server Services - the solution to the main problem that prevents a true binary plugin independence.
Read more.
The OQGRAPH (GPLv2+) engine allows you to deal with hierarchies (such as category trees) and graphs (such as social networks) right inside your database. It works together with other storage engines (such as InnoDB) using normal joins. there are no SQL syntax additions or changes.
Read more.
Are you interested in splitting your application's reads and writes, so writes go to the master and SELECT queries go to slaves? This session is for you. Learn common patterns, pitfalls, and solutions.
Read more.
MySQL Security and User Administration is now made easy. Grant all on *.* no more. With SECURICH it is very easy to grant privileges on all but a few tables, make use of roles (groups of privileges), clone, rename, block or unblock users. You can set password complexity, history, expiry and you can do all this using either command line or an open-source, GUI cross platform tool called SAM-My.
Read more.
If you're using or planning to use an Object-Relational Mapping (ORM) library
for PHP, this talk is for you. We'll survey common ORMs available and see how to use them,
including relevant design patterns.
Additionally, we'll examine potential pitfalls that can lead to poor performance and other side
effects if you use ORMs in their default manner or without understanding what they do.
Read more.
SQL Injection is one of the most common and most serious threats to web application security. In this presentation, you'll see some myths busted, you'll get a better understanding of SQL Injection, and you'll learn simple and effective techniques to combat it.
Read more.
MySQL is becoming more and more popular as a DB for business intelligence and data warehouse solutions. The implementation of these solutions are often based on an approach that is typical of commercial DBs and expensive HW. In this session we will present the best techniques to use MySQL in a OLAP environment, for modelling, loading, querying, caching and indexing multidimensional DBs.
Read more.
Not primarily thought of as a geospatial data store, MySQL is making huge strides in this field. A branch is being developed on MySQL forge that is implementing all functionality defined by the Open GeoSpatial Consortium(OGC). This tutorial will combine a geospatial programming crash course with real world examples integrating MySQL geospatial storage and functionality into existing applications.
Read more.
Not primarily thought of as a geospatial data store, MySQL is making huge strides in this field. A branch is being developed on MySQL forge that is implementing all functionality defined by the Open GeoSpatial Consortium(OGC). This tutorial will combine a geospatial programming crash course with real world examples integrating MySQL geospatial storage and functionality into existing applications.
Read more.
InfiniDB is a scalable, column-oriented database purpose-built for data warehousing and analytical workloads. Session attendees will learn how to leverage InfiniDB to build a future-proof information management infrastructure that can continually scale to meet evolving user, data and performance needs.
Read more.
MySQL data types do not support the SQL standard WITH TIME ZONE attribute. How do you store times in MySQL to efficiently show your customers times in their own time zone?
Read more.
Two MySQL engineers who have worked on developing stored procedures or related features will walk through the whole thing.
Read more.
Two MySQL engineers who have worked on developing stored procedures or related features will walk through the whole thing.
Read more.
Before you throw away the binary logs that you use for replication, transform them into an analysis tool. Use them to track the frequency of inserts, updates and deletes on all of your tables. Maintain a history of the response times of your most frequent write queries.
Read more.
Need instant results to your queries? Learn how to become a real-time data and analytics expert by adding Streaming SQL to your MySQL skill set. SQLstream's streaming SQL architects will introduce you to key concepts in Stream Computing using SQL:2008 & MySQL, followed by real world examples
Read more.
Sphinx is a FOSS full-text search engine that makes searching MySQL databases a breeze. This talk covers a number of recently developed advanced Sphinx features (RT indexes, parallel searching improvements, subquery caches, hitless indexes, "blended" indexing, SphinxQL interface, etc) in detail, explaining how and why to use them in your application.
Read more.
Join us as we present the best of Wednesday night's Ignite MySQL presentations.
Read more.
Facebook runs MySQL on commodity servers. Commodity servers have become extremely fast. Learn about the methods we use to identify performance bottlenecks in MySQL and the projects we have completed or started to keep pace with hardware advances.
Read more.
Lucene is a powerful, high-performance, full-featured text search engine library.
In this presentation, learn how you can use Lucene with MySQL to offer powerful searching capabilities to your stakeholders. This session is highly recommended for those looking to add full-text cross-platform, database independent search capability to their application.
Read more.
Caching is a powerful weapon in the arsenal of an enterprise data architect. Designing an optimal caching strategy for your organization can increase performance and help save cost, but a poorly designed caching strategy often hurts more than it helps. We will cover strategies encompassing popular options available for caching.
Read more.
A demo of downloadable publicly available as-of-April-2010 MySQL alphas + betas.
Read more.
Why start a new database company? What is RethinkDB all about? What will database technology look like twenty years from now? In this talk we will explore these questions, present some of the exciting technology we've been developing at RethinkDB, and show how it fits into our larger vision of what database systems may look like in the future
Read more.