MySQL Admin Cookbook LITE: Replication and Indexing. Make your database quicker, more efficient, and better organized with replication and indexing - Helion

ebook

Autor: Udo Schwedt, Daniel Schneller
Tytuł oryginału: MySQL Admin Cookbook LITE: Replication and Indexing. Make your database quicker, more efficient, and better organized with replication and indexing
ISBN: 9781849516150
stron: 104, Format: ebook
Data wydania: 2011-05-13
Księgarnia: Helion

Cena książki: 69,90 zł

Osoby, które kupiły tę książkę, wybierały także »

Osoby które kupowały "MySQL Admin Cookbook LITE: Replication and Indexing. Make your database quicker, more efficient, and better organized with replication and indexing", wybierały także:

Windows Media Center. Domowe centrum rozrywki 66,67 zł, (8,00 zł -88%)
Ruby on Rails. Ćwiczenia 18,75 zł, (3,00 zł -84%)
Przywództwo w świecie VUCA. Jak być skutecznym liderem w niepewnym środowisku 58,64 zł, (12,90 zł -78%)
Scrum. O zwinnym zarządzaniu projektami. Wydanie II rozszerzone 58,64 zł, (12,90 zł -78%)
Od hierarchii do turkusu, czyli jak zarządzać w XXI wieku 58,64 zł, (12,90 zł -78%)

Spis treści

MySQL Admin Cookbook LITE: Replication and Indexing. Make your database quicker, more efficient, and better organized with replication and indexing eBook -- spis treści

MySQL Admin Cookbook: LITE
- Table of Contents
- MySQL Admin Cookbook: LITE
- Credits
- About the Authors
- About the Reviewers
- Preface
  - What this book covers
  - What you need for this book
  - Who this book is for
  - Conventions
  - Reader feedback
  - Customer support
    - Errata
    - Piracy
    - Questions
- 1. Replication
  - Introduction
    - Statement Based Replication
      - Filtering
  - Setting up automatically updated slaves of a server based on a SQL dump
    - Getting ready
    - How to do it...
    - How it works...
    - See also
  - Setting up automatically updated slaves of a selection of tables based on a SQL dump
    - Getting ready
    - How to do it...
    - How it works...
    - Theres more...
  - Setting up automatically updated slaves using data file copy
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
      - Conserving data file by using LVM snapshots
      - Backing up data using Percona xtrabackup
  - Sharing read load across multiple machines
    - Getting ready
    - How to do it...
      - How it works
      - There's more...
        
        Working with connection pools
        
        Working on other programming environments
        
        Considering efficiency while adding slaves
  - Using replication to provide full-text indexing for InnoDB tables
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
      - Setting up new slaves in this scenario
    - See also
  - Estimating network and slave I/O load
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
      - Handling intermittent connectivity between master and slave
      - Enabling compression with the slave_compressed_protocol option
  - Limiting network and slave I/O load in heavy write scenarios using the blackhole storage engine
    - Getting ready
    - How to do it...
    - How it works...
      - Other storage engines than InnoDB
  - Setting up slaves via network streaming
    - Getting ready
    - How to do it...
    - How it works...
      - Temporary daemon
      - Dumping master data
      - Shutting down and compressing
      - Transferring to the slave and uncompressing
      - Adjusting slave configuration
      - Connecting to the master
      - Starting the slave
  - Skipping problematic queries
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
  - Checking if servers are in sync
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
  - Avoiding duplicate server IDs
    - Getting ready
    - How to do it
    - How it works...
    - There's more...
      - Recognizing symptoms of duplicate server IDs
  - Setting up slaves to report custom information about themselves to the master
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
- 2. Indexing
  - Introduction
    - Infinite storage, infinite expectations
    - Speed by redundancy
    - Storage engine differences
    - MyISAM
    - InnoDB
      - Primary (clustered) indexes
      - Secondary indexes
    - General requirements for the recipes in this chapter
  - Adding indexes to tables
    - Getting ready
    - How to do it...
      - How it works...
      - There's more...
        
        Using MySQL Query Browser to generate the SQL statements
        
        Prefix indexes
        
        Prefix primary keys
      - See also
  - Adding a fulltext index
    - Getting ready
    - How to do it...
      - How it works...
      - There's more...
        
        Case sensitivity
        
        Word length
        
        Stopwords
        
        Ignoring frequent words
        
        Query modes
        
        Sphinx
      - See also
  - Creating a normalized text search column
    - Getting ready
    - How to do it...
    - How it works...
    - There is more...
  - Removing indexes from tables
    - Getting ready
    - How to do it...
      - How it works...
      - There's more...
      - See also
  - Estimating InnoDB index space requirements
    - Getting ready...
    - How to do it...
    - How it works
    - There's more...
      - Considering actual data lengths in your estimate
      - Minding character sets
  - Using prefix primary keys
    - Getting ready...
    - How to do it...
    - How it works...
  - Choosing InnoDB primary key columns
    - Getting ready
    - How to do it...
    - How it works...
      - Uniqueness
      - Immutability
      - Key length
      - Single column keys
      - Clustered Index
  - Speeding up searches for (sub)domains
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
    - See also
  - Finding duplicate indexes
    - Getting ready
    - How to do it...
    - How it works
    - There's more...
- Index