High Performance MySQL [Electronic resources] نسخه متنی

R-tree indexes

RAID (Redundant Array of Inexpensive Disks)

hardware versus software RAID

hot-swappable disks

IDE versus SCSI disks

mirroring

multiple arrays, using

on slaves

parity blocks

RAID 0

RAID 1

RAID 10 (RAID 1+0)

RAID 5

RAID tables (MyISAM storage engine)

striping

summary of features

write caching

raw backups

read committed isolation level

read lock

read uncommitted isolation level

read/write locks

read_heartbeat script

reconfiguration

recovery

dumps, restoring from

mysqldump

mysqlhotcopy

mysqlsnapshot

offline backups

references privilege

regular expressions and indexes

Reiser, Hans

ReiserFS filesystem

reload privilege

REPAIR TABLE command

repeatable read isolation level

replication
2nd

administration and maintenance

log rotation

master status

masters, changing

monitoring

replication heartbeat

slave status

architectures

backups and

common problems

binary and transaction logs out of sync

bulk-loading data

hostname changes, caused by

log corruption

missing temporary tables

nonreplicated dependencies

nonunique server IDs

slave data changes

configuring

account creation

configuration file entries

custom architectures

dual master architecture

on existing servers

master and slave servers

master, restarting

new servers

pyramid architecture

replication ring (multi-master)

slave with two masters architecture

slave, restarting

files and settings

filtering

log files

log index files

status files

implementation, differences in MySQL versions

LOAD TABLE FROM MASTER command

master and slave servers

query processing

over an intermittent connection

performance, testing

problems not solved by

online ordering

real time data transmission

problems solved by

backup and recovery using

data distribution

high availability and failover

load-balancing using

proposed enhancements

fail-safe replication

safe multi-master replication

slaves, adding

query processing

MySQL 3.23

MySQL 4.0

rules

slaves, copying master data to

snapshots versus backups

tools

check_repl script

fix_repl script

mysqlbinlog utility

mysqldiff script

purge_binary_logs script

read_heartbeat script

write_heartbeat script

requests

RESET MASTER command

REVOKE command

role based addressing

ROLLBACK statement

round-robin DNS

row locks