High Availability MySQL Cookbook.

Over 60 simple but incredibly effective recipes focusing on different methods of achieving high availability for MySQL database.

Saved in:
Bibliographic Details
Main Author: Davies, Alex
Format: eBook
Language:English
Published: Birmingham : Packt Pub., 2010.
Subjects:
Online Access:Click for online access

MARC

LEADER 00000cam a2200000 4500
001 ocn796383959
003 OCoLC
005 20240909213021.0
006 m o d
007 cr unu||||||||
008 121121s2010 enk o 000 0 eng d
040 |a EBLCP  |b eng  |e pn  |c EBLCP  |d OCLCQ  |d DEBSZ  |d OCLCQ  |d ZCU  |d MERUC  |d ICG  |d OCLCO  |d OCLCF  |d OCLCQ  |d OCLCO  |d OCLCQ  |d DKC  |d AU@  |d OCLCQ  |d OCLCO  |d OCLCQ  |d OCLCO  |d OCLCQ 
020 |a 9781847199959 
020 |a 184719995X 
035 |a (OCoLC)796383959 
050 4 |a QA76.73.S67 D38 2010 
049 |a HCDD 
100 1 |a Davies, Alex. 
245 1 0 |a High Availability MySQL Cookbook. 
260 |a Birmingham :  |b Packt Pub.,  |c 2010. 
300 |a 1 online resource (447 pages) 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
505 0 |a High Availability MySQL Cookbook; High Availability MySQL Cookbook; Credits; About the Author; About the Reviewers; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Errata; Piracy; Questions; 1. High Availability with MySQL Cluster; Introduction; Designing a MySQL Cluster; How to do it ... ; How it works ... ; There's more ... ; Creating an initial cluster configuration file-config.ini; How to do it ... ; There's more ... ; Installing a management node; How to do it ... ; Starting a management node; How to do it ... 
505 8 |a There's more ... Installing and starting storage nodes; Getting ready; How to do it ... ; There's more ... ; Installing and starting SQL nodes; How to do it ... ; Creating a MySQL Cluster table; How to do it ... ; Restarting a MySQL Cluster without downtime; Getting started; How to do it ... ; Recovering from a cluster shutdown; How to do it ... ; How it works ... ; There's more ... ; 2. MySQL Cluster Backup and Recovery; Introduction; Importing SQL files to a MySQL server and converting them to MySQL Cluster; How to do it ... ; There's more ... ; Taking an online backup of a MySQL Cluster; Getting ready. 
505 8 |a How to do it ... There's more ... ; Preventing commands hanging; Aborting backups in progress; Defining an exact time for a consistent backup; Restoring from a MySQL Cluster online backup; How to do it ... ; Restricting write access to a MySQL Cluster with single-user mode; How to do it ... ; There's more ... ; Taking an offline backup with MySQL Cluster; How to do it ... ; There's more ... ; Importing a cluster SQL file to an unclustered MySQL Server; Running mysqldump for a consistent backup; 3. MySQL Cluster Management; Introduction; Configuring multiple management nodes; Getting ready; How to do it ... 
505 8 |a There's more ... See also; Obtaining usage information; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Adding storage nodes online; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Replicating between MySQL Clusters; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Replication between clusters with a backup channel; How to do it ... ; There's more ... ; See also; User-defined partitioning; Getting ready; How to do it ... ; There's more ... ; Disk-based tables; Getting ready; How to do it ... ; How it works ... ; There's more ... 
505 8 |a Calculating DataMemory and IndexMemoryGetting ready; How to do it ... ; There's more ... ; See also; 4. MySQL Cluster Troubleshooting; Introduction; Single storage node failure; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Multiple storage node failures; Getting ready; How to do it ... ; Storage node partitioning and arbitration; Getting ready; How to do it ... ; How it works ... ; Debugging MySQL Clusters; Getting ready; How to do it ... ; There's more ... ; Firewalls; Host resolution; Memory; Seeking help; Getting ready; How to do it ... ; There's more ... 
520 |a Over 60 simple but incredibly effective recipes focusing on different methods of achieving high availability for MySQL database. 
588 0 |a Print version record. 
650 0 |a SQL (Computer program language) 
650 0 |a Database management. 
650 7 |a Database management  |2 fast 
650 7 |a SQL (Computer program language)  |2 fast 
776 0 8 |i Print version:  |a Davies, Alex.  |t High Availability MySQL Cookbook.  |d Birmingham : Packt Publishing, ©2010  |z 9781847199942 
856 4 0 |u https://ebookcentral.proquest.com/lib/holycrosscollege-ebooks/detail.action?docID=944947  |y Click for online access 
903 |a EBC-AC 
994 |a 92  |b HCD