Long time readers of this blog will assert that I have no problem presenting an unpopular opinion, and/or sticking my foot in my mouth. Some times both at once! (“But wait… there’s more!”) So when N. Shah asks me how he should split his database (a tags table, items table, and users table) I say: [...]
If there’s one thing that the OpenFount guys have shown me is that they’re serious about the Infinidisk product. Mr. Donahue gave me a quick call this evening (seems my e-mail server and his e-mail server aren’t talking properly, so while I get his communications) he has not received mine (probably explaining the lack of [...]
I’m really very impressed with the speed at which the Openfount guys responded to my last post. I definitely give Kudos to Bill for being on top of things! I’m running out the door so I’ll keep this short and sweet. He’s right, I did generalize databases into InnoDB, but thats because it’s what I [...]
I mentioned a while back that I was going to be playing with the S3 Infinidisk Product. What I found in my testing was that this product is not prime time ready. There was a nasty bug which caused data to be lost if the mv command was used. The scripts themselves were unintuitive. They [...]
We all new that this would happen, google and microsoft going vying to build the biggest field of silicon trees. But what does this mean, and does it tie in with amazons latest service?! I think that undoubtedly it does. There’s talk about a last man standing game when it comes to internet bandwidth. And [...]
I’ve been kind of floating around this topic for a while… Well databases in general… And I see a lot of people who have rather high standards (which is not a bad thing.) I imagine the complication of offering a service like this comes from the fact that database people have very stringent standards. Things [...]
Imagine for a moment, if you will, making your MySQL queries via a REST API. Weird, huh? I’ll admit its a crazy idea, but then a lot of my ideas are crazy. Still. Work with me here. Query –> || REST API || The query is a select Rest API synchronously determines both which servers [...]
you could use the mysql binary logs, stored on an infinidisk, to accomplish much the same thing, however, the fact that the pgsql WAL’s are copied automatically by the database server, and no nasty hacks are needed makes PostgreSQL a much cleaner first choice IMHO. However I’ve of course not tested this… yet..
I have written mostly about MySQL here in the past. The reason for this is simple: MySQL is what I know. I have always been a die hard “everything in its place and a place for everything” fanatic. I’ll bash Microsoft with the best of them, but I still recognize their place in the market. [...]
http://www.openfount.com/blog/s3infidisk-for-ec2 This certainly looks very interesting! I cant help but wonder if the memory caching in the neterprise version is enough to run small MySQL instances on? At the very least being able to MySQLdump regularly to a file directly on S3 would be useful as opposed to mysqldump to a file, split it into [...]