Cargando…
MySQL admin cookbook : 99 great recipes for mastering MySQL configuration and administration /
"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 w...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, U.K. :
Packt Pub.,
©2010.
|
| Colección: | Quick answers to common problems.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Authors; About the Reviewers; Table of Contents; Preface; Chapter 1: Replication; Introduction; 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; Setting up automatically updated slavesusing 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 engineSetting 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; Introduction; 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)domainsFinding duplicate indexes; Chapter 3: Tools; Introduction; Transferring connection settings between different machines using a network share; Sorting MySQL GUI Tools' stored connections; Automatically creating stored connections; Adding custom graphs to MySQL Administrator; Displaying query results page by page and with scrolling using the MySQL command-line client; Extracting information from verbose output using the MySQL command-line client; Specifying a default pager; Using a custom prompt to distinguish connections
- Encrypting a MySQL server connection with SSHCreating an encrypted MySQL console via SSH; Using a PuTTY template connection for SSH secured connections; Chapter 4: Backing Up and Restoring MySQL Data; Introduction; Using MySQL Administrator GUI Tool as a frontend for backups; Copying all data files to a backup location; Creating a SQL dump of all databases; Creating a SQL dump of specific databases; Creating a SQL dump of specific tables; Compressing SQL dumps on-the-fly; Rotating and purging binary logs; Using replication to perform backups without hurting a production system's performance
- Restoring data from a dump to a previously backed-up statePerforming a point-in-time recovery using the binary logs; Chapter 5: Managing Data; Introduction; Exporting data to a simple CSV file; Exporting data to a custom file format; Using stored procedures to export repeatedly; Importing data from a simple CSV file; Importing data from custom file formats; Inserting new data and updating data if it already exists; Inserting data based on existing database content; Deleting all data from large tables; Deleting all but a fragment of a large table's data