On Dec 6, 11:51 pm, Andrew Stromnov <[EMAIL PROTECTED]> wrote: > I have DB with onemasterserver and several replicated slaves > (MySQL). How to implement this functionality: read-only request can be > passed to any DB (masterorslave), but any write request with > following read requests must be sended tomasteronly (to avoid > synchronization lag).
This is an example of vertical partitioning. I am trying to find out how to implement this with SA too. Quite an offen-used scheme. Strange that no one has replied this thread yet. SA even has support for sharding (which is more complex than vertical partitioning IMHO) so there certainly should be the way for 1-master-N- slaves scheme. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---