Shaun M. Thomas - PostgreSQL 9 High Availability Cookbook
Here you can read online Shaun M. Thomas - PostgreSQL 9 High Availability Cookbook full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2014, publisher: Packt Publishing, genre: Home and family. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:
Romance novel
Science fiction
Adventure
Detective
Science
History
Home and family
Prose
Art
Politics
Computer
Non-fiction
Religion
Business
Children
Humor
Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.
- Book:PostgreSQL 9 High Availability Cookbook
- Author:
- Publisher:Packt Publishing
- Genre:
- Year:2014
- Rating:3 / 5
- Favourites:Add to favourites
- Your mark:
PostgreSQL 9 High Availability Cookbook: summary, description and annotation
We offer to read an annotation, description, summary or preface (depends on what the author of the book "PostgreSQL 9 High Availability Cookbook" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.
Over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL
Overview
- Create a PostgreSQL cluster that stays online even when disaster strikes
- Avoid costly downtime and data loss that can ruin your business
- Perform data replication and monitor your data with hands-on industry-driven recipes and detailed step-by-step explanations
In Detail
PostgreSQL, often known as simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards-compliance.
From hardware selection to software stacks and horizontal scalability, this book will help you build a versatile PostgreSQL cluster that will survive crashes, resist data corruption, and grow smoothly with customer demand. We start with selecting the necessary hardware to handle multiple failure scenarios with redundancy. Then, we discuss how to automate and visualize these checks with Nagios, check_mk, and Graphite. Well finally round off by tackling the complex problem of data scalability.
What you will learn from this book
- Protect your data with PostgreSQL replication and management tools such as Slony, Bucardo, and Londiste
- Choose the correct hardware for redundancy and scale
- Prepare for catastrophes and prevent them before they happen
- Reduce database resource contention with connection pooling
- Automate monitoring and alerts to visualize cluster activity using Nagios and collectd
- Construct a robust software stack that can detect and fix outages
- Design a scalable schema architecture to handle billions of queries
Approach
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.
Who this book is written for
If you are a PostgreSQL DBA working on Linux systems who want a database that never gives up, this book is for you. If youve 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.
Shaun M. Thomas: author's other books
Who wrote PostgreSQL 9 High Availability Cookbook? Find out the surname, the name of the author of the book and a list of all author's works by series.
PostgreSQL 9 High Availability Cookbook — read online for free the complete book (whole text) full work
Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "PostgreSQL 9 High Availability Cookbook" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.
Font size:
Interval:
Bookmark:
Copyright 2014 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.
First published: July 2014
Production reference: 1100714
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham B3 2PB, UK.
ISBN 978-1-84951-696-9
www.packtpub.com
Cover image by Pratyush (<>)
Author
Shaun M. Thomas
Reviewers
Hans-Jrgen Schnig
Sheldon E. Strauch
Vasilis Ventirozos
Tomas Vondra
Acquisition Editors
Anthony Albuquerque
Harsha Bharwani
Content Development Editor
Sriram Neelakantan
Technical Editor
Tanvi Bhatt
Copy Editors
Janbal Dharmaraj
Sayanee Mukherjee
Karuna Narayanan
Project Coordinator
Kartik Vedam
Proofreaders
Maria Gould
Ameesha Green
Paul Hindle
Indexers
Hemangini Bari
Tejal Soni
Priya Subramani
Graphics
Sheetal Aute
Disha Haria
Abhinash Sahu
Production Coordinator
Melwyn D'sa
Cover Work
Melwyn D'sa
Shaun M. Thomas has been working with PostgreSQL since late 2000. He is a frequent contributor to the PostgreSQL Performance and General mailing lists, assisting other DBAs with the knowledge he's gained over the years. In 2011 and 2012, he gave presentations at the Postgres Open conference on topics such as handling extreme throughput, high availability, server redundancy, and failover techniques. Most recently, he has contributed the Shard Manager extension and the walctl WAL management suite.
Currently, he serves as the database architect at OptionsHouse, an online options brokerage with a PostgreSQL cluster that handles almost 2 billion queries per day. Many of the techniques used in this book were developed specifically for this extreme environment.
He believes that PostgreSQL has a stupendous future ahead, and he can't wait to see the advancements subsequent versions will bring.
I'd like to thank my wife, Jennifer, for putting up with the weeks of long nights and for providing the encouragement I needed to get it all done. This book is my thank you letter to the PostgreSQL community, which helped me out of jams more times than I can count. I'd also like to thank OptionsHouse for putting me in charge of the busiest database I'd ever seen, forcing me to learn enough to keep it all running smoothly.
Hans-Jrgen Schnig is the founder and CEO of Cybertec Schnig & Schnig GmbH (www.postgresql-support.de), a company that focuses on PostgreSQL support, training, and consulting, as well as on scalable PostgreSQL solutions.
He has 15 years of experience in the field of PostgreSQL and has written several books that deal with PostgreSQL in the past couple of years.
Sheldon E. Strauch is a 20 year veteran of software consulting at companies such as IBM, Sears, Ernst & Young, and Kraft Foods. He has a Bachelor's degree in Business Administration and leverages his technical skills to improve business self-awareness. His interests include data gathering, management, and mining; maps and mapping; business intelligence; and application of data analysis for continuous improvement. He is currently focused on the development of end-to-end data management and mining at Enova International, a financial services company located in Chicago. In his spare time, he enjoys the performing arts, particularly music, and traveling with his wife Marilyn.
Vasilis Ventirozos has been working with databases for more than a decade on mission critical applications for companies in both the telecom and lottery industries. While he has worked with a number of database technologies, he considers PostgreSQL his database of choice. He currently works at OmniTI, a full-stack IT services company focused on highly scalable web infrastructure, providing PostgreSQL-related consulting and management.
Tomas Vondra has been working with PostgreSQL since 2003; although he's been working with various other databases since then (both open source and commercial), he instantly fell in love with PostgreSQL and the wonderful community built around it.
He is currently working at GoodData, a company that operates a BI cloud platform built on PostgreSQL, as a "performance specialist" and is mainly responsible for tracking and improving performance. In his free time, he's usually writing PostgreSQL extensions and patches or hacking something else related to PostgreSQL.
You might want to visit www.PacktPub.com for support files and downloads related to your book.
Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at > for more details.
At www.PacktPub.com, you can also read a collection of free technical articles, sign up for a range of free newsletters and receive exclusive discounts and offers on Packt books and eBooks.
http://PacktLib.PacktPub.com
Do you need instant solutions to your IT questions? PacktLib is Packt's online digital book library. Here, you can access, read and search across Packt's entire library of books.
- Fully searchable across every book published by Packt
- Copy and paste, print and bookmark content
- On demand and accessible via web browser
If you have an account with Packt at www.PacktPub.com, you can use this to access PacktLib today and view nine entirely free books. Simply use your login credentials for immediate access.
Welcome to PostgreSQL 9 High Availability Cookbook ! As a database, PostgreSQL is beginning to take its place in the world of high transaction rates and very large data installations. With this comes an increasing demand for PostgreSQL to act as a critical piece of infrastructure. System outages in these environments can be spectacularly costly and demand a higher caliber of management and tooling.
Font size:
Interval:
Bookmark:
Similar books «PostgreSQL 9 High Availability Cookbook»
Look at similar books to PostgreSQL 9 High Availability Cookbook. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.
Discussion, reviews of the book PostgreSQL 9 High Availability Cookbook and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.