What it means to be a Postgres extension • Hacker News Board

Re: What it means to be a Postgres extension

#31

Post by siscia » Mon, Nov 06, 2017, 4:04 PM UTC

manigandham wrote: post #30

siscia wrote: post #4

Since we are talking about postgres, please let me go a little OT Is there any interests in a RDS as a Service? So basically setting up and running a completely fault aware postgres cluster in any infrastructure, either public or private?

What seems to be missing in the market is the ability to only pay for the setup and maintenance operations, but use my own existing cloud account and resources instead of running multi-tenant or in some other company's cloud account. Basically as if I hired a contractor to install, monitor and upgrade, but automated. Existing services charge too much since they resell VMs and storage, while also being less flexible w…

Exactly!

Ideally, I would just need an SSH key inside your machines and the capabilities to open an ssh tunnel inside the firewall to scrape metrics.

Ideally, the metric should get exposed back to the customer.

I am not a big fan of containers when working with data that are irreplaceable. But the use k8s may really help.

Re: What it means to be a Postgres extension

#32

Post by manigandham » Mon, Nov 06, 2017, 4:26 PM UTC

no1youknowz wrote: post #12

siscia wrote: post #4

Since we are talking about postgres, please let me go a little OT Is there any interests in a RDS as a Service? So basically setting up and running a completely fault aware postgres cluster in any infrastructure, either public or private?

Out of interest, could you support MySQL? Or more specifically MemSQL?

MySQL and MemSQL are very different, are you looking for a data warehouse specifically?

They are closed-source and require enterprise licensing based on RAM quota so it's not simple to do automated cloud provisioning. They do have their own MemSQL cloud offering so you might inquire into that. Also MemSQL Ops is probably the easiest and most reliable operations software for any database, it just takes a few clicks to install and upgrade your cluster.

Re: What it means to be a Postgres extension

#33

Post by manigandham » Mon, Nov 06, 2017, 4:28 PM UTC

siscia wrote: post #31

manigandham wrote: post #30

Earlier quoted context omitted.

What seems to be missing in the market is the ability to only pay for the setup and maintenance operations, but use my own existing cloud account and resources instead of running multi-tenant or in some other company's cloud account. Basically as if I hired a contractor to install, monitor and upgrade, but automated. Existing services charge too much since they resell VMs and storage, while also being less flexible w…

Exactly! Ideally, I would just need an SSH key inside your machines and the capabilities to open an ssh tunnel inside the firewall to scrape metrics. Ideally, the metric should get exposed back to the customer. I am not a big fan of containers when working with data that are irreplaceable. But the use k8s may really help.

We would be interested, along with other datastores like ElasticSearch, Redis, etc.

AWS, Azure and Google all have various resource organization systems now so that the environment can be isolated but still within our overall account. We run on Google and it would be nice to have a separate project for managed databases while taking advantage of our existing billing arrangements and private network.

Re: What it means to be a Postgres extension

#34

Post by siscia » Mon, Nov 06, 2017, 4:31 PM UTC

manigandham wrote: post #33

siscia wrote: post #31

Earlier quoted context omitted.

Exactly! Ideally, I would just need an SSH key inside your machines and the capabilities to open an ssh tunnel inside the firewall to scrape metrics. Ideally, the metric should get exposed back to the customer. I am not a big fan of containers when working with data that are irreplaceable. But the use k8s may really help.

We would be interested, along with other datastores like ElasticSearch, Redis, etc. AWS, Azure and Google all have various resource organization systems now so that the environment can be isolated but still within our overall account. We run on Google and it would be nice to have a separate project for managed databases while taking advantage of our existing billing arrangements and private network.

I will make sure to keep you updated :-)

Re: What it means to be a Postgres extension

#35

Post by riku_iki » Tue, Nov 07, 2017, 1:41 AM UTC

mosselman wrote: post #10

Can anyone shed some light on how the supposed new cluster features of Postgres 10 compare to something like Citus? In other words. Does Postgres 10 offer the same features in terms of clustering as Citus does?

Citus provides ability to build sharded environment.

Data for different customers can be stored on separate nodes, and your DB is not limited by capacity of one node.

In regular PG, all data need to fit single node.