Design, implement, and build server architecture using #PostgreSQL 9, with Packt’s new book and eBook Packt is pleased to announce the release of its new book PostgreSQL 9 High Availability Cookbook. Filled with easy-to-follow industry-driven recipes, administrators will learn how to build a versatile PostgreSQL cluster and avoid costly downtime. About the author: Shaun 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 knowledge hes gained over the years. In 2011 and 2012, he presented 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 is the database architect at OptionsHouse, an online options brokerage with a PostgreSQL cluster that handles almost two billion queries per day. Many of the techniques used in this book were developed specifically for this extreme environment. PostgreSQL 9 High Availability Cookbook starts by showing readers how to choose the right hardware and software they need to build a versatile PostgreSQL cluster. This, in turn, will prevent severs from crashing. Building a versatile data cluster will resist data corruption, and grow smoothly with customer demand. Administrators will also learn how to protect data with PostgreSQL replication and management tools such as Slony, Bucardo, and Londiste. This book will also teach them how to automate checks with Nagios check_mk, and Graphite and theyll also learn how to visualize these checks. Each chapter in this book is designed to simplify highly complex database operations. PostgreSQL 9 High Availability Cookbook covers the following topics: Preface Chapter 1: Hardware Planning Chapter 2: Handling and Avoiding Downtime Chapter 3: Pooling Resources Chapter 4: Troubleshooting Chapter 5: Monitoring Chapter 6: Replication Chapter 7: Replication Management Tools Chapter 8: Advanced Stack Chapter 9: Cluster Control Chapter 10: Data Distribution Index This is book is for PostgreSQL DBA working on Linux systems. Administrators wanting to guarantee system stability will find that this book is a valuable resource. For more information, please visit: goo.gl/H8N8mP
Posted on: Fri, 25 Jul 2014 10:10:50 +0000