Lightning Talks

Monday 5:20PM

@ Demo Theater in the Exhibit Hall

Mariella Di Giacomo - ViaSat

Determining the best and most suitable relational database management system (RDBMS) for a given project isn't an easy task and it can be rather challenging at times. It is like benchmarking fast cars created by different racing teams!
The presentation will compare, using a large body of experimental results, two highly-available cloud closed-source products, Amazon Aurora MySQL and RDS MySQL, both based on the Open Source MySQL Edition.
Both use cases have demonstrated that MySQL is a great
solution for concurrent writes, reads and read and write traffic.
Additionally, both scenarios have proven to be successful, satisfying data integrity, reliability and scalability with different outcomes.


perc@rjweb.org
 Experience: Beginner
Business / Case Studies

Monday 5:25PM

@ Demo Theater in the Exhibit Hall

Kayla Boyer - Shopify

The role of the DBA is evolving, as more companies and products move to a hybrid model where, along with their traditional work, DBAs are expected to code. We've scaled our Data Stores team to bring in pure developers, pure DBAs, and a mix of both. We were able to find creative ways to help support our DBAs to better adapt to the changes in the industry. We're discovering how increasingly complex it is to find candidates with this mix of experience, and through learning from our struggles we have learned the best methods to find DBAs and to help them evolve. We want DBAs to be prepared for this new world and would love to share our industry findings with this community.


king.jen@shopify.com
 Experience: Advanced
Operations

Monday 5:30PM

@ Demo Theater in the Exhibit Hall

Øystein Grøvlen - Oracle

One of the most popular new features of MySQL 5.7 was JSON support. Now you can use SQL to search, extract information from, and change JSON documents. MySQL 8.0 takes this a step further. Using the JSON_TABLE function, you will be able to construct relational tables based on the contents of JSON documents. This way, you will be able to use the power of SQL to process JSON. For example, you can use SQL aggregate functions on your JSON data, or use the WHERE clause to find interesting objects within a JSON array.

This lightning talk will give a short introduction into how JSON_TABLE provides the missing link when processing JSON documents in MySQL.


Administration
 Experience: Intermediate
Developer

Monday 5:40PM

@ Demo Theater in the Exhibit Hall

Laurent Kolakofsky - Indeed.com

Scaling MySQL infrastructure is challenging, traditional setup don't scale horizontally and require manual configuration management.

This talk is about how we scaled MySQL infrastructure at Indeed. Using HaProxy, we dynamically take backends in/out of rotation based on replication lag. Through this proxy, we load-balance reads across a pool of replicas, ensure replication lag is below a threshold, and easily take replicas out of rotation for maintenance, removing the work of manually updating application's configuration.

You will also learn about different routing strategy we use, such as fail-to-primary vs fail-open, and about surprising application connection pool's behaviors we learned along the way.


MySQL / MariaDB
 Experience: Intermediate
Operations

Monday 5:45PM

@ Demo Theater in the Exhibit Hall

Michael Wang - Salesforce

In master/slave replication cluster, there are many branch nodes. They are full-blown database servers yet its only purpose is to serve binlogs to its slaves.

Blackhole storage engine does not storage any data in the table, but allows the transactions to be recorded in the binlogs. Therefore it is suitable as binlog servers with reduced capacity requirements.

With the release of Percona server 5.7.20-19 in January 2018, MySQL server becomes a viable solution as it fixes two critical bugs related to blackhole engine.

This talk describes the implementation details.


MySQL / MariaDB
 Experience: Intermediate
Business / Case Studies, Operations

Wednesday 4:00PM-4:05PM

@ Demo Theater in the Exhibit Hall

Amazon Aurora MySQL and RDS MySQL: Lessons learned (Lightning Talk)

Mariella Di Giacomo - ViaSat

Determining the best and most suitable relational database management system (RDBMS) for a given project isn't an easy task and it can be rather challenging at times. It is like benchmarking fast cars created by different racing teams!
The presentation will compare, using a large body of experimental results, two highly-available cloud closed-source products, Amazon Aurora MySQL and RDS MySQL, both based on the Open Source MySQL Edition.
Both use cases have demonstrated that MySQL is a great
solution for concurrent writes, reads and read and write traffic.
Additionally, both scenarios have proven to be successful, satisfying data integrity, reliability and scalability with different outcomes.


 Experience: Beginner
Business / Case Studies

Wednesday 4:05PM-4:10PM

@ Demo Theater in the Exhibit Hall

JSON_TABLE - The Best of Both Worlds

Øystein Grøvlen - Oracle

One of the most popular new features of MySQL 5.7 was JSON support. Now you can use SQL to search, extract information from, and change JSON documents. MySQL 8.0 takes this a step further. Using the JSON_TABLE function, you will be able to construct relational tables based on the contents of JSON documents. This way, you will be able to use the power of SQL to process JSON. For example, you can use SQL aggregate functions on your JSON data, or use the WHERE clause to find interesting objects within a JSON array.

This lightning talk will give a short introduction into how JSON_TABLE provides the missing link when processing JSON documents in MySQL.


Administration
 Experience: Intermediate
Developer

Wednesday 4:10PM-4:15PM

@ Demo Theater in the Exhibit Hall

Scaling MySQL with HaProxy

Laurent Kolakofsky - Indeed.com

Scaling MySQL infrastructure is challenging, traditional setup don't scale horizontally and require manual configuration management.

This talk is about how we scaled MySQL infrastructure at Indeed. Using HaProxy, we dynamically take backends in/out of rotation based on replication lag. Through this proxy, we load-balance reads across a pool of replicas, ensure replication lag is below a threshold, and easily take replicas out of rotation for maintenance, removing the work of manually updating application's configuration.

You will also learn about different routing strategy we use, such as fail-to-primary vs fail-open, and about surprising application connection pool's behaviors we learned along the way.


MySQL / MariaDB
 Experience: Intermediate
Operations

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA