MySQL Admin Cookbook LITE: Replication and Indexing
|Also available on:|
- Set up MySQL to perform administrative tasks such as replication and indexing
- Balance server loads across multiple machines, ease backups and much more with replication
- Allow for rapid and efficient access across your database with indexing
- Part of Packt's Cookbook series: Each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible
Table of ContentsPreface
Chapter 1: Replication
Chapter 2: Indexing
- Chapter 1: Replication
- Setting up automatically updated slaves of
- a server based on a SQL dump
- Setting up automatically updated slaves of a selection of tables based on a SQL dump
- Setting up automatically updated slaves using data file copy
- Sharing read load across multiple machines
- Using replication to provide full-text indexing for InnoDB tables
- Estimating network and slave I/O load
- Limiting network and slave I/O load in heavy write scenarios using the blackhole storage engine
- Setting up slaves via network streaming
- Skipping problematic queries
- Checking if servers are in sync
- Avoiding duplicate server IDs
- Setting up slaves to report custom information about themselves to the master
- Chapter 2: Indexing
- Adding indexes to tables
- Adding a fulltext index
- Creating a normalized text search column
- Removing indexes from tables
- Estimating InnoDB index space requirements
- Using prefix primary keys
- Choosing InnoDB primary key columns
- Speeding up searches for (sub)domains
- Finding duplicate indexes
Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.
Sorry, there are currently no downloads available for this title.
Lite EditionLearn more
Full EditionLearn more
| Set up MySQL to perform administrative tasks such as replication and indexing
|Balance server loads across multiple machines, ease backups and much more with replication
|Allow for rapid and efficient access across your database with indexing|
|eBook available as PDF downloads|
|eBook available as ePub downloads|
|Available on PacktLib|
|Deal with typical performance bottlenecks and lock-contention problems|
|Restrict access sensibly and regain access to your database in case of loss of administrative user credentials|
What you will learn from this book
- 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
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!
This cookbook presents solutions to problems in the form of recipes. Each recipe provides the reader with easy step-by-step descriptions of the actions necessary to accomplish a specific task. Example values and code samples are used throughout the recipes, which makes adaptation for individual needs easy
Who this book is for
This book is for ambitious MySQL users as well as professional data center database administrators. Beginners as well as experienced administrators will benefit from this cookbook and get fresh ideas to improve their MySQL environments. Detailed background information will enable them to widen their MySQL horizon.
It does not cover SQL basics, how to install MySQL servers, or how to design a relational database schema. Readers are expected to have a basic understanding of the SQL language and database concepts in general.