Questions tagged [amazon-rds]

Amazon Relational Database Service is a web service that makes it easy to set up, operate, and scale a relational database in the cloud.

Filter by
Sorted by
Tagged with
1
vote
1answer
535 views

What is the optimal setting for innodb_buffer_pool_instances for a mid level AWS RDS server with 6gb buffer pool?

We have a MySQL 5.7 AWS RDS instance running on a db.m4.large instance. The basic resources for that instance type are: 7.5gb RAM 2 VCPU RDS defaults to a calculation that allocates 75% of RAM to ...
0
votes
1answer
46 views

“Could not find server error” when using INSERT SELECT statement in SQL Server

I'm trying to copy a record from a production database table into a staging database table. They are both SQL Server databases on Amazon RDS. My query looks something like this: INSERT INTO [...
1
vote
0answers
477 views

Linked server from SQL server on AWS RDS to On premises Oracle database

We are planning to migrate an on-premises Microsoft SQL server database to AWS RDS SQL server. Everything is good except one roadblock, i.e this SQL server database has a linked server to on premises ...
1
vote
0answers
20 views

User / Client IP restrictions in Postgres running on RDS

I'm looking to restrict connection access for specific accounts based on the client IP. All of our services are running on AWS so I want an account that has R/W permissions to only be able to connect ...
2
votes
1answer
555 views

Temporarily disable indexes before updating whole table

For testing purposes I periodically restore production backup into a new database (AWS RDS PostgreSQL instance) with pg_restore. In the new database I run SQL queries that anonymize sensitive data. ...
1
vote
1answer
28 views

How does an encrypted DynamoDB (the same question applies to RDS as well) query work?

I am trying to understand whether the primary key is encrypted when I choose to encrypt in rest for AWS DynamoDB If the primary key is encrypted, how does a primary-key look up get performed under ...
0
votes
1answer
24 views

MySQL how to migrate to new server without data lost?

I'm using AWS RDS, with 1 master & 1 slave. Just now I alter 1 of the table and hangup halfway, so I force stop the process. Now the database got some problem. Let say I wanted to instantiate a ...
1
vote
1answer
56 views

Is there any AWS RDS Utility to Manage Master Slave mysql db with read write splitting?

I am looking for a solution for production which can manage the read and write splitting on master and slave connection as i can't affford to define multiple connection string for R/W in whole ...
1
vote
2answers
2k views

enabling BINARY LOG on AWS RDS MySQL

Context I am trying to enable BINARY LOGs on a MySQL RDS instance. Issue I used CALL mysql.rds_set_configuration('binlog retention hours', 24) without encountering an error. And using CALL mysql....
3
votes
1answer
1k views

Postgres 9.4 wal_level=logical increases disk space

I am trying to use the AWS Database Migration Service to migrate data from an RDS Postgres instance to an Aurora MySQL instance. Database Migration Service requires the wal_level to be set as logical ...
2
votes
0answers
204 views

AWS RDS PostgreSQL - Managing Permissions

Relatively new to AWS RDS PostgreSQL environment. We are creating a database with multiple schemas. Users are grouped by "schema_role" that have privileges to create objects in assigned schemas. My ...
2
votes
2answers
478 views

Database Mail on Amazon RDS / SQL Server

Since Database Mail is not supported on Amazon RDS with SQL Server, can anyone offer any suggestions on how to send e-mail notifications for failed SQL Server jobs in Amazon RDS? Thanks in advance ...
1
vote
1answer
77 views

Migrating PostgreSQL DB from AWS to Alibaba Cloud

I'm migrating PostgreSQL RDS instance from AWS located in Frankfurt to the RDS instance in Alibaba Cloud also located in Frankfurt. I use Data Transmission tool from Alibaba Cloud. It connects both DB ...
3
votes
0answers
322 views

AWS RDS postrgres massive disk use, small tables

I can't figure out why our AWS postgres server has consumed all of it's space. We just had to up the storage space allocated to it, but can't find any hint from postgres that it's using that much ...
1
vote
0answers
18 views

Can I do profiles of an Oracle RDS instance on Amazon?

Is there any way to get histories of queries from a 3rd party application to an RDS Oracle instance? We have a DB with less than a million rows, and we are running some queries through a 3rd party ...
2
votes
1answer
801 views

PostgreSQL - can I use logical replication from a replica's WAL?

I would like to use logical replication. However, as PostgreSQL works now, it can eat up the whole disk and then block the database. Especially in Amazon Web Services RDS, this is a problem because ...
0
votes
1answer
36 views

