Cargando…
PostgreSQL 9 high availability cookbook : over 100 recipes to desin and implement a highly available server with advanced features of PostgreSQL /
A comprehensive series of dependable recipes to design, build, and implement a PostgreSQL server architecture free of common pitfalls that can operate for years to come. Each chapter is packed with instructions and examples to simplify even highly complex database operations. If you are a PostgreSQL...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, UK :
Packt Pub.,
2014.
|
| Colección: | Quick answers to common problems.
|
| Temas: | |
| Acceso en línea: | Texto completo Texto completo |
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | EBOOKCENTRAL_ocn888035955 | ||
| 003 | OCoLC | ||
| 005 | 20240329122006.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 140820s2014 enka o 001 0 eng d | ||
| 040 | |a UMI |b eng |e pn |c UMI |d MHW |d DEBBG |d DEBSZ |d YDXCP |d OCLCQ |d OCLCO |d OCLCF |d OCLCQ |d N$T |d E7B |d COO |d COCUF |d K6U |d CNNOR |d CCO |d PIFAG |d FVL |d IDEBK |d EBLCP |d S4S |d OCLCQ |d ZCU |d AGLDB |d MERUC |d OCLCQ |d OCLCO |d D6H |d VTS |d CEF |d ICG |d OCLCQ |d OCLCO |d STF |d DKC |d OCLCQ |d OCLCO |d AJS |d OCLCO |d SGP |d OCLCQ |d OCLCO |d OCLCL | ||
| 019 | |a 884549082 |a 889263878 |a 907254278 | ||
| 020 | |a 9781849516976 | ||
| 020 | |a 1849516979 | ||
| 020 | |a 1849516960 | ||
| 020 | |a 9781849516969 | ||
| 020 | |a 1306974933 | ||
| 020 | |a 9781306974936 | ||
| 020 | |z 9781849516969 | ||
| 029 | 1 | |a AU@ |b 000053793165 | |
| 029 | 1 | |a AU@ |b 000056928961 | |
| 029 | 1 | |a AU@ |b 000059332624 | |
| 029 | 1 | |a CHNEW |b 000698357 | |
| 029 | 1 | |a CHNEW |b 000888214 | |
| 029 | 1 | |a CHVBK |b 374471312 | |
| 029 | 1 | |a DEBBG |b BV042182353 | |
| 029 | 1 | |a DEBBG |b BV043611037 | |
| 029 | 1 | |a DEBSZ |b 410567663 | |
| 029 | 1 | |a DEBSZ |b 41723032X | |
| 029 | 1 | |a DEBSZ |b 49314837X | |
| 029 | 1 | |a GBVCP |b 815094329 | |
| 035 | |a (OCoLC)888035955 |z (OCoLC)884549082 |z (OCoLC)889263878 |z (OCoLC)907254278 | ||
| 037 | |a CL0500000466 |b Safari Books Online | ||
| 050 | 4 | |a QA76.9.D3 |b .T466 2014eb | |
| 072 | 7 | |a COM |x 021000 |2 bisacsh | |
| 072 | 7 | |a COM |x 051170 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.74 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Thomas, Shaun M. | |
| 245 | 1 | 0 | |a PostgreSQL 9 high availability cookbook : |b over 100 recipes to desin and implement a highly available server with advanced features of PostgreSQL / |c Shaun M. Thomas. |
| 246 | 3 | |a Postrege Structured Query Language | |
| 260 | |a Birmingham, UK : |b Packt Pub., |c 2014. | ||
| 300 | |a 1 online resource (1 volume) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 490 | 1 | |a Quick answers to common problems | |
| 588 | 0 | |a Online resource; title from title page (Safari, viewed August 9, 2014). | |
| 500 | |a Includes index. | ||
| 520 | |a A comprehensive series of dependable recipes to design, build, and implement a PostgreSQL server architecture free of common pitfalls that can operate for years to come. Each chapter is packed with instructions and examples to simplify even highly complex database operations. If you are a PostgreSQL DBA working on Linux systems who want a database that never gives up, this book is for you. If you've ever experienced a database outage, restored from a backup, spent hours trying to repair a malfunctioning cluster, or simply want to guarantee system stability, this book is definitely for you. | ||
| 505 | 0 | |a Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Hardware Planning; Introduction; Planning for redundancy; Having enough IOPS; Sizing storage; Investing in a RAID; Picking a processor; Making the most of memory; Exploring nimble networking; Managing motherboards; Selecting a chassis; Saddling up to a SAN; Tallying up; Protecting your eggs; Chapter 2: Handling and Avoiding Downtime; Introduction; Determining acceptable losses; Configuration -- getting it right the first time; Configuration -- managing scary settings | |
| 505 | 8 | |a Identifying important tablesDefusing cache poisoning; Exploring the magic of virtual IPs; Terminating rogue connections; Reducing contention with concurrent indexes; Managing system migrations; Managing software upgrades; Mitigating the impact of hardware failure; Applying bonus kernel tweaks; Chapter 3: Pooling Resources; Introduction; Determining connection costs and limits; Installing PgBouncer; Configuring PgBouncer safely; Connecting to PgBouncer; Listing PgBouncer server connections; Listing PgBouncer client connections; Evaluating PgBouncer pool health; Installing pgpool | |
| 505 | 8 | |a Configuring pgpool for master/slave modeTesting a write query on pgpool; Swapping active nodes with pgpool; Combining the power of PgBouncer and pgpool; Chapter 4: Troubleshooting; Introduction; Performing triage; Installing common statistics packages; Evaluating the current disk performance with iostat; Tracking I/O-heavy processes with iotop; Viewing past performance with sar; Correlating performance with dstat; Interpreting /proc/meminfo; Examining /proc/net/bonding/bond0; Checking the pg_stat_activity view; Checking the pg_stat_statements view; Debugging with strace | |
| 505 | 8 | |a Logging checkpoints properlyChapter 5: Monitoring; Introduction; Figuring out what to monitor; Installing and configuring Nagios; Configuring Nagios to monitor a database host; Enhancing Nagios with check_mk; Getting to know check_postgres; Installing and configuring collectd; Adding a custom PostgreSQL monitor to collectd; Installing and configuring Graphite; Adding collectd data to Graphite; Building a graph in Graphite; Customizing a Graphite graph; Creating a Graphite dashboard; Chapter 6: Replication; Introduction; Deciding what to copy; Securing the WAL stream; Setting up a hot standby | |
| 505 | 8 | |a Upgrading to asynchronous replicationBulletproofing with synchronous replication; Faking replication with pg_receivexlog; Setting up Slony; Copying a few tables with Slony; Setting up Bucardo; Copying a few tables with Bucardo; Setting up Londiste; Copying a few tables with Londiste; Chapter 7: Replication Management Tools; Introduction; Deciding when to use third-party tools; Installing and configuring Barman; Backing up a database with Barman; Restoring a database with Barman; Installing and configuring OmniPITR; Managing WAL files with OmniPITR; Installing and configuring repmgr | |
| 590 | |a ProQuest Ebook Central |b Ebook Central Academic Complete | ||
| 590 | |a eBooks on EBSCOhost |b EBSCO eBook Subscription Academic Collection - Worldwide | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a PostgreSQL. |
| 630 | 0 | 7 | |a PostgreSQL. |2 blmlsh |
| 630 | 0 | 7 | |a PostgreSQL |2 fast |
| 650 | 0 | |a Database management. | |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 7 | |a COMPUTERS |x Databases |x General. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Programming Languages |x SQL. |2 bisacsh | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 758 | |i has work: |a PostgreSQL 9 high availability cookbook (Text) |1 https://id.oclc.org/worldcat/entity/E39PCXGfBwx894wHtBTbwtXFx8 |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Thomas, Shaun M. |t PostgreSQL 9 high availability cookbook : over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL. |d Birmingham, [England] : Packt Publishing, ©2014 |h iv, 384 pages |k Quick answers to common problems |z 9781849516969 |
| 830 | 0 | |a Quick answers to common problems. | |
| 856 | 4 | 0 | |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=1744438 |z Texto completo |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781849516969/?ar |z Texto completo |
| 938 | |a EBL - Ebook Library |b EBLB |n EBL1744438 | ||
| 938 | |a ebrary |b EBRY |n ebr10897258 | ||
| 938 | |a EBSCOhost |b EBSC |n 814701 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n cis28656519 | ||
| 938 | |a YBP Library Services |b YANK |n 11996497 | ||
| 994 | |a 92 |b IZTAP | ||