Tagged Questions

0
votes
0answers
87 views

To scale horizontally, is MySQL with sharding, memcache and master-slave replication better than MongoDB

I am building an api, to share discounts between users. Each discount can be linked with several users, using joins and many to many relationships. Currently I am using MySQL and I am looking to ...
-2
votes
1answer
147 views

Compare MongoDB and MySQL

Can anyone help me to make right decision for choosing scalable and reliable database? I have to create 3-4 tables with around 200 columns each and these tables will have around 5000 data records. As ...
3
votes
1answer
1k views

Mongodb - Returning the points nearest to a location, with distance

What is the mongodb's equivalent to this query: SELECT 111151.29341326*SQRT(pow(-6.186753-Latitude,2)+pow(106.772835-Longitude,2)*cos(-6.186753*0.017453292519943)*cos(Latitude*0.017453292519943)) as ...
3
votes
2answers
370 views

Import and Export database in Mongo just like MySQL

I am newbie to the Mongo.Before this I have worked only with MySQL.In MySQL we can import and export database easily.I want to know is there any option available in Mongo to import and export database ...
9
votes
5answers
648 views

Infrastructure for Highly Concurrent, High Write DB

My requirements are: 3000 Connections 70-85% Write vs Read Currently, we are maxing out a High-CPU, Extra Large Instance at 700 connections. All 8 cores are maxed. We think it's the number of ...