Reputation
459
Top tag
Next privilege 500 Rep.
Access review queues
Badges
3 17
Newest
 Explainer
Impact
~82k people reached

Jul
7
awarded  Explainer
May
13
asked weird auto inc generating id in mysql
Jan
12
asked mongoexport on 2.0.4
Jan
7
comment Any recommendation on my.cnf on aws.large instance?
how about innodb_buffer_pool_instances? This is new in 5.6 onwards. Do we get some real benifits out of it?
Jan
7
asked Any recommendation on my.cnf on aws.large instance?
Jan
3
revised Mysql Percona 5.6 slave lags gradually
fixed
Jan
3
revised Mysql Percona 5.6 slave lags gradually
new update
Jan
3
asked Mysql Percona 5.6 slave lags gradually
Jan
2
awarded  Yearling
Jan
2
accepted Dropping multiple KEYS of a table
Jan
2
comment Dropping multiple KEYS of a table
innodb. I'm going for pt-osc multiple drop together.
Jan
2
comment Dropping multiple KEYS of a table
What will happen to new operations to the table? Where will new records gets stored at the time of copying? Would it take table lock or metadata lock ?
Jan
2
asked Dropping multiple KEYS of a table
Dec
31
comment OOM in mysql-percona
tried with Buffer_pool_size with 180G. I will update after a week.
Dec
31
revised OOM in mysql-percona
added 84 characters in body
Dec
31
asked OOM in mysql-percona
Dec
28
comment What are the optimal mysqldump settings?
Read each arguments and its benefits and choose which would suite you. Also get to know scripting to trigger incase of failures.
Nov
13
comment Mongo Replication with VIP
So the drivers here are application drivers should be written in such a way. @mongo_client = MongoReplicaSetClient.new( ['n1.mydb.net:27017', 'n2.mydb.net:27017', 'n3.mydb.net:27017'] ).db("test").collection("sample") To choose its member. I'm I right?
Nov
2
comment Mongo Replication with VIP
Note: It will open write on secondary, doesn't mean that it will route the requests from application to secondary(NewMaster).
Oct
31
comment Mongo Replication with VIP
I do understand that it is for voting purpose. But when it can decide who should be available for writes and who shouldn't be, I would like to embed a logic that should also route application requests to the winner. Also I don't want to keep the host decision on app end. Kinda doesn't look clean for me.