Oct
04
2019
--

Top 5 Takeaways from Percona Live Europe 2019

Percona Live Europe Wrap Up

Percona Live Europe Wrap UpIt’s a wrap! Another Percona Live Europe is in the books and we want to thank everyone for making it an amazing event.

A special shout-out to this year’s sponsors: AWS, PlanetScale, Altinity, Galera Cluster, MySQL, Shannon Systems, Tarantool, Booking.com, Free Software Foundation, MariaDB, Open Source Initiative, HPCwire, Datanami, and Enterprise AI.

We saw lots of first-time attendees, and it was great to welcome them into the open source community. Many sessions were standing-room-only and the keynotes were, as usual, the highlight of the week.

Here are our key takeaways from the week:

#1. Monitoring & Management Got Better

We debuted v2 of our award-winning database monitoring tool, Percona Monitoring and Management, a single-pane-of-glass to monitor the performance of MySQL, MariaDB, MongoDB, and PostgreSQL database environments.

This version offers new performance and usability query improvements, new query analytics for PostgreSQL, new labeling with Leverage Standard (system-generated) and Custom tags, as well as a new administrative API.

“With users’ expectations for application speed and availability at an all-time high, companies require quicker and deeper insight into their database performance bottlenecks, a higher-level perspective of multiple systems they monitor, and the ability to monitor larger and more complex systems. PMM2 delivers on all these requirements and more,” said Peter Zaitsev, co-founder, and CEO of Percona. ~ DBTA

It can be used on-premises and in the cloud, and is compatible with major cloud providers such as Amazon Web Services (AWS), Google Cloud, and Microsoft Azure, with specific dashboards for AWS RDS and Amazon Aurora.

#2. Trusted Distribution

Percona Distribution for PostgreSQL was formally announced at PLE, offering the best and most critical enterprise components from the open-source community, in a single distribution, designed and tested to work together. It is an easy, yet powerful way to implement an enterprise-grade, fully open source PostgreSQL environment. Backed by Percona’s world-class support and engineering teams, it gives companies the peace of mind that these components are tested and configured to work together, with 24×7 support.

“Postgres is truly the most open of all of the most popular open source databases. So the licensing is very open, it’s very easy to contribute, it has a massive following and a massive base of contributors,” said Matt Yonkovit. “There’s a lot of awesome extensions, a lot of awesome features, a lot of awesome open source tools that are out in the ecosystem. And so there’s a lot to draw from, but the problem is, a lot of them don’t necessarily work together.”

“It was obvious that a lot of these components are already there, you just need to package them in a way that is designed to work together and minimize the bugs and the friction between these components, these extensions.”  ~ The New Stack

#3. By the Numbers

We shared the results from our 2019 Open Source Data Management Software Survey with the Percona Live Europe crowd, and the data shows some interesting trends:

  • Multi-database, multi-cloud, and hybrid are not only the reality but commonplace, with over 92% of respondents say they use more than one database.
  • Environments are getting increasingly more complex, and the larger the organization, the more complex the hosting environment.
  • The top two benefits of open source are cost savings (79.4%) and avoiding vendor lock-in (62%), but the benefit of having a community also scored over 50%.

Here’s what the press had to say about the survey:

“Companies around the world prefer to have multiple databases in multiple locations over multiple platforms, according to a report unveiled at the Percona Live 2019 event in Amsterdam,” Mayank Sharma, TechRadar

According to Ian Murphy, Enterprise Times, the Percona Open Source Data Management Survey results showed, “When Oracle bought Sun and acquired MySQL, there was an openly voiced concern for the future of open source databases. That has long been put to bed and with the rise of cloud, there are more open source based options than pure commercial ones.”

On making the results of Percona’s Open Source Data Management Survey raw data available to anyone: “We want to provide the community with a way to get this data, and use it and to make all open source databases better,” says Matt Yonkovit Percona’s Chief Experience Officer ~ Tech Radar

#4. Simple or Complex?

Matt may be biased, but his keynote about how efforts in simplicity often lead to more complexity was an important talk for our community. Even with automation, DevOps processes, and the emergence of new technology, systems still crash, databases are still breached, and “smart people still do stupid things.”

So… what can we do about it?

“We’ve strived for a long time to try and reduce the complexity of our corporate systems, especially around the database space. And what has been happening is the exact opposite of a simplification, it’s been making it more complex, it’s been making it more fractured, if you will,” said Matt Yonkovit, Percona Chief Experience Officer. ~ The New Stack

#5. The Open Source Community Rocks!

