Cargando…
MariaDB High Performance.
Designing and maintaining a huge amount of data in production is not an easy task. Understanding how solutions work, what kind of differences exist between them, and how to get them working is necessary before designing a solution for production. MariaDB High Performance will help you avoid mistakes...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Packt Publishing,
2014.
|
| Colección: | Community experience distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000Ia 4500 | ||
|---|---|---|---|
| 001 | EBSCO_ocn892045637 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 141003s2014 xx o 000 0 eng d | ||
| 040 | |a IDEBK |b eng |e pn |c IDEBK |d EBLCP |d OCLCQ |d N$T |d OCLCQ |d COO |d OCLCO |d OCLCF |d YDXCP |d OCLCQ |d FEM |d AGLDB |d ICA |d XFH |d MERUC |d OCLCQ |d OCLCO |d D6H |d OCLCQ |d OCLCO |d VNS |d VTS |d OCLCQ |d OCLCO |d STF |d OCLCQ |d OCLCO |d OCLCQ | ||
| 019 | |a 907286310 |a 968101178 |a 969040369 |a 994403696 | ||
| 020 | |a 9781783981618 |q (electronic bk.) | ||
| 020 | |a 178398161X |q (electronic bk.) | ||
| 020 | |a 1322153035 |q (electronic bk.) | ||
| 020 | |a 9781322153032 |q (electronic bk.) | ||
| 020 | |a 9781783981601 | ||
| 020 | |a 1783981601 | ||
| 029 | 1 | |a CHNEW |b 000888896 | |
| 029 | 1 | |a CHVBK |b 374476152 | |
| 029 | 1 | |a DEBSZ |b 484729381 | |
| 029 | 1 | |a GBVCP |b 815716826 | |
| 029 | 1 | |a AU@ |b 000067103571 | |
| 035 | |a (OCoLC)892045637 |z (OCoLC)907286310 |z (OCoLC)968101178 |z (OCoLC)969040369 |z (OCoLC)994403696 | ||
| 037 | |a 3614232206276492445 |b TotalBoox |f Ebook only |n www.totalboox.com | ||
| 050 | 4 | |a QA76.9.D3 | |
| 072 | 7 | |a COM |x 013000 |2 bisacsh | |
| 072 | 7 | |a COM |x 014000 |2 bisacsh | |
| 072 | 7 | |a COM |x 018000 |2 bisacsh | |
| 072 | 7 | |a COM |x 067000 |2 bisacsh | |
| 072 | 7 | |a COM |x 032000 |2 bisacsh | |
| 072 | 7 | |a COM |x 037000 |2 bisacsh | |
| 072 | 7 | |a COM |x 052000 |2 bisacsh | |
| 082 | 0 | 4 | |a 004/.36 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a MAVRO, Pierre. | |
| 245 | 1 | 0 | |a MariaDB High Performance. |
| 260 | |b Packt Publishing, |c 2014. | ||
| 300 | |a 1 online resource | ||
| 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 |2 rda | ||
| 490 | 1 | |a Community Experience Distilled | |
| 588 | 0 | |a Print version record. | |
| 520 | |a Designing and maintaining a huge amount of data in production is not an easy task. Understanding how solutions work, what kind of differences exist between them, and how to get them working is necessary before designing a solution for production. MariaDB High Performance will help you avoid mistakes, bad designs, and wrong strategic choices. This book will throw light on important and crucial subjects such as which hardware should be used in which situation and what the bottlenecks generally are. You will get acquainted with the latest addition to the MariaDB family, known as Spider, and you will get to know how data sharding is carried out across several MariaDB servers using Spider. | ||
| 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. | |
| 546 | |a English. | ||
| 590 | |a eBooks on EBSCOhost |b EBSCO eBook Subscription Academic Collection - Worldwide | ||
| 630 | 0 | 0 | |a MariaDB. |
| 630 | 0 | 7 | |a MariaDB. |2 fast |0 (OCoLC)fst01786766 |
| 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 Computer Literacy. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Computer Science. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Data Processing. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Hardware |x General. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Information Technology. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Machine Theory. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Reference. |2 bisacsh | |
| 650 | 7 | |a Client/server computing. |2 fast |0 (OCoLC)fst00864205 | |
| 650 | 7 | |a Database management. |2 fast |0 (OCoLC)fst00888037 | |
| 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://ebsco.uam.elogim.com/login.aspx?direct=true&scope=site&db=nlebk&AN=853664 |z Texto completo |
| 938 | |a EBL - Ebook Library |b EBLB |n EBL1797270 | ||
| 938 | |a EBSCOhost |b EBSC |n 853664 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n cis29836769 | ||
| 938 | |a YBP Library Services |b YANK |n 12092496 | ||
| 994 | |a 92 |b IZTAP | ||