Deploy to fly.io and get horizontal scalability of DB and middle tier. An alternative from google cloud run and cloud db

[gedw99]

googles cloud SQL does not give you horizontal scalability. You need to use Spanner for that and its a different API.

Fly.io does. I have been using it but not tried it with graphjin as i just don't have time, but i wanted to raise it here.

https://fly.io/docs/about/pricing/#postgresql-clusters

https://fly.io/blog/free-postgres/

https://fly.io/blog/globally-distributed-postgres/

The db is globally distributed with read only in other locations. It does an interesting approach that will work with graphql nicely i think.

It also load balances so if a region dies everything keeps going.

Its also much cheaper than google.

CLi: https://fly.io/docs/flyctl/

brew upgrade flyctl
Running `brew update --preinstall`...
==> Auto-updated Homebrew!
Updated 1 tap (homebrew/core).
==> Updated Formulae
Updated 1 formula.

Warning: superfly/tap/flyctl 0.0.297 already installed
➜  ~ flyctl apps list
NAME                	OWNER   	STATUS 	LATEST DEPLOY
gedw99-image-service	personal	running	2021-10-13T11:13:31Z

➜  ~ flyctl status -a gedw99-image-service
App
  Name     = gedw99-image-service
  Owner    = personal
  Version  = 17
  Status   = running
  Hostname = gedw99-image-service.fly.dev

Instances
ID      	PROCESS	VERSION	REGION	DESIRED	STATUS 	HEALTH CHECKS     	RESTARTS	CREATED
d207b92b	app    	17     	fra   	run    	running	1 total, 1 passing	0       	2021-10-13T15:34:46Z

you can run your middle tier instances similar to cloudrun and have control over scale up and down.

anyways, see what you think

[dosco]

I love what fly.io is doing and was thinking of deploying the GraphJin website and a demo on their free tier. While not a full cloud if you're looking for horizontal scalability checkout yugabyte.com they have a free tier as well. Maybe I'll run two demos on both these platforms. Another new entrant is planetscale.com which can host the MySQL demo.

[dosco]

If you do plan to try it I'd love to hear about it.

[gedw99]

It’s on my todo / bucket list.

fly.io just started offering scale to zero btw. Like google cloud run.

[gedw99]

Btw thanks for all the other hosting options.

[dosco]

Also I'm redoing the whole documentation site so we could have a nice list of deployment options.

[gedw99]

I found this fly setup to work well and be very developer friendly: https://github.com/bots-garden/capsule-on-fly-dot-io

The speed is really good...

Maybe make a "graphjin-deploy" repo and similar code for now, just to get going ?
The multi region scaling and ease of use is really nice.