I set up my postgresql database, master for write, the other for read using
the following:
DB=Sequel.postgres('postgres://master_server/database',
:servers=>{:read_only=>{:host=>'slave_server'}})
now when i execute sqls within a transaction, it didn't behave correct.
DB.transaction do
DB["update XX set age = 22 where id = 3"].update
DB["select age from XX where id = 3"].first
end
the second sql didn't return age: 22, So i guess the update sql and select
sql been executed on different databases, like update on master and query
on slave, is it possible?
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