One of the best takeaways from this year’s Percona Live was just how great our community is. As mentioned in our survey results, “the benefit of having a community” was noted as a top reason to adopt open source by over 50% of our respondents—and we can see why!

From networking in the hallways to dinners and community events, the sharing and support among the community are always astounding.

You are what makes the open source community so great, and we thank you for attending and participating in Percona Live Europe. Be sure to check out our Database Performance Blog, our social media accounts (Twitter, Facebook, LinkedIn), and be on the lookout for information about Percona Live 2020 in Austin, May 18-20.

We look forward to seeing you soon!

Sep
12
2019
--

Percona University Istanbul on October 4

Percona University Istanbul 2019

Percona University Istanbul 2019The latest Percona University event will be held in Istanbul on Friday, October 4. These are free events featuring technical presentations from Percona and guest speakers. Talks are good for anyone who uses database technologies as part of their tech stack. In other words, for pretty much anyone working databases, devops, and development.

Agenda

Here’s a quick look at the talks, put together by local Perconian, Alkin Tezuysal:

  • HA MySQL on Kubernetes using Percona XtraDB Cluster and ProxySQL presented by Ananias Tsalouchidis, Senior MySQL DBA, Percona
  • Introduction to MySQL Query Tuning for Dev[Op]s presented by Sveta Smirnova, Principal Support Escalation Specialist, Percona
  • Ten Things Developers Should Know About Databases presented by Peter Zaitsev, CEO, Percona
  • 40X Database Response in a Nutshell presented by Sinan Alyuruk, Gittigidiyor / EbayTK
  • PMM Installation and Configuration for PostgreSQL and MongoDB presented by Michael Nosek and Dimitri Vanoverbeke, Solutions Engineering, Percona
  • Sharding MySQL with Vitess presented by Harun Küçük, Sahibinden.com

Find out more and register

You can see the full agenda with timings on the event page. This event is being hosted by iyzico and with the support of eBay. Thank you to both companies for helping us with Percona University Istanbul.

Places are limited, refreshments and snacks are included, so please register in advance.

Do it soon to avoid disappointment!

Percona Live Europe 2019…

Have you bought your tickets for Percona Live Europe yet? The conference takes place from September 30 – October 2 at the Hilton Schiphol. This venue is within easy reach of the airport making it feasible to just drop in for the day if that’s all the time you can spare. Take a look at the full agenda for Percona Live Europe 2019 and reserve your place soon!

Sep
06
2019
--

Security Matters at Percona Live Europe 2019

Among the most widely debated topics in technology at the moment are security and data privacy. While the industry has long been aware of the threat of security breaches, recent examples have heightened concerns. Are you doing all you can to protect your data assets, and how do you know? Submissions to Percona Live events reflect the interests of the community of users of open source databases. Consequently, for Percona Live Europe 2019, security and compliance is a hot topic.

Data security sessions

Many conference sessions will address aspects of security and compliance as part of their story. Achieving high availability, the setting up of reliable database monitoring, and implementing sound backup and recovery plans are all important parts of the challenge. Tutorials will touch on those aspects of security that are relevant to their topic.

However, the sessions listed here focus on data security concerns. Full abstracts for these talks can be found on the agenda.

MongoDB Data Security: Custom Rules and Views presented by Adamo Tonete , Percona

MongoDB supports the creation of custom rules, allowing you to hide aspects of your data from users. Adamo will explain how to implement custom rules in MongoDB.

How to Protect PII Data in MySQL While Allowing Customers to Access the Database presented by Alexander Rubin, VirtualHealth

Dealing with health data is a sensitive issue. Alexander will take a look at data isolation, encryption, data masking, and data access.

Enhancing MySQL Security presented by Vinicius Grippa, Percona

In this session, the data life cycle will be considered from creation through to archiving and deletion. What are the technical implications of compliance with GDPR and HIPAA?

Protecting Your Secrets presented by John Boero, Hashicorp

A good look at protecting credentials and how to avoid “secret spread” presented by a security specialist.

PCI/DSS Compliance with MySQL: 2019 Edition presented by Carlos Tutté, Percona

A look at the protection of card data and meeting Payment Card Industry Data Security Standards when working with MySQL applications, including consideration of its limitations.

Securing MySQL with Vault and Table Level Encryption presented by Kevin Markwardt, Pythian

How to secure MySQL user accounts with Hashicorp Vault for MySQL user account rotation and expiration.

Data Protection and OSS in the Age of GDPR presented by Cristina DeLisle, DPO XWiki SAS