One SQL Server RDS instance plus one Ubuntu instance cost money on my initial free trial year [closed]

Why do I get charged when I only have one micro instance running as Ubuntu and another one a RDS. Does the extra RDS count as a separate instance? My RDS is Microsoft SQL Server exchange which should ...
0
votes
1answer
27 views

Some dates replicated with a +4 offset

I've set up replication between an EC2 instance as master and a MySQL 5.5 RDS instance as slave. Everything is (mostly) fine except for one odd thing: the dates in a transaction table are either ...
2
votes
0answers
49 views

Query store works in dev, but not production in Amazon RDS

I'm having an issue getting query store to collect and record data on our production workload, however, it works as expected on our non-production instances (development and staging). The only ...
0
votes
1answer
87 views

MySQL create index in 1B rows table

We're trying to add an index to one of our tables in production database. CREATE TABLE `abcd_s3_metadata` ( `rowId` bigint(20) NOT NULL AUTO_INCREMENT, `sId` varchar(50) NOT NULL, `ruid` ...
1
vote
2answers
994 views

Failure with ongoing replication from SQL Server RDS using AWS DMS

I'm trying to replicate from an SQL Server RDS database using DMS, and running into problems. I am able to load all data from one table into the destination (~1M rows) as a single 'Migrate existing ...
2
votes
1answer
654 views

How to install cstore_fdw inside RDS postgres 9.6

cstore_fdw is foreign data wrapper for columnar storage for postgresql. I want to install it inside RDS postgre 9.6 instance. Is it possible to install inside RDS instance? Thanks
2
votes
1answer
374 views

What are the downsides of using PARTITION for multi-tenant access?

We have an RDS Postgres database which keeps individual store data in a common schema with a field called store_id to distinguish between stores. Let's say we have 1MB per store and 10k stores so we'...
2
votes
2answers
820 views

Aurora MySQL 5.7 randomly fails

This is the 5th time. It happens once a week (Tuesday or Wednesday within 03:00-07:00 UTC+0). On the console, it shows available but inaccessible. We try to wait if the instance will recover itself, ...
1
vote
2answers
439 views

MySQL tuning: INNODB_BUFFER_POOL_SIZE not found?

My replicator MySQL db, hosted by Amazon-RDS-Aurora is performing poorly. The DB is quite powerful so performance shouldn't be an issue. When I executed SHOW VARIABLES; I could not find ...
0
votes
1answer
36 views

MySQL- reducing memory footprint

Our InnoDB/Mysql5.6 database is growing at a fairly steady pace of doubling in size every year, currently at 22Gb. This is sales data; we have a number of merchants each generating millions of rows, ...
1
vote
1answer
69 views

PostgreSQL - automating database grants [closed]

We're managing about 200 instances of postgres on Amazon RDS. The problem that we're constantly experiencing is that our "DBA" accounts can't access stuff. Basic stuff. Tables, views, etc. Is there ...
0
votes
0answers
402 views

AWS RDS MYSQL SP Privileges Issues (Error Code: 1227)

