Cargando…
Introducing InnoDB Cluster : learning the MySQL High Availability Stack /
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.1...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
[Berkeley, CA] :
Apress,
2018.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | OR_on1052566618 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 180914s2018 cau ob 001 0 eng d | ||
| 040 | |a N$T |b eng |e rda |e pn |c N$T |d GW5XE |d N$T |d EBLCP |d NLE |d YDX |d OCLCF |d MOQ |d UMI |d UAB |d UPM |d UKMGB |d OTZ |d G3B |d LVT |d OCLCQ |d TOH |d OCLCO |d STF |d U3W |d VT2 |d CAUOI |d LEAUB |d MERER |d UKAHL |d LQU |d C6I |d FVL |d OCLCQ |d SRU |d OCLCQ |d OCLCO |d COM |d OCLCQ | ||
| 016 | 7 | |a 019052497 |2 Uk | |
| 019 | |a 1052877444 |a 1056157447 |a 1060598089 |a 1081239171 |a 1086472028 |a 1103278515 |a 1105189931 |a 1105706283 |a 1111042569 | ||
| 020 | |a 9781484238851 |q (electronic bk.) | ||
| 020 | |a 1484238850 |q (electronic bk.) | ||
| 020 | |a 9781484238868 |q (print) | ||
| 020 | |a 1484238869 | ||
| 020 | |z 9781484238844 |q (print) | ||
| 020 | |z 1484238842 | ||
| 024 | 7 | |a 10.1007/978-1-4842-3885-1 |2 doi | |
| 024 | 8 | |a 10.1007/978-1-4842-3 | |
| 027 | |a SPRINTER | ||
| 029 | 1 | |a AU@ |b 000063975212 | |
| 029 | 1 | |a AU@ |b 000067496486 | |
| 029 | 1 | |a CHNEW |b 001073797 | |
| 029 | 1 | |a CHVBK |b 579466019 | |
| 029 | 1 | |a UKMGB |b 019052497 | |
| 035 | |a (OCoLC)1052566618 |z (OCoLC)1052877444 |z (OCoLC)1056157447 |z (OCoLC)1060598089 |z (OCoLC)1081239171 |z (OCoLC)1086472028 |z (OCoLC)1103278515 |z (OCoLC)1105189931 |z (OCoLC)1105706283 |z (OCoLC)1111042569 | ||
| 037 | |a CL0500000996 |b Safari Books Online | ||
| 050 | 4 | |a QA76.9.D3 | |
| 072 | 7 | |a COM |x 021000 |2 bisacsh | |
| 072 | 7 | |a UN |2 bicssc | |
| 072 | 7 | |a UN |2 thema | |
| 072 | 7 | |a UMT |2 thema | |
| 082 | 0 | 4 | |a 005.74 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Bell, Charles, |e author. | |
| 245 | 1 | 0 | |a Introducing InnoDB Cluster : |b learning the MySQL High Availability Stack / |c Charles Bell. |
| 264 | 1 | |a [Berkeley, CA] : |b Apress, |c 2018. | |
| 264 | 4 | |c ©2018 | |
| 300 | |a 1 online resource | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a text file | ||
| 347 | |b PDF | ||
| 588 | 0 | |a Online resource; title from PDF title page (SpringerLink, viewed September 18, 2018). | |
| 505 | 0 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 520 | |a 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. | ||
| 504 | |a Includes bibliographical references and index. | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a MySQL (Electronic resource) |
| 630 | 0 | 7 | |a MySQL (Electronic resource) |2 fast |0 (OCoLC)fst01395715 |
| 650 | 0 | |a Database management. | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 7 | |a Computer programming |x software development. |2 bicssc | |
| 650 | 7 | |a Databases. |2 bicssc | |
| 650 | 7 | |a COMPUTERS |x Databases |x General. |2 bisacsh | |
| 650 | 7 | |a Database management. |2 fast |0 (OCoLC)fst00888037 | |
| 776 | 0 | 8 | |i Print version: |a Bell, Charles. |t Introducing InnoDB Cluster. |d [Berkeley, CA] : Apress, 2018 |z 1484238842 |z 9781484238844 |w (OCoLC)1042352832 |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781484238851/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH35199999 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL5510546 | ||
| 938 | |a EBSCOhost |b EBSC |n 1887314 | ||
| 938 | |a YBP Library Services |b YANK |n 15698304 | ||
| 994 | |a 92 |b IZTAP | ||