The impact of GDPR on OSS and how to apply the model of data controller and data processor in the contexts of various communities and infrastructure providers. What is meant by “privacy by default and by design” and how could we envision them applied in our OSS.

Fortify Your MySQL Data Security in AWS Using ProxySQL Firewall presented by Marco Tusa, Percona

A practical approach to enhancing the security of MySQL databases with ProxySQL Firewall.

Large Scale Deployment of SSL/TLS For MySQL presented by Daniël van Eeden, booking.com

Real life experiences of deploying SSL/TLS on thousands of servers at booking.com, the problems encountered, and how they have been resolved.

You can view the full agenda or download a pdf guide to the conference sessions.Percona Live Schedule 2019

 

Sep
04
2019
--

Announcing Keynotes for Percona Live Europe 2019!

Percona Live Europe

With just under four weeks to go, we are happy to announce the keynote speakers for Percona Live Europe 2019.

With featured talks from Oracle, HashiCorp, Microsoft, and more, Percona Live provides an opportunity to network with peers and technology professionals. Mingle with all types of database community members: DBAs, developers, C-level executives, and the latest database technology trendsetters. Percona Live is the place to learn about how open source database technology can power your applications, improve your websites, and solve your critical database issues.

Without further ado, here’s the keynote line-up for 2019!

October 1, 2019

Peter ZaitsevPeter Zaitsev will kick off the event with his report on The State of Open Source Databases. Percona’s CEO will explore the current topics and trends impacting the database ecosystem, as well as the businesses that run open-source databases as part of their infrastructure. Will cloud-native surpass public cloud usage? How Is the changing licensing around open source going to impact you? What keeps most of your peers up at night? What will impact your business in 2020 and beyond?

 

Geir Hoydalsvik from Oracle will then share The State of the Dolphin. Where are we with MySQL 8.0 one year after GA? How was the journey and how the Community impacted the road map? Come to discover Oracle’s new release way, allowing them to be even closer to users looking for performance, stability, and innovation.

 

John BoeroWe will complete our first day keynotes with John Boero, HashiCorp and his session on Unlocking the Cloud Operating Model. To unlock the fastest path to the value of the cloud, enterprises must consider how to industrialize the application delivery process across each layer of the cloud: embracing the cloud operating model, and tuning people, processes, and tools to it. He’ll discuss what the Cloud Operating Model means for your enterprise.

 

Don’t miss out, buy your tickets here!

October 2, 2019

Craig Kerstiens Kick-off day two with Craig Kerstiens from Microsoft as he tells the journey of Postgres: From Respected by DBAs to Loved by Application Developers. Ten years ago, Postgres was a safe and stable database, although not at the same level of user-friendliness or rich feature set as other databases. But that all started to change as it learned from MySQL and Mongo. He’ll examine some of that journey and look at what the next five years may hold.

 

We will conclude our keynotes with a moderated panel discussing the Business Challenges Facing Modern Database Deployments. Business leaders from around the globe will talk trends, changes, and issues they face day-to-day. We will ask them for their advice on how to build scalable, secure, and world-class applications that meet user needs.

See the full schedule of tutorials, events, keynotes, and sessions. We look forward to seeing you there, so don’t miss out – buy your tickets here!

With thanks to our sponsors!

Platinum Sponsor

Percona

 

 

 

Gold Sponsors

PlanetScale

AWS

Silver Sponsors

Altinity

 

Tarantool

Galera

Shannon Systems

 

Community

FreeSoftware

Booking.com

MariaDB

Media

Datanami

EnterpriseAI

HOCwire

Aug
19
2019
--

Percona Live Europe 2019 Schedule

Percona Live Europe 2019

Percona Live EuropeIf you’ve been waiting to see the schedule before you commit to a ticket, wait no longer! With just a few spots to be confirmed before release, the bulk of the Percona Live Europe 2019 agenda can now be seen. We’ve said it before, but the quality of the submissions was high and it’s been a tough task to hone this down to the final schedule. We had to make more than a few tough decisions.

Thank you again to all of you who have submitted for this event, and to the Committee for their dedicated work on selecting the community’s picks.

We have allocated the talks to tracks according to their business theme this year. The good news is that if you want to follow just one specific technology – say, PostgreSQL – all talks will be tagged by their technology in the final program, so you can follow them easily no matter which track they appear under

Don’t forget to register soon as the discounted rate only lasts until September 1.

Time for some more of those featured talks…

