PostgreSQL High Availability Cookbook Second Edition

PostgreSQL High Availability Cookbook Second Edition
by Shaun M. Thomas
Print Length 页数: 472 pages
Publisher finelybook 出版社:‏ Packt Publishing – ebooks Account; 2nd Revised edition edition (6 Mar. 2017)
Language 语言: English
ISBN-10: 178712553X
ISBN-13: 9781787125537
Get to know effective ways to improve PostgreSQL’s performance and master query optimization,and database monitoring.About This Book
Perform essential database tasks such as benchmarking the database and optimizing the server’s memory usage
Learn ways to improve query performance and optimize the PostgreSQL server
Explore a wide range of high availability and replication mechanisms to build robust,highly available,scalable,and fault-tolerant PostgreSQL databases
Who This Book Is For
If you are a developer or administrator with limited PostgreSQL knowledge and want to develop your skills with this great open source database,then this book is ideal for you. Learning how to enhance the database performance is always an exciting topic to everyone,and this book will show you enough ways to enhance the database performance.
What You Will Learn
Build replication strategies for homogeneous and heterogeneous databases
Test and build a powerful machine with multiple bench marking techniques
Get to know a few SQL injection techniques
Find out how to manage the replication using multiple tools
Benchmark the database server using multiple strategies
Work with the query processing algorithms and their internal behaviors
Build a proper plan to upgrade or migrate to PostgreSQL from other databases
See the essential database load balancing techniques and the various partitioning approaches PostgreSQL provides
Learn memory optimization techniques and database server configurations
Contents
Chapter 1: Database Benchmarking
Chapter 2: Server Configuration and Control
Chapter 3: Device Optimization
Chapter 4: Monitoring Server Performance
Chapter 5: Connection Pooling and Database Partitioning
Chapter 6: High Availability and Replication
Chapter 7: Working with Third-Party Replication Management Utilities
Chapter 8: Database Monitoring and Performance
Chapter 9: Vacuum Internals
Chapter 10: Data Migration from Other Databases to PostgreSQL and Upgrading the PostgreSQL Cluster
Chapter 11: Query Optimization
Chapter 12: Database Indexing
了解有效的方法来改进PostgreSQL的性能和主查询优化以及数据库监控。
关于这本书
执行必要的数据库任务，例如对数据库进行基准测试并优化服务器的内存使用情况
了解如何提高查询性能并优化PostgreSQL服务器
探索广泛的高可用性和复制机制来构建强大，高可用性，可扩展和容错的PostgreSQL数据库
这本书是谁
如果您是具有有限PostgreSQL知识的开发人员或管理员，并希望利用这个优秀的开源数据库来开发您的技能，那么这本书是您理想的选择。学习如何提高数据库性能始终是每个人都很激动的话题，本书将向您展示足够的方法来增强数据库的性能。
你会学到什么
构建同构和异构数据库的复制策略
测试和建立一个强大的机器与多个台秤标记技术
了解一些SQL注入技术
了解如何使用多种工具管理复制
使用多种策略对数据库服务器进行基准测试
使用查询处理算法及其内部行为
构建一个适当的计划，从其他数据库升级或迁移到PostgreSQL
请参阅PostgreSQL提供的基本数据库负载平衡技术和各种分区方法
学习内存优化技术和数据库服务器配置
目录
第1章: 数据库基准
第2章: 服务器配置和控制
第3章: 设备优化
第4章: 监控服务器性能
第5章: 连接池和数据库分区
第6章: 高可用性和复制
第7章: 使用第三方复制管理实用程序
第8章: 数据库监控和性能
第9章: 真空内脏
第10章: 从其他数据库迁移到PostgreSQL并升级PostgreSQL群集
第11章: 查询优化
第12章: 数据库索引