Questions tagged [cloud]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1
votes
0answers
17 views

Licensing SQL Server on Oracle Cloud (per core) [closed]

A client have 3 SQL Server licenses (PN 7NQ-00215). Acording to this part number, he can use up to 6 cores. In Oracle Cloud Infrastructure, 1 oCPU shows as 2 vCPU inside the vm, much like as ...
2
votes
1answer
92 views

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 ...
1
vote
1answer
50 views

AWS iops vs disk iops?

Recently devops guy from our company told me that our local mysql stage environment are much faster than aws, because local disk has 10k iops, but our aws rds has only 500 iops. As far as I ...
0
votes
1answer
573 views

Running forms in Oracle Cloud Service

Since few years ago I have worked and extending a application build by Forms Builder 10g and running via Oracle Application Service 10g. The application can be launched as: http://portal.dev:7778/...
-1
votes
1answer
30 views

how to put encryption in place while creating db link between on premise db 12c and cloud db 11g

we need to create db link between our db on premise and our medical db on oracle cloud. Our main concern is the data encryption while data transfer happen. Need a solution.
0
votes
0answers
24 views

SQL Server Backup on OCI Object Storage

Is there any way I can take SQL Server database backup directly on OCI object storage? Couldnt find any method to map the object storage to windows.
0
votes
0answers
51 views

Exporting from Oracle Cloud, importing on local database

I am currently experiemting with oracle databases. I have a free tier at Oracle Cloud, with a free instance of autonomous database. As I like to have my backups locally I did an export, basically ...
1
vote
1answer
793 views

High data traffic from MySQL server to web server [closed]

I have one webserver running Magento : Community Edition 1.7.0.2 and a separate machine with MySQL 5.5.42 on it. Both machines are EC2 instances. I am seeing huge unexpected data traffic from the ...
-2
votes
3answers
182 views

How to maintain a Database with stored procedure that runs forever?

I have an interesting question and I cannot find a reply. I would like to create a database of prime numbers. On this page Prime numbers in a given range , I can find various examples of SQL code ...
0
votes
1answer
41 views

Change Azure Standard to Premium

I have one application using SQL Server Standard and would like the change to Premium, but I need to understand about the DTU. The application reaches 100% in DTU every day. Would talk know if I need ...
1
vote
0answers
49 views

How to scale MongoDB/GridFS for fast ingestion on limited timescale

I'm working on a cloud-agnostic service which must allow the ingestion of a lot of media files in a very limited timeframe. Some numbers: 3-4 hours total of workload: the service will be active ...
1
vote
1answer
98 views

Troubleshooting oracle database errors from cloud application

I am trying to troubleshoot an issue that presents as different database errors such as, ORA-01000: maximum open cursors exceeded or Unable to create DB Connection. I have reviewed the PLSQL to ...
1
vote
0answers
196 views

OCI KBHS-00719: Error 'unknown'; Archived object is not restored

I am encountering below error message from RMAN backup to OCI. Either the bucket named 'DB_BACKUP' does not exist in the namespace 'UNIcredits' or you are not authorized to access it. KBHS-01404:...
1
vote
2answers
2k views

Syncing data between onprem and Azure SQL

I have the following Scenario: an on-premise SQL Server 2008 R2 and an app using it as db. I want to create an Azure SQL database that will be synced (asynchronous replication) with the on-premise ...
1
vote
1answer
561 views

connect to Oracle Cloud from SQLPlus and Instant Client

I want to try to connect with SQLPlus to Oracle Cloud. for regular oracle I can connect from remote machine as follows: IP = 1.2.3.4 PORT = 1521 ServiceName = "ORCL1" Username = "username" Password ...
1
vote
1answer
331 views

MongoDB deployment across cloud and On Premises

We are planning to implement MongoDB as a stretch cluster which includes Primary secondary in DC 1, Secondary secondary in DC 2, Arbiter in cloud(DC 3) where DC 1 and DC 2 are on premise servers and ...
0
votes
2answers
50 views

What is cool-down time in Alibaba Cloud Auto Scaling?

I am using Auto scaling on my Alibaba Cloud Elastic Compute Service Instances. I am not aware of what the cool-down time is and the implications?
0
votes
3answers
91 views

Can I move / Modify the Object in Object Storage Service (OSS)

I am using Alibaba Cloud - ECS and have Storage Bucket - Object Storage Service (OSS). File Storage structure is like oss:/bucket/abc/xyz/123.jpg/ My Question is Can I move or modify the objects ...
3
votes
1answer
91 views

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 ...
0
votes
1answer
59 views

TSQL retrieve backup date from database after restore

Usecase: MSSQL Database is hosted in the cloud, I download the database thrue FTP and restore it on-premise automatically for reporting. Now I want to retrieve the date/time when the backup was made, ...
2
votes
1answer
134 views

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 ...
-2
votes
2answers
422 views

Problems with having SQL Server Identity Column in the Cloud

Our company is utilizing Identity(1,1) clustered primary index in SQL Server 2016 Enterprise, and will eventually deploy into the Cloud (Amazon AWS, Google Cloud). Is there any issues utilizing ...
0
votes
1answer
51 views

Is it possible to allocate data free for certain table?

After deleted a large dataset (~50GB) and optimized tables, some tables have data free (~50GB) and parts of tables have only data free (~KB). As my understanding, the data free are reused and not ...
1
vote
1answer
51 views

Can syslog be configured for Oracle Database Cloud Service?

Short Version: If I create a Cloud Database (on Oracle Database Cloud Service) - 1. Can it log to Syslog? 2. Can I set where that syslog is located (i.e., at which host:port)? Long Version: If ...
3
votes
2answers
2k 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 ...
1
vote
1answer
443 views

SQL GUID or Identity in the Cloud

Follow up from my previous question SQL Server Identity Column in the Cloud: Are there any general guidelines? Should a person use Clustered Index Identity or GUID in the cloud for SQL Server 2016? ...
0
votes
1answer
70 views

How to install MongoDB database as a service in ESxi?

I want to know is it possible to install mongodb directly to the ESXi without guest OS? Please tell me how to setup Data storage as a service environment inside ESXi.
3
votes
1answer
760 views

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 ...
1
vote
2answers
100 views

Is it safe for me to switch from an 8GB server to a 4GB server? (Stats inside)

We are looking to cut some of our server costs and the only place I think it might be possible is our db server. We're currently running an 8GB rackspace cloud that houses a mysql instance and I ...
0
votes
1answer
60 views

Migrating MS Access application

I'm advising a small non-tech company that outsources their software, hardware, and support services to a local IT provider. This company is preparing to migrate several of their internal applications ...
0
votes
1answer
570 views

Microsoft SQL Server -> Postgres Data Migration

I have data in a Microsoft SQL Server that needs to be migrated to Postgres. The problem is that the SQL Server gets continuous updates and is hosted on our local net, while the Postgres instance is ...
1
vote
1answer
147 views

Clarification on Cloud Computing Database

This question can be very generic, but I am trying to understand the concept of Cloud Databases. Let's say I have a Web Application, a Desktop Application, and Apps for my Web Application. All of my ...
2
votes
0answers
115 views

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 ...
0
votes
1answer
47 views

Migration MySQL to Cloud Environment replication

I'm having 5 MySQL database server , these 5 server are used for e-business web-server. Now I Would like to move the MySQL database to cloud environment for database continuous running. Recently we ...
2
votes
0answers
107 views

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 ...
1
vote
2answers
2k views

Connecting to Google Cloud SQL via SSH

The network I'm using doesn't allow port 3306 so I can't connect to Google Cloud SQL. How do I set up a proxy server (on a different network that allows 3306) that I could connect to via SSH to ...
-2
votes
1answer
79 views

Backup SQL Server database to the cloud or network folder [closed]

I can take a SQL Server backup to a local disk without any problem, but I now need to backup to a cloud disk or network folder that I can access. What are the best practices to do this?
8
votes
2answers
1k 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 ...
2
votes
1answer
1k views

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 ...
0
votes
0answers
98 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 ...
1
vote
1answer
238 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
158 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
69 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 ...
6
votes
1answer
5k 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, ...
20
votes
5answers
15k 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
1answer
251 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 ...
0
votes
1answer
3k 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 ...
1
vote
2answers
254 views

Migrating a database from SQL Server 2012 to the cloud [closed]

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 ...
1
vote
0answers
274 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 ...
3
votes
1answer
378 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 ...