More than one database?

[stlyz3]

With Bedrock, can a server run more than one database or just one? Use case is that we have a few small applications, for now in terms of size, and would usually throw the databases and the same MySQL or Postgresql instance. Is this scenario possible?

Just trying to decide if the six node setup good for one database or more than one.

Thanks
Willie Pritchett

[David Barrett]

Unfortunately Bedrock uses a single database to store all tables.  But out of curiosity, what is the advantage of having separate databases when hosted on the same hardware -- is it just to avoid table name collisions?

-david

Founder and CEO of Expensify (and BedrockDB)

--
You received this message because you are subscribed to the Google Groups "Bedrock" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bedrock+unsubscribe@googlegroups.com.
To post to this group, send email to bed...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/bedrock/067e2e18-56b5-474b-a789-66acf8b409d7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[stlyz3]

Mostly to avoid the table collisions and for security reasons.  Lets say we have an app that is for a helpdesk, one that is used for online ordering of products, and one that is used for patient profiles.  In this scenario, usually we would use 3 separate databases and DBAs or Developers that need access to that particular database gets explicit access.  In the case of each being an MVP, I wouldnt want to build out a complete cluster for each of the applications, individually, because they are MVPs.  

So was just trying to see if its best to start off with something like Postgres and then move to Bedrock once the apps gain traction?

On Sunday, October 29, 2017 at 4:09:14 PM UTC-4, David Barrett wrote:

Unfortunately Bedrock uses a single database to store all tables.  But out of curiosity, what is the advantage of having separate databases when hosted on the same hardware -- is it just to avoid table name collisions?

-david

Founder and CEO of Expensify (and BedrockDB)

On Sun, Oct 29, 2017 at 11:52 AM, stlyz3 <stl...@gmail.com> wrote:

With Bedrock, can a server run more than one database or just one?  Use case is that we have a few small applications, for now in terms of size, and would usually throw the databases and the same MySQL or Postgresql instance.  Is this scenario possible?

Just trying to decide if the six node setup good for one database or more than one.

Thanks
Willie Pritchett

--
You received this message because you are subscribed to the Google Groups "Bedrock" group.

To unsubscribe from this group and stop receiving emails from it, send an email to bedrock+u...@googlegroups.com.

[David Barrett]

Hm, well if you're just doing some early development and not running a production service, I recommend simply running a single-node cluster for each -- that'll provide total isolation.  However, Bedrock doesn't support the notion of multiple database files (with their own table namespaces) in a single cluster.

-david

To unsubscribe from this group and stop receiving emails from it, send an email to bedrock+unsubscribe@googlegroups.com.

To post to this group, send email to bed...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/bedrock/119aa030-3fbc-4585-89a8-ed754f48b77c%40googlegroups.com.

[Subhash Kalluri]

Guys, I would appreciate if you can make this conversation private, instead of CC’ing everyone in the group.

S

Subhash Kalluri

skype id: kalluri547

+91-9963754460

To view this discussion on the web visit https://groups.google.com/d/msgid/bedrock/CACrtYUq_Jjp%2BSesr9W%3DUfAuwnJJJ7862Htatgr0QNaEJok7wmg%40mail.gmail.com.

[David Barrett]

Hm, this is a mailing list about the Bedrock database, and I think it's fair game to discuss how best to use it and how it differs from other databases.  Sorry for filling your inbox, but if this isn't the topic you're interest in I suggest you unsubscribe.  Apologies for the inconvenience!

-david