Cargando…
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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, England :
Packt Publishing,
2014.
|
| Colección: | Community experience distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | OR_ocn893686254 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cn||||||||| | ||
| 008 | 140929t20142014enk o 001 0 eng d | ||
| 040 | |a E7B |b eng |e rda |e pn |c E7B |d OCLCO |d UMI |d DEBBG |d DEBSZ |d OCLCF |d OCLCQ |d REB |d CEF |d NLE |d UKMGB |d WYU |d UAB |d AU@ |d UKAHL |d RDF |d OCLCO |d OCLCQ |d QGK |d OCLCO | ||
| 015 | |a GBB742476 |2 bnb | ||
| 016 | 7 | |a 018006887 |2 Uk | |
| 019 | |a 893919797 |a 1259192643 | ||
| 020 | |a 9781783981618 |q (e-book) | ||
| 020 | |a 178398161X |q (e-book) | ||
| 020 | |a 1783981601 | ||
| 020 | |a 9781783981601 | ||
| 020 | |z 9781783981601 | ||
| 029 | 1 | |a AU@ |b 000057232359 | |
| 029 | 1 | |a DEBBG |b BV042489952 | |
| 029 | 1 | |a DEBSZ |b 434831336 | |
| 029 | 1 | |a GBVCP |b 882841998 | |
| 029 | 1 | |a UKMGB |b 018006887 | |
| 035 | |a (OCoLC)893686254 |z (OCoLC)893919797 |z (OCoLC)1259192643 | ||
| 037 | |a CL0500000495 |b Safari Books Online | ||
| 050 | 4 | |a QA76.9.D3 |b .M387 2014eb | |
| 082 | 0 | 4 | |a 005.7565 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Mavro, Pierre, |e author. | |
| 245 | 1 | 0 | |a MariaDB high performance : |b familiarize yourself with the MariaDB system and build high-performance applications / |c Pierre Mavro. |
| 264 | 1 | |a Birmingham, England : |b Packt Publishing, |c 2014. | |
| 264 | 4 | |c ©2014 | |
| 300 | |a 1 online resource (298 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a text file | ||
| 490 | 1 | |a Community Experience Distilled | |
| 500 | |a Includes index. | ||
| 588 | 0 | |a Online resource; title from PDF title page (ebrary, viewed September 29, 2014). | |
| 505 | 0 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 520 | |a 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 quickly if you are comfortable with learning and building large infrastructures for MariaDB using Linux. | ||
| 546 | |a English. | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a MariaDB. |
| 630 | 0 | 7 | |a MariaDB |2 fast |
| 650 | 0 | |a Database management. | |
| 650 | 0 | |a Client/server computing. | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 6 | |a Architecture client-serveur (Informatique) | |
| 650 | 7 | |a COMPUTERS |x Internet |x Application Development. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Desktop Applications |x Databases. |2 bisacsh | |
| 650 | 7 | |a Client/server computing |2 fast | |
| 650 | 7 | |a Database management |2 fast | |
| 776 | 0 | 8 | |i Print version: |a Mavro, Pierre. |t MariaDB high performance : familiarize yourself with the MariaDB system and build high-performance applications. |d Birmingham, England : Packt Publishing, ©2014 |h vi, 279 pages |k Community experience distilled. |z 9781783981601 |
| 830 | 0 | |a Community experience distilled. | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781783981601/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 936 | |a BATCHLOAD | ||
| 938 | |a Askews and Holts Library Services |b ASKH |n AH27089864 | ||
| 938 | |a ebrary |b EBRY |n ebr10940895 | ||
| 994 | |a 92 |b IZTAP | ||