[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
[X]
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
|