You’ll find the abstracts for these talks on our agenda. We have over 80 speakers at this year’s event addressing all aspects of open source database technology.

  • Test Like a Boss: Deploy and Test Complex Topologies With a Single Command, presented by Giuseppe Maxia
  • Why PostgreSQL is Becoming a Migration Target in Large Enterprises, presented by Jobin Augustine, Percona
  • MyRocks and RocksDB Advanced Features and Performance, presented by Yoshinori Matsunobu, Facebook
  • New Indexing and Aggregation Pipeline Capabilities in MongoDB 4.2, presented by Antonios Giannopoulos, ObjectRocket by Rackspace
  • Backing Up Wikipedia Databases, presented by Jaime Crespo, Manuel Arostegui of Wikipedia
  • How a Modern Database Gets Your Data Fast: MariaDB Query Optimizer by Vicen?iu Ciorbaru, MariaDB Foundation
  • Benchmarking Should Never Be Optional, Art van Scheppingen, Messagebird

Tutorial Schedule

Monday, September 30 is the tutorial day, offering a range of hands-on half-day sessions to get you up to speed with open source database technologies, along with a full day’s tutorial introducing MySQL administration. The half-day sessions include:

  • Innodb Architecture and Performance Optimization Tutorial for MySQL 8 presented by Peter Zaitsev, Percona
  • Introduction to PL/pgSQL Development presented by Jim Mlodgenski, AWS
  • MariaDB Server 10.4: The Complete Tutorial presented by Colin Charles, Consultant
  • MySQL 8.0 InnoDB Cluster – Easiest Tutorial! presented by Frédéric Descamps and Kenny Gryp, Oracle
  • Open Source Database Performance Optimization and Monitoring with PMM, presented by Michael Coburn, Percona
  • Getting Started with Kubernetes and XtraDB Cluster, presented by Matthew Boehm, Percona
  • MySQL, MariaDB & PostgreSQL as PaaS on Azure, presented by Jose Manuel Jurado Diaz,  Vitor Pombeiro, and Hamza Aqel, Microsoft
  • Percona XtraDB Cluster Tutorial, presented by Tibor Köröcz, Percona
  • PostgreSQL For Oracle and MySQL DBAs and For Beginners, Avinash Vallarapu, Percona
  • Percona Server for MongoDB, presented by Adamo Tonete and Vinicius Grippa, Percona
  • MySQL 101 presented by Tom De Cooman and Dimitri Vanervobeke, Percona

Convinced? Then register now before Sep 01 for discounted prices.

Aug
07
2019
--

Percona Live Europe 2019: Sneak Peek

ple19 trends technologies and innovations

ple19 trends technologies and innovationsWe had an amazing response to our Call for Papers for Percona Live Europe, offering talks of incredible breadth and depth. Our European open source database conference rivals its North American cousin in the number and quality of submissions, which has made it an incredibly tough job for the volunteer Committee – thank you, again – and the Percona team to put together the schedule. The hardest job has been deciding which talks we could afford to leave out when the quality is so high.

The full agenda will be published towards the end of next week, but in the meantime here’s just a peek at the talks we have in store. If you would like to attend, you only have until August 9 to get tickets at the lowest price, currently just €525  + VAT for all three days: a full day of tutorials plus two days of conference. Don’t miss out, registration is open now.

Here’s a taste of what’s in store from September 30 to October 2 in Amsterdam.

Lessons From Building Automation for a Large Distributed Database

Ameet Kotian and Leigh Johnson, Slack

Automation is a critical investment when scaling infrastructure operations. If you delay automating, your company’s growth will end up supported by a mountain of human toil.

Ameet (below, left) and Leigh (below, right) will outline the natural evolution of automation software. They believe at-scale automation software has the same sets of rigorous requirements as any other production software, but there are easily identifiable patterns common to automation software.

Once such an automation framework is available, you can build a self-healing infrastructure on top of it by feeding it reliable and robust failure signals.

Ameet Kotian, Slack           Leigh Johnson, Slack

Large Scale Deployment of SSL/TLS For MySQL

Daniël van Eeden, Booking.com

Deploying SSL/TLS with MySQL at Booking.com on thousands of servers is not without issues. In this session, Daniël will tell you what steps they took, what problems they hit, and how they improved various parts of the MySQL ecosystem while doing so. To start he’ll go over the basics, and then start to address some of the problems that were encountered inside MySQL, inside connectors, and with the tools that are used to maintain and manage MySQL databases.

Daniël van Eeden

 

Running ElasticSearch at Large Scale

Alex Cercel, Palantir Technologies

