February 28 - March 1, 2013
Montreal, Canada

Data Persistance Conference

Data Persistance MySQL indexes are often used to make performance better. However, they can make performance suffer if you are not using them properly. Oracle ACE Director Sheeri Cabral explains the pitfalls to avoid with indexes and how to utilize compound indexes to maximize index availability with the least amount of write overhead.
Data Persistance Database servers have hardware requirements different from other infrastructure software, specifically unique demands on I/O and memory. This presentation covers these differences and various I/O options and their benefits. Topics include solid-state drives (SSD), battery-backed RAID, controllers, and caching.
Data Persistance Dealing with lots of data can be daunting, if not done well it can affect the performance of your applications. Data has business value though and can't be ignored.

Storing it, dealing with it and mining it have huge rewards and can be fun. I'll cover some theory but the emphasis will be on the practical.
Data Persistance In this presentation, Sheeri Cabral will explain the differences and similarities among Oracle's MySQL, MariaDB, Drizzle, and the Percona patchset. You will learn the coding philosophies of the organizations behind the software, and how they interact with the community, so you can choose which fork is right for you.
Data Persistance ES provides an easy path to full-text search, synonyms, faceting, and geographic math, but there's a paucity of written wisdom beyond its API docs. This talk provides a survey of its capabilities and dives into the practical tradeoffs in a high-volume ES system, from indexing structures to the realities of deployment. Outline: http://bit.ly/OQxMje
Data Persistance PostgresSQL contains a very rich set of datatypes, richer than most other databases. Some are built into the core PostgreSQL, some are available as easy to install extensions. This means that if you choose and use the correct datatype, you get lots of additional functionality in your system, completely for free.
Data Persistance PostgreSQL 9.1 arrived with a new featured called KNN-GiST, or fast K-Nearest-Neighbour searching. Many people don't realize what that means, and what they're good for. This walk will look into both the more obvious geometrical and geographical cases, as well as the more surprising use-cases such as string matching and similarity
Data Persistance This talk introduces MongoDB. I will cover MongoDB's basic functionality, but also introduce replication and sharding. Focussing mostly on schema design and indexing gives you a solid base to get started with this scalable and high-performance document-oriented NoSQL database but also understand the design principles and use-cases.
Data Persistance Neo4j is a Java-based server to manage graphs of data. Nodes and edges - thinks people and friendship relations. This session will present the libraries available in PHP to communicate with this NoSQL server along with a few general strategies to use them efficiently to create well performing applications.
Data Persistance Emailing *.sql files to the in-house DBA before each release used to work for your single-node, single-environment website. You have recently been tasked with building a multi-environment application architecture when you realize that you need to come up with a more professional process which is less error-prone.
Data Persistance PHP and MySQL are the foundation of many web applications. Still many developers scratch only the surface of the provided interoperability between PHP and MySQL. In this session you will learn hidden gems and new features in these area both on PHP's and MySQL's side. Things like automatic load balancing or caching features or memcache integration.
Data Persistance More than some arcane NoSQL tool, Redis is a simple but powerful swiss army knife you can begin using today.

This talk introduces Redis and focuses on using it to cleanly solve everyday problems. Along the way, you'll learn how Redis can be used as an alternative to several common PHP tools.
Data Persistance The MySQL database is fast but still system performance has limits. For read-load MySQL's replication system is a known and proven way for scaling out. But what about write-loads? This session will discuss the latest state about sharding in MySQL. From a basic setup to later shard management an further improvements.
Data Persistance This talk explores the much-anticipated Postgres 9.0 features of hot standby and streaming replication. It explains how these features work, how to configure them, and their current limitations. It includes a hands-on demonstration that can be done either by the instructor or by students.

Explore all 155 sessions

Sponsored by

Media