Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [cloud]

56 questions
20
votes
5 answers

Best cloud platform for PostgreSQL

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 hardware configuration. What we are looking for is a…
Vlad Minaev
  • 301
  • 1
  • 2
  • 4
8
votes
2 answers

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 transaction logs on the same drive letter as the other…
Jason Kresowaty
  • 231
  • 1
  • 8
7
votes
1 answer

Confused about load balancing and horizontal scaling in postgresql

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, how do I distribute the database? Do I create one…
Benjamin Smith Max
  • 213
  • 3
  • 6
4
votes
2 answers

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 periodically. I have looked at: WAL-e which seemed…
Mackwerk
  • 189
  • 2
  • 8
4
votes
1 answer

Galera cluster into Google cloud platform

We have a galera cluster with 3 nodes, on 3 different physical machines but all located in the same datacenter. From what I understood, the reason they deployed this in the past was to increase availability and reliability, DC failures are not a…
Vincent Teyssier
  • 173
  • 1
  • 7
4
votes
1 answer

Sharding VS Replication

To improve query response will it be better to shard the data or replicate existing shards for faster response. In case of sharding the data might be nicely distributed and hence the queries. In case of replicating existing shards, there will be…
happs
  • 143
  • 1
  • 4
3
votes
1 answer

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 there: I'm not the tech guy in charge of the…
henwil
  • 31
  • 1
3
votes
1 answer

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 away from their hosting model to pure cloud, but…
Nathaniel Richards
  • 31
  • 1
3
votes
1 answer

Any Reason to have Regular Failover Clustering in Azure Cloud?

Is there a reason to have Regular SQL Failover Clustering when database is in Azure Cloud? I understand the benefits having Availability Groups in Azure Cloud for Database-Level protection. People can transition heavy Read queries to the secondary…
user158823
2
votes
1 answer

Is it possible to Increase storage performance in azure vm using disk striping?

Given the following Azure VM: E8s_v3 (8 cpu, 64 GB RAM, 12800 IOPS, 192 MBps) I added 2 SSD Premium drives, one for data (1024 GBs / 200 MBps / Host Caching enabled read-only) and one for Logs (256 GBs / 125 MBps / No Cache enabled) When I…
Victor Barajas
  • 363
  • 2
  • 12
2
votes
1 answer

SQL Server 2008R2 database migration to cloud: case-insensitive collation changed to case-sensitive

Recently felt the fall out (crappy legacy code base) of a database migration by a third party vendor where the collation was swapped from case-insensitive to case-sensitive. I am wondering if the collation was deliberately changed during the…
Gary Thomann
  • 133
  • 4
2
votes
0 answers

Architecture to scale Postgres read capacity for a limited time each day?

We run a postgreSQL (9.4) server to store data for a web application. Our next feature will require a very data intensive processing on the server requiring a lot of db queries and computation over these data. As we update our database daily, the…
zrz
  • 121
  • 1
2
votes
0 answers

PostgreSQL on Cluster

question - I'm working on a project that involves heavy computation and will continually grow in terms of the database it works with. I want to build a small cluster (NUCs I'm thinking) the run a private cloud to run this off of. The code really…
Doug
  • 21
  • 1
1
vote
1 answer

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 features should I be looking for? Draft use…
Jon
  • 23
  • 5
1
vote
1 answer

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 by other people from a different location. When…
Charlesliam
  • 115
  • 6
1
2 3 4