May 4, 2017

MySQL 8.0: Data Dictionary : An Internal Server Component that really matters

Ståle Deraas (Oracle) delivers his talk, "MySQL 8.0: Data Dictionary: An Internal Server Component that really matters", on DAY 3 of the Percona Live Open Source Database Conference 2017, 4/27, at Santa Clara, CA.

A new data dictionary based on transactional tables is being developed for MySQL Server. People could already play with it in the 8.0.0 dmr. This project is a huge step forward, improving many aspects of the server even...

Percona Live SessionsMySQL


May 4, 2017

Protecting MySQL network traffic

Daniël van Eeden, DBA from Booking.com delivers their talk, "Protecting MySQL network traffic", on DAY 1 of the Percona Live Open Source Database Conference 2017, 4/25, at Santa Clara, CA.

If your MySQL connections travel trough your network and maybe even over the internet then there are many possibilities where someone could eavesdrop. Protecting this with SSL (or TLS actually) is the obvious solution, but there are many SSL...

Percona Live SessionsMySQLOperations


May 4, 2017

Yahoo Case Study: MySQL Xtrabackup and its Recovery Scenario

Stacy Yuan (Yahoo), Kushal Shah (Yahoo), Yngve Eriksson (Yahoo) delivers their talk, "Yahoo Case Study: MySQL Xtrabackup and its Recovery Scenario", on DAY 3 of the Percona Live Open Source Database Conference 2017, 4/27, at Santa Clara, CA.

In this case study, we will present Yahoo's backup and recovery strategy.
We will present:
How to optimize backups of large amounts data using full, incremental, compress,...

Percona Live SessionsMySQLPercona XtraBackup


May 4, 2017

Load Data Fast!

Bill Karwin, Senior Database Architect at SchoolMessenger delivers their talk, "Load Data Fast!", on DAY 1 of the Percona Live Open Source Database Conference 2017, 4/25, at Santa Clara, CA.

We all have tasks from time to time for bulk-loading external data into MySQL. What's the best way of doing this? That's the task I faced recently when I was asked to help benchmark a multi-terabyte database. We had to find the most efficient...

Percona Live SessionsMySQL


May 4, 2017

Demystifying Benchmarks: How to Use Them To Better Evaluate Databases

Peter Friedenbach, Performance Architect from Clustrix, Inc. delivers their talk, "Demystifying Benchmarks: How to Use Them To Better Evaluate Databases", on DAY 1 of the Percona Live Open Source Database Conference 2017, 4/25 at Santa Clara, CA.

When looking for the “right” RDBMS for your application, there are many variables you need to consider to ensure you make the right choice. Not all databases are created equal, and you...

Percona Live SessionsBusiness / Case Study


May 4, 2017

AliSQL: breakthrough for the future

Wei Hu (Alibaba), Dengcheng He (Alibaba) delivers their talk, "AliSQL: breakthrough for the future", on DAY 3 of the Percona Live Open Source Database Conference 2017, 4/27, at Santa Clara, CA.

Last year, we joined Percona live the very first time and bring the world AliSQL, a MySQL branch maintained by Alibaba Database Team. We share many improvements we made on AliSQL, including Column Compression, Double Redo Buffer, "Hot SKU...

Percona Live SessionsMySQL


May 3, 2017

MyFlashSQL: Flash is more than faster-harddisk

Sang-Won Lee, Professor, Sungkyunkwan University delivers his talk, "MyFlashSQL: Flash is more than faster-harddisk", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.

We are witnessing the advent of all-flash era. As pure read/write block device, flash SSD simply outperforms harddisk in terms of IOPS and cost-effectiveness. But this is not the whole story. As IO device, flash SSD has...

Percona Live SessionsMySQLNew Tech & TrendsStorageOperations


May 3, 2017

How to Build a State Machine on MongoDB and Redis

Niki Castle delivers her talk, "How to Build a State Machine on MongoDB and Redis", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.

CRM platform Appboy uses MongoDB for its storage, with a Redis caching layer used in a variety of ways to maximize performance for the real-time messaging and analytics we view as crucial to a communication platform. Niki Castle, a software engineer at...

Percona Live SessionsMongoDBOperationsConfigurationOperations


May 3, 2017

Experiences using gh-ost in a multi-tier topology

Valerie Parham-Thompson, Ivan Groenewold (Pythian) deliver their talk, "Experiences using gh-ost in a multi-tier topology", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.

In this session we will share our experiences using gh-ost for long-running schema changes in a multi-tier replication topology under high-volume traffic. This will include sharing how gh-ost can work with...

Percona Live SessionsMySQLNew Tech & TrendsOperations


May 3, 2017

sysbench 1.0: teaching old dog new tricks

Alexey Kopytov, Software Engineer, delivers their talk, "sysbench 1.0: teaching old dog new tricks", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.

sysbench is a benchmark tool that is quite ubiquitous in the MySQL community. It is used by both beginners and huge corporations alike as a quick way to evaluate general system performance, a universal measuring tool to compare...

Percona Live SessionsBusiness / Case StudyMySQLOperationsOperationsPerformance OptimizationQuery Tuning and Optimization


Pages