Erlang Mailing Lists

Author Message

<  Erlyweb mailing list  ~  replication?

Guest
Posted: Mon Sep 01, 2008 9:46 pm Reply with quote
Guest
The backend of my project is very read-heavy and in it's current
implementation (Rails), we have been very successful with using
replication. To achieve this we keep a mysql connection manager object
that checks if a given statement is a write or a read and switches
between the master and the replicated slave as needed. Has anyone done
something like this with erlydb? If so, how?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "erlyweb" group.
To post to this group, send email to erlyweb@googlegroups.com
To unsubscribe from this group, send email to erlyweb+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/erlyweb?hl=en
-~----------~----~----~----~------~----~------~--~---

Post received from mailinglist
Guest
Posted: Mon Sep 01, 2008 11:00 pm Reply with quote
Guest
Do you only read from the slave or round robin reads between master
and slave? I don't know of such setup used with ErlyDB but it would be
pretty cool to implement it. At code generation time, you could tell
ErlyDB which db pools to use for reading and which for writing and
ErlyDB would make the generated functions use the different pools
depending on their functions.

Yariv

On Mon, Sep 1, 2008 at 2:46 PM, 5hundy <dweldon@gmail.com> wrote:
>
> The backend of my project is very read-heavy and in it's current
> implementation (Rails), we have been very successful with using
> replication. To achieve this we keep a mysql connection manager object
> that checks if a given statement is a write or a read and switches
> between the master and the replicated slave as needed. Has anyone done
> something like this with erlydb? If so, how?
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "erlyweb" group.
To post to this group, send email to erlyweb@googlegroups.com
To unsubscribe from this group, send email to erlyweb+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/erlyweb?hl=en
-~----------~----~----~----~------~----~------~--~---

Post received from mailinglist
Guest
Posted: Mon Sep 01, 2008 11:41 pm Reply with quote
Guest
We currently perform all reads from the local slave. Your suggestion
sounds excellent - I'm really new to erlyweb so any more specific
instructions would be greatly appreciated. I haven't tried using more
than one DB connection yet - still working on the basics of the
application.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "erlyweb" group.
To post to this group, send email to erlyweb@googlegroups.com
To unsubscribe from this group, send email to erlyweb+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/erlyweb?hl=en
-~----------~----~----~----~------~----~------~--~---

Post received from mailinglist

Display posts from previous:  

All times are GMT
Page 1 of 1
This forum is locked: you cannot post, reply to, or edit topics.

Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum