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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Mavro, Pierre (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham, England : Packt Publishing, 2014.
Colección:Community experience distilled.
Temas:
MariaDB.
MariaDB
Database management.
Client/server computing.
Bases de données > Gestion.
Architecture client-serveur (Informatique)
COMPUTERS > Internet > Application Development.
COMPUTERS > Desktop Applications > Databases.
Client/server computing
Database management
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
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

Ejemplares similares