Skip to main content

Your submission was sent successfully! Close

Thank you for signing up for our newsletter!
In these regular emails you will find the latest updates from Canonical and upcoming events where you can meet our team.Close

Thank you for contacting our team. We will be in touch shortly.Close

Integrate with a client application

This guide will show you how to integrate a client application with a cross-regional async setup using an example PostgreSQL deployment with two servers: one in Rome and one in Lisbon.

Prerequisites

Summary


Configure database endpoints

To make your database available to a client application, you must first offer and consume database endpoints.

Offer database endpoints

Offer the database endpoint on each of the postgresql applications.

juju switch rome
juju offer db1:database db1database

juju switch lisbon
juju offer db2:database db2database

Consume endpoints on client app

It is good practice to use a separate model for the client application rather than using one of the database host models.

juju add-model app
juju switch app
juju consume rome.db1database
juju consume lisbon.db2database

Internal client

If the client application is another charm, deploy them and connect them with juju integrate.

juju switch app

juju deploy postgresql-test-app
juju deploy pgbouncer --channel 1/stable

juju integrate postgresql-test-app:database pgbouncer
juju integrate pgbouncer db1database

External client

If the client application is external, they must be integrated via the data-integrator charm.

juju switch app

juju deploy data-integrator --config database-name=mydatabase
juju deploy pgbouncer pgbouncer-external --channel 1/stable

juju relate data-integrator pgbouncer-external
juju relate pgbouncer-external db1database

juju run data-integrator/leader get-credentials

Last updated 27 days ago. Help improve this document in the forum.