PostgreSQL High Availability Cookbook


Author: Shaun M. Thomas
Publisher: Packt Publishing Ltd
ISBN: 178712567X
Category: Computers
Page: 536
View: 7105
DOWNLOAD NOW »
Master over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL About This Book Create a PostgreSQL cluster that stays online even when disaster strikes Avoid costly downtime and data loss that can ruin your business Updated to include the newest features introduced in PostgreSQL 9.6 with hands-on industry-driven recipes Who This Book Is 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 you've 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. What You Will Learn Protect your data with PostgreSQL replication and management tools such as Slony, Bucardo, pglogical, and WAL-E Hardware planning to help your database run efficiently Prepare for catastrophes and prevent them before they happen Reduce database resource contention with connection pooling using pgpool and PgBouncer Automate monitoring and alerts to visualize cluster activity using Nagios and collected Construct a robust software stack that can detect and fix outages Learn simple PostgreSQL High Availability with Patroni, or dive into the full power of Pacemaker. In Detail Databases are nothing without the data they store. In the event of a failure - catastrophic or otherwise - immediate recovery is essential. By carefully combining multiple servers, it's even possible to hide the fact a failure occurred at all. 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. It all begins with hardware selection for the skeleton of an efficient PostgreSQL database cluster. Then it's on to preventing downtime as well as troubleshooting some real life problems that administrators commonly face. Next, we add database monitoring to the stack, using collectd, Nagios, and Graphite. And no stack is complete without replication using multiple internal and external tools, including the newly released pglogical extension. Pacemaker or Raft consensus tools are the final piece to grant the cluster the ability to heal itself. We even round off by tackling the complex problem of data scalability. This book exploits many new features introduced in PostgreSQL 9.6 to make the database more efficient and adaptive, and most importantly, keep it running. Style and approach This book contains practical recipes that will help the reader solve real world problems related to high availability in PostgreSQL. Every recipe is explained in detail, with relevant explanations, tips and tricks provided for quicker and easier understanding.

PostgreSQL 9 High Availability Cookbook


Author: Shaun
Publisher: Packt Pub Limited
ISBN: 9781849516969
Category: Computers
Page: 398
View: 3126
DOWNLOAD NOW »
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. If you are a PostgreSQL DBA working on Linux systems who want a database that never gives up, this book is for you. If you've 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.

PostgreSQL High Availability Cookbook - Second Edition


Author: Shaun M. Thomas
Publisher: N.A
ISBN: 9781787125537
Category:
Page: 472
View: 3467
DOWNLOAD NOW »
Over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL 9.4,9.5 and 9.6About This Book* Create a PostgreSQL cluster that stays online even when disaster strikes* Avoid costly downtime and data loss that can ruin your business* Updated to include the newest features introduced in PostgreSQL 9.6 with hands-on industry-driven recipesWho This Book Is ForIf you are a PostgreSQL DBA working on Linux systems who want a database that never gives up, this book is for you. If you've 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.What you will learn* Protect your data with PostgreSQL replication and management tools such as Slony, Bucardo, pglogical, and WAL-E* Hardware planning to help your database run efficiently* Prepare for catastrophes and prevent them before they happen* Reduce database resource contention with connection pooling using pgpool and PgBouncer* Automate monitoring and alerts to visualize cluster activity using Nagios and collected* Construct a robust software stack that can detect and fix outages* Learn simple PostgreSQL High Availability with Patroni, or dive into the full power of Pacemaker.In DetailDatabases are nothing without the data they store. In the event of a failure - catastrophic or otherwise - immediate recovery is essential. By carefully combining multiple servers, it's even possible to hide the fact a failure occurred at all.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. It all begins with hardware selection for the skeleton of an efficient PostgreSQL database cluster. Then it's on to preventing downtime as well as troubleshooting some real life problems that administrators commonly face. Next, we add database monitoring to the stack, using collectd, Nagios, and Graphite. And no stack is complete without replication using multiple internal and external tools, including the newly released pglogical extension. Pacemaker or Raft consensus tools are the final piece to grant the cluster the ability to heal itself. We even round off by tackling the complex problem of data scalability.This book exploits many new features introduced in PostgreSQL 9.6 to make the database more efficient and adaptive, and most importantly, keep it running.

