Re: [Spock Proxy Devel] building & running problems

[Frank F. <fr...@co...>]

On Nov 10, 2009, at 7:02 AM, Pavel Gushcha wrote:

> But as i understand, it is not thread-safe (if some spockproxy  
> intances work simulateniously with meta database).
>
> Some missing basic feautures/things, about i thinked:
> 1) After looking at logs, i see that spockproxy opens 50 connections  
> to meta database, this too many (for shards this is ok)
> 2) I can't specify port for meta database

You can do this in the config file or on the command line I believe (I  
only use the 3306 port so I'm not sure)

> So, i have following questions:
> 1) Do you plan to release in nearly future next version of  
> spockproxy (may be with fixes for compilation process)?

I don't think we have a new version planned anytime soon.

> 2) get_next_id() function is not present in sample medatbase dump,  
> so is good idea to add it, can you give me code for it?

It is much like you wrote - but we have added locks to make is thread  
safe.  But remember that since the proxy will request many next id's  
at a time it is unlikely that threads would collide (the proxy will  
ensure this because it hands out the id's)

> 3) Spockproxy support failover for high availability? I plan to have  
> 2 servers for each shard with master-master replication.

You have to make your own failover - but this is also much easier than  
you might think.  Once configured the Spockproxy only takes a second  
to restart even for the biggest, busiest DB's.  For HA the same proxy  
can be told to connect to a different master but currently you will  
have to restart the proxy.

> 4) Can i contribute code for spockproxy (patches for compilation,  
> etc)?

Yes - because of some changes at Spock we have not been working on our  
proxy very much lately.

Frank