The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
26 views

How to Choose an SQL Database for Simple Data Preparation & Analytics

In the interests of not making this a shopping list: please advise on "how" to choose a the right tool, as opposed to which is the best. E.g: Which questions should I be asking myself / client? What ...
1
vote
1answer
24 views

How to update MySQL data within intranet from MySQL data in cloud?

I am currently using a MySQL DB located within the intranet. Only the people within the LAN can access the information. I'm trying to re-create the MySQL DB in a cloud provider. This can be accessed ...
0
votes
2answers
55 views

To replicate, or not to replicate

1.Intro Hello, I am running web application on 2 separate geographical locations(e.g. Europe, Hong Kong). Let's suppose Hong Kong server is an Amazon EC2 instance(paying for disk space, IO disk ...
3
votes
1answer
707 views

Confused about load balancing and horizontal scaling in postgresql [closed]

Please correct me if I am wrong but I guess handling more requests and load by adding more machines or balancing the load between multiple servers is horizontal scalling. So, if I add more servers, ...
0
votes
0answers
56 views

How do I get let SQL Server 2005 know that I changed host name in Amazon AWS server?

I am using an Amazon AWS SQL Server 2008 R2 server for dev purposes. In order to follow a new naming convention, we changed the name of the host. I then tried to let SQL Server know about this ...
0
votes
1answer
237 views

How to real-time sync local Postgres instance to Cloud Postgres

I have a local postgres database (9.2) running on Ubuntu that is constantly being written to by an application capturing sub-second data. (99.9% of the transactions are inserts). I also have a ...
0
votes
0answers
63 views

How to/advice for hosting a multi-user database on the cloud with specific objectives

I have developed an application that users will be able to download and create an account with through our company. This application will always be connected to the internet. I have been testing the ...
0
votes
0answers
165 views

Rackspace Cloud Databases: incremental backup

Rackspace Cloud Databases are a little bit special in that we do not have access to the bin_log file, they are not servers in the traditional sense. I do have a couple of Cloud Servers with them but I ...
1
vote
2answers
122 views

Migrating a database from SQL Server 2012 to the cloud

I have a sample SQL Server database which is running on my computer. I have a cloud database account on AWS (free account). I want to migrate the database, with all tables, to the cloud. How can I do ...
3
votes
1answer
402 views

Postgres backup and WAL to S3

We are looking for a solution for the following problem: We have set up streaming replication so we have a master DB and a slave DB, we want to have basebackups and WAL files sent to our S3 storage ...
6
votes
2answers
455 views

SQL Server Transaction Logs in the Cloud

It is a common practice to place the transaction logs (*.ldf) on a separate physical disk system than database files (*.mdf, *.ndf). In a virtual machine cloud environment, is it okay to put the ...
1
vote
1answer
147 views

cloud computer to speed up sql big data queries?

i have been doing a lot of data mining at my new job. we collect TONS of data, and it's my job to visualize that sea of information in real time with statistic/heuristic analysis. we're currently ...
1
vote
1answer
557 views

What is the best and most performant MySQL cloud solution?

I'm looking for a solid solution (~1GB of DB space). Speed is crucial and I'm happy to spend up to $100 a month on a decent solution. The database will be used by a series of desktop applications ...
16
votes
5answers
3k views

Best cloud platform for PostgreSQL [closed]

Currently, in our project, we use dedicated servers for our PostgreSQL database. In theory, we can run anything on some cloud platforms. However, PostgreSQL configuration is strictly related to ...
3
votes
0answers
185 views

How does Postgres Plus Cloud Database on AWS compare with the alternatives [closed]

I'm familiar with the difficulties of scaling regular postgres on AWS and the limitation of services like RDS. Postgres plus cloud database (bit of a mouthful) seems to run out of the box on AWS, ...
3
votes
1answer
274 views

Postgres Plus Cloud Database on AWS for write heavy social game?

I'm one of four founders of a big social gaming iPhone app in Sweden. We now suffer from severe database server issues so I'm turning to you guys to get some help. First of all, let me get this out ...
3
votes
1answer
102 views

How do I back up On Premise Microsoft SQL Server 2008 to Azure cloud

I have a 50 GB hosted SQL Server database at SoftLayer. I want to do backups to cloud storage, as the SoftLayer managed SQL Server backups are ridiculously priced. Eventually we will totally move ...
3
votes
0answers
111 views

Tools for maintaining many dev/test environments on the cloud

The company I'm currently working with is "moving to the cloud" (isn't everyone these days?) In this case, they are moving to AWS, and they want a simple and effective way of managing multiple (SQL) ...