Databases Peter Zaitsev Percona You Might Know I am passionate - - PowerPoint PPT Presentation

Maximizing the Power and Value of Open Source Databases

Peter Zaitsev Percona

2

You Might Know…

I am passionate about Open Source Databases

3

Open Source Databases

Leading in Growth

Source: https://db-engines.com/en/ranking

4

Long Term Popularity Trend

5

Dominate New Generation of Databases

6

Database Popularity per Stack Overflow

Source: https://insights.stackoverflow.com/survey/2018/ Source: https://insights.stackoverflow.com/survey/2017

19,7 25,9 32,9 41,2 58,7 26,6 21 26,5 38,6 55,6 10 20 30 40 50 60 70 SQLite MongoDB PostgreSQL SQL Server MySQL

Stack Overflow Popularity

2017 2018

Percona’s Mission

To Champion Unbiased Open Source Database Solutions

8

Our Vision

Best Open Source is 100% free and Open Source Enterprise Grade Open Source No Vendor Lock-In The best and longest lasting Open Source projects start and end with the community

Summary:

• Open
• Accessible
• Free
• Portable
• Enterprise Grade
• Strong Community

9

Our Goal

Provide and Promote 100% Free and Open Source Enterprise Ready Database Platforms Enhance the community and the ecosystem by making existing open source even better by:

• Making Enterprise Features Accessible to the Masses
• Providing Content, Best Practices, and Education to All
• Enhancing Existing Open Source Software to meet the needs of 90% of the application

workloads

State of Leading Open Source Databases

11

MySQL is as Strong as Ever

Most popular open source database Most popular database choice in the cloud MySQL 8 looks amazing Internally we have seen explosive growth of MySQL in the enterprise space over the last 2 years.

12

MariaDB is Doing Great

It is not just a MySQL Variant, it is its own database Distinct focus on Oracle compatibility features MariaDB 10.3 is now available Won distribution politics war and presents in most Linux distributions

13

MongoDB is Showing Great Traction

Huge improvements in stability, scale, ease of use MongoDB, Inc. had successful IPO, continues growth By far the most popular document store MongoDB 4.0 supports transaction, making it a great fit for even more enterprise workloads MongoDB License Change to SSPL

14

PostgreSQL Shines

Fastest Growth among popular open source databases Database of the year 2017 by DB-Engines Very active and broad ecosystem (open source and not) PostgreSQL 11 just released

Trends and Impacts for Database Deployments

16

Cloud

Workloads are moving to the cloud Database are not exception Specific cloud infrastructure skills are required

“83% of Enterprise Workloads will be in the cloud by 2020” -- Forbes “96% of respondents are using Public Cloud Cloud now” -- RightScale

17

Database as a Service (DBaaS)

DBaaS becomes preferred way to run databases in the cloud

• Do not need to maintain skills to focus on database plumbing
• Evolving role of DBA to focus on higher value activities
• All large cloud vendors have DBaaS offerings now
• Offering your technology as DBaaS is must

18

Recent DBaaS Announcements

19

DBA vs DBaaS (Amazon View)

DBA

• New Apps
• App Upgrades
• Schema Design
• Query Construction
• Query Optimization

DBaaS

• Automatic fail-over
• Backup & recovery
• Isolation & security
• Industry compliance
• Push-button scaling
• Automated patching
• Advanced monitoring
• Routine maintenance

20

Containers

Applications are leading the way to be run in containers Docker – de-facto container standard Kubernetes – container orchestration platform Kubernetes is just getting good for database workloads

21

Docker and Kubernetes Adoption

22

Automation

Few DBAs to manage large fleet of database service Large application vendors and DBaaS providers Current generation – rule-based Emerging trend – machine learning/AI-based

Security and Compliance

#1 Concern of Percona Customers in 2018 #1 Concern among CTO’s and CIO’s One breach can put you out of business GDPR, HIPPA, PCI are not just for enterprise

Breach Statistics

https://www.thalesgroup.com/sites/default/files/asset/document/2018-data-threat_report-global-edition.pdf

Developer Power