ElasticSearch is a high performance search engine based on Apache Lucene.  It is growing in popularity which means that more and more users are running part of their search patterns against the information stored on this datastore. However, it’s quite difficult to find a comprehensive set of best practices that will assist in efficiently running large scale clusters. In this talk, Alex will cover tuning parameters and approaches that will help you to run fast, efficient, and well-written queries on stable, perfomant clusters. He’ll offer tips and tricks based on his experience that will help you to make some informed choices when building your own large scale cluster.

Alex Cercel

MongoDB Data Security – Custom Rules and Views

Adamo Tonete, Percona

In this presentation, Adamo will discuss how to create custom rules when MongoDB’s default rules are not enough for the application. Have you needed to give a more permissive rule to a user just because this user wanted to run a specific command? This is what the talk will address.

Also, he’ll talk about how to use views to hide fields from users when you want to prevent them from viewing the whole of a collection. If you have concerns about MongoDB security, you should come to this talk.

Adamo Tonete, Percona

Tutorial: Introduction to PL/pgSQL Development

Jim Mlodgenski, AWS

When developing against a PostgreSQL database, many times you will use SQL from your applications, but sometimes you need more. You might need to run some of your logic on the database server for performance or you may want to just create some server-side functions to simplify your application development. There is an infinite number of reasons why you would want to write some code that runs on the PostgreSQL server and PostgreSQL has a rich set of options when you want to do that, but most times, you will use PL/pgSQL. The primary objective of this tutorial is to introduce you to the PostgreSQL PL/pgSQL programming language and to give you the practical skills to be a productive developer working with PostgreSQL databases.

Jim Mlodgenski, AWS

How to Protect PII data in MySQL While Allowing Customers to Access the Database

Alexander Rubin, VirtualHealth

Protecting PII data is one of the biggest challenges of a security-minded DBA. But when you add a requirement to allow customers to have direct access to a database replica, it will make the life of a DBA a nightmare. VirtualHealth deals with medical data. In this talk, Alexander shares his experience of how to implement customer authentication, authorization, and data isolation in MySQL.

Alexander Rubin

 

Our journey to better MySQL availability using Global Transaction IDs, ProxySQL and Consul

Stéphane Combaudon and Yuriy Olshanetsky, Rakuten Intelligence

Data is core to business at Rakuten Intelligence. While databases not being available can hurt the company badly, the system was not initially designed with MySQL high availability in mind. Each MySQL master switch involved stopping and restarting applications, which at some point was no longer a valid option.

No existing HA solution worked well, so they focused on implementing the glue between existing bricks, the main ones being: ProxySQL (connection management between the applications and MySQL), Consul (service discovery), and MySQL GTIDs (easy tracking of transactions across servers).

Stéphane (below, left) and Yuriy (below, right) will share their failures and how they incrementally improved their system to reach their availability goals.

Stephane Combaudon       Yuriy Olshanetsky

Strength in Numbers: Slack’s Database Architecture

Josh Varner and Guido Iaquinti, Slack

Traditionally, database reliability has focused heavily on the stability of a single server or a small number of servers. At Slack, however, they’ve built a database architecture that instead focuses on an approach of strength in numbers. The team has designed this architecture to allow failures to happen and to limit the effects of those failures instead of attempting to eliminate them entirely. They’ve also built this architecture from the ground up to be cloud-first, and to use the nuances of running databases in the cloud to Slack’s advantage.

In this talk, Josh (below, left) and Guido (below, right) will review the architecture, specifically focusing on their Vitess infrastructure. Vitess currently handles nearly half of Slack’s database traffic. They’ll talk about how we’ve built this system to withstand common failures and continue to perform at our scale.

Josh Varner, Slack      Guido Iaquinti, Slack

MySQL Shell : the best DBA tool?

Frédéric Descamps, Oracle

MySQL Shell 8.0.17 has been released with a new extension framework. Join this session to discover how to write your own extension.  Frédéric (“LeFred”) will also give you an overview of several useful extensions, how to find them, and how to install them. Finally, he’ll show you how to create your own.

Frédéric Descamps, Oracle

Ready to join us?

Then register now! 

Jul
15
2019
--

Percona Live Europe 2019 Conference Updates

The Percona Live Open Source Database Conference, Europe 2019 will have a one week extension of the call for papers.  Our new close date will be Monday July 22, 2019.  Any and all topics related to open source database technologies are invited.

This year’s conference takes a new approach, organizing tracks along these key business themes:

  • Performance & Scalability
  • Public, Private, and Hybrid Clouds & Everything In Between
  • Building Large, Scalable, & Secure Database Deployments
  • Hot Topics, New Features, & Trends You Should Know About
  • Monitor, Manage, & Maintain Databases at Scale
  • How to Reduce Costs & Complexity with Open Source Databases
  • Fascinating or important talks that don’t 100% fit in the other tracks