PostgreSQL Cookbook


Author: Chitij Chauhan
Publisher: Packt Publishing Ltd
ISBN: 1783555343
Category: Computers
Page: 286
View: 5835
DOWNLOAD NOW »
If you are a system administrator, database administrator, architect, developer, or anyone with an interest in planning, managing, and designing database solutions using PostgreSQL, this is the book for you. This book is suited for you if you have some prior experience with any relational database or with the SQL language.

PostgreSQL Administration Cookbook - Third Edition


Author: Simon Riggs,Gianni Ciolli,Hannu Krosing,Gabriele Bartolini
Publisher: N.A
ISBN: 9781785883187
Category:
Page: 570
View: 6114
DOWNLOAD NOW »
Over 90 recipes to help you administer your PostgreSQL database more efficientlyAbout This Book* Get to grips with the capabilities of PostgreSQL 9.6 to administer your database more efficiently,* Monitor, replicate and make your database highly secure and available,* A step-by-step, recipe-based guide to help you tackle any problem in PostgreSQL administration with easeWho This Book Is ForIf you are an administrator who wants to leverage the useful PostgreSQL functionalities to create and manage databases efficiently, this is the book for you. This book assumes a basic working knowledge of PostgreSQL, and some previous experience in PostgreSQL administration is required.What you will learn* Implement PostgreSQL features for reliability and performance* Harness the power of the latest PostgreSQL 9.5 & 9.6 features* Manage PostgreSQL versions 9.5 & 9.6* Advanced technical tips for experienced users* Explore best practices for planning and designing live databases* Select and implement robust backup and recovery techniques* Concise and clear guidance on replication and high availability* Latest details on Logical Replication and Bi-Directional ReplicationIn DetailPostgreSQL is an open-source database management tool used for handling large data sets (big data) and also as a JSON document database.Starting with short and simple recipes to get you back up and running with an exploration of the ins and outs of your database, you will soon dive into core features such as configuration, server control, tables, and data. You will tackle a variety of problems a database administrator usually encounters - spanning from creating tables to managing views, from improving performance to securing your database, and from using monitoring tools to using storage engines. Recipes based on important topics like high availability, concurrency, replication, backup and recovery, as well as diagnostics and troubleshooting are also given special importance. By the end of this book, you will have all the knowledge you need to run, manage and maintain your PostgreSQL efficiently.DBAs of all levels will be catered for with recipes of varying difficulty, allowing the reader to administer PostgreSQL efficiently. Tagline: Over XXX recipes to help you administer your PostgreSQL database more efficiently

PostgreSQL 10 Administration Cookbook

