High availability MySQL cookbook.
(eBook)
Author
Published
Birmingham, U.K. : Packt Pub., ©2010.
Format
eBook
ISBN
9781847199959, 184719995X
Physical Desc
1 online resource ([5], iii, 261 pages) : illustrations
Status
Description
Loading Description...
Also in this Series
Checking series information...
Subjects
OCLC Fast Subjects
More Details
Language
English
Notes
Description
Annotation High Availability is something that all web sites hope to achieve, especially those that are linked to big companies. MySQL, an open source relational database management system (RDBMS), can be made highly available to protect from corruption, hardware failure, software crashes, and user error. Running a MySQL setup is quite simple. Things start getting complex when you start thinking about the best way to provide redundancy. There are a large number of techniques available to add 'redundancy' and 'high availability' to MySQL, but most are both poorly understood and documented. This book will provide you with recipes showing how to design, implement, and manage a MySQL Cluster and achieve high availability using MySQL replication, block level replication, shared storage, and the open source Global File System (GFS). This book covers all the major techniques available for increasing availability of your MySQL databases. It demonstrates how to design, implement, troubleshoot and manage a highly available MySQL setup using any one of several techniques, which are shown in different recipes. It is based on MySQL Cluster 7.0, MySQL (for non clustered recipes) 5.0.77, and CentOS / RedHat Enterprise Linux 5.3. The book starts by introducing MySQL Cluster as a technology and explaining how to set up a simple cluster. It will help you to master the options available for backing up and restoring a file in the MySQL Cluster. By following the practical examples in this book, you will learn how to manage the MySQL Cluster. Further, we will discuss some troubleshooting aspects of the MySQL Cluster. We also have a look at achieving high availability for MySQL databases with the techniques of MySQL Replication, block level replication, shared storage (a SAN or NAS), and DRBD. Finally, you will learn the principles of Performance tuning and tune MySQL database for optimal performance.
Local note
O'Reilly,O'Reilly Online Learning: Academic/Public Library Edition
Reviews from GoodReads
Loading GoodReads Reviews.
Citations
APA Citation, 7th Edition (style guide)
Davies, A. (2010). High availability MySQL cookbook . Packt Pub..
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Davies, Alex, 1987-. 2010. High Availability MySQL Cookbook. Packt Pub.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Davies, Alex, 1987-. High Availability MySQL Cookbook Packt Pub, 2010.
MLA Citation, 9th Edition (style guide)Davies, Alex. High Availability MySQL Cookbook Packt Pub., 2010.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.
Staff View
Grouped Work ID
4846c3b6-dd11-5944-99e7-6df39a98e479-eng
Grouping Information
Grouped Work ID | 4846c3b6-dd11-5944-99e7-6df39a98e479-eng |
---|---|
Full title | high availability mysql cookbook |
Author | davies alex |
Grouping Category | book |
Last Update | 2023-12-11 15:41:25PM |
Last Indexed | 2024-03-29 02:39:32AM |
Book Cover Information
Image Source | syndetics |
---|---|
First Loaded | Jan 17, 2023 |
Last Used | Mar 25, 2024 |
Marc Record
First Detected | Nov 09, 2022 03:40:26 PM |
---|---|
Last File Modification Time | Dec 11, 2023 03:47:15 PM |
MARC Record
LEADER | 04276cam a2200565Ia 4500 | ||
---|---|---|---|
001 | ocn699810119 | ||
003 | OCoLC | ||
005 | 20231006123411.0 | ||
006 | m o d | ||
007 | cr unu|||||||| | ||
008 | 110201s2010 enka o 001 0 eng d | ||
019 | |a 968088776|a 969049579 | ||
020 | |a 9781847199959 | ||
020 | |a 184719995X | ||
020 | |z 1847199941 | ||
020 | |z 9781847199942 | ||
029 | 1 | |a DEBSZ|b 355449927 | |
029 | 1 | |a GBVCP|b 785355111 | |
035 | |a (OCoLC)699810119|z (OCoLC)968088776|z (OCoLC)969049579 | ||
037 | |a CL0500000082|b Safari Books Online | ||
040 | |a UMI|b eng|e pn|c UMI|d OCLCQ|d TOL|d DEBSZ|d OCLCQ|d OCLCF|d OCLCQ|d DKDLA|d OCLCQ|d FEM|d OCLCQ|d CEF|d UAB|d OCLCO|d OCLCQ | ||
049 | |a TKLA | ||
050 | 4 | |a QA76.73.S67|b D384 2010 | |
082 | 0 | 4 | |a 005.75/85|q OCoLC|2 22/eng/20230216 |
100 | 1 | |a Davies, Alex,|d 1987-|0 http://id.loc.gov/authorities/names/nr2006011372 | |
245 | 1 | 0 | |a High availability MySQL cookbook. |
260 | |a Birmingham, U.K. :|b Packt Pub.,|c ©2010. | ||
300 | |a 1 online resource ([5], iii, 261 pages) :|b illustrations | ||
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|2 rda | ||
520 | 8 | |a Annotation High Availability is something that all web sites hope to achieve, especially those that are linked to big companies. MySQL, an open source relational database management system (RDBMS), can be made highly available to protect from corruption, hardware failure, software crashes, and user error. Running a MySQL setup is quite simple. Things start getting complex when you start thinking about the best way to provide redundancy. There are a large number of techniques available to add 'redundancy' and 'high availability' to MySQL, but most are both poorly understood and documented. This book will provide you with recipes showing how to design, implement, and manage a MySQL Cluster and achieve high availability using MySQL replication, block level replication, shared storage, and the open source Global File System (GFS). This book covers all the major techniques available for increasing availability of your MySQL databases. It demonstrates how to design, implement, troubleshoot and manage a highly available MySQL setup using any one of several techniques, which are shown in different recipes. It is based on MySQL Cluster 7.0, MySQL (for non clustered recipes) 5.0.77, and CentOS / RedHat Enterprise Linux 5.3. The book starts by introducing MySQL Cluster as a technology and explaining how to set up a simple cluster. It will help you to master the options available for backing up and restoring a file in the MySQL Cluster. By following the practical examples in this book, you will learn how to manage the MySQL Cluster. Further, we will discuss some troubleshooting aspects of the MySQL Cluster. We also have a look at achieving high availability for MySQL databases with the techniques of MySQL Replication, block level replication, shared storage (a SAN or NAS), and DRBD. Finally, you will learn the principles of Performance tuning and tune MySQL database for optimal performance. | |
588 | 0 | |a Print version record. | |
590 | |a O'Reilly|b O'Reilly Online Learning: Academic/Public Library Edition | ||
630 | 0 | 0 | |a MySQL (Electronic resource)|0 http://id.loc.gov/authorities/names/n2004021601 |
630 | 0 | 7 | |a MySQL (Electronic resource)|2 blmlsh |
630 | 0 | 7 | |a MySQL (Electronic resource)|2 fast|0 (OCoLC)fst01395715 |
650 | 0 | |a Database management.|0 http://id.loc.gov/authorities/subjects/sh85035848 | |
650 | 0 | |a Relational databases.|0 http://id.loc.gov/authorities/subjects/sh86007768 | |
650 | 6 | |a Bases de données|x Gestion. | |
650 | 6 | |a Bases de données relationnelles. | |
650 | 7 | |a Database management.|2 blmlsh | |
650 | 7 | |a Relational databases.|2 blmlsh | |
650 | 7 | |a Database management.|2 fast|0 (OCoLC)fst00888037 | |
650 | 7 | |a Relational databases.|2 fast|0 (OCoLC)fst01093575 | |
655 | 4 | |a Programming Languages. | |
776 | 0 | 8 | |i Print version:|a Davies, A.|t High availability MySQL cookbook.|d [S.l.] : Packt Publishing Limited|z 1847199941|w (OCoLC)680435007 |
856 | 4 | 0 | |u https://ezproxy.knoxlib.org/login?url=https://learning.oreilly.com/library/view/~/9781847199942/?ar |
994 | |a 92|b TKL |