MySQL Admin Cookbook
and over one million other books are available for Amazon Kindle .
Learn more
| |||||||||||||||
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Frequently Bought Together
Product details
|
Product Description
Product Description
MySQL is the most popular open-source database and is also known for its easy set up feature. However, proper configuration beyond the default settings still is a challenge, along with some other day-to-day maintenance tasks such as backing up and restoring, performance tuning, and server monitoring. These tasks have not been covered thoroughly in the default documentation.
This book provides both step-by-step recipes and relevant background information on these topics and more. It covers everything from basic to advanced aspects of MySQL administration and configuration. One of the things you are really going to love about this book is that all recipes are based on real-world experience and were derived from proven solutions used in an enterprise environment.
This book shows you everything you need to know about MySQL Administration. You will learn to set up MySQL replication to manage load balancing and deal with online backup and fail-over scenarios. As you consider the benefits of backing up, you might like to back up your database efficiently with advanced techniques covered in this book.
The book demonstrates how to create, modify, and delete indexes. You will also learn to identify duplicate indexes, which hinder your MySQL server performance. This book focuses on administration tasks and will help you as an administrator to optimize the database for efficiency and reliability.
You will learn to manage data efficiently by inserting data in existing database content and importing and exporting databases. The sooner you learn about taking advantage of metadata from this book, the sooner you can start using the space efficiently. Get to know about managing users and assigning privileges and regaining lost administrative user credentials. Finally, learn to manage the database schema by customizing it to automate database schema evolution in the context of application updates.
This book provides both step-by-step recipes and relevant background information on these topics and more. It covers everything from basic to advanced aspects of MySQL administration and configuration. One of the things you are really going to love about this book is that all recipes are based on real-world experience and were derived from proven solutions used in an enterprise environment.
This book shows you everything you need to know about MySQL Administration. You will learn to set up MySQL replication to manage load balancing and deal with online backup and fail-over scenarios. As you consider the benefits of backing up, you might like to back up your database efficiently with advanced techniques covered in this book.
The book demonstrates how to create, modify, and delete indexes. You will also learn to identify duplicate indexes, which hinder your MySQL server performance. This book focuses on administration tasks and will help you as an administrator to optimize the database for efficiency and reliability.
You will learn to manage data efficiently by inserting data in existing database content and importing and exporting databases. The sooner you learn about taking advantage of metadata from this book, the sooner you can start using the space efficiently. Get to know about managing users and assigning privileges and regaining lost administrative user credentials. Finally, learn to manage the database schema by customizing it to automate database schema evolution in the context of application updates.
About the Author
Daniel Schneller
Daniel Schneller works as a software developer, database administrator, and general IT professional for an independent software vendor in the retail sector. After successfully graduating from the University of Cooperative Education in Heidenheim, Germany with a degree in Business Computer Science, he started his career as a professional software developer, focused on the Microsoft technology stack. In 2002 he started focusing on enterprise-level Java development and has since gained extensive knowledge and experience implementing large scale systems based on Java EE and relational databases, especially MySQL since version 4.0.
Currently he is mostly involved with the ongoing development of framework-level functionality, including customization and extension of an ORM-based persistence layer. He is involved in different open source projects such as FindBugs, Eclipse, and Checkstyle and infrequently blogs about Java, MySQL, Windows, Linux and other insanities.
Udo Schwedt
Udo Schwedt is head of the Java architecture team and deputy head of the Java development department at the IT service provider for Germany's market leader in the Do-It-Yourself sector. After finishing his studies at RWTH Aachen, Germany with a degree in Computer Science, he started his career as a professional Java developer in a leading software company in the banking sector. In 2003, he joined his current company as a framework developer, subsequently taking the role of a lead architect.
Both authors are involved in a large scale international software project, which encompasses development of a Java-based merchandise management software solution. This decentralized multi-platform environment is based on more than 500 decentralized MySQL server instances with more than 5,500 replication slaves. Daniel and Udo are responsible for configuration and management of this infrastructure.
Inside This Book
(Learn More)
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 organise and find favourite items. |
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
4 reviews
2 of 2 people found the following review helpful
Some missing recipes
28 April 2010
Format:Paperback
This book is a great first attempt at a book that has been needed for a long time. It covers the everyday practical parts of managing a MySQL server.
I have been hungry for this book for a long time. Most books about MySQL focus on the SQL language and give you long chapters on how to form complex queries. Or, they dive deep into MySQL commands command and the use of my.cnf. I have a bookshelf full of these books. None have given me help making backups on-the-fly without interrupting customer services or preventing mysqldump from failing with error 2013. This book, "MySQL Admin Cookbook", covers everyday issues database administrators (DBA) face.
I'm calling it a "first attempt" because you'll get a taste of the practical side but the authors don't give you all the tools. It covers transferring connections settings between different machines with a network share. Good. It doesn't talk enough about the tools every MySQL DBA know, like MaatKit, openarkkit, mycheckpoint, mysqltuner and so many more.
Another example, Chapter 5 covers the common details for loading large data sets using the LOAD DATA INFILE command. Common. But it doesn't talk about how you can replace a CSV or MyIsam files directly with tools like mysql-replace-tables-live.
If you are NOT a DBA and MySQL is something you're using, I FULLY recommend this book. If you are a DBA, unless your new, you will find most of this book covers things you have already learned on your own.
This book starts like a very good HOWTO with replication in chapter one without mentioning
the monitoring tool mk-heartbeat. By chapter six it get cooking with good tips on analyzing, monitoring and configuring your MySQL and then simmers to an ending with managing users and schemas.
I look forward to Rev2 of this book when it really gets cooking.
99 GREAT recipes? No. Everyday foods is more what it is.
I have been hungry for this book for a long time. Most books about MySQL focus on the SQL language and give you long chapters on how to form complex queries. Or, they dive deep into MySQL commands command and the use of my.cnf. I have a bookshelf full of these books. None have given me help making backups on-the-fly without interrupting customer services or preventing mysqldump from failing with error 2013. This book, "MySQL Admin Cookbook", covers everyday issues database administrators (DBA) face.
I'm calling it a "first attempt" because you'll get a taste of the practical side but the authors don't give you all the tools. It covers transferring connections settings between different machines with a network share. Good. It doesn't talk enough about the tools every MySQL DBA know, like MaatKit, openarkkit, mycheckpoint, mysqltuner and so many more.
Another example, Chapter 5 covers the common details for loading large data sets using the LOAD DATA INFILE command. Common. But it doesn't talk about how you can replace a CSV or MyIsam files directly with tools like mysql-replace-tables-live.
If you are NOT a DBA and MySQL is something you're using, I FULLY recommend this book. If you are a DBA, unless your new, you will find most of this book covers things you have already learned on your own.
This book starts like a very good HOWTO with replication in chapter one without mentioning
the monitoring tool mk-heartbeat. By chapter six it get cooking with good tips on analyzing, monitoring and configuring your MySQL and then simmers to an ending with managing users and schemas.
I look forward to Rev2 of this book when it really gets cooking.
99 GREAT recipes? No. Everyday foods is more what it is.
Different than what I expected
13 May 2010
Format:Paperback
I use PHP and HTML in my day to day work and I have dabbled in MySQL. However, I have not done much beyond the basic PHPMyAdmin and MySQL database design. So I was intrigued by a more thorough look into the technology that is used to power the data driven sites that I create. As I began to read this book, I have to admit that I was quickly overwhelmed by the depth of what was being covered. It is way beyond what my current level will allow me to understand. But, that really isn't the book's problem, it is my own lack of knowledge and experience!
I can see this book being a tremendous asset as I continue to learn how to manage large-scale MySQL installs. Having a collection of "recipes" for many different issues and situations is a great benefit.
This is a very targeted, focused book and it is also a great resource for the individual that occasionally finds himself working on a MySQL database. The techniques and tools are there, but it is not for the faint of heart!
I can see this book being a tremendous asset as I continue to learn how to manage large-scale MySQL installs. Having a collection of "recipes" for many different issues and situations is a great benefit.
This is a very targeted, focused book and it is also a great resource for the individual that occasionally finds himself working on a MySQL database. The techniques and tools are there, but it is not for the faint of heart!
A good place for Novices and Intermediates to start
21 April 2010
Format:Paperback
Usually I try to avoid the cookbook type of computer books because usually the 'recipies', often messy scripts or pages of obfuscated code, seem only to work for the authors and not for me. So I had a little trepidation when I was asked to review the MySQL Admin Cookbook. Daniel Schneller and Udo Schwedt manage to pack a lot of very solid information into 360 pages of text that would work for novice to intermediate MySQL DBAs and provide some food for thought for seasoned DBAs.
What I liked: The material was presented with the reasons behind the recipe and pointers to useful tools. Yes, all the material is in the manuals but sometimes there are too many trees in the way for a novice so see the trees. In very calm ,concise language, the authors tackle successfully a wide range of DBA chores in a way that is easy to follow.
I would not hesitate to give this book to a novice to intermediate DBA as a tool to help them work through replication, configuration, indexes and tools.
What I did not like: Time has marched on and the references to MySQL Administrator make a few tiny sections seem dated but I am sure only the Workbench team knew what that product would evolve into. Also the section on monitoring is a bit light but then most DBAs do not need to wade in as deeply as the book goes let alone into Enterprise Monitor or other tools.
So this book is a solid four out of five stars and well worth being brought home by those new to MySQL DBA work and those seeking 'recipes' for thier instances.
What I liked: The material was presented with the reasons behind the recipe and pointers to useful tools. Yes, all the material is in the manuals but sometimes there are too many trees in the way for a novice so see the trees. In very calm ,concise language, the authors tackle successfully a wide range of DBA chores in a way that is easy to follow.
I would not hesitate to give this book to a novice to intermediate DBA as a tool to help them work through replication, configuration, indexes and tools.
What I did not like: Time has marched on and the references to MySQL Administrator make a few tiny sections seem dated but I am sure only the Workbench team knew what that product would evolve into. Also the section on monitoring is a bit light but then most DBAs do not need to wade in as deeply as the book goes let alone into Enterprise Monitor or other tools.
So this book is a solid four out of five stars and well worth being brought home by those new to MySQL DBA work and those seeking 'recipes' for thier instances.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
