High availability MySQL cookbook.
(eBook)

Book Cover
Average Rating
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...

More Like This

Loading more titles like this title...

Syndetics Unbound

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
Go To Grouped Work

Grouping Information

Grouped Work ID4846c3b6-dd11-5944-99e7-6df39a98e479-eng
Full titlehigh availability mysql cookbook
Authordavies alex
Grouping Categorybook
Last Update2023-12-11 15:41:25PM
Last Indexed2024-03-29 02:39:32AM

Book Cover Information

Image Sourcesyndetics
First LoadedJan 17, 2023
Last UsedMar 25, 2024

Marc Record

First DetectedNov 09, 2022 03:40:26 PM
Last File Modification TimeDec 11, 2023 03:47:15 PM

MARC Record

LEADER04276cam a2200565Ia 4500
001ocn699810119
003OCoLC
00520231006123411.0
006m     o  d        
007cr unu||||||||
008110201s2010    enka    o     001 0 eng d
019 |a 968088776|a 969049579
020 |a 9781847199959
020 |a 184719995X
020 |z 1847199941
020 |z 9781847199942
0291 |a DEBSZ|b 355449927
0291 |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
08204|a 005.75/85|q OCoLC|2 22/eng/20230216
1001 |a Davies, Alex,|d 1987-|0 http://id.loc.gov/authorities/names/nr2006011372
24510|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
5208 |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.
5880 |a Print version record.
590 |a O'Reilly|b O'Reilly Online Learning: Academic/Public Library Edition
63000|a MySQL (Electronic resource)|0 http://id.loc.gov/authorities/names/n2004021601
63007|a MySQL (Electronic resource)|2 blmlsh
63007|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.
77608|i Print version:|a Davies, A.|t High availability MySQL cookbook.|d [S.l.] : Packt Publishing Limited|z 1847199941|w (OCoLC)680435007
85640|u https://ezproxy.knoxlib.org/login?url=https://learning.oreilly.com/library/view/~/9781847199942/?ar
994 |a 92|b TKL