Cloud Computing Blog - AWS Questions and Answers

Pretty URL with Short IDs with CouchBase

2012-10-31T15:21:00.001-07:00

Another question regarding CouchBase. From my understanding, when you add a new document with the 'ADD' command, if the document has a key which already presence in the bucket, the insertion will fail. This can be useful because I don't want to use GUID for some of my documents because they result in very long URLs, so with that enforcement, you can actually create a ID generator that will

Gibrish when inserting non-English string into CouchBase JSON document

2012-10-31T12:33:00.001-07:00

When I put a non-English characters values as string into CouchBase I get gibrish: "name": " ״§„ˆ״±״© …״×״±״¬… †״µˆ״µ …״¬״§† ״¥„‰ ", Part of the ASP.NET code: ... name = " الفورية مترجم نصوص مجاني إلى ", ... client.StoreJson(StoreMode.Add, "2", box); So what I am trying to solve now is how to put UTF-8 non-English characters into a JSON format document into

CouchBase 2.0 beta - Binary instead of JSON when storing data in ASP.NET [SOLVED]

2012-10-31T00:35:00.002-07:00

Right now I am working with CouchBase and ASP.NET. CouchBase in my opinion is one of the best NoSQL solutions out there, and I've checked quite a few. The problem is that getting answers to questions is very hard, the forum has very little movement there, and even asking questions on stackoverflow doesn't yield fast answers. Still, I prefer CouchBase over MongoDB for many reasons. Now for my

Grantia data vs redis cloud - Question Raised?

2012-10-27T08:27:00.001-07:00

I am looking into Grantia Data hosted Redis solution. However, I've searched the web and found a website that looks almost identical to the first one. Take a look and tell me what you think? redis-cloud.com grantia-data.com Answer: 1. redis-cloud.com - is used for our Redis service 2. garantiadata.com/memcached - is used for our Memcached service 3. garantiadata.com - is used for

Cassandra.io, Hosted Cassandra up to 10TB data Storage!

2012-10-26T22:35:00.002-07:00

If you are searching for a scalalbe Cassandra hosted solution, you should probably take a look at the only hosted solution out there, cassandra.io. I am personally very interested in what cassandra.io has to offer, although I am also checking on implementing Cassandra myself on Amazon AWS. The great thing about Cassandra.io is that you have a free package which you can use, which is kind of

OrientDB - Auto Sharding coming soon?

2012-10-26T16:16:00.001-07:00

On my quest to find an affordable way to scale database in the cloud, I find out about OrientDB. It seems like a super flexible DB NoSQL solution with ACID transactions, fast indexes, native SQL queries and much more. The best thing about it is that its free! What I still think is missing is auto sharding feature. I've read on their forums (Google group) that they are working on it and it

Windows as Tabs on a single Window - WindowsTabs great for developers

2012-10-23T11:28:00.000-07:00

I am currently working with MongoDB and Python. The problem is that I am watching a webinar and I have to work with several command prompt windows and that's a mass to switch and arrange several windows on the screen of my laptop computer. I've find out a great software called windowstabs, which enables you to group several windows under one windows and show each window as a tab, like it when

DIY Sharding solution with Amazon RDS and DynamoDB

2012-10-20T10:47:00.001-07:00

I want to share with you a sharding strategy that I am working on. I want to be able to solve the sharding problem myself. I know that there are a lot of things to be taken care off, but I was building this strategy specific for my application. My goal is to be able to use Amazon RDS, be able to add servers on the fly, insert are round-robin and with kind of friendly URLs as numbers.

MySQL BigInt ID Generation and Friendly URLs

2012-10-20T06:21:00.000-07:00

On my quest to find the best way to generate a numerical BigInt id for my MySQL primary key rows for some of my tables. I don't want to rely on the internal clock. I DO care about how the URL of my site will look like look and I don't want to put GUID in the URL. Let's assume that I have the following tables: - BOXES - ITEMS - USERS Each user can have several boxes. Each box can have

Choosing Primary Key for Sharded MySQL Configuration

2012-10-20T04:53:00.002-07:00

One of the problem that I'm facing with MySQL is choosing the primary key for a few of my tables. I know that this key will be used in the URL so when Google crawls the website it will fetch that specific page with the id in the URL. This means that I should give a good attention to what type of primary key to use. The easiest solution is to use AI Auto-Increment BigInt, but that doesn't goes

Scaling MySQL by using Spider MySQL engine

2012-10-20T04:44:00.002-07:00

Right now I'm checking Spider for MySQL, a MySQL engine that allows you to horizontally scale your MySQL. What Spider for MySQL does is makes the client see the databases in the cluster as if it was a single database. I wrote a question on stackoverflow to hear what people thing about it, if it's a good solution that helps solve some of the scalability issues that you might encounter when using

PHPMyAdmin alternative for Windows Software for MySQL and MSSQL

2012-10-20T04:41:00.000-07:00

