The DevOps Tool for MySQL

2020-02-27 57浏览

1.
2.MySQL Shell The DevOps Tool for MySQL Miguel Araújo Senior Software Developer MySQL Middleware and Clients October 02, 2017 Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Copyright © 2017, Oracle and/or its affiliates. All rights reserved.
3.Safe Harbor Statement The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle. Copyright © 2017, Oracle and/or its affiliates. All rights reserved. 3
6.Introduction - DevOps Software Development Software Operations DEVOPS … It’s all about CAMS*! * Damon Edwards and John Willis at DevOpsDays Mountainview 2010 Copyright © 2017, Oracle and/or its affiliates. All rights reserved. 6
7.Introduction - DevOps ... people and processes i.e. communication Measurement … meaningful monitoring data … quality, speed, consistency … information, tools, lessons Copyright © 2017, Oracle and/or its affiliates. All rights reserved. 7
8.DevOps:Goals • Continuous, faster development • Faster time to deliver • Lower the failure rate • Reduce dependency of staff that owns all the knowledge by sharing the competences to all the team Copyright © 2017, Oracle and/or its affiliates. All rights reserved. 8
9.DevOps:How? • Culture – Reduce friction between teams – Better collaboration between teams – Share knowledge and roles – Developers, sysadmins and DBAs must share work, decisions and ideas • Automation – Systems and scenarios need to be able to be easily and quickly reproducible – Use automation tools for deployment and configuration (puppet, chef, etc) – Deploying systems becomes easier to everyone and a standard – Lowers the risk Copyright © 2017, Oracle and/or its affiliates. All rights reserved. 9
10.DevOps:How? • Measurement – Monitoring – Check the service status – Learn the infrastructure – Anticipate failures and needs – Act fast! • Sharing – Share all monitoring info – Share test results and builds – Allows being able to plan ahead! Copyright © 2017, Oracle and/or its affiliates. All rights reserved. 10
12.MySQLShell:Intro • Interactive multi-language interface that supports development and administration for the MySQL Server • Integrating part of the Server, as a component • Can be used to perform data queries or updates, and administration operations Copyright © 2017, Oracle and/or its affiliates. All rights reserved. 12
13.MySQLShell:Goal • One tool for MySQL development and administrative tasks • Natural interface for all MySQL related ”DevOps”! – Unified Interface for Developers and DBAs • Intuitive, flexible and powerful • Provides scripting with development and administrative APIs Copyright © 2017, Oracle and/or its affiliates. All rights reserved. 13
14.MySQLShell:Features (Dev) • Interactive multi-language support – JavaScript, Python and SQL – Both interactive and batch operations • Document and Relational models – Supports the classic relational model MySQL Development – Modern fluent API for the MySQL Document Store • CRUD and Relational – Supports the traditional Table results, as well as JSON or Tab separated output Copyright © 2017, Oracle and/or its affiliates. All rights reserved. 14
16.MySQLShell:Features (Ops) • AdministrationAPI:AdminAPI – Creation and Management of InnoDB Clusters – Hides the complexityof:• Configuration • Provisioning • Orchestration – Simple and straight-forward – Doesn’t require MySQL expertise – Flexible, powerful and secure – Available in both JavaScript and Python MySQL Administration Copyright © 2017, Oracle and/or its affiliates. All rights reserved. 16
19.MySQL InnoDBCluster:Background • High Availability – Critical Factor – Replication as a common solution – MySQL has supportfor:• Classic master-slave replication • DRDB • Other OS or VM solutions ... Copyright © 2017, Oracle and/or its affiliates. All rights reserved. 19
20.MySQL InnoDBCluster:Background • High Availability – Critical Factor – Replication as a common solution – MySQL has supportfor:• Classic master-slave replication • DRDB • Other OS or VM solutions ... • Group Replication – Virtually synchronous replication – Update-everywhere – Automatic server fail-over • Distributed recovery – Group reconfiguration Copyright © 2017, Oracle and/or its affiliates. All rights reserved. 20
21.MySQL InnoDBCluster:Background • Challenging task – Not easy to setup and maintain – Technical knowledge needed – How to configure the applications? – How to integrate all the components? ?? Copyright © 2017, Oracle and/or its affiliates. All rights reserved. 21
22.MySQL InnoDBCluster:Vision “A single product — MySQL — with high availability and scaling features baked in; providing an integrated end-to-end solution that is easy to use.” – Engineering Team Copyright © 2017, Oracle and/or its affiliates. All rights reserved. 22
28.InnoDB Cluster App Servers with MySQL Router MySQL Shell Setup, Manage, Orchestrate Clients MySQL Group Replication One Product Full Stack HA Solution Easy to use! Copyright © 2017, Oracle and/or its affiliates. All rights reserved. 28
32.Summary • MySQL Shell brings together developers and DBAs • Unifiedinterface:one tool! • Development and Administration APIs • MySQL InnoDB Cluster is THE MySQL Native HA out-of-boxsolution:• Easy touse:usability as a top concern • Powerful and flexible • MySQL Shell with AdminAPI Copyright © 2017, Oracle and/or its affiliates. All rights reserved. 32
33.Resources • MySQL ShellUserguide:'>Userguide: