DEV Community: ScaleChamp

Connect to ScaleChamp Managed PostgreSQL with SQLAlchemy

Mike Faraponov — Sat, 10 Oct 2020 12:19:47 +0000

Create database instance in Control Panel:

Select service, cloud, region:
Select plan:
Wait until instance will be in RUNNING state:
Then connect to it from your python application:

from sqlalchemy import create_engine

conn_args = {
    "sslmode": "verify-full",
    "sslrootcert": "<path to your ca.pem downloaded from UI>",
}

engine = create_engine("postgresql://<user>:<password>@<hostname>:5432/ssndb", connect_args=conn_args)

conn = engine.connect()

To make sure no one can gain access to your database accept allowlisted IPs checkout firewalls section.
Voa'la. See you at ScaleChamp

Failover Proxy

Mike Faraponov — Tue, 29 Sep 2020 19:39:39 +0000

In case you ever think about failover proxy solution to migrate database from one server to another, consider failover proxy script, no need for HA Proxy at least for TCP based services:

#!/bin/bash

iptables -t nat -A PREROUTING -p tcp --dport $PORT -j DNAT --to-destination $TARGET:$PORT
iptables -t nat -A POSTROUTING -j MASQUERADE

We at ScaleChamp utilising Failover Proxy to reduce downtime until DNS propagates to new master server.

While this solution do not provide session support and may require some retries for transactions on application level, it's still a simple and universal solution for many use cases.

P.S.
Do not forget to enable ip forwarding via sysctl. Also in order to archive atomical iptables update consider ip namespaces (netns).

ScaleChamp Redis Maxmemory-policy

Mike Faraponov — Sun, 19 Jul 2020 12:13:26 +0000

Happy to announce that ScaleChamp Redis/KeyDB/KeyDB PRO now support maxmemory-policy modification via Control Panel

More at https://www.scalechamp.com/changelog/

ScaleChamp Changelog

Mike Faraponov — Fri, 17 Jul 2020 16:48:16 +0000

We happy to announce that we published our first changelog announcements at Changelog Page

ScaleChamp now available under DigitalOcean tools.

ScaleChamp

Mike Faraponov — Thu, 09 Jul 2020 20:38:38 +0000

Just want you to know that there is a ScaleChamp Managed Databases available.

ScaleChamp is a multi-cloud victorious managed databases provided with support of PostgreSQL, MySQL, KeyDB, KeyDB PRO and many more choices.

Just select a service, cloud (from 11 available), region/AZ and choose preferred configuration and you are ready to go!

// Detect dark theme var iframe = document.getElementById('tweet-1282663571571314688-143'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1282663571571314688&theme=dark" }