PostgreSQL replication : understand basic replication concepts and efficiently replicate interruptions /: understand basic replication concepts and efficiently replicate interruptions. (2013)

• Record Type: Book
• Further Information: Note: Zoltan Böszörmenyi, Hans-Jürgen Schönig.
• Other Names: Böszörményi, Zoltán; Schönig, Hans-Jürgen
• Contents: 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. 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. 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. 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? 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.
• Publisher Details: Place of publication not identified : Packt Publishing
• Publication Date: 2013
• Extent: 1 online resource
• Subjects: 005.7565; COMPUTERS -- Databases -- General; SQL (Computer program language); Relational databases; Client/server computing; Database management; COMPUTERS -- Programming Languages -- SQL; Client/server computing; Database management; Relational databases; SQL (Computer program language); Electronic books
• Languages: English
• ISBNs: 9781849516730; 1849516731; 9781299832442; 9781849516723; 1849516723
• Related ISBNs: 129983244X
• Notes: Note: Print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.