Book Image

MariaDB High Performance

By : Pierre Mavro
Book Image

MariaDB High Performance

By: Pierre Mavro

Overview of this book

Table of Contents (18 chapters)
MariaDB High Performance
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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
    • about / Graphs
    • URL / Graphs
  • 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
    / Index
  • 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
    • about / Engines
    • BTREE / Engines
    • RTREE / Engines
    • HASH / 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
    • URL / Kernel disks' I/O schedulers
  • 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
    • about / LVM
    • snapshot / Snapshot
    • backup / Backup
  • 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
    • URL / Migrating from MySQL to MariaDB
  • 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
    • Graphite / Graphs
    • Collectd / Graphs
    • Statd / Graphs
  • 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
    • URL / 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
    / SATA magnetic drives
  • Sequence / Introduction to MariaDB engines
  • server certificate
    • building / Building your server certificate
  • Severalnines
    • URL / Load balanced architecture
  • 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
    • about / Graphs
    • URL / Graphs
  • 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
    • about / Sysbench
    • - fileio / Sysbench
    • - cpu / Sysbench
    • - memory / Sysbench
    • - threads / Sysbench
    • - mutex / Sysbench
    • - oltp / 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
    • about / Automatic solution using the cgconfig daemon
  • 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