Tips

Deploy multi-node cluster using HAProxy load balancer

Deploy a secure multi-node CockroachDB cluster on multiple machines, using HAProxy load balancers to distribute client traffic.

https://www.cockroachlabs.com/docs/stable/deploy-cockroachdb-on-premises.html

Adapting SQLAlchemy to CockroachDB

CockroachDB is similar enough to PostgreSQL that SQLAlchemy’s built-in PostgreSQL dialect gets us most of the way there, but we still need a few tweaks that can be found in our cockroachdb python package.

https://www.cockroachlabs.com/blog/building-application-cockroachdb-sqlalchemy-2/

https://www.cockroachlabs.com/docs/stable/build-a-python-app-with-cockroachdb-sqlalchemy.html

SqlAlchemy Best Practice

https://www.cockroachlabs.com/docs/stable/build-a-python-app-with-cockroachdb-sqlalchemy.html#best-practices