High Performance MySQL
(Sprache: Englisch)
As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance--issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to these little...
Leider schon ausverkauft
versandkostenfrei
Buch
38.00 €
Produktdetails
Produktinformationen zu „High Performance MySQL “
As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance--issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to these little understood topics.
Author Jeremy Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo!, maintained years of contacts with the MySQL AB team, and presents regularly at conferences. Jeremy and Derek have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmarking, and writing some of their own tools in order to produce the information in this book.
In High Performance MySQL you will learn about MySQL indexing and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments. And you'll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs.
Topics include:
* A review of configuration and setup options
* Storage engines and table types
* Benchmarking
* Indexes
* Query Optimization
* Application Design
* Server Performance
* Replication
* Load-balancing
* Backup and Recovery
* Security
Author Jeremy Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo!, maintained years of contacts with the MySQL AB team, and presents regularly at conferences. Jeremy and Derek have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmarking, and writing some of their own tools in order to produce the information in this book.
In High Performance MySQL you will learn about MySQL indexing and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments. And you'll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs.
Topics include:
* A review of configuration and setup options
* Storage engines and table types
* Benchmarking
* Indexes
* Query Optimization
* Application Design
* Server Performance
* Replication
* Load-balancing
* Backup and Recovery
* Security
Klappentext zu „High Performance MySQL “
As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance--issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to these little understood topics.Author Jeremy Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo!, maintained years of contacts with the MySQL AB team, and presents regularly at conferences. Jeremy and Derek have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmarking, and writing some of their own tools in order to produce the information in this book.In High Performance MySQL you will learn about MySQL indexing and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments.And you'll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs.Topics include: A review of configuration and setup options Storage engines and table types Benchmarking Indexes Query Optimization Application Design Server Performance Replication Load-balancing Backup and Recovery Security.
As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance-issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to these little understood topics.
Author Jeremy Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo!, maintained years of contacts with the MySQL AB team, and presents regularly at conferences. Jeremy and Derek have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmarking, and writing some of their own tools in order to produce the information in this book.
In High Performance MySQL you will learn about MySQL indexing and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments. And you'll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs.
Topics include:
- A review of configuration and setup options
- Storage engines and table types
- Benchmarking
- Indexes
- Query Optimization
- Application Design
- Server Performance
- Replication
- Load-balancing
- Backup and Recovery
- Security
Author Jeremy Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo!, maintained years of contacts with the MySQL AB team, and presents regularly at conferences. Jeremy and Derek have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmarking, and writing some of their own tools in order to produce the information in this book.
In High Performance MySQL you will learn about MySQL indexing and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments. And you'll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs.
Topics include:
- A review of configuration and setup options
- Storage engines and table types
- Benchmarking
- Indexes
- Query Optimization
- Application Design
- Server Performance
- Replication
- Load-balancing
- Backup and Recovery
- Security
Autoren-Porträt von Jeremy D. Zawodny, Derek J. Balling
Jeremy Zawodny moved from Northwest Ohio to Silicon Valley in late 1999 so he could work for Yahoo!--just in time to witness the .com bubble bursting first-hand. He's been at Yahoo! ever since, helping to put MySQL and other Open Source technologies to use in fun, interesting, and often very big ways. Starting with the popular and high-traffic Yahoo! Finance site, he worked to make MySQL part of the site's core infrastructure in large batch operations as well as real-time feed processing and serving content directly on the site. He then helped to spread "the MySQL religion" to numerous other groups within Yahoo!. Nowadays he acts as Yahoo!'s MySQL guru, working with Yahoo!'s many engineering groups to get the most out of their MySQL deployments. In 2000, he began writing for Linux Magazine and continues to do so today as a columnist and contributing editor.Derek J. Balling has been a Perl programmer and UNIX/Linux system administrator since 1996, having helped build two different ISPs from the ground up in the midwestern United States. He spent several years of his career at Yahoo!, working in their Infrastructure Group, where he worked on tools to help improve system uptime. He presently works as a system administrator at Vassar College. He has also written articles for "The Perl Journal" and a number of online magazines.
Bibliographische Angaben
- Autoren: Jeremy D. Zawodny , Derek J. Balling
- 2004, XVI, 276 Seiten, mit Schwarz-Weiß-Abbildungen, Maße: 23,5 cm, Kartoniert (TB), Englisch
- Verlag: O'Reilly Media
- ISBN-10: 0596003064
- ISBN-13: 9780596003067
Sprache:
Englisch
Rezension zu „High Performance MySQL “
"Das vorliegende Buch richtet sich an MySQL-Administratoren, die kleine wie große Serverinstallationen optimal für Performanz und Verfügbarkeit einrichten wollen. Die Autoren greifen auf ihre umfangreiche (und in der Community geschätzte) Erfahrung zurück. Zawodny ist für die MySQL-Server-Farm bei Yahoo verantwortlich und hat unter anderem die in dem Buch behandelten Werkzeuge mytop und MyBench geschrieben. Balling hat mehrere Jahre in der Yahoo-Infrastruktur-Gruppe gearbeitet. In insgesamt 10 Kapiteln behandeln die Autoren Themen aus dem Bereichen Optimierung, Sicherung, Replikation und Lastverteilung. `Back to Basics' und `Benchmarking' fallen insofern aus dem Rahmen, als sie die Grundlagen und das Vokabular für das Verständnis der übrigen Kapitel bereitstellen. Kapitel 2 ist unterschiedlichen Storage Engines gewidmet. Detailliert werden Eigenschaften, Vor-/Nachteile derjenigen MySQL-Programmmodule vorgestellt, die für die eigentliche Speicherung der Daten verantwortlich sind. Anhand praxisnaher Beispiele helfen die Autoren dem Leser bei der Frage nach der geeigneten Storage Engine. Die Kapitel 4 und 5 behandeln die Verbesserung der Ausführungsgeschwindigkeit von SQL-Anfragen. Unter anderem werden die in MySQL verwendbaren Indexverfahren sowie das Profiling von SQL-Anfragen behandelt. Kapitel 6 beschäftigt sich mit der Performanzoptimierung des Servers und gibt hilfreiche Tipps für die Wahl von Hardware, Betriebssystem sowie das Auflösen von Flaschenhälsen. Hochverfügbarkeit und Lastenverteilung auf Basis von Replikation sind Bestandteil des achten Abschnitts. Da die Cluster-Technik bei Drucklegung der ersten Auflage noch nicht verfügbar war (sie wurde erst im April vorgestellt), geben die Autoren nur einen kurzen Ausblick auf dieser Alternative zur Replikation und führen in einem weiteren Kapitel verschiedene Strategien für Backup und Recovery von MySQL-Datenbanken ein. Das letzte Kapitel behandelt Sicherheitsaspekte bei der Installation und Konfiguration eines
... mehr
MySQL-Servers. In den Anhängen werden unter anderem die bekannte phpMyAdmin-Software für die Browser-gestützte Wartung einer MySQL-Installation sowie mytop, ein top-Klon für MySQL, vorgestellt. Gegenstand der Untersuchung ist vorrangig MySQL 4.0 (ab Version 4.0.14). Auf Neuerungen in den aktuellen Entwicklerversionen 4.1 (Alpha) und MySQL 5.0 (Preview) gehen Zawodny und Balling jeodch ein. In Teilen ist das Buch sogar für Administratoren relevant, die noch 3.23-Installationen verwalten.
Das Buch ist Administratoren (und Entwicklern) uneingeschränkt zu empfehlen." - iX, 08/2004, Sebastian Bergmann
"Man merkt, dass die Autoren über viel Erfahrung verfügen und somit in der Lage sind, auch kniffelige Sachverhalte anzugehen. Überdies haben sie es verstanden, ihr Anliegen prägnant vor der Leserschaft auszubreiten. Der Leser muss nicht erst eine ellenlange Einführung über sich ergehen lassen, um nach ungefähr 100 Seiten festzustellen, dass er das falsche Buch gekauft hat! Zusätzlich steuert das Autorenteam Tools und Skripte der Marke `Eigenbau' bei (Perl-Skripte). Ansonsten findet man etliche Beispiele für effektive SQL-Statements und Konfigurationsmöglichkeiten." - PHP Magazin, 02/2005, Thomas Kaufmann
Das Buch ist Administratoren (und Entwicklern) uneingeschränkt zu empfehlen." - iX, 08/2004, Sebastian Bergmann
"Man merkt, dass die Autoren über viel Erfahrung verfügen und somit in der Lage sind, auch kniffelige Sachverhalte anzugehen. Überdies haben sie es verstanden, ihr Anliegen prägnant vor der Leserschaft auszubreiten. Der Leser muss nicht erst eine ellenlange Einführung über sich ergehen lassen, um nach ungefähr 100 Seiten festzustellen, dass er das falsche Buch gekauft hat! Zusätzlich steuert das Autorenteam Tools und Skripte der Marke `Eigenbau' bei (Perl-Skripte). Ansonsten findet man etliche Beispiele für effektive SQL-Statements und Konfigurationsmöglichkeiten." - PHP Magazin, 02/2005, Thomas Kaufmann
... weniger
Kommentar zu "High Performance MySQL"
0 Gebrauchte Artikel zu „High Performance MySQL“
Zustand | Preis | Porto | Zahlung | Verkäufer | Rating |
---|
Schreiben Sie einen Kommentar zu "High Performance MySQL".
Kommentar verfassen