Index
A
- acceleration card / RAID and acceleration cards
- advanced mechanisms, Galera Cluster
- transaction reordering / How Galera Cluster works
- write sets / How Galera Cluster works
- database state machine / How Galera Cluster works
- group communication / How Galera Cluster works
- Advanced Message Queuing Protocol (AMQP) software / Paused replication
- AMD
- functionalities / Constructor name options
- architectures, Galera Cluster
- designing / Designing redundant architectures
- read and write nodes / Read and write nodes
- load balanced architecture / Load balanced architecture
- WAN replication / WAN replication
- disaster recovery (DR) / Disaster recovery
- architecture types, MariaDB / Architecture types and performances
- ARCHIVE / Introduction to MariaDB engines
- Aria / Introduction to MariaDB engines
- Atomicity, Consistency, Isolation, Durability(ACID) / Transaction commits and logs
- auto-increment-increment / Dual master replication and risks
- auto-increment-offset / Dual master replication and risks
- automatic management
- about / Automatic management
- HAProxy / HAProxy
- Pacemaker / Pacemaker or Percona Replication Manager
- Percona Replication Manager / Pacemaker or Percona Replication Manager
- DRBD / DRBD
B
- backup
- restoring / Using mysqlhotcopy
- backup, LVM / Backup
- Battery Backup Unit (BBU) / RAID cards and levels
- Bgs mode, Spider / The bgs mode
- binlogs
- analyzing / Analyzing binlogs
- binlogs, nontransactional caches / Binlogs for nontransactional caches
- binlogs, transactional caches / Binlogs for transactional caches
- binlogs cache
- about / The binlogs cache
- BIOS power management optimization
- about / BIOS power management optimization
- C-States / C-States
- P-States / P-States
- constructor name options / Constructor name options
- power management optimization / Power management optimization
- disks optimization / Disk and filesystem optimization
- filesystem optimization / Disk and filesystem optimization
- hardware, dedicating with cgroups / Dedicating hardware with cgroups
- hardware optimization, dedicating with NUMA / Dedicating hardware optimization with NUMA
- BLACKHOLE / Introduction to MariaDB engines
- BTREE index engine
- about / Engines
- buffer pool instances, InnoDB / Buffer pool instances
C
- - cpu / Sysbench
- C-States / C-States
- cache size, TokuDB / Cache size
- cascade slaves
- about / Cascade slaves
- Cassandra / Introduction to MariaDB engines
- certificate authority (CA)
- about / Generating certificates
- building / Building your own CA
- certificates
- generating / Generating certificates
- checking / Checking your certificates
- CFQ scheduler
- about / Kernel disks' I/O schedulers
- cgconfig daemon
- used, for automatic solution / Automatic solution using the cgconfig daemon
- cgroups
- hardware, dedicating with / Dedicating hardware with cgroups
- cgroups, creating
- manual solution / Manual solution
- automatic solution, cgconfig daemon used / Automatic solution using the cgconfig daemon
- classical dump
- options / Using mysqldump
- classical replication
- migrating, to GTID replication / Migrating from classical to GTID replication
- classic engines, MySQL
- MyISAM / Introduction to MariaDB engines
- InnoDB / Introduction to MariaDB engines
- BLACKHOLE / Introduction to MariaDB engines
- CSV / Introduction to MariaDB engines
- MEMORY / Introduction to MariaDB engines
- ARCHIVE / Introduction to MariaDB engines
- MERGE / Introduction to MariaDB engines
- client certificates
- building / Building your client certificates
- client SSL
- MariaDB, configuring for / Client SSL
- Collectd
- Completely Fair Queuing (CFQ)
- about / Kernel disks' I/O schedulers
- compression / Compression
- compression feature, TokuDB / Compression
- compression options
- about / Compression options
- compression type, TokuDB
- UNCOMPRESSED / Compression
- QUICKLZ / Compression
- ZLIB / Compression
- LZMA / Compression
- configuration
- testing / Testing the configuration
- configuration file
- using / Using the configuration file
- Connect / Introduction to MariaDB engines
- connection recycle mode, Spider / The connection recycle mode
- connections
- about / Maximum connections
- consensus clustering / Consensus clustering and maintenance
- constructor name options / Constructor name options
- Copy on Write / Snapshot
- Corosync / Pacemaker or Percona Replication Manager
- CPU
- about / CPU
- cpufreq / cpufreq
- cpuidle / cpuidle
- CRUD (Create/Update/Delete) / Introduction to MariaDB engines
- CSV / Introduction to MariaDB engines
D
- data
- recovering, after server failure / Recovering data after server failure
- data transfer, Galera Cluster
- State Snapshot Transfer (SST) / Transfer methods
- Incremental State Transfer (IST) / Transfer methods
- deadline scheduler
- about / Kernel disks' I/O schedulers
- Demand caching / RAID cards and levels
- disaster recovery (DR)
- about / Disaster recovery
- advantages / Disaster recovery
- Disk arrays / Disk arrays
- disk optimization
- kernel I/O scheduler / Kernel disks' I/O schedulers
- partition alignment / Partition alignment
- SSD optimization / SSD optimization
- SWAP / SWAP
- disks
- about / Disks
- SATA magnetic drives / SATA magnetic drives
- SAS magnetic drives / SAS magnetic drives
- Hybrid drives / Hybrid drives
- SSDs / SSDs
- DNS cache server
- about / The DNS cache server
- DNS connections
- about / DNS connections
- Donor node
- dedicating / Dedicating a donor node
- DRBD / DRBD
- dual master replication
- about / Dual master replication and risks
- installing / Installing and configuring a dual master
- configuring / Installing and configuring a dual master
- repairing / How to repair a dual master replication
E
- Elasticsearch / Logs
- Error-Correcting Code memory (ECC memory)
- about / RAM
- evs.inactive_check_period
- about / WAN replication
- evs.inactive_timeout
- about / WAN replication
- evs.install_timeout
- about / WAN replication
- evs.keepalive_period
- about / WAN replication
- evs.suspect_timeout
- about / WAN replication
- explain command
- about / The explain command
- Extract-Transform-Load (ETL) / Multimaster slave replication
F
- - fileio / Sysbench
- FederatedX / Introduction to MariaDB engines
- filesystem optimization
- filesystem options / Filesystem options
- filesystem options / Filesystem options
- first boot, Galera Cluster
- performing / First boot
- first shard
- creating / Creating your first shard
- flush method, InnoDB / The flush method
- flush method, TokuDB / The flush method
- fridim
- URL / Paused replication
- full backup
- about / Full backup
- restoring from / Restoring from a full backup
- functionalities
- disabled, for Intel / Constructor name options
- Fusion-IO direct acceleration cards / Fusion-io direct acceleration cards
G
- Galera1 / First boot
- Galera backup
- about / Galera backup
- Galera Cluster
- working / How Galera Cluster works
- advantages / How Galera Cluster works
- advanced mechanisms / How Galera Cluster works
- limitations / Galera Cluster limitations
- configuration / The basics of installation and configuration
- installing / Installation
- installing manually / Installation
- configuration files / Configuration files
- first boot, performing / First boot
- usages / Usages and understandings
- starting / Starting after a complete blackout
- performance tuning / Performance tuning
- redundant architectures, designing / Designing redundant architectures
- tests / Tests and issues
- issues, resolving / Tests and issues
- nodes, testing / Break Galera
- about / Galera Cluster
- Galera Cluster, advantages
- true multimaster / How Galera Cluster works
- synchronous replication / How Galera Cluster works
- consistent data / How Galera Cluster works
- multithreaded slave / How Galera Cluster works
- no need of HA Cluster for management / How Galera Cluster works
- hot standby / How Galera Cluster works
- transparent to applications / How Galera Cluster works
- no read and write splitting needed / How Galera Cluster works
- WAN / How Galera Cluster works
- Galera Cluster, usages
- transfer methods / Transfer methods
- Donor node, dedicating / Dedicating a donor node
- consensus clustering / Consensus clustering and maintenance
- maintenance, performing / Consensus clustering and maintenance
- Garb, using / Garb – the quorum solution
- Galera Cluster configuration
- MariaDB configuration file, editing / MariaDB configuration
- Galera configuration file, creating / Galera configuration
- Galera configuration file
- creating / Galera configuration
- wrep_provider / Galera configuration
- wsrep_cluster_name / Galera configuration
- wsrep_node_name / Galera configuration
- wsrep_node_address / Galera configuration
- wsrep_cluster_address / Galera configuration
- wsrep_provider_options / Galera configuration
- gcache.size / Galera configuration
- gcache.name / Galera configuration
- gcache.page_size / Galera configuration
- wsrep_retry_autocommit / Galera configuration
- wsrep_sst_method / Galera configuration
- wsrep_slave_threads / Galera configuration
- wsrep_replication_myisam / Galera configuration
- wsrep_sst_receive_address / Galera configuration
- wsrep_notify_cmd / Galera configuration
- MariaDB options, overriding / Galera configuration
- GALERA_GROUP / Garb – the quorum solution
- GALERA_NODES / Garb – the quorum solution
- Garb
- about / Garb – the quorum solution
- using / Garb – the quorum solution
- configuration file, editing / Garb – the quorum solution
- Gcache size
- about / Gcache size
- global statistics
- about / Global statistics
- graph
- using / Graphs
- Graphite
- about / Graphs
- graphs
- about / Graphs
- GTID
- about / What is GTID
- GTID replication
- about / How replication works, GTID replication
- advantages / GTID replication
- master node, configuring / Configuring the master node
- master node, preparing / Preparing the master node
- GTID slave node, configuring / Configuring a GTID slave node
- slave, creating / Creating a slave
- slave, starting / Starting the slave
- slave status, checking / Checking the slave status
- classical replication, migrating to / Migrating from classical to GTID replication
- GTID slave node
- configuring / Configuring a GTID slave node
H
- HandlerSocket / Introduction to MariaDB engines
- HAProxy
- installing / Installing HAProxy, HAProxy, Load balanced architecture
- configuring / Configuring HAProxy
- about / HAProxy
- maintenance mode / Learning about the maintenance mode
- statistics / Using Unix Socket
- Keepalived / Keepalived
- using / Load balanced architecture
- Hard Disk Drives (HDDs) / SATA magnetic drives
- hardware
- selecting / Choosing the appropriate hardware
- dedicating, with cgroups / Dedicating hardware with cgroups
- hardware, selecting
- disks / Disks
- RAID card / RAID and acceleration cards
- acceleration card / RAID and acceleration cards
- RAID cards / RAID cards and levels
- levels / RAID cards and levels
- Fusion-IO direct acceleration cards / Fusion-io direct acceleration cards
- Disk arrays / Disk arrays
- RAM / RAM
- CPU / CPU
- hardware optimization
- dedicating, with NUMA / Dedicating hardware optimization with NUMA
- HASH index engine
- about / Engines
- HATop
- about / Using HATop
- using / Using HATop
- Heartbeat / Pacemaker or Percona Replication Manager
- Hybrid drives / Hybrid drives
I
- IBMDB2I / Introduction to MariaDB engines
- incremental backup
- about / Incremental backup
- restoring from / Restoring from an incremental backup
- Incremental State Transfer (IST) / Transfer methods
- index
- about / Index
- index engines
- indexes types
- about / Types
- InnoDB / Introduction to MariaDB engines
- about / InnoDB/XtraDB
- pool size / Pool size and statistics
- statistics / Pool size and statistics
- redo logs / Redo logs
- transaction commits / Transaction commits and logs
- logs / Transaction commits and logs
- buffer pool instances / Buffer pool instances
- flush method / The flush method
- innodb_buffer_pool_instances parameter / Buffer pool instances
- innotop
- about / innotop
- installation, TokuDB / Installation
- intel_idle driver
- about / cpuidle
- issues resolving, Galera Cluster
- paused replication / Paused replication
- split-brain / Split-brain
K
- Keepalived / Keepalived
- kernel I/O scheduler / Kernel disks' I/O schedulers
- key buffer, MyISAM
- about / Key buffer
- Key_reads_requests variable / Key buffer
- Key_reads variable / Key buffer
- Key_writes_requests variable / Key buffer
- Key_writes variable / Key buffer
- Kibana / Logs
L
- Linux kernel website
- load balanced architecture, Galera Cluster architectures
- about / Load balanced architecture
- logbin information
- about / Using Xtrabackup
- logs / Logs
- logs, InnoDB / Transaction commits and logs
- logs, TokuDB / Transaction commits and logs
- Logstash/Flume/Fluentd / Logs
- Look-ahead caching / RAID cards and levels
- LVM
- lvresize command / Snapshot
M
- - memory / Sysbench
- maintenance, Galera Cluster
- performing / Consensus clustering and maintenance
- maintenance mode
- about / Learning about the maintenance mode
- Unix Socket, using / Using Unix Socket
- HATop, using / Using HATop
- configuration file, using / Using the configuration file
- Man In The Middle (MITM) / SSL replication
- manual solution, cgroups / Manual solution
- MariaDB
- about / MariaDB history
- history / MariaDB history
- features / MariaDB history
- hardware requisites / Choosing the appropriate hardware
- architecture types / Architecture types and performances
- performances / Architecture types and performances
- MySQL, migrating to / Migrating from MySQL to MariaDB
- configuring, for SSL / Configuring MariaDB for SSL
- configuring, for master SSL / Master SSL
- configuring, for client SSL / Client SSL
- MariaDB compatibility
- MariaDB engines
- about / Introduction to MariaDB engines
- Aria / Introduction to MariaDB engines
- XtraDB / Introduction to MariaDB engines
- PBXT / Introduction to MariaDB engines
- FederatedX / Introduction to MariaDB engines
- SphinxSE / Introduction to MariaDB engines
- IBMDB2I / Introduction to MariaDB engines
- TokuDB / Introduction to MariaDB engines
- Cassandra / Introduction to MariaDB engines
- Connect / Introduction to MariaDB engines
- Sequence / Introduction to MariaDB engines
- Spider / Introduction to MariaDB engines
- HandlerSocket / Introduction to MariaDB engines
- MariaDB instances
- MariaDB options, overriding
- binlog_format / Galera configuration
- innodb_autoinc_lock_mode / Galera configuration
- innodb_flush_log_at_trx_commit / Galera configuration
- query_cache_size / Galera configuration
- master
- slave, switching to / GTID – switching a slave to master and recovering
- master node, GTID replication
- configuring / Configuring the master node, Preparing the master node
- master node, replication
- configuring / Configuring the master node
- preparing / Preparing the master node
- master SSL
- MariaDB, configuring for / Master SSL
- MEMORY / Introduction to MariaDB engines
- MERGE / Introduction to MariaDB engines
- middle slaves
- replication performance, speeding up for / Speeding up replication performance for middle slaves
- modes
- operations, performing / innotop
- monitoring solutions
- about / Other monitoring solutions
- graph, using / Graphs
- logs / Logs
- multimaster slave replication
- about / Multimaster slave replication
- multisource replication, setting up / Setting up a multisource replication
- options / Other options
- multisource replication
- setting up / Setting up a multisource replication
- MyISAM / Introduction to MariaDB engines
- about / MyISAM
- key buffer / Key buffer
- MySQL
- migrating, to MariaDB / Migrating from MySQL to MariaDB
- mysqldump
- about / Creating a slave, Using mysqldump
- using / Using mysqldump, Using mysqldump, Using mysqldump
- compression / Compression
- options / Compression
- mysqlhotcopy
- using / Using mysqlhotcopy
- options / Using mysqlhotcopy
- mysqlsla
- about / mysqlsla
- mysqltuner
- about / mysqltuner
- mytop
- about / mytop
N
- --no-stalk option / pt-stalk
- ncurses / Using HATop
- nontransactional caches, binlogs / Binlogs for nontransactional caches
- noop scheduler
- about / Kernel disks' I/O schedulers
- NUMA
- hardware optimization, dedicating / Dedicating hardware optimization with NUMA
- number of shards
- about / Number of shards
O
- - oltp / Sysbench
- Online Transaction Processing (OLTP) / Sysbench
- open tables
- about / Open tables
- options, fine-tune parallel replication
- about / Parallel replication
- options, replications
- replicate_do_db / Restricting replications
- replicate_do_table / Restricting replications
- replicate_wild_do_table / Restricting replications
- replicate_ignore_db / Restricting replications
- replicate_ignore_table / Restricting replications
- replicate_wild_ignore_table / Restricting replications
P
- P-States / P-States
- Pacemaker / Pacemaker or Percona Replication Manager
- parallel replication
- about / Parallel replication
- parallel slave threads
- about / Parallel slave threads
- partition alignment / Partition alignment
- PBXT / Introduction to MariaDB engines
- pc.bootstrap=1 / Starting after a complete blackout
- pc.wait_prim=no / Starting after a complete blackout
- Percona Replication Manager / Pacemaker or Percona Replication Manager
- Percona Replication Manager (PRM) / Pacemaker or Percona Replication Manager
- Percona Toolkits
- about / Percona Toolkits
- URL / Percona Toolkits
- pt-query-digest / pt-query-digest
- pt-stalk / pt-stalk
- pt-summary / pt-summary
- pt-mysql-summary / pt-mysql-summary
- pt-duplicate-key-checker / pt-duplicate-key-checker
- pt-index-usage / pt-index-usage
- performance schema
- about / Performance schema
- performance schema, features
- URL / Performance schema
- performance tuning
- about / Performance tuning
- Spider, parameters / Spider parameters
- number of shards / Number of shards
- performance tuning, Galera Cluster
- parallel slave threads / Parallel slave threads
- Gcache size / Gcache size
- performance_schema
- about / Performance schema
- pool size, InnoDB / Pool size and statistics
- power management optimization
- about / Power management optimization
- cpufreq / cpufreq
- cpuidle / cpuidle
- process list progression
- about / Process list progression
- profiling
- about / Profiling
- pt-duplicate-key-checker / pt-duplicate-key-checker
- pt-index-usage / pt-index-usage
- pt-mysql-summary / pt-mysql-summary
- pt-query-digest / pt-query-digest
- pt-stalk / pt-stalk
- pt-summary / pt-summary
Q
- query cache
- about / The query cache
- scenarios / The query cache
- values, viewing / Understanding the query cache
- modifying / Modifying the query cache
- query_cache_type parameter
- values / Understanding the query cache
- Query_plan / Slow query logs
- Query_time / Slow query logs
R
- -rA option / Pacemaker or Percona Replication Manager
- RAID 0 / RAID cards and levels
- RAID 1 / RAID cards and levels
- RAID 5 / RAID cards and levels
- RAID 6 / RAID cards and levels
- RAID 10 / RAID cards and levels
- RAID card / RAID and acceleration cards
- RAID cards / RAID cards and levels
- Raid levels
- solutions / RAID cards and levels
- RAID 0 / RAID cards and levels
- RAID 1 / RAID cards and levels
- RAID 5 / RAID cards and levels
- RAID 6 / RAID cards and levels
- RAID 10 / RAID cards and levels
- RAM
- about / RAM
- read and write nodes, Galera Cluster architectures
- about / Read and write nodes
- read cache
- Demand caching / RAID cards and levels
- Look-ahead caching / RAID cards and levels
- read transactions
- load balancing / Load balancing read transactions
- HAProxy, installing / Installing HAProxy
- HAProxy, configuring / Configuring HAProxy
- web health, checking / Checking health
- configuration, testing / Testing the configuration
- redo logs, InnoDB / Redo logs
- Redundant Array of Independent Disks (RAID) / SATA magnetic drives
- remote SQL logs, Spider / Remote SQL logs
- replicated shards
- creating / Creating replicated shards
- replication
- working / How replication works
- use cases / Use cases and troubleshooting
- troubleshooting / Use cases and troubleshooting
- options / Restricting replications
- sharding / Sharding replication
- replication, working
- master node, configuring / Configuring the master node
- master node, preparing / Preparing the master node
- slave node, configuring / Configuring the slave node
- slave, creating / Creating a slave
- slave status, checking / Checking the slave status
- replication mechanisms
- standard replication / How replication works
- GTID replication / How replication works
- replication performance
- speeding up, for middle slaves / Speeding up replication performance for middle slaves
- replications
- restricting / Restricting replications
- replication status
- about / Replication
- rollback, snapshot / Rollback
- rotation speeds
- 10K rpms / SAS magnetic drives
- 15K rpms / SAS magnetic drives
- Rows_examined / Slow query logs
- rsync method
- about / Using rsync
- using / Using rsync
- RTREE index engine
- about / Engines
S
- SAS magnetic drives / SAS magnetic drives
- SATA magnetic drives
- 5400 rpms / SATA magnetic drives
- 7200 rpms / SATA magnetic drives
- Sequence / Introduction to MariaDB engines
- server certificate
- building / Building your server certificate
- Severalnines
- shard
- replicated shards, creating / Creating replicated shards
- Spider HA, monitoring / Spider HA monitoring
- data, recovering after server failure / Recovering data after server failure
- Shoot The Other Node In The Head (STONITH) / Pacemaker or Percona Replication Manager
- show explain command
- about / The show explain command
- SHOW SLAVE STATUS command
- about / Restricting replications
- single instance
- checking / Single instance
- skip-innodb option / Speeding up replication performance for middle slaves
- SkySQL
- about / MariaDB history
- slave
- creating / Creating a slave
- switching, to master / GTID – switching a slave to master and recovering
- designing, in multiple continents / Designing slave in multiple continents
- slave, creating
- mysqldump, using / Using mysqldump
- Xtrabackup, using / Using Xtrabackup
- slave, GTID replication
- creating / Creating a slave
- starting / Starting the slave
- slave cascading
- performing / Cascade slaves
- slave node, replication
- configuring / Configuring the slave node
- slave status, GTID replication
- checking / Checking the slave status
- slave status, replication
- checking / Checking the slave status
- slave status command / Client SSL
- slow queries
- about / Slow queries
- slow query log feature
- about / Slow queries
- slow query logs
- about / Slow query logs
- snapshot
- about / Snapshot
- removing / Removing snapshots
- rollback / Rollback
- Solid State Drives (SSDs) / Hybrid drives
- solutions, SQL errors
- correct / SQL errors
- skip / SQL errors
- GTID / SQL errors
- SphinxSE / Introduction to MariaDB engines
- Spider / Introduction to MariaDB engines
- configuring / Configuring Spider
- Spider, parameters
- Bgs mode / The bgs mode
- connection recycle mode / The connection recycle mode
- statistics tables / Statistics tables
- remote SQL logs / Remote SQL logs
- Spider HA
- monitoring / Spider HA monitoring
- split-brain
- about / Split-brain
- SQL errors / SQL errors
- SSD optimization / SSD optimization
- SSDs / SSDs
- SSL
- MariaDB, configuring for / Configuring MariaDB for SSL
- SSL replication
- about / SSL replication
- standard replication / How replication works
- Statd
- State Snapshot Transfer (SST) / Transfer methods
- statistics
- reading / Resetting statistics
- statistics, InnoDB / Pool size and statistics
- statistics tables, Spider / Statistics tables
- status information, Galera Cluster
- wsrep_local_state_comment / First boot
- Joining mode, wsrep_local_state_comment / First boot
- Donor mode, wsrep_local_state_comment / First boot
- Joined mode, wsrep_local_state_comment / First boot
- Synced mode, wsrep_local_state_comment / First boot
- wsrep_cluster_size / First boot
- wsrep_cluster_state_uuid / First boot
- wsrep_cluster_conf_id / First boot
- wsrep_cluster_status / First boot
- primary mode, wsrep_cluster_status / First boot
- non-primary mode, wsrep_cluster_status / First boot
- disconnected mode, wsrep_cluster_status / First boot
- wsrep_connected / First boot
- wsrep_ready / First boot
- storage engines
- optimizing / Optimizing storage engines
- databases, summarizing / Summarizing your databases
- InnoDB / InnoDB/XtraDB
- XtraDB / InnoDB/XtraDB
- MyISAM / MyISAM
- SWAP / SWAP
- swappiness value
- about / SWAP
- Sysbench
T
- - threads / Sysbench
- temporary directory, TokuDB / Temporary directory
- temporary tables
- about / Temporary tables
- TokuDB / Introduction to MariaDB engines
- about / TokuDB
- installing / Installation
- flush method / The flush method
- cache size / Cache size
- transaction commits / Transaction commits and logs
- logs / Transaction commits and logs
- temporary directory / Temporary directory
- compression feature / Compression
- TokuKV / Installation
- Tokutek
- about / TokuDB
- transactional caches, binlogs / Binlogs for transactional caches
- transaction commits, InnoDB / Transaction commits and logs
- transaction commits, TokuDB / Transaction commits and logs
- transfer methods, Galera Cluster
- about / Transfer methods
- mysqldump, using / Using mysqldump
- Xtrabackup, using / Using Xtrabackup
- rsync, using / Using rsync
- troubleshooting, replication
- about / Use cases and troubleshooting
- SQL errors / SQL errors
- binlogs, analyzing / Analyzing binlogs
- slave, switching to master / GTID – switching a slave to master and recovering
- recovering / GTID – switching a slave to master and recovering
U
- Uniform Memory Architecture (UMA) / Dedicating hardware optimization with NUMA
- Unix Socket
- using / Using Unix Socket
- update-rc.d command
- use cases, replication / Use cases and troubleshooting
- user statistics
- about / User statistics
- Using_Gtid parameter / Checking the slave status
V
- Vagrant file
- requisites / Architecture types and performances
- values, temporary tables
- Created_tmp_disk_tables / Temporary tables
- Created_tmp_files / Temporary tables
- Created_tmp_tables / Temporary tables
- values, transactional cache
- Binlog_cache_use / Binlogs for transactional caches
- Binlog_cache_disk_use / Binlogs for transactional caches
- variables, query cache
- Qcache_free_memory / Understanding the query cache
- Qcache_hits / Understanding the query cache
- Qcache_inserts / Understanding the query cache
- Qcache_lowmem_prunes / Understanding the query cache
- Qcache_not_cached / Understanding the query cache
- query_cache_size / Modifying the query cache
- query_cache_limit / Modifying the query cache
- Virtual IP (VIP) / Keepalived
- Virtual Router Redundancy Protocol (VRRP) / Keepalived
W
- WAN replication, Galera Cluster architectures
- about / WAN replication
- web health
- checking / Checking health
- Write-back caching / RAID cards and levels
- Write-through caching / RAID cards and levels
- write cache
- Write-back caching / RAID cards and levels
- Write-through caching / RAID cards and levels
X
- Xtrabackup
- about / Creating a slave, Using Xtrabackup, Xtrabackup
- using / Using Xtrabackup, Using Xtrabackup
- full backup / Full backup
- incremental backup / Incremental backup
- full backup, restoring from / Restoring from a full backup
- incremental backup, restoring from / Restoring from an incremental backup
- XtraDB / Introduction to MariaDB engines
- about / InnoDB/XtraDB