Beginning PostgreSQL on the Cloud (eBook)

Simplifying Database as a Service on Cloud Platforms

Baji Shaik, Avinash Vallarapu (Autoren)

eBook Download: PDF

2018 | 1st ed.
XX, 381 Seiten
Apress (Verlag)
978-1-4842-3447-1 (ISBN)

Infos

Get started with PostgreSQL on the cloud and discover the advantages, disadvantages, and limitations of the cloud services from Amazon, Rackspace, Google, and Azure. Once you have chosen your cloud service, you will focus on securing it and developing a back-up strategy for your PostgreSQL instance as part of your long-term plan. Beginning PostgreSQL on the Cloud covers other essential topics such as setting up replication and high availability; encrypting your saved cloud data; creating a connection pooler for your database; and monitoring PostgreSQL on the cloud. The book concludes by showing you how to install and configure some of the tools that will help you get started with PostgreSQL on the cloud. 

This book shows you how database as a service enables you to spread your data across multiple data centers, ensuring that it is always accessible. You'll discover that this model does not expect you to install and maintain databases yourself because the database service provider does it for you. You no longer have to worry about the scalability and high availability of your database.

What You Will Learn

• Migrate PostgreSQL to the cloud
  
• Choose the best configuration and specifications of cloud instances
  
• Set up a backup strategy that enables point-in-time recovery 
  
• Use connection pooling and load balancing on cloud environments
  
• Monitor database environments on the cloud
  

Who This Book Is For

Those who are looking to migrate to PostgreSQL on the Cloud. It will also help database administrators in setting up a cloud environment in an optimized way and help them with their day-to-day tasks.

Baji Shaik is a Database Administrator and Developer. He works as a Database Consultant at OpenSCG, Hyderabad, India. He got introduced to databases in 2011 and over the years, has worked with Oracle, PostgreSQL, and Greenplum. He holds a wide range of expertise and experience in SQL/NoSQL database technologies and has developed many successful database solutions addressing challenging business requirements. He has provided solutions using PostgreSQL for reporting, business intelligence, data warehousing, applications, and development support. He has good Knowledge of Automation, Orchestration and DevOps in a Cloud environment.

Avinash Vallarapu is a Senior Consultant at one of Postgres' Parent companies - OpenSCG. He has over 11 years of experience in various Database technologies such as Oracle, PostgreSQL, MySQL, MariaDB, MongoDB and is an avid Python Developer. He has coded tools for PostgreSQL for High Availability in Windows Environments. His expertise is on Migrations of Oracle to PostgreSQL and Cloud deployments of PostgreSQL. He holds vast experience in performing Architectural Health Checks of PostgreSQL environments for customers across the globe.

Autor

Baji Shaik is a database administrator and developer. He was introduced to databases in 2011 and over the years, has worked with Oracle, PostgreSQL, and Greenplum. He has a wide range of expertise and experience in SQL/NoSQL databases and has developed many successful database solutions addressing challenging business requirements. He has been working with a database service, where he continuously supports databases in automation and helps in developing features, fixing and testing defects of the service. Baji has organized a number of PostgreSQL meet-ups and maintains his own technical blog at bajis-postgres.blogspot.in, where he likes to share his knowledge with the community. He co-authored PostgreSQL Development Essentials, released in September 2016.

Inhalt

Chapter 1: Introduction to Database on the Cloud Chapter 2: PostgreSQL Architecture Chapter 3:  Amazon Cloud Chapter 4: Rackspace Cloud Chapter 5: Google Cloud Chapter 6: Azure Cloud Chapter 7: Security on the  Cloud Chapter 8:  Backups on the Cloud Chapter 9:  Replication and High Availability on The Cloud Chapter 10: Encryption on the Cloud Chapter 11: Connection Pooling on the Cloud Chapter 12:  Monitoring Cloud Databases

Produkt-Details

• Erscheint lt. Verlag: 19.3.2018
• Zusatzinfo: XX, 381 p. 288 illus.
• Verlagsort: Berkeley
• Sprache: englisch
• Themenwelt: Mathematik / Informatik ► Informatik ► Datenbanken
• Themenwelt: Mathematik / Informatik ► Informatik ► Programmiersprachen / -werkzeuge
• Themenwelt: Informatik ► Theorie / Studium ► Compilerbau
• Schlagworte: amazoncloud • Azure • Cloud • Database • DBaas • Deployment • googlecloud • IaaS • Maintenance • Migration • PostgreSQL • rackspace
• ISBN-10: 1-4842-3447-2 / 1484234472
• ISBN-13: 978-1-4842-3447-1 / 9781484234471