I have created SP in RDS-MYSQL with the user of abc. Now, I want to update from user xyz but its giving me message: (Note: Both user have full access on db) Error Code: 1227 Access denied; you need (...
3
votes
0answers
554 views

Why am I getting permission denied on an ownership change?

My current user is pronto mediapop_staging=> select current_user; current_user -------------- pronto (1 row) This user a standard super user created on AWS RDS. mediapop_staging=> \du ...
1
vote
1answer
335 views

Are read replicas heavy reading in affect masterDB?

We have a very heavy load in Read side with large DB tables in 2 hours per day that affect to Db so as solutions I have created read replica for it. If application fetches large heavy data on read ...
1
vote
2answers
392 views

How to simulate production workloads on a dummy database?

We are planning to enable Multi AZ on our production database which uses Amazon RDS as a managed service. Our Database is using SQL Server 2012 standard version. Before enabling that, I wanted to ...
6
votes
2answers
2k views

Does ALTER TABLE - ADD COLUMN lock the table?

I have a question about the ALTER TABLE ... ADD COLUMN DDL statement. On a Amazon RDS instance with MariaDB v10.2, I've noticed that INSERT statements complete and the rows are correctly inserted in ...
1
vote
2answers
193 views

Deleting old data in MySQL becomes slower over time

I have an application running on Amazon MySQL/RDS that needs to maintain 2 weeks of transactional history after which time data can (usually) be purged. Because this isn't a hard rule I cannot use ...
1
vote
2answers
1k views

DBMS_DATAPUMP error: The current API cannot be executed because of inconsistencies between the API and the current definition of the job

I'm trying to do an impdp on a Amazon RDS Oracle instance using DBMS_DATAPUMP. I'm following the steps described in the Amazon RDS guide (Importing Data into Oracle on Amazon RDS). I've already ...
2
votes
3answers
260 views

How to set space usage alert for database using SQL Server 2012 with Amazon RDS as managed service?

I have a database whose initial size is set to 1000 GB. Is there a way where i can set an alert when the max space is used and database size is nearing to 1000 GB, for eg when it reaches maybe 995 or ...
0
votes
0answers
341 views

SQL Server RDS master user disabled

I've inherited a SQL Server Web Edition RDS instance from another firm whereby they took a snapshot and then shared it with our firm's RDS account. After reinstating the instance under our account, ...
1
vote
2answers
401 views

Significantly Slower DB Dumps on AWS RDS After Turning on Encryption?

Turning on encryption on an AWS RDS MySQL instance results in significantly slower database dumps (using mysqldump). mysqldump -u test -p -h xxx.aws.com > dump.sql Is there a reason for ...
0
votes
3answers
1k views

Slow query while using DISTINCT in MYSQL with various other conditions (10 million records)

I am working on a social Network where, as usual there is a feed for users where they are able to see the activities of users a user is following and not the users who are blocked by the users. This ...
2
votes
0answers
152 views

understanding mysqlslap concurrency

I have a RDS instance running in AWS. By default max_connections=45 so I used mysqlslap to see how it works. I ran: mysqlslap --concurrency=20 --host=deleteme.ckn5fsf3nwqp.ca-central-1.rds....
1
vote
1answer
430 views

MySQL - admin user is able to change password of the super user

I am new to MySQL administration and hence this question - I wanted to create a MySQL admin user who wasn't the super-user. I assumed Amazon RDS MySQL community server will be a good template to work ...
4
votes
4answers
997 views

RDS MySQL I/O freeze during backup causes RDS instance to crash [closed]

I have a simple WordPress site using Amazon RDS MySQL 5.6.39 Single-AZ instance. Almost every night during backup window RDS instance crashes and getting recovered causing about 20 minutes of downtime....
1
vote
1answer
834 views

Not a able to kill the DB session in Postgres RDS

We are trying to killing one of DB session but not able to do it. Tried with following command getting "TRUE" after issuing command. Still we can see the session is active. select ...
2
votes
0answers
108 views

Postgresql- how to rotate table partitions, trunc oldest every day?

I need to create a partitioned table with 4 rotating partitions for 4 days, and every day truncate the oldest partition. I know how to create table partitions on postgres, but I can't understand how ...
3
votes
0answers
404 views

What can cause slow planning times for “select 1”?

I have a database that is used by a Production application. It's an db.m3.medium on Amazon RDS. We've noticed that a lot of queries are starting to get slow that typically shouldn't be slow (e.g. ...
1
vote
1answer
117 views

AWS VS Azure , which one is preferable for SQL Server 2012 standard version? [closed]

I want few recommendations while considering azure vs aws for our current database which is SQL Server 2012 standard edition. Currently we are using AWS RDS for managing our database, recently we had ...
-1
votes
1answer
309 views

Allocation of disk space to new created databases in production [closed]

Our current production database has total disk space of 2 TB. (SQL Serve 2012 standard RTM version.) Currently we have database size allocation as attached. Apart from FUNDSDB and DBAdmin, remaining ...
0
votes
1answer
50 views

Using an AWS database that can store more than 65,535 bytes in a row

I have a MySQL Barracuda table with about 150 fields and most of them are TEXT types. If I wanted to store more than 65,535 characters in a row, would it be possible to do so using Amazon's AWS ...
2
votes
1answer
379 views

do single AZ AWS RDS instances self heal?

I'm aware of "multi AZ" databases "auto failing over" if one side goes down. My question is, if you have a single AZ RDS database, and the database box "dies" does AWS automatically spin up a new one ...
0
votes
0answers
51 views

troubleshoot cpu usage mysql

We are running a few Mysql server on EC2 instances and RDS instances on AWS. From time to time they suddenly spike in CPU, and/or memory usage but when we login into the instances, it's too late and ...
4
votes
0answers
1k views

Queries running very slowly in Amazon RDS PostgreSQL read-replica

We have been maintaining a project which has both web and mobile application platform. The backend of the project is developed in Django 1.10 and deployed in AWS. At the beginning, when there were ...