Peter Zaitsev (Percona) delivers their talk "MySQL Monitoring with Percona Monitoring and Management" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.
In this talk, I will introduce Percona’s latest open source software tool: Percona Monitoring and Management (PMM). I will briefly discuss high-level aspects of monitoring we’ve found work well in practice at Percona, and then spend...
Marco Tusa (Percona) delivers his talk "Use ProxySQL to Improve Your MySQL High Availability Solution" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.
ProxySQL is a flexible, fast and highly configurable piece of software that provides dramatic improvement to your cluster and high availability (HA) architecture.
The presentation will discuss how to deploy ProxySQL in...
Geir Høydalsvik (Oracle) delivers his talk "MySQL 8.0: Major new features" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.
In this session, I will describe the new features that have all ready been announced for MySQL 8.0.
In addition to Data Dictionnary, CTEs and windows function the session is covering:
* Move to utf8(mb4) as MySQL's default character set
*...
John Schulz (Pythian) delivers his talk "B-Trees, Fractal Trees, Heaps and Log Structured Merge Trees, Where did they all come from and Why?" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.
For many years the B-Tree has reigned supreme as the data structure of choice for most databases. There have always been a few other data structures used as well but they were generally not...
Mark Filipi (SurveyMonkey), Brian Cain (Dropbox) delivers his talk, "MySQL GTID Implementation, Maintenance, and Best Practices - The Short Version", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.
Many MySQL shops have made the transition from MySQL 5.5 to 5.6 in the last few years, but GTID (global transaction identifier) implementation has often been considered too difficult or...
Matthew Lang (Continuent) delivers his talk, "Multi-Site, Multi-Master Done Right", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.
The MySQL marketplace has quite a few High-Availability (HA) solutions such as Continuent Tungsten, Galera/XtraDB Cluster, various MySQL script/patch solutions, and RDS with multi-zone HA. Providing seamless, automatic failover with zero down-time...
Adamo Tonete (Percona) delivers his talk, "MongoDB Index Types, How, When and Where Should They be Used?", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.
MongoDB has 12 index types. Do you know how each works, or when each should be used. This talk is about arming you with this knowledge as well as understanding how the index impact performance, storage, and even sharding of your data...
Alexander Rubin (Percona) delivers his talk, "MongoDB and MySQL: JSON, Document Store Perspectives", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.
In this session, we will explain what tradeoffs both MySQL and MongoDB make in their document models. We will look into what use cases will do better in which style and why. Leaving the talk you should have a good foundation to help weigh...
Chris Larsen (Yahoo Inc.) delivers his talk, "OpenTSDB - Time Series Schema on Schemaless NoSQL", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.
This talk will cover the special case of time series data and the evolution of various schemas from RRD files to RDBMS schemas to NoSQL stores. Particularly we'll focus on why, as the amount of time series data grows and slicing the data by...
Konstantin Osipov (Tarantool.org) delivers his talk, "Vinyl: why we wrote our own write-optimized storage engine rather than chose RocksDB", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.
Tarantool 1.7 features a new storage engine for solid state and rotating disks: Vinyl. Vinyl implements log structured merge trees, just like Cassandra or RocksDB.
In this talk, I will begin...
Patrick King (Yelp) delivers his talk, "PostgreSQL to MySQL: A DBA Perspective", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.
Come on a journey with Patrick as he walks you through his transformation from a PostgreSQL DBA to a MySQL DBA. This talk will be a story of Patrick's journey where we'll walk through some of the major differences between PostgreSQL and MySQL and how we use...
Sailesh Krishnamurthy (Amazon Web Services) delivers his talk, "Amazon Aurora: A deep-dive into what's new", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.
Amazon Aurora is a fully managed relational database engine that combines the speed and availability of high-end commercial databases with the
simplicity and cost-effectiveness of open source databases. It is purpose-built...
Jean-François Gagné (Booking.com) delivers his talk, "MySQL/MariaDB Parallel Replication: inventory, use cases and limitations", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.
In the last 24 months, MySQL/MariaDB replication speed has improved a lot, thanks to parallel replication. MySQL and MariaDB Server have different types of parallel replication; in this talk, I present the...
Bimal Kharel, Senior Technical Services Engineer, Percona delivers his talk, "Understanding all the Options for Replica-sets and Replication Patterns", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.
MongoDB Replication Tags, hidden notes, priority, votes and more are some of the least understood parts of MongoDB. We will talk about these how to consider using them or not using them,...
Michael J. Freedman, Co-founder/CTO, Timescale - Professor of Computer Science, TimescaleDB delivers his talk, "Building a scalable time-series database on PostgreSQL", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.
Today everything is instrumented, generating more and more time-series data streams that need to be monitored and analyzed. When it comes to storing this data, many...
Siying Dong, Software Engineer, Facebook Inc delivers his talk, "Six New Important RocksDB Features And Planned Works", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.
In the previous year, many RocksDB features were added. In this talk we explain the six most important ones: bulk loading, persistent cache, Lua compaction filter, blob storage, range delete and direct I/O. We also...
Dharshan Rangegowda, CEO, ScaleGrid delivers his talk, "Deploying mongodb on public clouds: Architecture and options", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.
Public clouds like AWS & Azure have become very popular platforms over the past few years. These public clouds provide a plethora of infrastructure features to help make your life easier - we will dig into the...
Álvaro Hernández, CEO, 8Kdata delivers his talk, "ToroDB Stampede: open-source BI connector for MongoDB", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.
There are many valid reasons to want your MongoDB data to interact with the relational/SQL ecosystem: the humongous amount of tools available; the ability to use the SQL query language; or the need for really fast aggregate queries....
Eric Ferreira, Principal Engineer, AWS, Amazon delivers his talk, "How innovation happens on Amazon Redshift", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.
Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to efficiently analyze all your data using your existing business intelligence tools.
How we got there...
Vicentiu-Marian Ciorbaru, Software Engineer, MariaDB Foundation delivers his talk, "Common Table Expressions and Window Functions simple, maintainable, fast queries", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.
MariaDB Server 10.2 has brought two new important querying features, Common Table Expressions (CTEs) and Window Functions. Both features provide, greater expressibility to...
For general inquiries, please send us your question and someone will contact you.
