PostgreSQL 9 High Availability Cookbook.pdf

(3342 KB) Pobierz
PostgreSQL 9 High
Availability Cookbook
Over 100 recipes to design and implement a highly
available server with the advanced features of PostgreSQL
Shaun M. Thomas
BIRMINGHAM - MUMBAI
PostgreSQL 9 High Availability Cookbook
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 (
tysoncinematics@gmail.com
)
Credits
Author
Shaun M. Thomas
Reviewers
Hans-Jürgen Schönig
Sheldon E. Strauch
Vasilis Ventirozos
Tomas Vondra
Indexers
Acquisition Editors
Anthony Albuquerque
Harsha Bharwani
Content Development Editor
Sriram Neelakantan
Technical Editor
Tanvi Bhatt
Copy Editors
Janbal Dharmaraj
Sayanee Mukherjee
Karuna Narayanan
Hemangini Bari
Tejal Soni
Priya Subramani
Graphics
Sheetal Aute
Disha Haria
Abhinash Sahu
Production Coordinator
Melwyn D'sa
Cover Work
Melwyn D'sa
Project Coordinator
Kartik Vedam
Proofreaders
Maria Gould
Ameesha Green
Paul Hindle
About the Author
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.

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin