Cargando…
PostgreSQL replication : understand basic replication concepts and efficiently replicate interruptions /
This book has a chapter dedicated to each aspect of replication. The new features of PostgreSQL 9 are introduced and there are lots of practical examples and screenshots.""PostgreSQL Replication"" is ideal for PostgreSQL administrators who want to set up and understand replicatio...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Packt Publishing,
2013.
|
| Colección: | Community experience distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000Ia 4500 | ||
|---|---|---|---|
| 001 | EBSCO_ocn857713157 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 130906s2013 xx o 000 0 eng d | ||
| 040 | |a IDEBK |b eng |e pn |c IDEBK |d OCLCQ |d EBLCP |d MHW |d E7B |d MEAUC |d DEBSZ |d N$T |d OCLCQ |d YDXCP |d OCLCF |d OCLCQ |d COO |d OCLCO |d OCLCQ |d AGLDB |d ICA |d ZCU |d MERUC |d OCLCQ |d D6H |d OCLCQ |d VTS |d ICG |d NLE |d OCLCQ |d UKMGB |d STF |d DKC |d OCLCQ |d UKAHL |d OCLCQ |d AJS |d OCLCQ |d OCLCO |d OCLCQ | ||
| 015 | |a GBB747686 |2 bnb | ||
| 016 | 7 | |a 018014771 |2 Uk | |
| 020 | |a 9781849516730 |q (electronic bk.) | ||
| 020 | |a 1849516731 |q (electronic bk.) | ||
| 020 | |a 129983244X |q (electronic bk.) | ||
| 020 | |a 9781299832442 |q (electronic bk.) | ||
| 020 | |a 9781849516723 | ||
| 020 | |a 1849516723 | ||
| 029 | 1 | |a AU@ |b 000062476584 | |
| 029 | 1 | |a CHNEW |b 000634499 | |
| 029 | 1 | |a CHNEW |b 001052054 | |
| 029 | 1 | |a CHVBK |b 567708748 | |
| 029 | 1 | |a DEBBG |b BV041632546 | |
| 029 | 1 | |a DEBBG |b BV044062901 | |
| 029 | 1 | |a DEBSZ |b 397618832 | |
| 029 | 1 | |a DEBSZ |b 493126627 | |
| 029 | 1 | |a UKMGB |b 018014771 | |
| 035 | |a (OCoLC)857713157 | ||
| 037 | |a 9781849516730 |b Packt Publishing Pvt. Ltd | ||
| 050 | 4 | |a QA76.73.S67 | |
| 072 | 7 | |a COM |x 051170 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.7565 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Böszörményi, Zoltán. | |
| 245 | 1 | 0 | |a PostgreSQL replication : |b understand basic replication concepts and efficiently replicate interruptions / |c Zoltan Böszörmenyi, Hans-Jürgen Schönig. |
| 260 | |b Packt Publishing, |c 2013. | ||
| 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 | ||
| 490 | 1 | |a Community experience distilled | |
| 520 | |a This book has a chapter dedicated to each aspect of replication. The new features of PostgreSQL 9 are introduced and there are lots of practical examples and screenshots.""PostgreSQL Replication"" is ideal for PostgreSQL administrators who want to set up and understand replication. If you want to make your databases more robust, more secure, faster, and more scalable, you will find all the information you need in this single book focusing exclusively on PostgreSQL replication. It is assumed that you already have some basic experience with PostgreSQL. | ||
| 505 | 0 | |a Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Understanding Replication Concepts; The CAP theory and physical limitations; Understanding the CAP theory; Why the speed of light matters; Long distance transmission; Why latency matters; Different types of replication; Synchronous versus asynchronous replication; Understanding replication and data loss; Considering the performance issues; Single-master versus multi-master replication; Logical versus physical replication; When to use physical replication. | |
| 505 | 8 | |a When to use logical replicationUsing sharding and data distribution; Understanding the purpose of sharding; An example of designing a sharded system; An example of querying different fields; Pros and cons of sharding; Choosing between sharding and redundancy; Increasing and decreasing the size of a cluster; Combining sharding and replication; Various sharding solutions; PostgreSQL-based sharding; External frameworks/middleware; Summary; Chapter 2: Understanding the PostgreSQL Transaction Log; How PostgreSQL writes data; The PostgreSQL disk layout; Looking into the data directory. | |
| 505 | 8 | |a PG_VERSION -- PostgreSQL version numberbase -- the actual data directory; global -- the global data; pg_clog -- the commit log; pg_hba.conf -- host-based network configuration; pg_ident.conf -- ident authentication; pg_multixact -- multi-transaction status data; pg_notify -- LISTEN/NOTIFY data; pg_serial -- information about committed serializable transactions; pg_snapshot -- exported snapshots; pg_stat_tmp -- temporary statistics data; pg_subtrans -- subtransaction data; pg_tblspc -- symbolic links to tablespaces; pg_twophase -- information about prepared statements. | |
| 505 | 8 | |a Pg_XLOG -- the PostgreSQL transaction log (WAL)postgresql.conf -- the central PostgreSQL configuration file; Writing one row of data; A simple INSERT statement; Read consistency; The purpose of the shared buffer; Mixed reads and writes; The XLOG and replication; Understanding consistency and data loss; All the way to the disk; From memory to memory; From memory to the disk; One word about batteries; Beyond fsync(); PostgreSQL consistency levels; Tuning checkpoints and the XLOG; Understanding the checkpoints; Configuring checkpoints; About segments and timeouts; To write or not to write? | |
| 505 | 8 | |a Tweaking WAL buffersThe internal structure of the XLOG; Understanding the XLOG records; Making the XLOG deterministic; Making the XLOG reliable; LSNs and shared buffer interaction; Debugging the XLOG and putting it all together; Summary; Chapter 3: Understanding Point-In-Time-Recovery; Understanding the purpose of PITR; Moving to the bigger picture; Archiving the transaction log; Taking base backups; Using pg_basebackup; Modifying pg_hba.conf; Signaling the master server; pg_basebackup -- basic features; Making use of the traditional methods to create base backups; Tablespace issues. | |
| 588 | 0 | |a Print version record. | |
| 590 | |a eBooks on EBSCOhost |b EBSCO eBook Subscription Academic Collection - Worldwide | ||
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 0 | |a Relational databases. | |
| 650 | 0 | |a Client/server computing. | |
| 650 | 0 | |a Database management. | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 6 | |a Bases de données relationnelles. | |
| 650 | 6 | |a Architecture client-serveur (Informatique) | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 7 | |a COMPUTERS |x Programming Languages |x SQL. |2 bisacsh | |
| 650 | 7 | |a Client/server computing. |2 fast |0 (OCoLC)fst00864205 | |
| 650 | 7 | |a Database management. |2 fast |0 (OCoLC)fst00888037 | |
| 650 | 7 | |a Relational databases. |2 fast |0 (OCoLC)fst01093575 | |
| 650 | 7 | |a SQL (Computer program language) |2 fast |0 (OCoLC)fst01102869 | |
| 700 | 1 | |a Schönig, Hans-Jürgen. | |
| 830 | 0 | |a Community experience distilled. | |
| 856 | 4 | 0 | |u https://ebsco.uam.elogim.com/login.aspx?direct=true&scope=site&db=nlebk&AN=637225 |z Texto completo |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26850733 | ||
| 938 | |a ebrary |b EBRY |n ebr10754139 | ||
| 938 | |a EBSCOhost |b EBSC |n 637225 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n cis26099000 | ||
| 938 | |a YBP Library Services |b YANK |n 11114143 | ||
| 994 | |a 92 |b IZTAP | ||