MySQL Admin Cookbook LITE: Replication and Indexing

Make your database quicker, more efficient, and better organized with replication and indexing
Code Files

MySQL Admin Cookbook LITE: Replication and Indexing

Daniel Schneller, Udo Schwedt

Make your database quicker, more efficient, and better organized with replication and indexing
Mapt Subscription
FREE
$30.00/m after trial
eBook
$7.00
RRP $9.99
Save 29%
Print + eBook
$19.99
RRP $19.99
What do I get with a Mapt subscription?
  • Unlimited access to all Packt’s 6,000+ eBooks and Videos
  • 100+ new titles a month, learning paths, assessments & code files
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$7.00
$19.99
$29.99 p/m after trial
RRP $9.99
RRP $19.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


MySQL Admin Cookbook LITE: Replication and Indexing Book Cover
MySQL Admin Cookbook LITE: Replication and Indexing
$ 9.99
$ 7.00
Creating your MySQL Database: Practical Design Tips and Techniques  Book Cover
Creating your MySQL Database: Practical Design Tips and Techniques
$ 11.99
$ 8.40
Buy 2 for $15.40
Save $6.58
Add to Cart

Book Details

ISBN 139781849516143
Paperback104 pages

Book 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 remains a challenge, along with day-to-day maintenance tasks such as indexing and replication. These tasks have not been covered thoroughly in the default documentation.

This MySQL Admin Cookbook LITE covers two key aspects of MySQL administration in detail; replication, which will allow you to organize your database more efficiently, and indexing, which enables you to access information even in the deepest, darkest depths of your largest databases.

All of the recipes are based on real-world experience which were derived from proven solutions used in an enterprise environment.

To find out more about upgrading to the full edition, visit www.packtpub.com/lite-editions and log into your account for offers and help. If you don’t have an account on PacktPub.com, visit today and set one up!

Table of Contents

What You Will Learn

  • Set up MySQL replication to manage load balancing, online back up, and fail-over scenarios
  • Create, modify, and delete indexes; also identify duplicate indexes to optimize your MySQL servers' performance
  • Set up automatically updated slaves
  • Estimate and limit your network and slave I/O load
  • Check that your servers are in sync to improve communication
  • Learn about primary keys
  • Speed up your searches for sub-domains

Authors

Table of Contents

Book Details

ISBN 139781849516143
Paperback104 pages
Read More

Read More Reviews

Recommended for You

Creating your MySQL Database: Practical Design Tips and Techniques  Book Cover
Creating your MySQL Database: Practical Design Tips and Techniques
$ 11.99
$ 8.40
Mastering phpMyAdmin for Effective MySQL Management  Book Cover
Mastering phpMyAdmin for Effective MySQL Management
$ 23.99
$ 16.80
Mastering phpMyAdmin 3.4 for Effective MySQL Management Book Cover
Mastering phpMyAdmin 3.4 for Effective MySQL Management
$ 23.99
$ 16.80
phpMyAdmin Starter Book Cover
phpMyAdmin Starter
$ 12.99
$ 9.10
OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide ( 1ZO-051 ) Book Cover
OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide ( 1ZO-051 )
$ 29.99
$ 21.00
Apache Tomcat 7 Essentials Book Cover
Apache Tomcat 7 Essentials
$ 23.99
$ 16.80