Index
A
- --all-databases command
- about / How to do it...
- --all-databases option
- about / How to do it…
- --all-tablespaces option
- about / How to do it…
- abort command
- about / Aborting backups in progress
- ALTER TABLE command
- designing / How to do it…
- Arbitrator
- about / How to do it…
- attributes
- about / There's more…
B
- Binary logs
- about / Getting ready
- binlog-format parameter
- about / Row-based replication
- block-level replication
- advantages / Summary of options
- disadvantages / Summary of options
- block level replication
- about / Introduction
- DRBD / Introduction
- synchronous mode / Introduction
- Bonnie
- about / See also
- Bytes column
- about / There's more...
C
- --config-file=config.ini flag
- about / How to do it...
- CentOS 5
- noop scheduler / There's more...
- deadline scheduler / There's more...
- anticipatory scheduler / There's more...
- CFQ scheduler / There's more...
- CHANGE MASTER TO command
- about / How to do it...
- working / How it works...
- clustat command
- cluster shutdown
- recovering from / Recovering from a cluster shutdown, How to do it…
- partial cluster failure / How to do it…
- complete cluster failure / How to do it…
- split brain problem / How to do it…
- working / How it works…
- cluster SQL file
- importing, to unclustered MySQL server / Importing a cluster SQL file to an unclustered MySQL Server
- clusvcadm command
- config.ini file
- config.ini file, creating
- steps / How to do it…
- Conga
- using, for MySQL configuration / Configuring MySQL on shared storage with Conga, How to do it…
- luci / Configuring MySQL on shared storage with Conga
- ricci / Configuring MySQL on shared storage with Conga
- using, configuringation / How to do it…
- luci, installing / How to do it…
- working / How it works…
- CREATE LOGFILE GROUP command
- about / There's more...
- CREATE NODEGROUP <nodeID>,<nodeID> command
- CREATE TABLESPACE SQL command
- about / How to do it...
- cron job
- woes / Cron job woes
D
- --delete-master-logs command
- about / How to do it...
- -d parameter
- about / How it works...
- DataMemory
- calculating / Getting ready, How to do it...
- requirements / How to do it...
- DBD@mysql
- installing, commands / There's more...
- DESC tablename command
- about / There's more…
- df -h command
- about / How to do it...
- disk-based tables
- configuring / Getting ready, How to do it...
- working / How it works...
- disk space
- some databases, logging / Only logging some databases
- individual binary log size, limiting / Limiting individual binary log size
- binary logs, rotating / Rotating binary logs
- downloading
- SQL nodes / How to do it…
- DRBD
- about / Introduction
- consequence / Introduction
- asyncronous setting / Introduction
- semi-syncronous setting / Introduction
- syncronous setting / Introduction
- installing, on two Linux servers / Installing DRBD on two Linux servers
- DRBD, installing on two Linux servers
- starting with / Getting ready
- steps / How to do it...
- working / How it works...
- DRBD cluster
- MySQL service, moving manually / DRBD clusterMySQL service, moving manuallyGetting ready
- MySQL service, moving / DRBD clusterMySQL service, moving manuallyGetting ready, How to do it...
E
- echo command / How to do it...
- endianness
- about / There's more…
F
- fencing
- for high availability / Fencing for high availability
- configuring / Fencing for high availability, Hfencingdummy fencing, creatingow to do it…
- manual fencing, configuring / Fencing for high availability
- dummy fencing, creating / Hfencingdummy fencing, creatingow to do it…
- setting up, on VMware / There's more…
- device, adding / There's more…
- fFencing
- about / Fencing for high availability
- filesystem
- mounting, on both nodes / Mounting filesystem on both nodes
- fragments
- about / There's more…
G
- GFS
- about / Preparing a Linux server for shared storage
- MySQL, configuring / Configuring MySQL with GFS, How to do it…
- GFS2
- about / Configuring MySQL with GFS
- GFS performance
- requirements / Tuning GFS on shared storage
- maximizing / How to do it...
- _netdev option / How to do it...
- noatime option / How to do it...
- nodiratime option / How to do it...
- working / How it works...
- --color adding to ls, problems / How it works...
- Global File System
- about / Introduction
H
- --hex-blob command
- about / How to do it...
- HBAs
- about / How to do it…
- heartbeat
- about / Using heartbeat for automatic failover
- using, for automatic failover / Getting ready, How to do it...
- working / How it works...
- HeartbeatIntervalDbApi parameter
- about / How it works…
- HeartbeatIntervalDbDb parameter
- about / How it works…
- HostName parameter / How to do it…
- about / Getting ready
I
- --initial flag / How to do it…
- about / How to do it...
- IndexMemory
- calculating / Getting ready, How to do it...
- requirements / How to do it...
- installing
- management node / Installing a management node, How to do it…
- SQL nodes / How to do it…
- mylvmbackup / How to do it...
- iptables command
- about / How to do it…
- iptraf command
- about / There's more...
- IQN
- about / How to do it…
- iSCSI
- volume, preparing / Preparing a Linux server for shared storage, How to do it…
- software initiators, using / How to do it…
K
- kill command / There's more…
L
- --lock-all-tables command
- about / How to do it...
- --lock-all-tables option
- about / How to do it…
- LCP
- about / How it works…
- Linux kernel IO
- about / Tuning the Linux kernel IO
- tuning / Getting ready, How to do it...
- monitoring, top commmand / Getting ready
- swap, field options / Getting ready
- swap / Getting ready
- IO field options / Getting ready
- CPU field options / Getting ready
- sar command / Getting ready
- r/s field / Getting ready
- nd w/s field / Getting ready
- wsec/s field / Getting ready
- Rsec/s field / Getting ready
- Avgrq-sz field / Getting ready
- Avggu-sz field / Getting ready
- await field / Getting ready
- svctm field / Getting ready
- working / How it works...
- Linux server
- preparing, for shared storage / Preparing a Linux server for shared storage, How to do it…
- LUN
- about / How to do it…
- lvcreate command
- about / How to do it...
- LVM
- about / Using LVM to reduce downtime on a master when bringing a slave online
- using, to reduce master down time / Getting ready, How to do it...
- lvsize parameter / How to do it...
M
- --master-data command
- about / How to do it...
- management node
- installing / Installing a management node, How to do it…
- starting / Starting a management node, How to do it…, There's more…
- master
- about / Introduction
- slaves / Introduction
- mk-slave-prefetch / There's more...
- mkdir command / How to do it…
- MMM
- initial installation / Multi Master Replication Manager (MMM): initial installation, How to do it...
- about / Multi Master Replication Manager (MMM): initial installation
- Perl scripts, mmmd_agent / Multi Master Replication Manager (MMM): initial installation
- Perl scripts, mmmd_mon / Multi Master Replication Manager (MMM): initial installation
- MySQL nodes, installing / Multi Master Replication Manager (MMM): installing the MySQL nodes, How to do it...
- monitoring node, installing / Multi Master Replication Manager (MMM): installing monitoring node, How to do it...
- managing / Managing and using Multi Master Replication Manager (MMM) , How to do it…
- using / Managing and using Multi Master Replication Manager (MMM) , How to do it…
- working / How it works...
- failure, detecting / Failure detection
- mmm_control set_online command
- using / How to do it…
- move_role command
- about / There's more...
- multi-site architectures
- about / Multi-site architectures
- multiple management nodes
- configuring / Configuring multiple management nodes, Getting ready, How to do it..., There's more...
- multiple storage node failure
- options / Multiple storage node failures
- handling / Getting ready, How to do it…
- mylvmbackup
- installing / How to do it...
- working / How it works…
- mylvmbackup installation
- perl-TimeDate, installing / How to do it...
- perl-Config-IniFiles, installing / How to do it...
- MySQL
- configuring, with GFS / Configuring MySQL with GFS, How to do it…
- mysqlbinlog command
- about / Statement-based replication
- MySQL Cluster
- about / Introduction
- designing / Designing a MySQL Cluster, How to do it..., Introduction
- management node / How to do it...
- data or storage node / How to do it...
- API nodes / How to do it...
- problems / How to do it...
- working / How it works…
- shared nothing property / How it works…
- data chopping / There's more…
- two-phase commit / There's more…
- deploying / There's more…
- operating system requirements / There's more…
- indexes, limitation / There's more…
- transactions, limitation / There's more…
- version 7 limitations / There's more…
- network requirements / There's more…
- System RAM, requirements / There's more…
- System RAM, best practices / There's more…
- processor architecture requirements / There's more…
- initial cluster configuration file, creating / Creating an initial cluster configuration file—config.ini
- storage nodes / Installing and starting storage nodes
- table, creating / Creating a MySQL Cluster table
- restarting, without downtime / Restarting a MySQL Cluster without downtime
- Arbitrator / How to do it…
- backing up, ways / Introduction
- human error / Introduction
- application error / Introduction
- disaster recovery / Introduction
- write access restricting, single-user mode used / Restricting write access to a MySQL Cluster with single-user mode, How to do it…, There's more…
- offline backup, obtaining / Taking an offline backup with MySQL Cluster, How to do it…
- replicating between / Getting ready, How to do it...
- storage node, partitioning / Storage node partitioning and arbitration
- queries, tuning within / Tuning queries within a MySQL Cluster, How to do it...
- advantages / Summary of options
- disadvantages / Summary of options
- MySQL Cluster, debugging
- points / Getting ready
- steps / How to do it...
- firewalls / Firewalls
- host resolution / Host resolution
- memory / Memory
- MySQL Cluster, restarting without downtime
- requirements / Getting started
- storage node, restarting / How to do it…
- management node, restarting / How to do it…
- SQL node, restarting / How to do it…
- MySQL Cluster management
- about / Introduction
- multiple management nodes, configuring / Configuring multiple management nodes
- usage, obtaining / Obtaining usage information
- online storage nodes, adding / Adding storage nodes online
- user-defined partitioning / User-defined partitioning
- disk-based tables / Disk-based tables
- MySQL Cluster offline backup
- obtaining / Taking an offline backup with MySQL Cluster, How to do it…
- MySQL Cluster online backup
- about / Taking an online backup of a MySQL Cluster
- obtaining / Getting ready
- metadata / Getting ready
- table data / Getting ready
- transaction logs / Getting ready
- initiating / How to do it…
- initiation tricks / Preventing commands hanging
- command hanging, preventing / Preventing commands hanging
- backups in progress, aborting / Aborting backups in progress
- consistent backup time, defining / Defining an exact time for a consistent backup
- restoring from / Restoring from a MySQL Cluster online backup, How to do it…
- restoration principles / Restoring from a MySQL Cluster online backup
- ndb_restore process / Restoring from a MySQL Cluster online backup
- MySQL Cluster SQL nodes
- tuning / Tuning MySQL Cluster SQL nodes, How to do it...
- working / How it works...
- MySQL Cluster storage nodes
- tuning / How to do it...
- working / How it works...
- MySQL Cluster table
- about / How to do it…
- creating / How to do it…
- MySQL Cluster troubleshooting
- single storage node failure, handling / Single storage node failure
- multiple storage node failure, handling / Multiple storage node failures
- debugging / Debugging MySQL Clusters
- Seeking help / Seeking help
- network redundancy / NIC teaming with MySQL Cluster
- MySQL Cluster usage
- obtaining / How to do it..., There's more...
- working / How it works...
- mysql command
- MySQL configuration
- on shared storage, Conga used / Configuring MySQL on shared storage with Conga, How to do it…
- cluster status, using / Obtaining the cluster status, MMySQL configurationcluster status, usingigration of MySQL from node to node
- service migration, from node to node / MMySQL configurationcluster status, usingigration of MySQL from node to node
- mysqldump command
- about / Introduction, How to do it...
- running, for consistent backup / Running mysqldump for a consistent backup
- MySQL Replication
- advantages / Summary of options
- disadvantages / Summary of options
- MySQL replication
- about / Introduction
- setup, designing / Designing a replication setup
- MySQL replication setup
- master / Getting ready
- slaves / Getting ready
- Binary logs / Getting ready
- designing / How to do it...
- Master-Slave setup / Master and slave
- Master-Slave setup, uses / Master and slave
- Master-Slave setup, disadvantages / Master and slave
- Multi-master / Multi-master (active / active)
- Active / passive master replication / Active / passive master
- working / MiMySQL replication setupworkingxed-mode replication, Row-based replication
- mixed-mode replication / MiMySQL replication setupworkingxed-mode replication
- statement-based replication / Statement-based replication
- binlog_format / Row-based replication, CoMySQL replication setupbinlog_formatnfiguring a replication master
- MySQL Replication setup
- row-based replication / Row-based replication
- MySQL Replication tuning
- about / MySQL Replication tuning
- steps / How to do it...
- ALTER TABLE, achieving / How to do it...
N
- --ndb-nodeid=X flag
- about / How to do it...
- --nostart flag / There's more…
- <nodeid> REPORT MemoryUsage command
- about / How to do it...
- <nodeid> STATUS command / How to do it…
- NDB
- about / Introduction, How to do it…
- ndb_desc command
- about / There's more...
- ndb_restore command
- about / How to do it…
- ndb_size.pl
- additional options / There's more...
- network redundancy
- MySQL cluster, using / Getting ready, network redundancyMySQL cluster, usingHow to do it…, There's more…
- noatime mount option
- nodegroups
- about / There's more…
- NoOfReplicas parameter / How to do it…
O
- objects
- about / There's more…
- online storage nodes
- adding / online storage nodesaddingHow to do it...
- working / How it works...
R
- replication
- between MySQL Clusters / Getting ready, How to do it...
- working / How it works...
- between MySQL Clusters, backup channel used / Replication between clusters with a backup channel, How to do it…, There's more…
- safety tricks / Replication safety tricks
- replication, safety tricks
- about / Replication safety tricks
- auto-increment problems, solving / How to do it..., There's more...
- MySQL server data, preventing / How to do it..., There's more...
- my cnf values / How to do it...
- replication channel
- about / Getting ready
- diagram / Getting ready
- replication master
- setting up, process / Getting ready
- node ID, configuring / How to do it...
- binary log, configuring / How to do it...
- replication user account, configuring / How to do it...
- working / How it works...
- disk space / Disk space
- performance / Performance
- binary log caching / Binary log caching
- replication slave
- configuring, without syncing data / How to do it...
- configuring, SQL dump used / Configuring a replication slave, migrating data with a simple SQL dump, How to do it...
- restart parameter
- about / How to do it…
- RHEL
- noop scheduler / There's more...
- deadline scheduler / There's more...
- anticipatory scheduler / There's more...
- CFQ scheduler / There's more...
- RPM
- about / Installing a management node
S
- sar command
- about / Getting ready
- Seeking help
- about / Getting ready
- using / How to do it...
- bug, posting / How to do it...
- server-id parameter
- about / How to do it...
- service command
- about / How to do it...
- shared-storage clustering
- advantages / Summary of options
- disadvantages / Summary of options
- shared MySQL storage
- two servers, configuring / Configuring two servers for shared storage MySQL
- CentOS required package, installing / How to do it…
- logical volume, creating / How to do it…
- filesystem, creating / How to do it…
- MySQL, installing / How to do it…
- shared storage cluster
- Linux server, preparing / Preparing a Linux server for shared storage
- simplified structure / Preparing a Linux server for shared storage
- preparing, for Liux server / Preparing a Linux server for shared storage
- architecture,designing / How to do it…
- show command
- about / How to do it...
- SHOW command
- about / How to do it…
- SHOW ENGINES command
- about / How to do it…, There's more…
- SHOW MASTER STATUS command
- about / How to do it...
- single-site architectures
- MySQL master / slave replication / MySQL master / slave replication
- MySQL master / master replication / MySQL master / master replication
- shared storage / Shared storage, Block level replication, MySQL Cluster
- shared storage, storage area network / Shared storage
- shared storage, block-level replication / Block level replication
- single storage node failure
- handling / Single storage node failure, Getting ready, How to do it…
- working / How it works…
- single user mode
- using, for write access restriction / Restricting write access to a MySQL Cluster with single-user mode, How to do it…, There's more…
- single write transaction
- diagrammatic representation / Introduction
- sizer
- about / See also
- slave-allow-batching option
- about / There's more…
- split brain problem
- about / How to do it..., How to do it…
- SQL files
- importing, to MySQL server / Importing SQL files to a MySQL server and converting them to MySQL Cluster, How to do it…
- converting, to MySQL cluster / How to do it…
- row number, checking / There's more…
- SQL nodes
- about / Installing and starting SQL nodes
- installing / How to do it…
- downloading / How to do it…
- starting / How to do it…
- START BACKUP command
- about / How to do it…
- START BACKUP NOWAIT option
- about / Preventing commands hanging
- START BACKUP WAIT STARTED
- about / Preventing commands hanging
- STONITH
- about / Fencing for high availability
- storage node
- partitioning / Storage node partitioning and arbitration, How to do it…
- arbitration / How to do it…
- partitioned nodes, working / How it works…
- storage nodes
- installing / Getting ready
- files, downloading / How to do it…
- starting / How to do it…
- phases / There's more…
T
- tail -f command
- about / How to do it…
- tar command
- about / How to do it...
U
- UNDO_BUFFER_SIZE parameter
- about / There's more...
- user-defined partitioning
- starting with / Getting ready
- steps / How to do it...
- uses / There's more...
- UUID() function
V
- vgs command
- about / Getting ready, How to do it...
- vgs commanD
- about / Getting ready
- VIP
- about / MySQL master / slave replication
- vm.swappiness parameter / There's more...
- vmstat command
- about / How to do it..., Getting ready
Y
- yum list | grep drbd command / Getting ready