Over 165 effective recipes for database management and maintenance in PostgreSQL 10
Author: Gianni Ciolli,Simon Riggs
Publisher: Packt Publishing Ltd
ISBN: 1788477898
Category: Computers
Page: 576
View: 3923
DOWNLOAD NOW »
A practical guide to administer, monitor and replicate your PostgreSQL 10 database Key Features Get to grips with the capabilities of PostgreSQL 10 to administer your database more efficiently Monitor, tune, secure and protect your database for optimal performance A step-by-step, recipe-based guide to help you tackle any problem in PostgreSQL 10 administration with ease Book Description PostgreSQL is a powerful, open source database management system with an enviable reputation for high performance and stability. With many new features in its arsenal, PostgreSQL 10 allows users to scale up their PostgreSQL infrastructure. This book takes a step-by-step, recipe-based approach to effective PostgreSQL administration. Throughout this book, you will be introduced to these new features such as logical replication, native table partitioning, additional query parallelism, and much more. You will learn how to tackle a variety of problems that are basically the pain points for any database administrator - from creating tables to managing views, from improving performance to securing your database. More importantly, the book pays special attention to topics such as monitoring roles, backup, and recovery of your PostgreSQL 10 database, ensuring high availability, concurrency, and replication. By the end of this book, you will know everything you need to know to be the go-to PostgreSQL expert in your organization. What you will learn Get to grips with the newly released PostgreSQL 10 features to improve database performance and reliability Manage open source PostgreSQL versions 10 on various platforms. Explore best practices for planning and designing live databases Select and implement robust backup and recovery techniques in PostgreSQL 10 Explore concise and clear guidance on replication and high availability Discover advanced technical tips for experienced users Who this book is for This book is for database administrators, data architects, developers, or anyone with an interest in planning for, or running, live production databases using PostgreSQL. It is most suited to those looking for hands-on solutions to any problem associated with PostgreSQL administration.

PostgreSQL High Performance Cookbook


Author: Chitij Chauhan,Dinesh Kumar
Publisher: Packt Publishing Ltd
ISBN: 1785287249
Category: Computers
Page: 360
View: 2505
DOWNLOAD NOW »
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 In Detail PostgreSQL is one of the most powerful and easy to use database management systems. It has strong support from the community and is being actively developed with a new release every year. PostgreSQL supports the most advanced features included in SQL standards. It also provides NoSQL capabilities and very rich data types and extensions. All of this makes PostgreSQL a very attractive solution in software systems. If you run a database, you want it to perform well and you want to be able to secure it. As the world's most advanced open source database, PostgreSQL has unique built-in ways to achieve these goals. This book will show you a multitude of ways to enhance your database's performance and give you insights into measuring and optimizing a PostgreSQL database to achieve better performance. This book is your one-stop guide to elevate your PostgreSQL knowledge to the next level. First, you'll get familiarized with essential developer/administrator concepts such as load balancing, connection pooling, and distributing connections to multiple nodes. Next, you will explore memory optimization techniques before exploring the security controls offered by PostgreSQL. Then, you will move on to the essential database/server monitoring and replication strategies with PostgreSQL. Finally, you will learn about query processing algorithms. Style and approach This comprehensive guide is packed with practical administration tasks. Each topic is explained using examples and a step-by-step approach.

Mastering PostgreSQL 10

Expert techniques on PostgreSQL 10 development and administration
Author: Hans-Jürgen Schönig
Publisher: Packt Publishing Ltd
ISBN: 1788470532
Category: Computers
Page: 428
View: 8323
DOWNLOAD NOW »
Master the capabilities of PostgreSQL 10 to efficiently manage and maintain your database Key Features Your one-stop guide to mastering advanced concepts in PostgreSQL 10 with ease Master query optimization, replication, and high availability with PostgreSQL Extend the functionalities of your PostgreSQL instance to suit your organizational needs with minimal effort Book Description PostgreSQL is an open source database used for handling large datasets (big data) and as a JSON document database. This book highlights the newly introduced features in PostgreSQL 10, and shows you how you can build better PostgreSQL applications, and administer your PostgreSQL database more efficiently. We begin by explaining advanced database design concepts in PostgreSQL 10, along with indexing and query optimization. You will also see how to work with event triggers and perform concurrent transactions and table partitioning, along with exploring SQL and server tuning. We will walk you through implementing advanced administrative tasks such as server maintenance and monitoring, replication, recovery, high availability, and much more. You will understand common and not-so-common troubleshooting problems and how you can overcome them. By the end of this book, you will have an expert-level command of advanced database functionalities and will be able to implement advanced administrative tasks with PostgreSQL 10. What you will learn Get to grips with the advanced features of PostgreSQL 10 and handle advanced SQL Make use of the indexing features in PostgreSQL and fine-tune the performance of your queries Work with stored procedures and manage backup and recovery Master replication and failover techniques Troubleshoot your PostgreSQL instance for solutions to common and not-so-common problems Learn how to migrate your database from MySQL and Oracle to PostgreSQL without any hassle Who this book is for If you are a PostgreSQL data architect or an administrator and want to understand how to implement advanced functionalities and master complex administrative tasks with PostgreSQL 10, then this book is perfect for you. Prior experience of administrating a PostgreSQL database and a working knowledge of SQL are required to make the best use of this book.

