Can I configure shards dynamically? Meaning a new customer signs up, and I create the database from a known schema, then immediately connect to it? Without restarting to update the servers Hash?
Thanks! -- François Beausoleil http://github.com/francois Le mercredi 15 juin 2011 à 11:45, Jeremy Evans a écrit : > On Jun 15, 8:06 am, François Beausoleil > <[email protected] (http://gmail.com)> wrote: > > Hi all! > > > > I'm thinking of building a multi-tenant SaaS application, with one > > database per tenant. In the global config, I'll store the a Sequel > > connection string for each tenant, thus when a request comes in, I'll > > have to establish a connection. Two questions immediately popped up: > > > > * Will Sequel cache connections per connection string by default, or > > should I implement that myself; > > * How will my Sequel models behave? Can I even use models? > > > > I don't anticipate millions of users: I'm aiming for 500-1000 tenants, > > each with one to 5 simultaneous users. > > > > Any ideas / pointers appreciated. > > You can use the sharding support to do this, assuming the same schema > is used in all databases: > http://sequel.rubyforge.org/rdoc/files/doc/sharding_rdoc.html > > Jeremy > > -- > You received this message because you are subscribed to the Google Groups > "sequel-talk" group. > To post to this group, send email to [email protected] > (mailto:[email protected]). > To unsubscribe from this group, send email to > [email protected] > (mailto:[email protected]). > For more options, visit this group at > http://groups.google.com/group/sequel-talk?hl=en. -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
