Aug 23, 2018

MySQL Performance Optimization and Troubleshooting with Percona Monitoring and Management

Peter Zaitsev (Percona) delivers the talk, "MySQL Performance Optimization and Troubleshooting with Percona Monitoring and Management ", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBA's. The databases powering your applications need to be able to handle...

Percona Live SessionsMySQLMonitoring and OperationsPerformance OptimizationMySQL-related Technologies


Aug 23, 2018

TimescaleDB: Re-Engineering PostgreSQL as a Time-Series Database Unlisted

Mike Freedman (Timescale) delivers the talk, "TimescaleDB: Re-Engineering PostgreSQL as a Time-Series Database", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

Time-series data is now everywhere and increasingly used to power core applications. It also creates a number of technical challenges: to ingest high volumes of data; to ask complex, queries for recent and historical time...

Percona Live SessionsOpen Source DatabasePostgreSQL


Aug 23, 2018

Highway Safety: Street Signs to Watch For When Running Galera Clusters

Marco Nicosia (Pivotal Software) delivers the talk, "Highway Safety: Street Signs to Watch For When Running Galera Clusters", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

Planning to run MySQL, but want HA or horizontal scaling? Galera seems like the perfect fit! It can be, so long as your developers are aware of several important hazards. Galera's documentation hints at these, but...

Percona Live SessionsContainers and AutomationMySQLScalabilityMySQL-related Technologies


Aug 23, 2018

Distributed PostgreSQL

Simon Riggs (2ndQuadrant) delivers the talk, "Distributed PostgreSQL", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

This session is a review of the various ways in which PostgreSQL allows you to distribute your data across multiple nodes: remote data access, replication, sharding, distributed query and multi-master.

Percona Live SessionsPostgreSQLReplication


Aug 23, 2018

Aurora PostgreSQL Deep Dive

Grant McAlister (Amazon Web Services) delivers the talk, "Aurora PostgreSQL Deep Dive", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

In this session, we will dive deep into the unique features and changes that make up Aurora PostgreSQL - including understanding the architectural differences that contribute to improved scalability, availability, and durability. Some of the items that...

Percona Live SessionsPostgreSQLCloudScalabilityCloud Solutions


Aug 21, 2018

"Triggers" in MongoDB

Antonios Giannopoulos (ObjectRocket), Jason Terpko (ObjectRocket) delivers the talk, "'Triggers' in MongoDB", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

A database trigger is a stored procedure that is executed when specific actions occur within a database. Triggers fit perfectly on a relational schema (foreign keys) and are implemented as a built-in functionality on popular...

Percona Live SessionsMongoDB


Aug 21, 2018

Designing and launching the next-generation database system @ Slack: from whiteboard to production

Guido Iaquinti (Slack) delivers the talk, "Designing and launching the next-generation database system @ Slack: from whiteboard to production", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

Slack is a messaging platform for teams that brings all communication together, creating a single unified archive accessible through powerful search.

MySQL is the primary storage for all...

Percona Live SessionsMySQLMySQL-related Technologies


Aug 20, 2018

Securing Access to Facebook's Databases

Andrew Regner (Facebook) delivers the talk, "Securing Access to Facebook's Databases", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

Since the beginning, Facebook has used a conventional username/password to secure access to production MySQL instances. Over the last few years we've been working on moving to x509 TLS client certificate authenticated connections. Given the many types...

Percona Live SessionsMySQLSecurityMySQL-related Technologies


Aug 20, 2018

Meet MariaDB 10.3

Vicentiu Ciorbaru (MariaDB Foundation) delivers the talk, "Meet MariaDB 10.3", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

MariaDB 10.3 is rapidly approaching GA status. This talk will go through all new features coming in MariaDB 10.3. Highlights are:
* Oracle Compatibility Layer
* System Versioned Tables
* Custom Aggregate Functions

Percona Live SessionsMariaDB


Aug 20, 2018

Taskerman: A Distributed Cluster Task Manager

Raghavendra Prabhu (Yelp) delivers the talk, "Taskerman: A Distributed Cluster Task Manager", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

At Yelp we have a constantly growing polyglot data tier consisting of data stores such as Cassandra, Elasticsearch, MySQL, and Zookeeper. These distributed datastores often ask to be treated like pets but can only be reared like cattle given the...

Percona Live SessionsCloudMySQLMonitoring and OperationsMySQL-related Technologies


Pages