Vous voulez voir cette page en français ? Cliquez ici.

 

or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
16 used & new from CDN$ 23.95
Have one to sell? Sell yours here
 
   
High Performance MySQL: Optimization, Backups, Replication, Load Balancing & More
 
See larger image 
Share your own customer images
Publisher: learn how customers can search inside this book.

High Performance MySQL: Optimization, Backups, Replication, Load Balancing & More (Paperback)

by Jeremy D Zawodny (Author), Derek J Balling (Author), Zawodny Jeremy (Author), Balling Derek (Author)
4.8 out of 5 stars  See all reviews (9 customer reviews)
List Price: CDN$ 57.95
Price: CDN$ 36.51 & eligible for FREE Super Saver Shipping on orders over CDN$ 39. Details
You Save: CDN$ 21.44 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Temporarily out of stock.
Order now and we'll deliver when available. We'll e-mail you with an estimated delivery date as soon as we have more information. Your account will only be charged when we ship the item.
Ships from and sold by Amazon.ca. Gift-wrap available.

8 new from CDN$ 36.51 8 used from CDN$ 23.95

Frequently Bought Together

Customers buy this book with MySQL Cookbook by Paul DuBois

High Performance MySQL: Optimization, Backups, Replication, Load Balancing & More + MySQL Cookbook
Price For Both: CDN$ 77.45

One of these items ships sooner than the other. Show details

  • This item: High Performance MySQL: Optimization, Backups, Replication, Load Balancing & More by Jeremy D Zawodny

    Temporarily out of stock.
    Order now and we'll deliver when available. We'll e-mail you with an estimated delivery date as soon as we have more information. Your account will only be charged when we ship the item.
    Ships from and sold by Amazon.ca.
    Eligible for FREE Super Saver Shipping on orders over CDN$ 39. Details

  • MySQL Cookbook by Paul DuBois

    In Stock.
    Ships from and sold by Amazon.ca.
    This item ships for FREE with Super Saver Shipping. Details

Customers Who Bought This Item Also Bought

MySQL Cookbook

MySQL Cookbook

by Paul DuBois
4.8 out of 5 stars (8)  CDN$ 40.94
Understanding MySQL Internals

Understanding MySQL Internals

by Sasha Pachev
CDN$ 40.94
MySQL Administrator's Guide and Language Reference

MySQL Administrator's Guide and Language Reference

by MySQL AB
4.5 out of 5 stars (2)  CDN$ 37.79
MySQL 5.0 Certification Study Guide

MySQL 5.0 Certification Study Guide

by Paul DuBois
CDN$ 49.13
Building Scalable Web Sites: Building, Scaling, and Optimizing the Next Generation of Web Applications

Building Scalable Web Sites: Building, Scaling, and Optimizing the Next Generation of Web Applications

by Cal Henderson
CDN$ 32.75
› Explore similar items

Product Details

Product Description

Product Description

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


About the Author

Zawodny is an engineer at Yahoo!


Balling has been a Perl programmer and Unix/Linux system administrator since 1996, having helped build two different ISPs frm the ground up in the midwestern United States. He presently works at a healthcare supply company in the New York metropolitan area, helping infiltrate the Open Source virus into their infrastructure.

