DocsGetting StartedStandalone

Standalone Crystal DBA deployment

The standalone deployment model is the easiest way to get started with Crystal DBA. It is suitable for individual developers, or anyone who wants to try Crystal DBA as quickly as possible.

Since standalone Crystal DBA runs on systems you control, its security model is the simplest to understand.

Architecture

In the standalone deployment model, Crystal DBA runs on a server such as a laptop or a development environment. If you can connect to your database using a PostgreSQL client such as the psql interactive terminal or the pgAdmin tool, then Crystal DBA will be able to connect.

The architecture is shown in the diagram below.

Standalone architecture diagram showing Crystal DBA running on a laptop or dev environment connecting to a PostgreSQL database running in a dev, staging, or production environment using a connection on port 5432, which is the standard port for the PostgreSQL wire protocol.

We recommend using a machine equipped with a GPU when running Crystal DBA in the standalone deployment model. Most modern laptops have an adequate GPU, and the performance will be much better than running Crystal DBA on a CPU.

You should make sure you understand how the connection between Crystal DBA and your database is encrypted and secured. You might rely on the security of your VPC, use PostgreSQL’s SSL/TLS encryption, or deploy ssh port forwarding/tunneling to securely connect to your database.

Please see the open source Crystal DBA documentation for detailed instructions for standalone Crystal DBA installation.