Instant PostgreSQL Backup and Restore How-to


Author: Shaun Thomas
Publisher: Packt Publishing Ltd
ISBN: 1782169113
Category: Computers
Page: 54
View: 1306
DOWNLOAD NOW »
Filled with practical, step-by-step instructions and clear explanations for the most important and useful tasks. This hands-on guide provides a quick and easy way to back up and restore your database using PostgreSQL.Written for database administrators who want to create backups of their critical enterprise data and efficiently restore it using PostgreSQL.

PostgreSQL 9.6 High Performance


Author: Ibrar Ahmed,Gregory Smith
Publisher: Packt Publishing Ltd
ISBN: 1784396508
Category: Computers
Page: 508
View: 5119
DOWNLOAD NOW »
Enhance the performance of your PostgreSQL system with this handy guide while avoiding common pitfalls that can slow it down. About This Book Learn the right techniques to obtain optimal PostgreSQL database performance, ranging from initial design to routine maintenance Fine tune the performance of your queries and avoid the common pitfalls that can slow your system down Contains tips and tricks on scaling successful database installations, and ensuring a highly available PostgreSQL solution Who This Book Is For This book is for intermediate to advanced database administrators and developers who use or plan to exploit the features of PostgreSQL in the best possible manner. While administrators can benefit from the topics related to the installation, configuration, and optimization of the server, developers will learn how to write optimal queries and address performance issues in their database design. This book will also benefit the PostgreSQL internal architects in being able to monitor the performance using benchmarking tools. What You Will Learn Learn the best practices to configure your PostgreSQL 9.6 database for optimal performance Write optimal queries and techniques to detect performance issue in queries Fine tune the performance of your queries using benchmarking and indexing techniques Ensure high performance and a highly available database using the scaling and replication techniques Discover how to make informed speed and reliability trade-offs Handle increasing database workloads without any hassle Use monitoring insights to continuously rework the design and configuration for best performance In Detail Database administrators and developers spend years learning techniques to configure their PostgreSQL database servers for optimal performance, mostly when they encounter performance issues. Scalability and high availability of the database solution is equally important these days. This book will show you how to configure new database installations and optimize existing database server installations using PostgreSQL 9.6. You will start with the basic concepts of database performance, because all successful database applications are destined to eventually run into issues when scaling up their performance. You will not only learn to optimize your database and queries for optimal performance, but also detect the real performance bottlenecks using PostgreSQL tools and some external tools. Next, you will learn how to benchmark your hardware and tune your operating system. Optimize your queries against the database with the help of right indexes, and monitor every layer, ranging from hardware to queries. Moving on, you will see how connection pooling, caching, partitioning, and replication will help you handle increasing database workloads. Achieving high database performance is not easy, but you can learn it by using the right guide—PostgreSQL 9.6 High Performance. Style and approach This book has been organized in such a manner that will help you understand basic PostgreSQL 9.6 performance tuning to advanced-level configuration. There are many real-world problems explained in this book and explained in clear language, because improving database performance requires an equal mix of understanding theoretical concepts and working through hands-on examples.

PostgreSQL 9.0 High Performance