If you are looking for a PHPMyAdmin alternative that works locally on your computer and can connect to remote MySQL server, you should try out HeidiSQL. This is a Windows based interface for managing both MySQL and Microsoft SQL database. It's simple to use and very intuitive. Just launch the software, enter the connection details (ie. password, username, host) and you can now manage your remote

How Pinterest Solved it's Database Scalability issues

2012-10-19T04:47:00.001-07:00

For those of you who are interested to know how Pinterest solved its DB scaling issues you can watch the video below. I've been interested to know how Pinterest was able to cope with such a high volume of data growth and requests. This video really helped me understand many things. JOINS ARE EVIL, and I intended to use MySQL with Join, but until I've seen this video. Joins just don't scale, no

Calpont InfiniDB 3 Looks promising - Easy Scalability on AWS?

2012-10-18T06:37:00.003-07:00

I have decided to use MySQL for my new project, taking into consideration that when I need to scale out, there are some middleware solutions out there like dbshards and scalebase that can solve my MySQL scalability problems. However, one of my blog visitors told me about another solution called InfiniDB 3 from CalPont.com. I am currently reading about it. It suppose to help you easily scale

PetaPoco and uuid_short() function in MySQL

2012-10-18T06:13:00.002-07:00

I am trying to use PetaPoco Micro ORM with uuid_short() with no success. I wonder how it's possible to create and insert command with PetaPoco taking advantage of the uuid_short() function that built in MySQL to generate a unique bigint number? I've sent this question to TopTenSoftwrae and hope to get a reply soon: Hi there, really need your help on a very simple question.I am using

Amazon RDS, Statement-base replication and UUID_SHORT() as Primary Key

2012-10-18T03:56:00.002-07:00

I've read about not being able to use Statement-base replication when using uuid_short() function to produce unique ids for the primary key column. My question is whether I can use replication with Amazon RDS when I use uuid_short() function on my table as primary key? Update: I've found and answer here on Amazon documentation. Amazon RDS replication is set to mixed-format, which includes

The Main Problem with Today's DB solutions

2012-10-17T09:46:00.001-07:00

The main problem with databases solutions today is the ability to scale capacity. We don't want to be able to store terabytes of data on a single database/node, because it won't help performance. In my opinion a good innovation would be the ability to hide sharding from the developer, make the application scale in capacity by adding nodes. It's not an OPTION, it's a MUST HAVE solution for

Amazon S3 + CloudSearch as a Database Solution

2012-10-01T18:29:00.001-07:00

I wanted to know if there is an option to use Amazon S3 as a database by taking advantage of Amazon CloudSearch to be used as a query-like engine. For example, to make paging, I might use Boolean expression and use letters as incremental values. Inserting and updating data can be done easily. Also backup and restore can be done easily by backing up the bucket. You don't have any size storage

SignalR with Redis for Scaling for more than Single Machine on AWS

2012-10-01T18:06:00.001-07:00

I am using SignalR as my push messaging engine. I've installed SignalR via NuGet in visual studio, test it and it works fine. When I deploy my application, I intend to put my website on many server and behind a Load Balancer on Amazon AWS. What I want to achieve is how to configure SignalR to communicate between those servers. I've read that I need to install Redis to do that and I did

NoSQL vs NewSQL vs My Stubbornness (I won't surrender)

2012-10-01T14:25:00.002-07:00

If you read my previous posts you know that I am kind of person who won't easily surrender to new hypes and new technology solutions that try to solve problems and by doing so they are actually make life more complicated to developers. As for the time of writing this article, the only two solutions that seems to get my attentions is NuoDb and ParElastic. The first one is a NewSQL DB technology

Scale on Demand with ParElastic Database Virtualization Engine

2012-10-01T13:51:00.001-07:00

Just a note, I've came a cross Parelastic.com website which also provides a very interesting approach for scaling your database. Here's a video about their solution: Of course one of the great things about Parelastic Database Scaling solution is that it allows you to query the database as if it was one big database. The solution is currently in beta and you can signup to get more

ScaleBase Pricing / Cost Anyone?

2012-10-01T13:31:00.001-07:00

I am searching for hours for ScaleBase Pricing. I even sent them an email but didn't get any response. that lead me to think that this solution is way too expensive and that's why they don't publish it online. If anyone of you have any idea what is the pricing, which licences are available, please comment below. Thanks. BTW: My other alternative is DBShards hwich from what I've read it costs

Scale MySQL with Automated Sharding using Harvest DB

2012-10-01T12:38:00.001-07:00

Today I came across a very nice solution for scaling MySQL with automated sharding and built-in map/reduce. This solution is called harvestDB and you can read more about it on harvestdb.com. On my long journey to ind on single solution to solve my MySQL sharding problem and prevent me from coding a sharding solution in code myself, I thought that I will spend time to see if there are other

Easy to use and affordable DB solution for Big Data

2012-09-30T19:46:00.003-07:00

After viewing all the available sharding options for various databases, including Azure SQL Federations, I've decided that the best thing to do is to make sharding myself. I've figured out that if each SQL Azure federation is a single database and you can't join between them, I can deploy my own sharding strategy and work with MySQL RDS. That means that when I query my databases, I will