Command Prompt, Inc.: Navigating PostgreSQL Deployments in the Cloud

As Amazon’s EC2, RDS, and Aurora gain more traction, organizations migrating to the cloud continue to eliminate the role of DBAs. “Many fail to realize that migrating to the cloud does not eliminate the need for a DBA. It only removes the need for on-premises staff to manage hardware and network infrastructure,” says Joshua D. Drake, Lead Consultant and President of Command Prompt, Inc. (CMD). In such a scenario, CMD — the oldest and most experienced PostgreSQL support provider in North America — notes lack of pre-planning and insufficient architecture as the primary reasoning behind performance and optimization issues with cloud adoption. In an effort to eliminate these issues, CMD focuses on delivering full stack support, consulting, and development. Their goal is to assist organizations with effective cloud management and migrations through PostgreSQL — the world’s most advanced open source database.

Drake points out that while there is a sense of security in having an on-premises facility, the majority of security breaches are caused internally. Countering the biggest challenge around AWS migration for clients with legacy infrastructure, CMD takes a hybrid approach by first providing an architectural review, followed by support for on-premises infrastructure and AWS-based cloud infrastructure. A project plan is put together to move clients fully into the cloud and address such common fears as multi-tenancy by encrypting sensitive data before and during the sending of data through functions provided by PostgreSQL.

Leveraging product as a service model, the company provides comprehensive services such as auto-discovery and auto alerts for server data without externally setting up monitoring services. The company is also building tools around simplified cloud data mining and migration services for better resource allocation and availability, catering to the increased cloud adoption.