Accelerate Your PostgreSQL System and Avoid the Common Pitfalls that Can Slow it Down
Author: Gregory Smith
Publisher: Packt Pub Limited
ISBN: 9781849510301
Category: Computers
Page: 442
View: 2023
DOWNLOAD NOW »
Improving database performance requires an equal mix of understanding theoretical concepts and working through hands-on examples. You'll find both here. Many of the examples given will be immediately useful for monitoring and improving your PostgreSQL deployments, providing insight into hard-to-obtain information about your database. This book is aimed at intermediate to advanced database administrators using or planning to use PostgreSQL. Portions will also interest systems administrators looking to build or monitor a PostgreSQL installation, as well as developers interested in advanced database internals that impact application design.

PostgreSQL Server Programming - Second Edition


Author: Usama Dar,Hannu Krosing,Jim Mlodgenski,Kirk Roybal
Publisher: Packt Publishing Ltd
ISBN: 1783980591
Category: Computers
Page: 320
View: 8180
DOWNLOAD NOW »
This book is for moderate to advanced PostgreSQL database professionals who wish to extend PostgreSQL, utilizing the most updated features of PostgreSQL 9.4. For a better understanding of this book, familiarity with writing SQL, a basic idea of query tuning, and some coding experience in your preferred language is expected.

PostgreSQL Replication


Author: Hans-Jürgen Schönig
Publisher: Packt Publishing Ltd
ISBN: 1783988541
Category: Computers
Page: 322
View: 6335
DOWNLOAD NOW »
PostgreSQL offers a comprehensive set of replication related features. Unleashing the power of PostgreSQL provides you with countless opportunities and a competitive advantage over other database systems. This book will guide you through the most important concepts of PostgreSQL replication. It contains all the information you need to design and operate replicated setups. Beginning by giving you an understanding of replication concepts, the PostgreSQL transaction log, and Point-in-time Recovery, we gradually move on to setting up asynchronous and synchronous replication. Next up, you will learn to monitor a PostgreSQL cluster setup, deal with monitoring tools, and then move on to understanding Linux High Availability. Further, we explore widely-used tools such as Slony, SkyTools, Postgres-XC, and walbouncer, and set up PL/Proxy. Finally, you'll get acquainted with the new technology of BDR, which allows bidirectional replication in PostgreSQL.

PostgreSQL 9 Administration Cookbook

Solve Real-world PostgreSQL Problems with Over 100 Simple, Yet Incredibly Effective Recipes
Author: Simon Riggs,Hannu Krosing
Publisher: Packt Publishing Ltd
ISBN: 1849510296
Category: Computers
Page: 345
View: 8222
DOWNLOAD NOW »
PostgreSQL is a powerful, open source object-relational database system. An enterprise database, PostgreSQL includes features such as Multi-Version Concurrency Control (MVCC), point-in-time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write-ahead logging for fault tolerance. PostgreSQL 9 Admin cookbook covers everything a database administrator needs to protect, manage and run a healthy and efficient PostgreSQL 9.0 database. PostgreSQL 9 Admin Cookbook describes key aspects of the PostgreSQL open source database system. The book covers everything a sysadmin or DBA needs to protect, manage, and run a healthy and efficient PostgreSQL 9 database. This hands-on guide will assist developers working on live databases, supporting web or enterprise software applications using Java, Python, Ruby, or .Net from any development framework. It's easy to manage your database when you've got PostgreSQL 9 Admin Cookbook to hand. PostgreSQL is fast becoming one of the world's most popular server databases with an enviable reputation for performance, stability, and an enormous range of advanced features. PostgreSQL is one of the oldest open source projects, completely free to use and developed by a very diverse worldwide community. Most of all, It Just Works! PostgreSQL 9 Admin Cookbook offers the information you need to manage your live production databases on PostgreSQL. The book contains insights direct from the main author of the PostgreSQL replication and recovery features, and the database architect of the most successful startup using PostgreSQL, Skype. This practical guide gives quick answers to common questions and problems, building on the authors' experience as trainers, users, and core developers of the PostgreSQL database server. Each technical aspect is broken down into short recipes that demonstrate solutions with working code then explain why and how that works. The book is intended to be a desk reference for both new users and technical experts. The book covers all the latest features in PostgreSQL 9. Soon you will be running a smooth database with ease! A practical guide, this cookbook will ensure you run a smooth PostgreSQL database

