Aug 13, 2018

Monitoring PostgreSQL with PMM (Percona Monitoring and Management)

Michael Coburn (Percona) delivers the talk, "Monitoring PostgreSQL with PMM (Percona Monitoring and Management)", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

Learn how to monitor PostgreSQL using PMM (Percona Monitoring and Management) so that you can:
* Gain greater visibility of performance and bottlenecks PostgreSQL
* Consolidate your PostgreSQL servers into the same...

Percona Live SessionsPostgreSQLPerformanceMonitoring and OperationsPercona Open Source Software


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 13, 2018

External Authentication with Percona Server for MongoDB and MongoDB Enterprise

Jason Terpko (ObjectRocket) delivers the talk, "External Authentication with Percona Server for MongoDB and MongoDB Enterprise", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA. This presentation will discuss implementing external authentication when using Percona Server for MongoDB and MongoDB Enterprise. It will review authentication using OpenLDAP or ActiveDirectory and ActiveDirectory with...

Percona Live SessionsMongoDBConfiguration


Aug 13, 2018

MySQL: How to Save Bandwidth

Georgi Kodinov (Oracle) delivers the talk, "MySQL: How to Save Bandwidth ", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

The full title of this presentation should be: "Save some bandwidth by not transmitting the full resultset metadata over the wire when you don't need it." Indeed, one the latest features in the MySQL protocol allows you to save some network bandwidth by not...

Percona Live SessionsMySQLMySQL 101


Aug 13, 2018

MySQL 8.0: What is New in Optimizer and Executor?

Manyi Lu (Oracle) delivers the talk, "MySQL 8.0: What is New in Optimizer and Executor?", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

There are substantial improvements in the Optimizer in MySQL 8.0. Most noticeably, we have added support for advanced SQL features like common table expressions, windowing functions and grouping() function. We also made DBAs' lives easier with...

Percona Live SessionsMySQLMySQL 101Performance


Aug 13, 2018

Your First MongoDB Environment: What You Should Know Before Choosing MongoDB as Your Database

Adamo Tonete (Percona) delivers the talk, "Your First MongoDB Environment: What You Should Know Before Choosing MongoDB as Your Database", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

In this 101 topic, we are going to discuss the advantages and disadvantages of MongoDB.

For who never worked with MongoDB and are considering migrating to this database this talk will give you a...

Percona Live SessionsMongoDBMongoDB 101


Aug 13, 2018

Accelerating MySQL with JIT Compilers

David Yeager (Dynimize) delivers the talk, "Accelerating MySQL with JIT Compilers", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

Accelerating MySQL with Just-In-Time (JIT) compilation is emerging as a quick and easy way to achieve greater efficiencies with MySQL. In this talk, l'll go over the benefits and caveats of using Dynimizer, a binary-to-binary JIT compiler, with MySQL...

Percona Live SessionsMySQLPerformanceMySQL-related Technologies


Aug 13, 2018

Scaling a High-Traffic Database: Moving Tables Across Clusters

Bryana Knight (GitHub) delivers the talk, "Scaling a High-Traffic Database: Moving Tables Across Clusters", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

While GitHub isn't the biggest database around in terms of the amount of data we hold in MySQL, it is among the top 50 busiest sites on the internet. Facing an immediate need to distribute load, we came up with creative ways to move...

Percona Live SessionsMySQLReplicationMonitoring and OperationsScalability


Aug 13, 2018

Securing Your Data on PostgreSQL

Payal Singh (OmniTI Computer Consulting Inc.) delivers the talk, "Securing Your Data on PostgreSQL", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

While most applications are aware of the minimum basic security features, there is often a lack of understanding about how best to manage them, especially with major security features being released with every major version of Postgres. As...

Percona Live SessionsPostgreSQLSecurity


Aug 13, 2018

How Microsoft Built MySQL, PostgreSQL and MariaDB for the Cloud

Jun Su (Microsoft) delivers the talk, "How Microsoft Built MySQL, PostgreSQL and MariaDB for the Cloud", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

Offering MySQL, PostgreSQL and MariaDB database services in the cloud is different than doing so on-premise. Latency, connection redirection, optimal performance configuration are just a few challenges. In this session, Jun Su will...

Percona Live SessionsPostgreSQLCloudMariaDBMySQLPerformance OptimizationScalabilityCloud Solutions


Pages