But as always the conference will be rich in expertise about MySQL®, MongoDB®, MariaDB®, PostgreSQL, Kubernetes®, and everything else related to open source databases.

Program Committee Announced

Percona is pleased to announce the conference program committee.  We are grateful for the participation of these senior technical experts from across the open source database world:

  • Laine Campbell, Facebook
  • Colin Charles, Consultant
  • Frédéric Descamps, Oracle
  • Antonios Giannopoulos, Object Rocket
  • Giuseppe Maxia, Software Explorer
  • Valerie Parham-Thompson, Pythian
  • Nicolai Plum, Booking.com

Percona’s committee representatives are:

  • Jobin Augustine, Senior Support Engineer
  • Vinicius Grippa, Senior Support Engineer
  • Sveta Smirnova, Principal Support Escalation Specialist
  • Alkin Tezuysal, Senior Technical Manager

The conference program will be announced on a rolling basis in early August.

Registration is OPEN!

Finally,  registration is now open!! Buying your ticket early will get you the best value by far at just €525 for all three days until August 9 . We are hosting the conference at a stunning new airport venue, the Amsterdam Hilton Schiphol, allowing easy access for international travelers but just 20 minutes by train from the historic heart of Amsterdam.  This new venue provides outstanding modern facilities with room for the conference to continue to grow. Read more about the event or simply…

Register here now

 

Jul
02
2019
--

Percona Live 2019’s Top 10 Highest-Rated Talks

Percona Live 2019 Highest Rated Talks

The votes have been tallied, and we’re happy to fill you in on the Top 10 highest-rated talks at the Percona Live Open Source Database Conference 2019! A big thanks to everyone who voted, and if you didn’t attend any of these at the conference, now’s your chance to see what you missed. Percona Live conferences provide the open source database community with an opportunity to discover and discuss the latest open source trends, technologies, and innovations. The conference includes the best and brightest innovators and influencers in the open source database industry.

10. MongoDB Data Security – Custom Rules and Views – Adamo Tonete (Percona)

In this presentation, Adamo Tonete discusses how to create custom rules when the default rules are not enough for the application. Have you ever needed to give a more permissive rule to a user just because this user wanted to run a specific command? Also, he discusses how to use view for hiding fields from users when we don’t want them to read all of the collection.

 

9. Scaling MySQL at Venmo – Dong Wang (PayPal), Heidi Wang (PayPal), Van Pham (Venmo)

In this presentation, speakers discuss the MySQL architecture and application ecosystem in Venmo, scalability challenges of MySQL for Venmo applications for Super Bowl peak traffic, short term scalability improvements for peak traffic, including horizontal and vertical scalability approaches, and case studies of MySQL performance tuning.

 

8. Vitess: Running Sharded MySQL on Kubernetes – Sugu Sougoumarane & Dan Kozlowski (PlanetScale)

Sugu Sougoumarane & Dan Kozlowski (PlanetScale) discuss how to shard MySQL on Kubernetes in Vitess. Vitess has continued to evolve into a massively scalable sharded solution for the cloud. It’s is now used for storing core business data for companies like Slack, Square, JD.com, and many others. This session will cover the high-level features of Vitess with a focus on what makes it cloud-native.

 

7. MySQL Technology Evolutions at Facebook – Yoshinori Matsunobu (Facebook)

In this talk, Yoshinori Matsunobu (Facebook) introduces how they evolved MySQL for their workloads and modern hardware, including enhanced replication, space-efficient storage engine, and multi-tenancy.

 

6. The Highs and Lows of Running a Distributed Database on Kubernetes – Alex Robinson (Cockroach Labs)

Alex Robinson talks about his experiences trying to reliably run CockroachDB, the open source distributed SQL database, on Kubernetes, optimize its performance, and help others do the same in their heterogeneous environments. Learn about what kinds of stateful applications can most easily be run in containers, which Kubernetes features and usage patterns are most helpful for running them, along with some pitfalls encountered along the way.

 

5. Databases at Scale, at Square – Emily Slocombe (Square)

Emily Slocombe (Square) discusses databases at scale. At Square, they operate thousands of database instances to power a financial network, from payments to payroll. In a word: money. “Mission-critical” isn’t critical enough. Come learn how they operate MySQL and Redis with billions of dollars at stake. They’ll look at everything: configuration, management, monitoring, tooling, security, high-availability, replication and more.

 

