Questions tagged [aws]
Amazon Web Services.
347
questions
-1
votes
0answers
32 views
How can retrieve deleted mongodb database in ubuntu server?
I mistakenly uninstalled MongoDB using the commands below. Also, it's a live database with a real customer so this mistake fully ruins my project.
sudo apt-get purge mongodb-org*
sudo rm -r /...
1
vote
1answer
26 views
SQL Server linked server from on premises to SQL Server instance on Windows in Amazon EC2
I am trying to create a SQL Server linked server from on premises to SQL Server instance on Windows in Amazon EC2 (2 different domains) and getting:
Login timeout expired.
I am using sa account ...
1
vote
0answers
13 views
How to calcuate current IOPS consumed in AWS
We have a SQL Server hosted on AWS using EC2 and EBS. SQL Files are hosted on EBS. EBS vol type is GP2 and drive IOPS is 480.
At an instance of time Write Througput in AWS is showing is 725 and Read ...
0
votes
1answer
17 views
How the transaction logs are maintained in MSSQL RDS?
Just curious, I was asked that if RDS takes transactional log / incremental log backup for point in time recovery, does RDS shrink the logs too?
In MSSQL instance, we shrink logs if transactional ...
0
votes
0answers
41 views
SSHtunnelForwarder to Linux Box, then connect to Postgres RDS (AWS)
I'm trying to write a python script to update DDL in a Aurora RDS (postgres) on AWS. In Order to do this, I need to SSHTunnel to a linux box that sits at the edge of the VPC, then do another jump to ...
1
vote
1answer
33 views
What does RRQMS and WRQMS mean?
I found a possiblity to display Rrqms and Wrqms graphs in AWS RDS Enhanced monitoring page (I use Postgres 9.5.19) but I can't find any detailed explenation about these parameters.
By googling I only ...
2
votes
0answers
72 views
Linked Server: An error occurred during decryption
We're running a SQL Server instance on AWS RDS. I believe this is a 2017 instance. We also have a couple of Linux EC2 instances running SQL Server (not sure the version, but I assume 2017)
Our RDS ...
0
votes
1answer
88 views
Script to install Oracle client 12c2 on Redhat linux 7.5
Can someone help me to provide a script which I can use to install the Oracle client as part of the server build or AMI. Below script I was able to pull out from the guide in the Oracle site. But ...
0
votes
0answers
49 views
Migrate cluster Aurora RDS postgres from 9.X to 10 without downtime
Ok, this question is to find some strategy or tool that helps me to migrate from cluster Aurora RDS postgres from 9.6 to 10 without downtime.
What I find until now
Aurora RDS is allowed to do major ...
1
vote
1answer
52 views
RDS MySQL 8.0.16 has empty “INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS” table
On aws RDS I have an mysql 8.0.16 instance running.
My problem is now, that the INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS table is empty.
This is a problem for me because I would like to create ...
-2
votes
1answer
17 views
Estimating aws postgres delete activity rate
I have a table organized by date. Of the 84M rows, 26M all hit on one date. I want to delete that date.
There is an index on the date field.
I started a delete from <table> where <...
0
votes
0answers
19 views
Does AWS DocumentDB automatically scale down disk space?
I have swapped to DocumentDB from MongoDB so I don't need to manage my DB and it's nicely in the AWS stack.
I have recently done some load testing creating a DB of 180GB, now my DB is back down to ...
1
vote
1answer
13 views
Data Pipeline load bulk tables in one time
I am using AWS Data Pipeline for copying my RDS MySQL Database to Redshift. I need to create separate pipeline for each table and each pipeline create new EC2 instance. (Process takes time).
Problem
...
0
votes
0answers
66 views
ElasticSearch Node Failure or Shard Failure?
My Elasticsearch cluster dropped from 2B documents to 900M Records, on AWS it shows
Relocating shards: 4
Whilst Showing
Active Shards: 35
and
Active primary shards: 34
(Might not be ...
0
votes
1answer
35 views
AWS RDS: How do I diagnose this failure?
I have a simple RDS setup: one database, no replication. It has been running for around 2 years without any problems. CPU usage is generally less than 5%, sometimes boosting to around 10%.
Today, ...
1
vote
0answers
54 views
How to connect mongodb from aws ec2 ubuntu docker containers?
I have tried
mongosqld --addr localhost:3002 --mongo-uri xxxxx.com:27017
But it is throwing the following error:
unable to load MongoDB information:
failed to create admin session for ...
0
votes
1answer
115 views
Number of Worker threads available in PostgreSQL
In SQL Server we can have many worker threads per CPU core. Does anyone know if the same is true in PostgreSQL and can point me at a reference? (assume version 11).
The background is that we have ...
1
vote
0answers
13 views
Which FLUSH command before taking EBS volume snapshot?
The FLUSH TABLES WITH... command has a few flavors. The manual meagerly describes the differences between:
FLUSH TABLES WITH READ LOCK
FLUSH TABLES WITH READ LOCK AND DISABLE CHECKPOINT
FLUSH TABLES ....
0
votes
0answers
15 views
High constant CPU on Aurora/RDS
I've noticed recently that our resting CPU on our Aurora RDS cluster appears to be about 80%. I'm unsure when this started, as we don't have alarms/metrics in place (something I plan to rectify now).
...
1
vote
0answers
46 views
AWS RDS Multi A-Z vs DigitalOcean Managed Databases
I am currently hosting my database inside a t2.large instance on AWS EC2 which provides 8GB RAM and 2 CPUs. I am now looking for better options which are more scalable and provides features like ...
-1
votes
1answer
9 views
Impact of changing swappiness
On one of my aws ec2 m4.10xlarge instance running Ubuntu 16.04 LTS with 160 GB memory, I want to change the swappiness from the default 60 to 10. Does changing this at runtime using
sysctl -w vm....
0
votes
0answers
459 views
The MySQL server is running with the --read-only option so it cannot execute this statement
I am using amazon aurora RDS in my application. I have created cluster endpoint by selecting both read and write instance. Then I used that instance in my application. Whenever I am executing update ...
0
votes
1answer
28 views
Upload file to RDS Postgres Instance
I want to create custom Full Text Search dictionary with special stop words from some_words.stop. How to upload this file to my RDS instance by FTP?
2
votes
1answer
53 views
SQL Server Installation - TempDB not created in the directory specified in ConfigurationFile.ini
I'm attempting to install SQL Server 2016 SP2 on a newly created EC2 instance. I'm using a configuration file I previously generated. In the configuration file I've specified where I'd like the TempDB ...
0
votes
0answers
66 views
Connecting to postgres via ODBC from AWS Oracle RDS
I would like to connect a 12.1 Oracle RDS AWS instance to a Postgres database (also running at AWS but hosted on an EC2 instance).
There are a number of examples of how you could do this (eg
https://...
0
votes
2answers
156 views
Amazon RDS Ola Hallengren
Very new to SQL on AWS RDS so.
Need to create maintenance jobs on an AWS RDS SQL2016 instance. I know parts of Ola Hallengren's life saver maintenance script works, Index, stats and integrity.
...
0
votes
1answer
60 views
Detecting Logical Replication Error on Postgres v10 on AWS RDS CloudWatch metrics
https://www.postgresql.org/docs/10/logical-replication-restrictions.html
States:
"When the schema is changed on the publisher and replicated data starts arriving at the subscriber but does not fit ...
1
vote
2answers
21 views
GRANT permission ON database TO user not working on AWS
I'm having trouble granting a user permission on AWS.
mysql> GRANT CREATE ON *.* TO 'hmrex_db'@'%';
Query OK, 0 rows affected (0.01 sec)
mysql> SHOW GRANTS FOR 'hmrex_db'@'%';
+----------------...
0
votes
2answers
33 views
What is the best way to upload custom-parsed data into AWS Aurora PostgreSQL
I have a large (5-10 GB) binary file on AWS S3 that will require custom parsing, probably in python. It is essentially a sequential set of millions of dataframes, all having the same structure. What ...
3
votes
1answer
164 views
AWS aurora (postgres) proper value for the shared_buffers parameter
I think it's fairly well known that a normal PostgreSQL database has a starting value of 25% of system memory for its shared_buffers parameter, but I haven't been able to find anything regarding a ...
0
votes
0answers
36 views
AWS aurora mysql is restarted unexpectedly
In our system
one of aurora mysql instances was't available for short period.
because this instance suddenly restarted at 08/14/2019 3:56JST.
we already checked error log for aurora.
but i found ...
0
votes
0answers
10 views
AWS Redshift Workload Management
I am planning an AWS Redshift (RS) data warehouse and expect to have mix of longer-term jobs (60%) and short-term jobs (40%). The plan is to use workload management (WLM) and create multiple queues to ...
0
votes
2answers
206 views
MongoDB Replica Set InitialSyncOplogSourceMissing error
I am setting up a 3 nodes MongoDB replica set with one node in AWS using Mongo 3.6.12. There are about 400GB data need to sync to secondary nodes. Initial sync starts fine. However, after data sync ...
1
vote
1answer
127 views
Do not replicate Delete operations AWS DMS
I am using AWS DMS to replicate ongoing changes with SQL Server as a source and target endpoint. The tasks are running and replicating data with low latency. However, I need the tasks configured not ...
0
votes
0answers
8 views
How to restore data in aws rds without snapshot
Suppose I have snapshot at 9 AM and the data crashes at 3 PM and I want the data till 2:55 pm. How to restore data till 2:55 PM. Is there any method .if so how to do that.
1
vote
1answer
182 views
AWS Aurora MySQL Serverless CPU utilization is growing for unknown reason
We have been using Aurora serverless databases in staging and production environments for a few months now, and find the CPU remains in the range 15-20% almost all the time. However in the past week ...
0
votes
0answers
42 views
Partition Alignment in AWS SSD EBS
I'm setting up a new SQL Server 2008 r2 in AWS with IO1 SSD EBS volumes. My smaller EBS volumes are aligned correctly when they were formatted but the larger volumes, 3TB, are not because they used ...
0
votes
0answers
314 views
AWS RDS mysql deadlock
Everything in our production environment was working well. Yesterday, suddenly out of no where we were getting "lock wait" on any transaction related to a specific row. Same transaction on another row ...
0
votes
0answers
10 views
How to find the master instance of a read replica in AWS RDS PostgreSQL?
I have an RDS Postgres instance whose role is Replica. I do not see the master in the same region and probably is in another region of the AWS account. How do I find the master for this replica?
...
1
vote
0answers
101 views
Win 2019 + SQL Server 2014 slowly locks up the server
We have a 2019 + 2014 sql server box that was running fine for a few days after we first stood it up on Ec2.
After a week I removed a temp drive (EBS) that we had initially used to load up the ...
0
votes
0answers
9 views
Elastic search data synchronization with different databases
We are using elastic search hosted in AWS for apps wide search in our organization. We had initially dumped our existing data using logstash.
However, we are struck at keeping the Elastic DB in sync ...
0
votes
0answers
27 views
Find an equivalent way to make “$setIsSubset” with AWS DocumentDB
I need to find another way to make this operation : "$setIsSubset" with AWS DocumentDB (MongoDB like).
I'm not an expert with the mongo request, but I need to convert this instruction for my ...
0
votes
0answers
3 views
Copying fields from first line item to header in MySQL (5.7 on Amazon)
We have a header table ("opportunities") and a line-item table ("opportunity_details"). Each header record has 7 fields of vendor information that get copied from the first (by record-ID) line-item ...
0
votes
0answers
64 views
How to switch MBR to GPT without losing any existed data originally in MBR, AWS Ubuntu EC2
I'm trying to extend my diskspace for my AWS EC2 Ubuntu instance, the partition I've started with is MBR and the maximum it can go is 2TB.
Currently the diskspace is full with important data, I need ...
2
votes
1answer
111 views
Redshift Spectrum CTE Union
I have a query with a CTE that uses a Spectrum table. When I try to union the CTE with itself:
WITH foo AS (
SELECT col1
FROM spectrum.bar
)
SELECT * FROM foo UNION ALL
SELECT * FROM foo;
I get ...
0
votes
0answers
24 views
SQL Server read-replica hosted on AWS with ephemeral storage
I have a temporary need (during transition from on-prem to AWS) to provide a high-performance SQL server instance for analytics.
I would like to purchase two SQL server enterprise instances. One ...
0
votes
1answer
13 views
Redshift is missing in target database list of AWS SCT Schema Convertion Tool
I want to convert schema of SQL Server database to Amazon Redshift using AWS SCT tool
But as target database, Redshift is not listed
When I use PostgreSQL compatible with IP address of the cluster, ...
0
votes
1answer
28 views
SQL Server license from AWS Marketplace with ? cores
We are planning to buy a SQL Server 2012 Enterprise edition license from AWS Marketplace for our company. We have exhausted our previous licenses and we need to add a new region with SQL Server in ...
0
votes
1answer
484 views
How to set the wal_level in AWS RDS Postgresql?
How do I know which wal_level my AWS RDS Postgres 11.1 database has?
I checked 'parameter groups', but was unable to find the wal_level.
Once found, how do I change it?
0
votes
0answers
85 views
Can SQL Developer be used with the Athena JDBC Driver
I'm trying to connect to Athena using the JDBC drivers provided by Amazon, and using SQL Developer as the client. So far, I haven't had any luck with Java 1.8.181 and AthenaJDBC42-2.0.7.jar Has anyone ...
