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...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Packt Publishing,
2014.
|
| Schriftenreihe: | Community experience distilled.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | 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. |
| Beschreibung: | 1 online resource |
| ISBN: | 9781783981618 178398161X 1322153035 9781322153032 9781783981601 1783981601 |
Internformat
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn892045637 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.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 |d OCLCO |d OCLCQ |d OCLKB | ||
| 019 | |a 907286310 |a 968101178 |a 969040369 |a 994403696 |a 1432346729 | ||
| 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 | ||
| 035 | |a (OCoLC)892045637 |z (OCoLC)907286310 |z (OCoLC)968101178 |z (OCoLC)969040369 |z (OCoLC)994403696 |z (OCoLC)1432346729 | ||
| 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 | 7 | |a 004/.36 |2 23 | |
| 049 | |a MAIN | ||
| 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. | ||
| 630 | 0 | 0 | |a MariaDB. |0 http://id.loc.gov/authorities/names/n2011046345 |
| 630 | 0 | 7 | |a MariaDB |2 fast |
| 650 | 0 | |a Database management. |0 http://id.loc.gov/authorities/subjects/sh85035848 | |
| 650 | 0 | |a Client/server computing. |0 http://id.loc.gov/authorities/subjects/sh93000502 | |
| 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 | |
| 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. |0 http://id.loc.gov/authorities/names/no2011030603 | |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=853664 |3 Volltext |
| 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 | ||
| 938 | |b OCKB |z perlego.catalogue,cece57ba-c697-455e-990f-418adaf2f087-emi | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn892045637 |
|---|---|
| _version_ | 1816882289997512704 |
| adam_text | |
| any_adam_object | |
| author | MAVRO, Pierre |
| author_facet | MAVRO, Pierre |
| author_role | |
| author_sort | MAVRO, Pierre |
| author_variant | p m pm |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D3 |
| callnumber-search | QA76.9.D3 |
| callnumber-sort | QA 276.9 D3 |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| contents | 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. |
| ctrlnum | (OCoLC)892045637 |
| dewey-full | 004/.36 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 004 - Computer science |
| dewey-raw | 004/.36 |
| dewey-search | 004/.36 |
| dewey-sort | 14 236 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>07061cam a2200829 a 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn892045637</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr cnu---unuuu</controlfield><controlfield tag="008">141003s2014 xx o 000 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">IDEBK</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">IDEBK</subfield><subfield code="d">EBLCP</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">N$T</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">COO</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCF</subfield><subfield code="d">YDXCP</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">FEM</subfield><subfield code="d">AGLDB</subfield><subfield code="d">ICA</subfield><subfield code="d">XFH</subfield><subfield code="d">MERUC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">D6H</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">VNS</subfield><subfield code="d">VTS</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">STF</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLKB</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">907286310</subfield><subfield code="a">968101178</subfield><subfield code="a">969040369</subfield><subfield code="a">994403696</subfield><subfield code="a">1432346729</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781783981618</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">178398161X</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1322153035</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781322153032</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781783981601</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1783981601</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)892045637</subfield><subfield code="z">(OCoLC)907286310</subfield><subfield code="z">(OCoLC)968101178</subfield><subfield code="z">(OCoLC)969040369</subfield><subfield code="z">(OCoLC)994403696</subfield><subfield code="z">(OCoLC)1432346729</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">3614232206276492445</subfield><subfield code="b">TotalBoox</subfield><subfield code="f">Ebook only</subfield><subfield code="n">www.totalboox.com</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.9.D3</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">013000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">014000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">018000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">067000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">032000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">037000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">052000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">004/.36</subfield><subfield code="2">23</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">MAVRO, Pierre.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">MariaDB High Performance.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="b">Packt Publishing,</subfield><subfield code="c">2014.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="347" ind1=" " ind2=" "><subfield code="a">text file</subfield><subfield code="2">rda</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">Community Experience Distilled</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Print version record.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="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.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="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.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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.</subfield></datafield><datafield tag="546" ind1=" " ind2=" "><subfield code="a">English.</subfield></datafield><datafield tag="630" ind1="0" ind2="0"><subfield code="a">MariaDB.</subfield><subfield code="0">http://id.loc.gov/authorities/names/n2011046345</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">MariaDB</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85035848</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Client/server computing.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh93000502</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Gestion.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Architecture client-serveur (Informatique)</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Computer Literacy.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Computer Science.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Data Processing.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Hardware</subfield><subfield code="x">General.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Information Technology.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Machine Theory.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Reference.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Client/server computing</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="2">fast</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Mavro, Pierre.</subfield><subfield code="t">MariaDB high performance : familiarize yourself with the MariaDB system and build high-performance applications.</subfield><subfield code="d">Birmingham, England : Packt Publishing, ©2014</subfield><subfield code="h">vi, 279 pages</subfield><subfield code="k">Community experience distilled.</subfield><subfield code="z">9781783981601</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Community experience distilled.</subfield><subfield code="0">http://id.loc.gov/authorities/names/no2011030603</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=853664</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBL - Ebook Library</subfield><subfield code="b">EBLB</subfield><subfield code="n">EBL1797270</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">853664</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ProQuest MyiLibrary Digital eBook Collection</subfield><subfield code="b">IDEB</subfield><subfield code="n">cis29836769</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">12092496</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="b">OCKB</subfield><subfield code="z">perlego.catalogue,cece57ba-c697-455e-990f-418adaf2f087-emi</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBA-ocn892045637 |
| illustrated | Not Illustrated |
| indexdate | 2024-11-27T13:26:15Z |
| institution | BVB |
| isbn | 9781783981618 178398161X 1322153035 9781322153032 9781783981601 1783981601 |
| language | English |
| oclc_num | 892045637 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource |
| psigel | ZDB-4-EBA |
| publishDate | 2014 |
| publishDateSearch | 2014 |
| publishDateSort | 2014 |
| publisher | Packt Publishing, |
| record_format | marc |
| series | Community experience distilled. |
| series2 | Community Experience Distilled |
| spelling | MAVRO, Pierre. MariaDB High Performance. Packt Publishing, 2014. 1 online resource text txt rdacontent computer c rdamedia online resource cr rdacarrier text file rda Community Experience Distilled Print version record. 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. 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. English. MariaDB. http://id.loc.gov/authorities/names/n2011046345 MariaDB fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Client/server computing. http://id.loc.gov/authorities/subjects/sh93000502 Bases de données Gestion. Architecture client-serveur (Informatique) COMPUTERS Computer Literacy. bisacsh COMPUTERS Computer Science. bisacsh COMPUTERS Data Processing. bisacsh COMPUTERS Hardware General. bisacsh COMPUTERS Information Technology. bisacsh COMPUTERS Machine Theory. bisacsh COMPUTERS Reference. bisacsh Client/server computing fast Database management fast Print version: Mavro, Pierre. MariaDB high performance : familiarize yourself with the MariaDB system and build high-performance applications. Birmingham, England : Packt Publishing, ©2014 vi, 279 pages Community experience distilled. 9781783981601 Community experience distilled. http://id.loc.gov/authorities/names/no2011030603 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=853664 Volltext |
| spellingShingle | MAVRO, Pierre MariaDB High Performance. Community experience distilled. 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. MariaDB. http://id.loc.gov/authorities/names/n2011046345 MariaDB fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Client/server computing. http://id.loc.gov/authorities/subjects/sh93000502 Bases de données Gestion. Architecture client-serveur (Informatique) COMPUTERS Computer Literacy. bisacsh COMPUTERS Computer Science. bisacsh COMPUTERS Data Processing. bisacsh COMPUTERS Hardware General. bisacsh COMPUTERS Information Technology. bisacsh COMPUTERS Machine Theory. bisacsh COMPUTERS Reference. bisacsh Client/server computing fast Database management fast |
| subject_GND | http://id.loc.gov/authorities/names/n2011046345 http://id.loc.gov/authorities/subjects/sh85035848 http://id.loc.gov/authorities/subjects/sh93000502 |
| title | MariaDB High Performance. |
| title_auth | MariaDB High Performance. |
| title_exact_search | MariaDB High Performance. |
| title_full | MariaDB High Performance. |
| title_fullStr | MariaDB High Performance. |
| title_full_unstemmed | MariaDB High Performance. |
| title_short | MariaDB High Performance. |
| title_sort | mariadb high performance |
| topic | MariaDB. http://id.loc.gov/authorities/names/n2011046345 MariaDB fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Client/server computing. http://id.loc.gov/authorities/subjects/sh93000502 Bases de données Gestion. Architecture client-serveur (Informatique) COMPUTERS Computer Literacy. bisacsh COMPUTERS Computer Science. bisacsh COMPUTERS Data Processing. bisacsh COMPUTERS Hardware General. bisacsh COMPUTERS Information Technology. bisacsh COMPUTERS Machine Theory. bisacsh COMPUTERS Reference. bisacsh Client/server computing fast Database management fast |
| topic_facet | MariaDB. MariaDB Database management. Client/server computing. Bases de données Gestion. Architecture client-serveur (Informatique) COMPUTERS Computer Literacy. COMPUTERS Computer Science. COMPUTERS Data Processing. COMPUTERS Hardware General. COMPUTERS Information Technology. COMPUTERS Machine Theory. COMPUTERS Reference. Client/server computing Database management |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=853664 |
| work_keys_str_mv | AT mavropierre mariadbhighperformance |