Questions tagged [cloud]
The cloud tag has no usage guidance.
52
questions
0
votes
2
answers
103
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 ...
- 9
0
votes
1
answer
463
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 ...
- 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 ...
- 123
-2
votes
1
answer
40
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-...
- 107
1
vote
1
answer
476
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 ...
- 123
-1
votes
1
answer
332
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.
- 1
0
votes
0
answers
333
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
2
votes
1
answer
568
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 ...
- 363
1
vote
1
answer
591
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 ...
- 11
1
vote
0
answers
218
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 ...
- 111
1
vote
1
answer
185
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 ...
- 111
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:...
- 43
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 ...
- 874
1
vote
1
answer
774
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 ...
- 25
0
votes
3
answers
470
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 ...
- 80
3
votes
1
answer
121
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 ...
user158823
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, ...
- 1
0
votes
2
answers
201
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?
- 9
2
votes
1
answer
223
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 ...
- 133
0
votes
1
answer
143
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 ...
- 143
1
vote
1
answer
94
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 ...
- 113
0
votes
1
answer
665
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/...
- 385
1
vote
1
answer
570
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? ...
user129291
-2
votes
2
answers
521
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 ...
user129291
0
votes
2
answers
222
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.
- 101
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 ...
- 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 ...
- 173
0
votes
1
answer
69
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 ...
- 145
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 ...
- 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 ...
- 1
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 ...
- 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 ...
- 21
0
votes
1
answer
740
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 ...
- 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 ...
- 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 ...
- 143
-2
votes
1
answer
98
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?
- 109
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 ...
- 23
1
vote
1
answer
221
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 ...
- 115
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 ...
- 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, ...
1
vote
2
answers
105
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 ...
- 151
1
vote
1
answer
5k
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 ...
- 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 ...
- 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 ...
user6162
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 ...
- 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 ...
- 231
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 ...
xero
1
vote
1
answer
905
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 ...
- 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 ...
- 301
3
votes
1
answer
393
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 ...
- 31