skip to content
Introducing InnoDB Cluster : learning the MySQL High Availability Stack Preview this item
ClosePreview this item
Checking...

Introducing InnoDB Cluster : learning the MySQL High Availability Stack

Author: Charles Bell
Publisher: [Berkeley, CA] : Apress, 2018. ©2018
Edition/Format:   eBook : Document : EnglishView all editions and formats
Summary:
Set up, manage, and configure the new InnoDB Cluster feature in MySQL from Oracle. If you are growing your MySQL installation and want to explore making your servers highly available, this book provides what you need to know about high availability and the new tools that are available in MySQL 8.0.11 and later. Introducing InnoDB Cluster teaches you about the building blocks that make up InnoDB Cluster such as MySQL  Read more...
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Bell, Charles.
Introducing InnoDB Cluster.
[Berkeley, CA] : Apress, 2018
(OCoLC)1042352832
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Charles Bell
ISBN: 9781484238851 1484238850 9781484238868 1484238869
OCLC Number: 1052566618
Description: 1 online resource
Contents: Intro; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Chapter 1: Introduction to High Availability; What Is High Availability?; Recovery; Logical Backup; Physical Backup; Redundancy; Scaling; Fault Tolerance; Overview of MySQL High-Availability Features; MySQL Replication Primer; MySQL Replication Tutorial; Initialize the Data Directories; Configure the Master; Configure the Slaves; Start the MySQL Instances; Create the Replication User Account; Connect the Slaves to the Master; Connect with Log File and Position; Connect with GTIDs. Start ReplicationVerify Replication Status; Example MySQL Replication Script; Challenges for MySQL DBAs; Setup; Troubleshooting; Maintenance; Administration; References on MySQL High Availability; Summary; Chapter 2: What Is MySQL InnoDB Cluster?; Overview; What Is a Storage Engine?; MyISAM; Memory; Merge; Archive; Federated; CSV; Blackhole; InnoDB; Introducing InnoDB Cluster; InnoDB Cluster and the MySQL Document Store; InnoDB Cluster and NDB Cluster; Components; Group Replication; MySQL Shell; X DevAPI; AdminAPI; Router; Installing InnoDB Cluster; Summary; Chapter 3: MySQL Group Replication. Concepts, Terms, and LingoOverview; MySQL Group Replication Tutorial; Initialize the Data Directories; Configure the Primary; Configure the Secondaries; Start the MySQL Instances; Install the Group Replication Plugin; Create the Replication User Account; Start Group Replication on the Primary; Connect the Secondaries to the Primary; Start Group Replication on the Secondaries; Verify Group Replication Status; Demonstration of Failover; DevOps Scripts; Summary; Chapter 4: MySQL Shell; Using MySQL Shell; Shell Commands; Options; Sessions and Modes; Session Objects; Modes Supported; Connections. Using a URIUsing Individual Options; Using Connections in Scripts; Using SSL Connections; Installing the MySQL Shell; Enabling the X Plugin; Enable the X Plugin by Using MySQL Shell; Enable the X Plugin by Using the MySQL Client; Tutorial; Installing the Sample Database; Inserting Data; Selecting the Data; Summary; Chapter 5: High Availability in a Sandbox; Getting Started with the AdminAPI; The dba Class; The cluster Class; Demonstration; Setup and Configuration; Create and Deploy Instances in the Sandbox; Create the Cluster; Add the Instances to the Cluster; Check the Status of the Cluster. FailoverDevOps Scripts; Summary; Chapter 6: MySQL Router; Overview; Installation; MySQL Installer (Windows); Other Platforms; Configuration; Setting Up InnoDB Cluster in a Sandbox; Modifying the Configuration File; Configuring with the Bootstrap Option; Using the Bootstrap Configuration File; [DEFAULT]; [logger]; [metadata_cache:MyCluster]; [routing:]; Starting the Router; Testing the New Configuration; Using the Router with Your Applications; Summary; Chapter 7: Example MySQL High Availability Deployment; Establishing the Servers; Installing MySQL on Commodity Hardware.
Responsibility: Charles Bell.

Abstract:

Set up, manage, and configure the new InnoDB Cluster feature in MySQL from Oracle. If you are growing your MySQL installation and want to explore making your servers highly available, this book provides what you need to know about high availability and the new tools that are available in MySQL 8.0.11 and later. Introducing InnoDB Cluster teaches you about the building blocks that make up InnoDB Cluster such as MySQL Group Replication for storing data redundantly, MySQL Router for the routing of inbound connections, and MySQL Shell for simplified setup and configuration, status reporting, and even automatic failover. You will understand how it all works together to ensure that your data are available even when your primary database server goes down. Features described in this book are available in the Community Edition of MySQL, beginning with the version 8.0.11 GA release, making this book relevant for any MySQL users in need of redundancy against failure. Tutorials in the book show how to configure a test environment and plan a production deployment. Examples are provided in the form of a walk-through of a typical MySQL high-availability setup. What You'll Learn Discover the newest high-availability features in MySQL Set up and use InnoDB Cluster as an HA solution Migrate your existing servers to MySQL 8 Employ best practices for using InnoDB Cluster Configure servers for optimal automatic failover to ensure that applications continue when a server fails Configure MySQL Router to load-balance inbound connections to the cluster Who This Book Is For Systems engineers, developers, and database professionals wanting to learn about the powerful high availability (HA) features, beginning with MySQL 8.0.11: MySQL Shell, MySQL Router, and MySQL Group Replication. The book is useful for those designing high-availability systems backed by a database, and for those interested in open source HA solutions.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/1052566618> # Introducing InnoDB Cluster : learning the MySQL High Availability Stack
    a schema:MediaObject, schema:CreativeWork, schema:Book ;
    library:oclcnum "1052566618" ;
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/cau> ;
    rdfs:comment "Warning: This malformed URI has been treated as a string - 'https://www.safaribooksonline.com/library/view/title/9781484238851/?ar?orpq&email=^u'" ;
    schema:about <http://experiment.worldcat.org/entity/work/data/5300005878#Topic/database_management> ; # Database management
    schema:about <http://experiment.worldcat.org/entity/work/data/5300005878#CreativeWork/mysql_electronic_resource> ; # MySQL (Electronic resource)
    schema:about <http://experiment.worldcat.org/entity/work/data/5300005878#Topic/databases> ; # Databases
    schema:about <http://experiment.worldcat.org/entity/work/data/5300005878#Topic/computers_databases_general> ; # COMPUTERS--Databases--General
    schema:about <http://dewey.info/class/005.74/e23/> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/5300005878#Topic/computer_programming_software_development> ; # Computer programming--software development
    schema:about <http://experiment.worldcat.org/entity/work/data/5300005878#Topic/open_source> ; # Open Source
    schema:author <http://experiment.worldcat.org/entity/work/data/5300005878#Person/bell_charles> ; # Charles Bell
    schema:bookFormat schema:EBook ;
    schema:datePublished "2018" ;
    schema:description "Set up, manage, and configure the new InnoDB Cluster feature in MySQL from Oracle. If you are growing your MySQL installation and want to explore making your servers highly available, this book provides what you need to know about high availability and the new tools that are available in MySQL 8.0.11 and later. Introducing InnoDB Cluster teaches you about the building blocks that make up InnoDB Cluster such as MySQL Group Replication for storing data redundantly, MySQL Router for the routing of inbound connections, and MySQL Shell for simplified setup and configuration, status reporting, and even automatic failover. You will understand how it all works together to ensure that your data are available even when your primary database server goes down. Features described in this book are available in the Community Edition of MySQL, beginning with the version 8.0.11 GA release, making this book relevant for any MySQL users in need of redundancy against failure. Tutorials in the book show how to configure a test environment and plan a production deployment. Examples are provided in the form of a walk-through of a typical MySQL high-availability setup. What You'll Learn Discover the newest high-availability features in MySQL Set up and use InnoDB Cluster as an HA solution Migrate your existing servers to MySQL 8 Employ best practices for using InnoDB Cluster Configure servers for optimal automatic failover to ensure that applications continue when a server fails Configure MySQL Router to load-balance inbound connections to the cluster Who This Book Is For Systems engineers, developers, and database professionals wanting to learn about the powerful high availability (HA) features, beginning with MySQL 8.0.11: MySQL Shell, MySQL Router, and MySQL Group Replication. The book is useful for those designing high-availability systems backed by a database, and for those interested in open source HA solutions."@en ;
    schema:description "Intro; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Chapter 1: Introduction to High Availability; What Is High Availability?; Recovery; Logical Backup; Physical Backup; Redundancy; Scaling; Fault Tolerance; Overview of MySQL High-Availability Features; MySQL Replication Primer; MySQL Replication Tutorial; Initialize the Data Directories; Configure the Master; Configure the Slaves; Start the MySQL Instances; Create the Replication User Account; Connect the Slaves to the Master; Connect with Log File and Position; Connect with GTIDs."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/5300005878> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/1042352832> ;
    schema:name "Introducing InnoDB Cluster : learning the MySQL High Availability Stack"@en ;
    schema:productID "1052566618" ;
    schema:url <http://ezaccess.libraries.psu.edu/login?url=https://doi.org/10.1007/978-1-4842-3885-1> ;
    schema:url <http://ezproxy.lindenwood.edu:2048/login?url=https://www.safaribooksonline.com/library/view//9781484238851/?ar> ;
    schema:url "https://www.safaribooksonline.com/library/view/title/9781484238851/?ar?orpq&email=^u" ;
    schema:url <http://link.springer.com/10.1007/978-1-4842-3885-1> ;
    schema:url <http://proquest.safaribooksonline.com/9781484238851> ;
    schema:url <http://www.vlebooks.com/vleweb/product/openreader?id=none&isbn=9781484238851> ;
    schema:url <http://ezproxy.torontopubliclibrary.ca/login?url=http://proquestcombo.safaribooksonline.com/?uiCode=torontopl&xmlId=9781484238851> ;
    schema:url <https://ezproxy.aub.edu.lb/login?url=https://doi.org/10.1007/978-1-4842-3885-1> ;
    schema:url <http://uproxy.library.dc-uoit.ca/login?url=http://link.springer.com/10.1007/978-1-4842-3885-1> ;
    schema:url <https://proxy.ufv.ca:2443/login?url=https://doi.org/10.1007/978-1-4842-3885-1> ;
    schema:url <https://ezproxy.lau.edu.lb:2443/login?url=https://doi.org/10.1007/978-1-4842-3885-1> ;
    schema:url <http://proquest.safaribooksonline.com/?uiCode=stanford&xmlId=9781484238851> ;
    schema:url <https://0-link-springer-com.pugwash.lib.warwick.ac.uk/book/10.1007/978-1-4842-3885-1> ;
    schema:url <http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=1887314> ;
    schema:url <https://doi.org/10.1007/978-1-4842-3885-1> ;
    schema:url <https://nls.ldls.org.uk/welcome.html?ark:/81055/vdc_100066401731.0x000001> ;
    schema:url <https://link.springer.com/10.1007/978-1-4842-3885-1> ;
    schema:url <https://www.safaribooksonline.com/library/view/-/9781484238851/?ar> ;
    schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=5510546> ;
    schema:workExample <http://dx.doi.org/10.1007/978-1-4842-3885-1> ;
    schema:workExample <http://worldcat.org/isbn/9781484238851> ;
    schema:workExample <http://worldcat.org/isbn/9781484238868> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/1052566618> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/5300005878#CreativeWork/mysql_electronic_resource> # MySQL (Electronic resource)
    a schema:CreativeWork ;
    schema:name "MySQL (Electronic resource)" ;
    .