4. Managing MySQL at Scale in Facebook – Junyi Lu (Facebook)

Junyi Lu (Facebook) covers a quick intro to shard/replicaset/instance/host and the scale of FB, the lifecycle of an instance, the tools used for moving instance between states: MPS Copy, rebuild_db etc., shard movements(OLM), and test infrastructure: Shadow and Merlindb.

 

3. MySQL Group Replication: The Magic Explained v2 – Frédéric Descamps (Oracle)

Frédéric Descamps (Oracle) explains how MySQL Group Replication replication works. This is a theoretical talk in which he explains in detail what replication is and how it works, what certification is and how it’s done. Also, he talks about XCOM and GCS.

 

2. Part 2: MySQL InnoDB Cluster in a Nutshell: The Saga Continues with 8.0, the full guide – Kenny Grypp & Frédéric Descamps (Oracle)

MySQL InnoDB Cluster in a Nutshell

 

 

 

 

 

 

 

 

During this tutorial, attendees got their hands on virtual machines and migrated standard Master-Slave architectures to the new MySQL InnoDB Cluster (native Group Replication) with minimal downtime. After explaining what Group Replication is and how it works (the magic behind it), Kenny and Frédéric experiment with multiple use cases to understand MySQL Group Replication. (Click image for slides)

 

1. MySQL Shell: The Best DBA tool? How to Use the MySQL Shell as a Framework for DBAs – Frédéric Descamps (Oracle)

In this talk, Frédéric shows us how to first configure the Shell for a nice, good looking experience with MySQL, and show some of the basic commands and objects. After this brief overview,  he shows how it’s possible to extend the Shell, and how he hacked it to create an Innotop clone inside the MySQL Shell.

Thanks to all sponsors, presenters, and attendees for a successful Percona Live Open Source Database Conference 2019!  Percona Live Europe 2019 is coming up next, taking place in Amsterdam, Netherlands from September 30 to October 2, 2019.  The Call for Papers is now open, and we invite you to submit your speaking proposal for breakouts, tutorials, or lightning talks at any level of expertise, from beginner to expert.

Jun
27
2019
--

Percona Live 2019’s Top 10 Most Attended Talks

Percona Live 2019 Most Attended Talks

We’re counting down the top 10 most attended talks at the Percona Live Open Source Database Conference 2019! For those of you who attended, chances are that some of you were at a few of these talks.  Percona Live conferences provide the open source database community with an opportunity to discover and discuss the latest open source trends, technologies, and innovations. The conference includes the best and brightest innovators and influencers in the open source database industry.

10. InnoDB Management and Scalability Improvements in MySQL 8.0 – Sunny Bains (Oracle)

Sunny Bains (Oracle) discusses improvements in MySQL 8 like scalability and InnoDB Management. Oracle’s MySQL 8.0 is a major release of new features and capabilities, including a new data dictionary, hosted in InnoDB, new REDO logs design, new UNDO logs, a new scheduler, descending indexes, and much more! Learn all about the changes in InnoDB delivered with MySQL 8.0 and how they affect the performance and the manageability of your database!

9. MySQL Group Replication: The Magic Explained v2 – Frédéric Descamps (Oracle)

Frédéric Descamps (Oracle) explains how MySQL Group Replication replication works. This is a theoretical talk in which he explains in detail what replication is and how it works, what certification is and how it’s done. Also, what is XCOM and GCS.

8. Using Ansible to Manage MySQL at DigitalOcean – Ben Mildren, Andrew Moore, & Dan Kowalewski (DigitalOcean)

Ben Mildren, Andrew Moore, & Dan Kowalewski (DigitalOcean) discuss how they use Ansible to manage the internal MySQL services at DigitalOcean, where this has worked well for them, as well as some of the issues they have experienced along the way. They’ll dive into how we use Ansible to manage MySQL, ProxySQL & Orchestrator and other related technologies in their environment and discuss topics such as static vs dynamic config management, Ansible performance tuning & anti-patterns, as well as testing strategies.

7. From Scheduled Downtime to Self-Healing in Less Than a Year – Karoly Nagy (Salesforce)

Karoly Nagy (Salesforce) discusses scheduled downtime to self-healing and how you can achieve this in less than a year. Infrastructure automation is not easy, especially for stateful services like MySQL (or any other database for that matter). It goes way beyond the capabilities of Ansible, Chef, SaltStack or other similar tools. In this session, Karoly will show you how he went from fully manual operations to a self-healing system in less than a year at Salesforce.

6. New Features in ProxySQL 2.0 – René Cannaò & Nick Vyzas (ProxySQL)

René Cannaò & Nick Vyzas (ProxySQL) discuss new features in ProxySQL 2.0. ProxySQL, the high performance, high availability, protocol-aware proxy for MySQL is now GA in version 2.0. This version introduces several new features, like causal reads using GTID, better support for AWS Aurora, native support for Galera Cluster, LDAP authentication and SSL for client connections.

5. Vitess: Running Sharded MySQL on Kubernetes – Sugu Sougoumarane & Dan Kozlowski (PlanetScale)

Sugu Sougoumarane & Dan Kozlowski (PlanetScale) discuss how to shard MySQL on Kubernetes in Vitess. Vitess has continued to evolve into a massively scalable sharded solution for the cloud. It’s is now used for storing core business data for companies like Slack, Square, JD.com, and many others. This session will cover the high-level features of Vitess with a focus on what makes it cloud-native.

4. Databases at Scale, at Square – Emily Slocombe (Square)

Emily Slocombe (Square) discusses databases at scale. At Square, they operate thousands of database instances to power a financial network, from payments to payroll. In a word: money. “Mission-critical” isn’t critical enough. Come learn how they operate MySQL and Redis with billions of dollars at stake. They’ll look at everything: configuration, management, monitoring, tooling, security, high-availability, replication and more.

3. MySQL Performance Optimization and Troubleshooting with Percona Monitoring and Management – Peter Zaitsev (Percona)

Peter Zaitsev (Percona) will discuss how you can optimize and troubleshoot MySQL performance and demonstrate how Percona Monitoring and Management (PMM) enables you to solve these challenges using free and open source software. We will look at specific, common MySQL problems and review the essential components in PMM that allow you to diagnose and resolve them.

2. New Features in MySQL 8.0 Replication – Luís Soares (Oracle)

Luís Soares (Oracle) highlights the new replication features in MySQL 8.0. Those that were released pre and post-GA. Come and learn, directly from the engineers, how the new features help you operate, sustain, and extend your MySQL Replication infrastructure.

1. The MySQL Query Optimizer Explained Through Optimizer Trace – Øystein Grøvlen (Alibaba Cloud)

Øystein Grøvlen (Alibaba Cloud) introduces you to the inner workings of the MySQL Query Optimizer by showing you examples with Optimizer Trace.  Øystein will cover the main phases of the MySQL optimizer and its optimization strategies, including query transformations, data access strategies, the range optimizer, the join optimizer, and subquery optimization. They will also show how optimizer trace gives you insight into the cost model and how the optimizer does cost estimations.

Thanks to all sponsors, presenters, and attendees for a successful Percona Live Open Source Database Conference 2019! We look forward to seeing you all next year!

Jun
25
2019
--

Percona Live Europe 2019 Call for Papers is Now Open!

The Call for Papers for Percona Live Europe 2019 is now open!  This year’s conference will be held September 30 – October 2, 2019 in Amsterdam, the Netherlands.

Percona Live is the one conference for the entire open source database community, especially for MySQL, PostgreSQL, MongoDB, and MariaDB. The theme of the 2019 conference is “Any Open Source Database, Any Platform, Any Time.”

Percona invites you to submit your speaking proposal for breakouts, tutorials, or lightning talks at any level of expertise, from beginner to expert.

  • Breakout Session – 50-minute talk (including Q&A).
  • Tutorial Session – In-depth training 3 or 6 hours long (including Q&A).
  • Lightning Talk – 10-minute talk on one key point.

Percona Live Europe will be organized around these six tracks:

  1. Performance & Scalability
  2. Public, Private, & Hybrid Clouds & Everything In Between
  3. Building Large, Scalable, & Secure DB Deployments
  4. Hot Topics, New Features, & Trends You Should Know About
  5. Monitor, Manage, & Maintain Databases At Scale
  6. How to Reduce Costs & Complexity with Open Source DBs

Talks should fall under one or more of these tracks and deal with topics such as using, deploying, or managing MySQL, PostgreSQL, MongoDB, MariaDB, or any other open source database.  Additional topics of particular interest  include monitoring, automation, migration, security, compliance, and Kubernetes.

The Call for Papers is open from June 25 – July 15, 2019.  To propose a talk visit https://www.percona.com/cfp.  Our full agenda will be announced in August at https://www.percona.com/live/amsterdam19. All speakers will receive a free full conference pass (except Lightning talks).

Powered by WordPress | Theme: Aeros 2.0 by TheBuckmaker.com