Skip to main content

Questions tagged [aws]

Amazon Web Services.

Filter by
Sorted by
Tagged with
8 votes
1 answer
4k views

What AWS instance to choose for write-heavy PostgreSQL database server

We are now having problems trouble to tackle the intensive traffic to our servers during peak hours; see this related question on tuning the DB. At the moment we are using a smaller cloud service for ...
lorgartzor's user avatar
5 votes
1 answer
2k views

Swap Usage but high Freeable memory

We have an AWS RDS with a MySQL database. Buffer Pool size is only 144GB out of the total available 244GB RAM. However, even at such a low RAM config, we see Swap Usage happening. Does anyone have any ...
Shahid Thaika's user avatar
3 votes
0 answers
695 views

RDS MSSQL in-place upgrade how to update master db compatibility level when rdsa account is db owner

Background My workplace infrastructure team ran a typical in-place upgrade of an RDS MSSQL instance to update the version from 2012 to 2017. After the upgrade, while logged in as the "master ...
dev_etter's user avatar
  • 751
3 votes
3 answers
1k 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 ...
Jonas Taulien's user avatar
9 votes
1 answer
12k views

Replication Lag on Postgres AWS RDS Service

We have a single master/single streaming replica Postgres 9.3 db on AWS. The load is not terribly high - this is a development/staging environment. (The production shows similar metrics). Point is the ...
MJB's user avatar
  • 191
8 votes
2 answers
6k views

MySQL on RDS, data transfer from one instance to another as a production job

I have a MySQL RDS instance ("production") from which I need to copy incremental data to another MySQL RDS instance ("reporting"). “Incremental data” being the new rows in certain tables. Currently ...
Alex Lo's user avatar
  • 181
7 votes
2 answers
35k views

How to solve MySQL “The table is full” error 1114 with Amazon RDS?

I am trying to add a new column in a table and the query giving me this error 1114. My RDS instance size is small. 1.7 GB memory, 1 ECU (1 virtual core with 1 ECU) Table i am trying to modify is ...
Ruchit Patel's user avatar
4 votes
2 answers
81k views

Cluster network name resource 'Cluster Name' failed registration

I have a fail-over cluster set between two Windows Server 2016 machines, and I'm seeing errors regarding the DNS record, both for the cluster itself and for any listener I try to add in SQL high ...
Green's user avatar
  • 41
4 votes
1 answer
3k 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 ...
Dan's user avatar
  • 141
4 votes
3 answers
14k views

How to decide whether to enable MySQL query cache using InnoDB

How should the decision to enable / disable the MySQL query cache be made, on a server that uses just InnoDB tables. Say for example, if the cache is enabled, then how should the output of: SHOW ...
Michal Charemza's user avatar
3 votes
0 answers
2k views

PostgreSQL continuous archiving - use snapshot for base backup on AWS?

I'm new to AWS and PostgreSQL admin and have been poring over the docs trying to come up with a good backup strategy for a fairly simple setup. I have a single Amazon Web Services EC2 instance that ...
Mark Berry's user avatar
3 votes
1 answer
3k views

storing files on mongodb

I am developing an app where user will upload multiple images along with some other data like name address etc. I am using MEAN stack for development, So I have some questions regarding this: How ...
Bhushan Goel's user avatar
2 votes
1 answer
107 views

AWS to Azure Degraded Performance With "Hash Match (Aggregate) Step"/"Temporary Disk" TempDB Performance Issue

Ok, so I have a series of AWS VM's, mostly using the z1d.3xlarge server class with built in SQL Server 2019, these servers each contain a NVMe of various size. (Not surprisingly) I've placed my SQL ...
David Rogers's user avatar
2 votes
1 answer
12k views

Problem when connecting to SQL Server

I'm trying to connect to my SQL Server Express and I get this error. This happens both locally and on client. Connection Timeout Expired. The timeout period elapsed during the post-login phase. ...
user3845038's user avatar
2 votes
2 answers
1k views

Sync MongoDB Replica set with Remote Replica Set

I'm wondering if it is possible (within reason) to sync a new MongoDB Replica Set(RS) with an RS currently in production. The Problem We have a site running on AWS that has its own MongoDB Replica ...
Eric Uldall's user avatar
2 votes
1 answer
3k views

pg_stat_statements causing DB to run out of memory

I enabled pg_stat_statements on an AWS RDS postgres 9.6.3 instance with 30GB RAM. We got the error message below in postgres log, and an event saying OS killed DB server process due to excessive ...
virtual void's user avatar
1 vote
2 answers
3k views

Can we disable binary logging for one specific session or user in AWS RDS

Currently we have a situation to disable binary logging for one set of queries on AWS RDS. We thought to set log-bin=0 for that specific session. As per Amazon, this is not possible. Is there any work ...
Uday's user avatar
  • 814
1 vote
1 answer
318 views

MySQL data precision confusion

I have two tables with same column. First table: DESC orders; Field Type Null Key Default Extra order_id int(8) unsigned zerofill NO PRI (null)...
Darwin Cabiling's user avatar
1 vote
0 answers
122 views

Backup data from RDS to S3 and delete from RDS once copied to S3

We have a requirement werein we have to backup data from RDS(MYSQL and Postgres) to S3 incrementally and to delete the already copied data from RDS. I thought of using aws data-pipeline for this, ...
Sumant Kumar's user avatar
0 votes
0 answers
242 views

Are there any unintended side effects of limiting a mongodb docker container's CPU or RAM?

It's easy to limit RAM and CPU usage for a docker container with the docker update -m command. We have limited RAM and CPU using docker update on multiple docker mongodb containers, particularly on an ...
J.E.C.'s user avatar
  • 101
0 votes
1 answer
432 views

Backups cannot be restored on AWS RDS - View creation problem. Access denied; you need (at least one of) the SUPER, SET USER privilege(s) for this

The environment is MariaDB 10.6.8, via Amazon RDS. We have all 'admin' rights but not SUPER on AWS databases. I have a view in an application that has it's data stored in a single schema. We use non-...
J. Gwinner's user avatar
0 votes
2 answers
3k 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 ...
Ben10's user avatar
  • 21
0 votes
2 answers
860 views

Table JOIN and CREATE new table extremely slow

I'm using something like this to create a new table: CREATE TABLE result AS (SELECT calls.*, targ_with_planned_calls.* FROM calls INNER JOIN planned ON calls.first_id = ...
jonmrich's user avatar
  • 101
-1 votes
2 answers
2k views

Heartbeat frequency in AWS DMS (Database Migration Service)?

Within "PostgreSQL Source WAL Heartbeat https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReleaseNotes.html#CHAP_ReleaseNotes.DMS230", what does heartbeat frequency represents? The AWS docs doesn'...
David Han's user avatar
-1 votes
1 answer
536 views

What value to set for MAX and MIN memory of SQL Server hosted on Bare Metal [duplicate]

Within AWS, Many of our Database servers are being migrated from EC2 Instance to Bare Metal. (Correct me, If I am wrong) In Bare metal, there are two memory limits available for the VM hosted on Bare ...
sachin-SQLServernewbiee's user avatar