MariaDB high performance familiarize yourself with the MariaDB system and build high-performance applications
This book is aimed at system administrators/architects or DBAs who want to learn more about how to grow their current infrastructure to support larger traffic. Before beginning with this book, we expect you to be well-practiced with MySQL/MariaDB for common usage. You will be able to get a grasp qui...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Birmingham, England :
Packt Publishing
2014.
|
| Edición: | 1st edition |
| Colección: | Community experience distilled.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628707506719 |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Performance Introduction; MariaDB history; Choosing the appropriate hardware; Disks; SATA magnetic drives; SAS magnetic drives; Hybrid drives; SSDs; RAID and acceleration cards; RAID cards and levels; Fusion-io direct acceleration cards; Disk arrays; RAM; CPU; Architecture types and performances; BIOS power management optimization; C-States; P-States; Constructor name options; Power management optimization; cpufreq; cpuidle; Disk and filesystem optimization
- Kernel disks'' I/O schedulersPartition alignment; SSD optimization; Filesystem options; SWAP; Dedicating hardware with cgroups; Manual solution; Automatic solution using the cgconfig daemon; Dedicating hardware optimization with NUMA; Migrating from MySQL to MariaDB; Introduction to MariaDB engines; Summary; Chapter 2: Performance Analysis; Slow queries; The explain command; Slow query logs; The show explain command; Profiling; Performance schema; User statistics; Sysbench; Percona Toolkits; pt-query-digest; pt-stalk; pt-summary; pt-mysql-summary; pt-duplicate-key-checker; pt-index-usage
- Process list progressionmytop; innotop; mysqlsla; Summary; Chapter 3: Performance Optimizations; Resetting statistics; Global statistics; DNS connections; The DNS cache server; Maximum connections; The binlogs cache; Binlogs for transactional caches; Binlogs for nontransactional caches; Temporary tables; Open tables; The query cache; Understanding the query cache; Modifying the query cache; Optimizing storage engines; Summarizing your databases; InnoDB/XtraDB; Pool size and statistics; Redo logs; Transaction commits and logs; Buffer pool instances; The flush method; TokuDB; Installation
- The flush methodCache size; Transaction commits and logs; Temporary directory; Compression; MyISAM; Key buffer; Index; Engines; Types; mysqltuner; Summary; Chapter 4: MariaDB Replication; How replication works; Configuring the master node; Preparing the master node; Configuring the slave node; Creating a slave; Using mysqldump; Using Xtrabackup; Checking the slave status; GTID replication; What is GTID; Configuring the master node; Preparing the master node; Configuring a GTID slave node; Creating a slave; Starting the slave; Checking the slave status
- Migrating from classical to GTID replicationParallel replication; Load balancing read transactions; Installing HAProxy; Configuring HAProxy; Checking health; Testing the configuration; Use cases and troubleshooting; SQL errors; Analyzing binlogs; GTID - switching a slave to master and recovering; Summary; Chapter 5: WAN Slave Architectures; Cascade slaves; Speeding up replication performance for middle slaves; Restricting replications; Designing slave in multiple continents; SSL replication; Generating certificates; Building your own CA; Building your server certificate
- Building your client certificates
