Questions tagged [cloud]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
9 views

Connecting a SOAP web service (XML) with a Solr Database

I've stood up a Solr Database in Cloud mode in our Cloudera stack using Cloudera manager and ZooKeeper. I know how to ingest data via pysolr and also through the local browser GUI, but that's usually ...
-1
votes
0answers
20 views

Would a database hosting service benefit from compressing its consumer's data? [on hold]

Not sure if this is the stack to ask the question but here it goes. Assuming I'm entering a partnership with a database hosting service which charges me on one criteria: how much space my data takes ...
1
vote
1answer
61 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
48 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:...
0
votes
0answers
34 views

Connect to Oracle Cloud DB using local SQLPlus/SQLDeveloper

I am practicing with Oracle Cloud Database and want to open the DB to connect from my local machine. I am following the documentation as best I can but it appears to be for an older version of the ...
0
votes
0answers
6 views

WebSync Replication over HTTPS URL between SQL Servers on Cloud and on Intranet behind Proxy

I have a SQL Server instance running on company intranet behind a web proxy server. On cloud, I have an other SQL Server instance. I tried to implement WebSync method using replication between these ...
1
vote
1answer
287 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
106 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
3answers
38 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
86 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
44 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, ...
0
votes
2answers
31 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?
2
votes
1answer
87 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 ...
0
votes
1answer
42 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
34 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 ...
0
votes
1answer
411 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
vote
1answer
386 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? ...
-2
votes
2answers
339 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
43 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.
1
vote
2answers
1k 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 ...
3
votes
1answer
600 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 ...
0
votes
1answer
43 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 ...
2
votes
0answers
102 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 ...
1
vote
1answer
649 views

High data traffic from MySQL server to web server

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
0answers
102 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 ...
0
votes
1answer
483 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
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
515 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 ...
-2
votes
1answer
74 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?
1
vote
1answer
230 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
149 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
67 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, ...
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
0answers
97 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
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
0answers
273 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
253 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 ...
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 ...
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 ...
1
vote
1answer
189 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
889 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 ...
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
373 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
248 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 ...
1
vote
1answer
141 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 ...