<http://experiment.worldcat.org/entity/work/data/5300005878#Person/bell_charles> # Charles Bell
    a schema:Person ;
    schema:familyName "Bell" ;
    schema:givenName "Charles" ;
    schema:name "Charles Bell" ;
    .

<http://experiment.worldcat.org/entity/work/data/5300005878#Topic/computer_programming_software_development> # Computer programming--software development
    a schema:Intangible ;
    schema:name "Computer programming--software development"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/5300005878#Topic/computers_databases_general> # COMPUTERS--Databases--General
    a schema:Intangible ;
    schema:name "COMPUTERS--Databases--General"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/5300005878#Topic/database_management> # Database management
    a schema:Intangible ;
    schema:name "Database management"@en ;
    schema:name "Database Management"@en ;
    .

<http://proquest.safaribooksonline.com/?uiCode=stanford&xmlId=9781484238851>
    rdfs:comment "Available to Stanford-affiliated users." ;
    .

<http://uproxy.library.dc-uoit.ca/login?url=http://link.springer.com/10.1007/978-1-4842-3885-1>
    rdfs:comment "eBook available for UOIT via SpringerLink. Click link to access" ;
    .

<http://worldcat.org/isbn/9781484238851>
    a schema:ProductModel ;
    schema:isbn "1484238850" ;
    schema:isbn "9781484238851" ;
    .

<http://worldcat.org/isbn/9781484238868>
    a schema:ProductModel ;
    schema:isbn "1484238869" ;
    schema:isbn "9781484238868" ;
    .

<http://www.worldcat.org/oclc/1042352832>
    a schema:CreativeWork ;
    rdfs:label "Introducing InnoDB Cluster." ;
    schema:description "Print version:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/1052566618> ; # Introducing InnoDB Cluster : learning the MySQL High Availability Stack
    .

<https://www.safaribooksonline.com/library/view/-/9781484238851/?ar>
    rdfs:comment "from Safari" ;
    rdfs:comment "(Unlimited Concurrent Users)" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.