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
63 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
4k 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....
4
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
260 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
684 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
95 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
447 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
19 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
1k 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
38 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
57 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
139 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` ...
2
votes
2answers
1k 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 ...
3
votes
1answer
854 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
483 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
1k 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
530 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
40 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
79 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
492 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
845 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
394 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
430 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
4k 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
289 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
341 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
440 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
3answers
497 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
2k 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
176 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
615 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
1k 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....
2
votes
1answer
1k 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
146 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
461 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
121 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
410 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
52 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
441 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
54 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 ...
1
vote
0answers
280 views

MySQL denied user from SELECT

I have a MySQL database running on AWS RDS. I also have a process which runs a SELECT query from a server called SOME_EC2. "SELECT command denied to user 'myuser'@'SOME_EC2_HOSTNAME' for table '...
10
votes
1answer
4k views

Why do I get a PostgreSQL permission error when specifying a tablespace in the “create database” command?

When I create a database in PostgreSQL without explicitly specifying a default tablespace the database is created without issue (I'm logged in as the pgsys user): postgres=> create database rich1; ...
1
vote
1answer
37 views

Guideline for MySQL free space

What is the guideline for how much free space to keep available on a MySQL AWS RDS instance (SSD)? In the past for an on-premises SQL Server install we used to use something like 2x the largest table ...
0
votes
2answers
86 views

Multiple DB restore in sequence

I am restoring several MariaDB databases into a Amazon AWS RDS MariaDB instance from an AWS EC2 machine in the same VPC / region etc. I am using a shell script like so: mysql -u root -h hostname....
4
votes
1answer
792 views

Why RDS PostgreSQL `MaximumUsedTransactionIDs` not decreasing even after data base seems correctly `VACUUM FREEZE`'d?

My MaximumUsedTransactionIDs seems to keep growing indefinitely, but I have these evidences hinting me it maybe should not be happening that way: $ PGPASSWORD=$MY_USER_LAND_RDS_SUPER_USER_PASSWORD ...
1
vote
1answer
336 views

After adding indexes to an AWS RDS MySQL DB getting huge/crippling spikes in IOPS

So after looking at the production database, I realised that several queries were running utilizing no indexes at all, and as such, were row-scanning close to 4 million rows. :/ I added the required ...
0
votes
0answers
245 views

Migrating on-prem MySQL 5.5 databases to AWS RDS MySQL 5.5

Migrating on-prem MySQL 5.5 databases to AWS RDS MySQL 5.5 Background Information: I have a MySQL 5.5 dump. I have migrated the same dump to an EC2 instance and it worked. I did restore to EC2 ...