PostgreSQL Developer's Guide


Author: Ibrar Ahmed,Asif Fayyaz,Amjad Shahzad
Publisher: Packt Publishing Ltd
ISBN: 1783989033
Category: Computers
Page: 270
View: 9855
DOWNLOAD NOW »
If you are a database developer who wants to learn how to design and implement databases for application development using PostgreSQL, this is the book for you. Existing knowledge of basic database concepts and some programming experience is required

PostgreSQL for Data Architects


Author: Jayadevan Maymala
Publisher: Packt Publishing Ltd
ISBN: 1783288612
Category: Computers
Page: 272
View: 4187
DOWNLOAD NOW »
This book is for developers and data architects who have some exposure to databases. It is assumed that you understand the basic concepts of tables and common database objects, including privileges and security.

Learning PostgreSQL


Author: Salahaldin Juba,Achim Vannahme,Andrey Volkov
Publisher: Packt Publishing Ltd
ISBN: 178398919X
Category: Computers
Page: 464
View: 7469
DOWNLOAD NOW »
Create, develop and manage relational databases in real world applications using PostgreSQL About This Book Learn about the PostgreSQL development life cycle including its testing and refactoring Build productive database solutions and use them in Java applications A comprehensive guide to learn about SQL, PostgreSQL procedural language and PL/pgSQL Who This Book Is For If you are a student, database developer or an administrator, interested in developing and maintaining a PostgreSQL database, then this book is for you. No knowledge of database programming or administration is necessary. What You Will Learn Learn concepts of data modelling and relation algebra Install and set up PostgreSQL database server and client software Implement data structures in PostgreSQL Manipulate data in the database using SQL Implement data processing logic in the database with stored functions, triggers and views Test database solutions and assess the performance Integrate database with Java applications Detailed knowledge of the main PostgreSQL building objects, most used extensions Practice database development life cycle including analysis, modelling, (documentation), testing, bug fixes and refactoring In Detail PostgreSQL is one of the most powerful and easy to use database management systems. It has strong support from the community and is being actively developed with a new release every year. PostgreSQL supports the most advanced features included in SQL standards. Also it provides NoSQL capabilities, and very rich data types and extensions. All that makes PostgreSQL a very attractive solution in various kinds of software systems. The book starts with the introduction of relational databases with PostegreSQL. It then moves on to covering data definition language (DDL) with emphasis on PostgreSQL and common DDL commands supported by ANSI SQL. You will then learn the data manipulation language (DML), and advanced topics like locking and multi version concurrency control (MVCC). This will give you a very robust background to tune and troubleshoot your application. The book then covers the implementation of data models in the database such as creating tables, setting up integrity constraints, building indexes, defining views and other schema objects. Next, it will give you an overview about the NoSQL capabilities of PostgreSQL along with Hstore, XML, Json and arrays. Finally by the end of the book, you'll learn to use the JDBC driver and manipulate data objects in the Hibernate framework. Style and approach An easy-to-follow guide to learn programming build applications with PostgreSQL, and manage a PostgreSQL database instance.

PostgreSQL 10 High Performance


