…guaranteed to be applied – what is guaranteed is that every node will do exactly the same thing with… to several nodes As you may see, I am pretty excited that this solution is available …for incremental node provisioning. By this I mean that if right now a node gets disconnected from the cluster…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
…in such setup you need to understand what to do with it if any other …handle most of our read traffic right ? Sure. Unless you’re using … allows use of efficient caching. Now lets look at the simplified case …code or something unpredicted. Summary: So am I denying all MySQL industry practices (…
Post: MySQL Sizing questions
June 23, 2006 By 4 Comments
…details, load distribution, what exactly application is doing and a lot of…wrong estimates than no estimates. Now than these estimates turn …no it is not. So am I saying we do not need any sizing…right but it still should be treated as a guess, making sure there is not catastrophy if you are wrong. I…
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
… fatal if one is careless. ; ) However, I am not writing this to share any …it right…the zen of grammar writing is a topic for another day). Doing this… and are just trying to see what shakes out under a certain type …s efficient test organization, we are now able to quickly produce complicated test…
Comment: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 16, 2009 By 16 Comments
… practice but I think for demonstration purposes it is a good choice. I do not …Am I reading it correctly? Also are you planning to make a sources available I think it would be really helpful right now I‘m not sure I understand completely what …
Comment: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
June 19, 2012 By 8 Comments
What if you wanted the Insert to happen but with the next auto-inc number. I have a situation where I…tries to insert records into the same table. Right now I am getting duplicate key records. Will the only way… Or is there another way. I dont want to do Insert ignore because I want the row inserted, …
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… is not actually buying us anything. Now bumping this up to 2GB actually… the past couple of months I have been doing a ton of work for… enough right? My two tables each contain 5M rows of data. let’s see what … memcached needs repeatability to be helpful. I am still getting a really solid # of …
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 2
October 16, 2009 By 8 Comments
…boost from the application. Now we are going to look at what we could achieve if …right here. It stands to reason that memcached should be faster for this application then the DB. Its just doing… is key to picking an appropriate solution. I am going to look at several database alternatives …
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
… Pool. You are right that I should consider the cost….999%. Cluster supports replication now. @Domas: Yes, I might be underestimating…about a single database/application. I am guessing from the figures…I have worked with NDB having 24 ndbd nodes handling insanely huge loads. 2.8 What the point here, do…
Post: Is VoltDB really as scalable as they claim?
February 28, 2011 By 3 Comments
…I published some time ago. Let’s go right to the results and then I… k-factors: 0, 1, 2.) Now, for the recommended degree of…software and services. I am not a VoltDB expert. I have some … level of detail that I would do if this were a…answering my own question: from what I know of VoltDB it does…
