Dec 9, 2019

Introduction to MySQL Query Tuning for DevOps

MySQL does its best to return requested bytes as fast as possible. However, it needs human help to identify what is important and should be accessed in the first place. Queries, written smartly, can significantly outperform automatically generated ones. Indexes and Optimizer statistics, not limited to the Histograms only, help increase the speed of the query.

DeveloperMySQLOperations


Aug 27, 2018

Lessons We Learned Developing Infrastructure Software at Box

Aleksandr Kuzminsky (Box) delivers the talk, "Lessons We Learned Developing Infrastructure Software at Box", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

As any modern DBA we lean more towards development daily activities. We write more software and do less routine tasks.

Along the way to development workflow full automation, we faced many problems. The session covers...

Percona Live SessionsContainers and AutomationDeveloper


Aug 20, 2018

Database Evolution in the Cloud Panel

Lixun Peng (Alibaba Cloud), Sunil Kamath (Microsoft), Baron Schwartz (VividCortex), Ann Schlemmer (Percona), Shawn Briscoe (Percona) delivers the talk, "Database Evolution in the Cloud Panel", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

How companies build applications and deploy databases has changed drastically over the last 5 years. Enterprises are moving applications and...

Percona Live SessionsDeveloperCloudNew Tech & TrendsMonitoring and OperationsCloud Solutions


Aug 13, 2018

Ghostferry: the Swiss Army Knife of Live Data Migrations with Minimum Downtime

Shuhao Wu (Shopify Inc.) delivers the talk, "Ghostferry: the Swiss Army Knife of Live Data Migrations with Minimum Downtime", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

Existing tools like mysqldump and replication cannot migrate data between GTID-enabled MySQL and non-GTID-enabled MySQL -- a common configuration across multiple cloud providers that cannot be changed. These tools...

Percona Live SessionsDeveloperCloudMySQLMigrationCloud Solutions


Aug 10, 2018

Combine the power of OSS DB engines and Microsoft Azure to migrate existing apps or build new apps

Sunil Kamath (Microsoft) delivers the talk, "Combine the power of OSS DB engines and Microsoft Azure to migrate existing apps or build new apps", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

Azure provides fully managed, enterprise-ready community MySQL and PostgreSQL services that are built for developers and devops engineers. These services use the community database technologies...

Percona Live SessionsDeveloperPostgreSQLMySQLPerformanceSecurityHigh Availability