Tag this product

 (What's this?)
Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items.
Your tags: Add your first tag
 
See most popular tags

What do customers ultimately buy after viewing this item?

High Performance MySQL: Optimization, Backups, Replication, and More
55% buy
High Performance MySQL: Optimization, Backups, Replication, and More
CDN$ 29.69
High Performance MySQL: Optimization, Backups, Replication, Load Balancing & More
23% buy the item featured on this page:
High Performance MySQL: Optimization, Backups, Replication, Load Balancing & More 4.8 out of 5 stars (9)
CDN$ 36.51
MySQL
10% buy
MySQL 4.7 out of 5 stars (101)
CDN$ 34.64
MySQL Administrator's Guide and Language Reference
8% buy
MySQL Administrator's Guide and Language Reference 4.5 out of 5 stars (2)
CDN$ 37.79
Explore similar items
 

Customer Reviews

9 Reviews
5 star:
 (7)
4 star:
 (2)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.8 out of 5 stars (9 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most helpful customer reviews

 
5.0 out of 5 stars Well explained MySQL concepts, Jul 10 2004
By Ales Kavsek (Ljubljana, Slovenia) - See all my reviews
As an Oracle DBA, I was looking for a book that can help me better understand MySQL core concepts and differences compared to my primary working platform. I was looking for a book with the flavor of Oracle Concepts Manual. I partially read official MySQL reference manual but didn't find (get?) all the answers (nor I really enjoyed reading it - sorry AB doc. team!).
I think this book filled my knowledge gap on MySQL perfectly. Actually, this book could easily bear different title, such as "MySQL concepts guide" or something like that. You'll probably read the book in a couple of days, thanks to the author's clear writing style.
Let me give you an example. Some technical topics are difficult to explain in a few sentences, like the one on letter I (Isolation) from ACID rules for 'safe' transactions. Just compare the explanation on "phantom reads" from this book with the one you'll find in Oracle Concepts Manual (freely available on-line from OTN). Now, which one did you understand on the first pass? ;-)
Thanks to clear and short explanations, right from the beginning of the book, I learned some important technical facts about MySQL that I could easily put in perspective with my Oracle background. For example:
-"All InnoDB tables have primary keys"
-"InnoDB tables are similar to Oracle index-organized tables."
-"MySQL will only ever use one index per table per query!"
-"MySQL doesn't cache rows for MyISAM tables, only indexes...as opposed to InnoDB"
-"...counts are very fast on MyISAM tables and slow on InnoDB tables..."
Obviously the chapters that I liked the most in this book are the ones that covers core things very well:
"2. Storage Engines",
"4. Indexes",
"5. Query Performance" and
"10. Security".
All other chapters are fine but not essential for my current use of MySQL (like the excellent chapter on replication where it's obvious that Jeremy poses vast practical experience with replication from his workplace at Yahoo!).
The only complaint that I have is the one on "Storage Engines" chapter. In my opinion multi storage engine architecture is the most important advantage of MySQL over all other database vendors
products. I wish author's went a little deeper with the details (and thanks but no thanks, I don't want to read source code ;-), especially InnoDB engine is not covered enough (hmm...or maybe it's just me, after all :-).
Overall this book is highly recommended to all DBAs, the existing MySQL DBAs as well as to all others that work with other RDBMS and want a fast way to pick the most important technical nuances of MySQL.
Was this review helpful to you? Yes No (Report this)



 
5.0 out of 5 stars High Performance INDEED!, Jul 3 2004
By Gilbert Lopez (Las Vegas) - See all my reviews
There's mysql documenation, and then there's this book. This book is like taking having the opportunity to pick at a seasoned pro's brain! I have almost every MySQL book out there and while the others merely taught me how to use MySQL, this one taught me how to push make it work FAST and EFFICIENT!

I honestly couldn't believe how much insight and experience I gained from this book. Almost every single page was fun and easy to read. I can honestly say that I can design and build one (...) database now as a direct result of this book.

Thank you so much guys!

Was this review helpful to you? Yes No (Report this)



 
5.0 out of 5 stars The best book on MySQL, Jun 30 2004
By Hayk Rachidian "hayk" (Alexandria, VA USA) - See all my reviews
(REAL NAME)   
I have read many books on MySQL and found this one the best. The book is perfect for me, Systems Architect, Oracle DBA. I found answers for most of my questions on MySQL from the systems, high performance, replication and other advance areas. The book is not for novice users, you need to have some experience in RDBMS to appreciate it. I plan on launching enterprise web site using MySQL, High Performance MySQL answers most of my questions and cleared doubts that I have had on MySQL.
Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 		 Most recent customer reviews

5.0 out of 5 stars Make MySQL efficient
While the authors go over the basics of MySQL briefly in the first couple of chapters this is not a book for the new MySQL administrator. Read more
Published on Jun 6 2004 by Harold McFarland

5.0 out of 5 stars Perfect...
Finally a book that does not spend chapters telling you how to log into MySQL and create a table. I've been heavily using MySQL for 3 years, and know a lot about it, but have... Read more
Published on May 15 2004 by Jason E. Garber

4.0 out of 5 stars Essential for any serious MySQL User
This is a very helpful and informative book. I learned a lot from it even though I have been using MySQL for nearly three years. Read more
Published on May 6 2004 by Jeff S. Barr

5.0 out of 5 stars THE reference for MySQL Administrators
I had the pleasure of being one of the technical reviewers of the book, and seeing the book is now available it's probably a good time to give my opinion on their work. Read more
Published on April 29 2004 by Mike Hillyer

4.0 out of 5 stars Not bad, but should also discuss limitations
MySQL has been gaining many adherents in recent years. The attraction of its open source and free nature is compelling to many. Read more
Published on April 28 2004 by W Boudville

5.0 out of 5 stars This is the one
Jeremy is the best! this books is full of valuable experiencs and insights. most mysql book out there simply copy and pasted the stuffs you can find from mysql. Read more
Published on April 19 2004

Only search this product's reviews


Listmania!

Create a Listmania! list

Look for similar items by category

Look for similar items by subject





















i.e., each book must be in subject 1 AND subject 2 AND ...

Feedback

Would you like to update product info or give feedback on images?

Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.