Author: Enrico Pirozzi,Ibrar Ahmed,Gregory Smith
Publisher: N.A
ISBN: 9781788474481
Category:
Page: 508
View: 2488
DOWNLOAD NOW »
Leverage the power of PostgreSQL 10 to design, administer and maintain a high-performance database solution Key Features Obtain optimal PostgreSQL 10 database performance, ranging from initial design to routine maintenance Fine tune the performance of your queries and avoid the common pitfalls that can slow your system down Contains tips and tricks on scaling successful database installations, and ensuring a highly available PostgreSQL solution Book Description PostgreSQL database servers have a common set of problems that they encounter as their usage gets heavier and requirements get more demanding. Peek into the future of your PostgreSQL 10 database's problems today. Know the warning signs to look for and how to avoid the most common issues before they even happen. Surprisingly, most PostgreSQL database applications evolve in the same way--choose the right hardware, tune the operating system and server memory use, optimize queries against the database and CPUs with the right indexes, and monitor every layer, from hardware to queries, using tools from inside and outside PostgreSQL. Also, using monitoring insight, PostgreSQL database applications continuously rework the design and configuration. On reaching the limits of a single server, they break things up; connection pooling, caching, partitioning, replication, and parallel queries can all help handle increasing database workloads. By the end of this book, you will have all the knowledge you need to design, run, and manage your PostgreSQL solution while ensuring high performance and high availability What you will learn Learn best practices for scaling PostgreSQL 10 installations Discover the best hardware for developing high-performance PostgreSQL applications Benchmark your whole system - from hardware to application Learn by real examples how server parameters impact performance Discover PostgreSQL 10 features for partitioning and parallel query Monitor your server, both inside and outside the database Design and implement a good replication system on PostgreSQL 10 Who this book is for This book is designed for database administrators and PostgreSQL architects who already use or plan to exploit the features of PostgreSQL 10 to design and maintain a high-performance PostgreSQL database. A working knowledge of SQL, and some experience with PostgreSQL will be helpful in getting the most out of this book.

Mastering Akka


Author: Christian Baxter
Publisher: Packt Publishing Ltd
ISBN: 1786468832
Category: Computers
Page: 436
View: 6572
DOWNLOAD NOW »
Master the art of creating scalable, concurrent, and reactive applications using Akka About This Book This book will help you cure anemic models with domain-driven design We cover major Akka programming concepts such as concurrency, scalability, and reactivity You will learn concepts like Event Sourcing and CQRS via Akka Persistence, Akka Streams, Akka Http as well as Akka Clustering Who This Book Is For If you want to use the Lightbend platform to create highly performant reactive applications, then this book is for you. If you are a Scala developer looking for techniques to use all features of the new Akka release and want to incorporate these solutions in your current or new projects, then this book is for you. Expert Java developers who want to build scalable, concurrent, and reactive application will find this book helpful. What You Will Learn Use Akka actors to enable parallel execution Build out domain-driven design based components like entities and aggregates Respond to command requests on that aggregate root that affect the internal state Leverage Akka Persistence, protobuf and Cassandra to save the persistent state of you entities Build out complex processing graphs with the Graph Builder DSL Understand the dynamic push/pull nature of backpressure handling within Akka Streams Route HTTP requests to an actor and return a response Deploy actor instances across a set of nodes via ConductR for high availability In Detail For a programmer, writing multi-threaded applications is critical as it is important to break large tasks into smaller ones and run them simultaneously. Akka is a distributed computing toolkit that uses the abstraction of the Actor model, enabling developers to build correct, concurrent, and distributed applications using Java and Scala with ease. The book begins with a quick introduction that simplifies concurrent programming with actors. We then proceed to master all aspects of domain-driven design. We'll teach you how to scale out with Akka Remoting/Clustering. Finally, we introduce Conductr as a means to deploy to and manage microservices across a cluster. Style and approach This comprehensive, fast-paced guide is packed with several real-world use cases that will help you understand concepts, issues, and resolutions while using Akka to create highly performant, scalable, and concurrency-proof reactive applications.

Troubleshooting PostgreSQL


Author: Hans-Jürgen Schönig
Publisher: Packt Publishing Ltd
ISBN: 1783555327
Category: Computers
Page: 164
View: 6144
DOWNLOAD NOW »
If you are a database administrator looking for solutions to common PostgreSQL problems, this is the book for you. The book is suitable for people with intermediate and professional expertise.