Questions tagged [cloud]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
19 views

MariaDB in the cloud....need some guidance

my plan is to move a mariadb into the cloud in germany. the clients will connect to it from 2 different office locations with 1gig/50mb up/dowload cable internet. Approx 10 clients will use the ...
kongootto's user avatar
0 votes
2 answers
116 views

Fully qualified or synonym for table in another database, cloud migration plan

Scenario: In SQL Server on-prem and plan to go the cloud in a year or two. I am writing a stored procedure in database A and I need to access a table from database B. Is it a best practice to create a ...
aimyee's user avatar
  • 9
0 votes
1 answer
506 views

Galera Cluster Crashes together?

Hello I'm currently having trouble with my galera cluster. It was working fine earlier but suddenly all of the Nodes crashed. I have 3 local nodes and 1 node on the cloud. During the time it went down ...
Glen G's user avatar
  • 3
0 votes
1 answer
29 views

Replicating to 3 databases one is web server

I have a customer that is looking for a very unusual replication configuration. I am hoping for some insight on why this is a bad idea, or even the possibility that it can be done. There are two ...
htm11h's user avatar
  • 123
-2 votes
1 answer
42 views

What are good options for cloud storage of audit data? (written continuously, rarely queried) [closed]

Cross-post from StackOverflow as I expect it may get closed there because S.O is so nitpicky... https://stackoverflow.com/questions/63432484/what-are-good-options-for-cloud-storage-of-audit-data-...
Orion Edwards's user avatar
1 vote
1 answer
543 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 ...
ogbofjnr's user avatar
  • 123
-1 votes
1 answer
360 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.
sajad's user avatar
  • 1
0 votes
0 answers
342 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 ...
natenjo's user avatar
2 votes
1 answer
589 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 ...
Victor Barajas's user avatar
1 vote
1 answer
632 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 ...
Luiz Paulo's user avatar
1 vote
0 answers
226 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 ...
Federico Bonelli's user avatar
1 vote
1 answer
186 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 ...
Gloria Santin's user avatar
1 vote
0 answers
1k 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:...
Mary Ann's user avatar
1 vote
1 answer
1k 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 ...
SHR's user avatar
  • 874
1 vote
1 answer
785 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 ...
vignesh's user avatar
  • 25
0 votes
3 answers
493 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 ...
Ghulam Qadir's user avatar
3 votes
1 answer
130 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 ...
user avatar
0 votes
1 answer
71 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, ...
boogjan's user avatar
0 votes
2 answers
219 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?
Bhtrox's user avatar
  • 9
2 votes
1 answer
229 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 ...
Gary Thomann's user avatar
0 votes
1 answer
157 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 ...
Ben's user avatar
  • 143
1 vote
1 answer
95 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 ...
boardrider's user avatar
0 votes
1 answer
669 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/...
manix's user avatar
  • 385
1 vote
1 answer
573 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? ...
user avatar
-2 votes
2 answers
525 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 ...
user avatar
0 votes
2 answers
226 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.
Sayed Uz Zaman's user avatar
1 vote
3 answers
3k 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 ...
JS_Diver's user avatar
  • 165
4 votes
1 answer
1k 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 ...
Vincent Teyssier's user avatar
0 votes
1 answer
70 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 ...
Piers Mana's user avatar
2 votes
0 answers
134 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 ...
zrz's user avatar
  • 121
0 votes
1 answer
51 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 ...
golden3's user avatar
1 vote
1 answer
1k 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 ...
siliconpi's user avatar
  • 111
2 votes
0 answers
111 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 ...
Doug's user avatar
  • 21
0 votes
1 answer
746 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 ...
wespiserA's user avatar
  • 101
1 vote
2 answers
3k 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 ...
Eustace's user avatar
  • 125
4 votes
1 answer
4k 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 ...
happs's user avatar
  • 143
-2 votes
1 answer
104 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?
Ahmed elroghay's user avatar
1 vote
1 answer
256 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 ...
Jon's user avatar
  • 23
1 vote
1 answer
222 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 ...
Charlesliam's user avatar
0 votes
2 answers
79 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 ...
no6's user avatar
  • 37
7 votes
1 answer
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, ...
Benjamin Smith Max's user avatar
1 vote
2 answers
106 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 ...
Eric Uldall's user avatar
1 vote
1 answer
6k 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 ...
hewstone's user avatar
  • 121
1 vote
0 answers
276 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 ...
Purefan's user avatar
  • 131
1 vote
2 answers
258 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 ...
user avatar
4 votes
2 answers
4k 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 ...
Mackwerk's user avatar
  • 189
8 votes
2 answers
2k 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 ...
Jason Kresowaty's user avatar
1 vote
1 answer
253 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 ...
user avatar
1 vote
1 answer
907 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 ...
Yeseanul's user avatar
  • 111
20 votes
5 answers
16k 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 ...
Vlad Minaev's user avatar