Increasing number of developers supported by single DBA Transitioning of DBA to auxiliary duty of Developers, SREs DBaaS enables self service for developers Increasing danger of poor database architecture schema and query design

Percona’s Role

Helping you to…

27

Embrace the Cloud

Maintain agility and remain competitive

• Focused, agile experts who can improve time-to-market

Accommodate rapid growth and application development

• Proactive, responsive services enable an agile, scalable, secure environment

Develop and deploy agile solutions

• Design and architecture expertise for dynamic, data-driven applications

Best-of-breed approach saves money and mitigates risk

• Amazon AWS (EC2, RDS, Aurora and S3), Microsoft Azure, Google CloudSQL,

Rackspace Cloud, MongoDB Atlas and others

“Providing our customers with current and relevant data that is accurate and up-to-date is the only way to stay relevant in our business. Percona’s expertise in database architecture for both MySQL and MongoDB allowed us to implement the best failover solution, and provided us with a way to continually monitor our environment.” Phil Hildebrand, Senior DBA, Moz

28

“Knowing Percona’s experts are available for resolving complex challenges gives us complete confidence in our ability to manage all

• eventualities. So, when in-depth database knowledge is needed, we can turn to the Percona team for their specialist perspective.”

Ryan Jones, Senior Manager of Product at Pivotal Cloud Foundry

Pivotal Cloud Foundry Uses Percona

Premier platform for running modern applications atop public and/or private clouds Relies on Percona for:

• Robust, high-performance MySQL data service solution
• MySQL expertise for complex challenges
• Advice on MySQL data services in the development

and delivery of PCF

29

Optimize Business Performance

Avoid downtime and outages and manage risk through sound architecture frameworks

• Deep operational knowledge to ensure uptime and availability

Meet expected customer experience (9s, load times)

• Industry-leading trusted advisors to maintain performance and stability

Foster business, operations and developer collaboration

• Best practices for productivity and innovation learned from 3000+ satisfied customers

“Our clients … need our data services to better reach their customers and take advantage of sales opportunities. A performant and available database is crucial to our business, especially as we grow and take on new clients and markets. With Percona’s help, we were able to ensure an optimized database that meets our customers’ needs.” Guillaume Morin, Head of Production and Infrastructure, Alkemics

30

“The gaming industry is quite competitive, and customers require both new applications and products as well as an online experience that meets high expectations. Our high-performance and highly-available cloud database environment is critical to helping our developers produce better applications, as well as providing an experience that meets our customers’ expectations. Percona XtraDB Cluster and Percona Support are critical for achieving the needed level of performance.” Andrew Cook, Manager Database Operations at Paddy Power Betfair

PaddyPowerBetfair Uses Percona

International sports betting and gaming operator Relies on Percona for:

• Guaranteed data uptime and reliability for a MySQL database deployed

into a private cloud environment spanning multiple datacenters

• Percona Support for 24x7x365 access to some of the industry’s

most experienced MySQL practitioners

• Validation of OpenStack database environment for developers ease-of-use

31

Reduce Costs and Complexity

Reduce complexity and costs for faster ROI

• Expert single-source support for your multi-vendor database

environment

Focus on application and database performance and design for revenue and growth

• Flexible, easy-to-understand engagement and pricing models that focus
• n customer success

Lower operational and infrastructure costs

• Enterprise-grade, 100% free open source to lower costs and complexity

“Combining Percona Managed Services with Amazon RDS and Amazon Aurora enabled Lookout to shift its focus away from maintaining servers and worrying about data replication, towards delivering new features and capabilities to its customers.” Michael Fortson, Director of Engineering, Lookout

32

“Our customers need data. Our business depends on providing that data all the time, whenever it’s needed, without fail. Percona’s expertise in database architecture for both MySQL and MongoDB allows us to implement the best failover solution, and provides us with a way to continually monitor our environment so that our customers can make the business decisions they need to.” Phil Hildebrand, Senior DBA at Moz

Moz Uses Percona

Software and resources to leverage power of SEO Relies on Percona for:

• HA for their customers
• Performance, uptime and responsiveness
• Expert technical design and maintenance to

improve database architecture

33

Maximize Power and Value of Open Source

Engage single enterprise-class vendor

• No vendor lock-in – unbiased, best-of-breed expertise in

multiple open source databases and cloud platforms

Use savings to deploy new applications and capabilities

• 100% free open source with enterprise features

Innovate and modernize applications

• Expertise in every stage of the application lifecycle

“Originally, we used MariaDB to deliver v1 of MySQL for PCF, but found that for v2 Percona Server for MySQL remains more in line with Oracle’s delivery. Combined with the ability to provide responsive, knowledgeable support, we found Percona to be a better fit for our customer’s needs.” Ryan Jones, Senior Manager of Product, Pivotal Cloud Foundry

34

“Guaranteeing database performance is key to making sure our web applications are responsive and up-to-date. Percona Care Ultimate helps us to achieve these objectives.” Pavel Genov, Head of Software Development at Pepper.com

Pepper Uses Percona

Largest community deal platform worldwide Relies on Percona for:

• Open source database remote managed service expertise
• Performance, uptime and responsiveness
• Online non-blocking, tightly compressed,

highly secure backups

35

Percona Server for MySQL 8.0

Percona Server for MySQL 8.0 Release Candidate out 10/31

• GA release by end of year

MyRocks storage engine – MySQL 8.0 compatible

• Fully supports native partitioning in MyRocks

Enterprise-ready, free and open source, with enterprise features

• ThreadPool for increased scalability
• PAM Authentication plugin
• Audit plugin for policy-based monitoring and logging of connection and query activities
• Backup locks for low impact backups

Enhanced performance over MySQL 8.0 Community Edition Includes all of the great new features available in MySQL 8.0 Community Edition GA includes full suite of enhanced encryption capabilities built-in, including integration with Hashicorp Vault

36

Percona Server for MongoDB 4.0

Encrypted WiredTiger storage engine (data at rest encryption) with local key management Enterprise ready, with free enterprise features:

• Plug-in authentication and auditing functionality
• SASL enables authentication through OpenLDAP or Active Directory
• Track and query database interactions of users or applications

WiredTiger, MMAPv1 and Percona Memory Engine storage engines

• Percona Memory Engine for in-memory computing workloads
• Equivalent to proprietary MongoDB Enterprise in-memory engine

Integrated open source hot backup system for WiredTiger Integration with Percona Toolkit and Percona Monitoring and Management for query performance analytics and troubleshooting Enhanced query profiling Available by the end of the year

37

Percona Monitoring and Management

Identify trends over time

• Point-in-time and historical views of database performance

Supports multiple databases technologies

• Single interface for monitoring many databases and environments

Custom AWS monitoring for RDS and Aurora Enables proactive maintenance

• Deep data analytics moves beyond standard monitoring

Scale to more than 1000 monitored instances with single monitoring host Support of PostgreSQL monitoring Agentless deployment for DBaaS, Windows and secure environments

How Percona Can Help

39

Open Source Database Experts

Augment your team with a market leader in open source database management

• Technology-agnostic and committed to open source
• Recognized database performance experts
• Unparalleled open source service and support
• Fastest SLAs and response times in the industry

Avoid vendor lock-in in on-premises or cloud environments

• MySQL, Percona Server for MySQL, MariaDB, MongoDB, Percona Server for MongoDB,

PostgreSQL

• Amazon AWS (EC2, RDS, Aurora and S3), Microsoft Azure, Google CloudSQL,

Rackspace Cloud, MongoDB Atlas and others

40

Unbiased, Trusted Partner

Reduce risk and operational costs

• Unbiased, best-of-breed enterprise-class
• Support
• Consulting
• Managed services
• Training
• Software
• On-premises and cloud environments

Single-source expertise in multi-vendor environments

• Eliminates lock-in
• Increases agility
• Enables business growth

Next To Follow

PostgreSQL 11

By Bruce Momjian

MongoDB 4.0

By Alex Rubin

MariaDB 10.3

By Arjen Lenz

das Ende