On Wednesday, September 24, 2014 9:02:47 PM UTC-7, henry beh wrote:
>
> Hi Jeremy Evans,
> Thank for quick response.
>
> This is my setting, where can i configure my another master database?
> DB=Sequel.connect(:adapter=>'mysql2', :host=>'127.0.0.1',
> :database=>'databaseName', :user=>'root', :password=>'password',
> :max_connections => 30,
> :logger => Logger.new('sequel-log.txt'),
> :servers=>{ :default=>proc{|db| {:host=>db.get_master_host}}
> })
>
> def DB.get_master_host
> @current_master_host ||= -1
> "master_server#{(@current_master_host+=1)%4}"
> end
>
>
First, just so you understand, you should only be using the sharding
support if all servers you are connecting to have the same schema (i.e.
master/slave or partitioned setups only). If these are two separate
databases with different tables, then you want to create two separate
Sequel::Database objects (i.e. call Sequel.connect twice).
Assuming you did want to use sharding, what you have looks OK, in that
Sequel will rotate connection to the four separate master servers.
However, this assumes you have a multi-master database configuration for
MySQL, is that the case?
Jeremy
--
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 http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
