Questions tagged [aurora]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
13 views

Question marks instead Hebrew characters after mysql dump and import

I tried to migrate my AWS RDS instance from Aurora to MySQL. I created a dump file from the Aurora and imported it into the MySQL instance. Both instances have the same characters set. mysql> ...
0
votes
0answers
15 views

Apply a DDL statement with zero downtime with Aurora Mysql

I have an Aurora Mysql 5.6.10a db cluster with one master and one read, that I need to apply a migration to with near zero-downtime. I'm trying to get a comments field to accept emojis by updating ...
0
votes
1answer
27 views

Is it possible that information_schema.columns doesn't hold an user table column information?

I am facing a strange issue here. I have a table which is not visible in information_schema.columns view. What could be the reason for that. Note: I am using RDS Aurora Postgresql 9.6.12
2
votes
0answers
40 views

Error in ALTER DEFAULT PRIVILEGES

I'm trying to create a new user in AWS Aurora Postgres DB. Create user worked fine and I can login to the DB using that account. granting permissions to it isn't. First: GRANT ALL on ALL tables in ...
0
votes
1answer
79 views

Aurora PostgreSQL CPU usage stuck at 100% for 8 hours

One of our Aurora PostgreSQL database's(48 cores) CPU usage stuck at 100% for nearly 8 hours. These situation happened 3 times in the past 4 months. We are using AWS's business support plan, in the ...
0
votes
0answers
35 views

Cannot connect to RDS Aurora Mysql Database Even Though It Exists

We have an RDS aurora mysql instance that has been up and running for a while without issue, however, today our application's connection to the db failed, with error ERROR 1049 (42000): Unknown ...
1
vote
1answer
34 views

Should I add my index after the table is populated or before (MySQL. Aurora)

I know this has been asked in the past, but sometimes things change over time and I wanted to double check. I have a table with about 9 Billion rows. Should I add the index before inserting the data ...
1
vote
0answers
198 views

Difference between Aurora Global database and Aurora regional database with multiple read replicas?

I am planning to migrate my 300GB RDS PostgreSql database to Aurora MySql using SCT and DMS. RDS Postgresql is in seven regions in current setup. Datapipelines are used to ingest data in these ...
0
votes
1answer
71 views

Aurora postgres grant permission to pg_attribute

In the process of migration from local postgres version to and RDS aurora postgres version. I'm using temporal tables and do for that reason have temporal tables that are inhirited from the origin. ...
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
1answer
27 views

Is it possible to commit a transaction that is waiting to RollBack?

I'm using Aurora MySql 5.6.10a and a query that was loading a table with 700 million rows crashed and now it's rolling back. I turned autocommit off to try to speed the data load up, but now it's ...
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
16 views

aurora postgresql logs

We are in the process of sending logs of Aurora PostgreSQL to a SIEM log management solution. However, there doesn't seem to be a option to publish Aurora PostgreSQL to Cloudwatch log group. Is there ...
0
votes
1answer
526 views

How can we publish Aurora (Postgres compatible) logs to Cloudwatch?

I'm looking for a way to publish Aurora (pg compatible) db logs to cloudwatch. In Postgres RDS, there is an option when we "modify" the instance to enable publishing db and upgrade logs to cloudwatch,...
1
vote
1answer
208 views

Recommended postgres parameters for index creation with 244gb RAM and 32 CPUs?

I have a 200 GB database with 26 tables that I need to create indexes on. Currently index creation takes a long time on the biggest tables, as they have ~12gb and 400,000,000 rows in them (>4 hours)....
0
votes
0answers
29 views

Amazon Aurora Cross Region Replica Not read only

I am doing a cross region replica of an aurora 5.6 database. When I connect to the reader end point I can still edit. For read_only the value is {TrueIfReplica}. If I change it to 1 it is then read ...
0
votes
0answers
72 views

Amazon Aurora Single vs multi az deployemnt

I am looking to switch from mysql rds to aurora rds. Right now I use mysql multi-AZ. When reading about Aurora I noted that the storage layer is stored in 3 AZ's. If an aurora instance fails the time ...
0
votes
1answer
1k views

Are the MariaDB and MySql drivers interchangeable when connecting to a MySQL backend Aurora cluster?

I saw a similar question asked before but I didn't get enough supporting information Does anyone know any new information on this? Can MariaDB connector (driver) be used instead of the MySQL ...
6
votes
1answer
828 views

What is the apgcc schema in Amazon RDS Postgresql?

Recently a mysterious new schema called apgcc appeared in every database in our testing Aurora Postgresql cluster (eu-west region). It is owned by the rdsadmin account. What is it, and where did it ...
1
vote
1answer
369 views

migrating from a local PostgreSQL database to Amazon Aurora

I have a local PostgreSQL database and I want to migrate it to Amazon Aurora, how do I do that? I found a documentation on how to migrate from RDS PostgreSQL database, however, mine is local and I ...
0
votes
1answer
784 views

Error log flooding with aborted connections (Aurora 2.03 - MySQL 5.7.12)

Here's some contextual information: I have a multi-tenant, WordPress MU installation running on Elastic Beanstalk, scaled up to 2 instances minimum. These are connected to the RDS database and are ...
1
vote
1answer
1k views

Is Postgres sharding available on Aurora (AWS)

I need to shard and/or partition my largeish Postgres db tables. The Postgres partitioning functionality seems crazy heavyweight (in terms of DDL). I see talk from <=2015 about pg_shard, but am ...
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
533 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 ...
3
votes
0answers
1k views

Why is Insert-Ignore so expensive in MySQL?

TL;DR: Inserting a large number of rows with no collisions is MUCH faster than (not) re-inserting the same rows, BOTH using the INSERT IGNORE syntax. Why is this? I would assume that the index lookup ...
1
vote
0answers
329 views

How do you capture blocked transactions

I can run SELECT r.trx_id waiting_trx_id, r.trx_mysql_thread_id waiting_thread, r.trx_query waiting_query, b.trx_id blocking_trx_id, b.trx_mysql_thread_id blocking_thread, b.trx_query ...
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; ...
0
votes
1answer
87 views

How do I truncate performance_schema tables on a read replica?

On occasion, you have to truncate events_statements_summary_by_digest, when it's hit the row limit. On a write master, this is easy, but on a read replica, there doesn't seem to be a way to do it. The ...
1
vote
1answer
3k views

Necessity of having two instances (Reader and Writer) in Amazon Aurora

I'm managing an Amazon Aurora account. Somebody set it up months ago. The service has TWO instances (same AZ): - project - project-eu-central-1b Same class (db.t2.small), but different "Replication ...
3
votes
1answer
774 views

SELECT COUNT(*) returning incorrect results

I am seeing some very strange behavior on PostgreSQL 9.6.3 on RDS Aurora. I am getting duplicate results from certain queries: => select count(id) from foos where id = 'deadbeef'; count ------- ...
4
votes
1answer
4k views

How to enable force ssl on AWS Aurora Postgres?

In AWS's direct postgres offering RDS Postgres, you can require SSL by setting the parameter group item rds.force_ssl to 1. This is as per the RDS postgres documentation: https://docs.aws.amazon.com/...
1
vote
1answer
221 views

Amazon's Aurora PostgreSQL

I've created few different instances, one instance is of Amazon Aurora PostgreSQL and other instances are of PostgreSQL, MySQL etc. How do I find our the Postgres instance is running within an AWS ...
1
vote
1answer
112 views

I can not find any document regarding to shared_heap_size

I am new to Postgres and recently I ran one command show all; It returned me a csv file with three columns name, settings, description. There are more than 200 results and out of which one result is ...
2
votes
3answers
162 views

MySQL Why is updating 0 rows slow?

Update: The where clauses are the same. The results are as outlined below. The following query runs within 0.1s and returns 0 results. SELECT id from content WHERE compliance_overridden = 1 AND ...
1
vote
0answers
59 views

How to find queries that use a given index for mysql?

I am looking to change indices on my MySQL table. My hunch was that one of the indices, that I am looking to remove, shouldn't be used. But it is being used, based on ...
0
votes
1answer
40 views

Single slave for multiple masters in AWS AuroraDB

We are planning to use AWS Aurora(MySQL version) as our relational database. There will be three masters in different regions. We need the data from these masters replicated in a single slave. I think ...
3
votes
0answers
2k views

RDS Aurora 5.6 died (randomly?)

Aurora MySQL 5.6.10a I can see these events in the console: February 20, 2018 at 4:27:24 PM UTC+11 <server>-production DB instance restarted February 20, 2018 at 4:26:52 PM UTC+11 <server&...
1
vote
2answers
802 views

mysql access denied from localhost

I've a very weird problem on mysql/Aurora 1.14 I have installed on a Linux EC2 instance on AWS. I have an user able to connect remotely to the instance but not locally. select user,host from mysql....
1
vote
1answer
164 views

Migrating from MySQL RDS to Aurora RDS with CNAME record

I understand migrating to Aurora is simply a matter of creating read replica from MySQL source and then promoting when caught up and stopping writes on MySQL RDS previous master. I use Route 53 DNS ...
0
votes
1answer
67 views

Amazon Aurora MySQL conditional comment queries

How does Amazon Aurora handle conditional queries based on MySQL version? I was unable to find any documentation on this. For example, the code below inserts into a database for MySQL 5.6.4 or newer. ...
0
votes
1answer
936 views

Cannot connect to Aurora RDS using workbench over ssh

I set up an environment on AWS that consists of a VPC with a private and public subnet following the instructions for Magento Quick Start: http://docs.aws.amazon.com/quickstart/latest/magento/...
0
votes
1answer
212 views

Amazon Aurora MySQL5.6 Performance Schema column datatype modified and can't be corrected

I'm having trouble getting performance_schema to work in a few of my Aurora instances. Brand new instances where I enable performance_schema work just fine, but several instances that I've had for ...
1
vote
2answers
10k views

How to avoid lock wait timeout exceed and improve MySQL InnoDB write speed

I ran a multi-threaded client spawning 25 threads to make concurrent API calls and insert data to AWS Aurora server. After some time, I started to see timeout error: lock wait timeout exceeded try ...
0
votes
1answer
351 views

Convert Code from SQL Server to MySQL [closed]

What will be the MySQL code for below code in SQL Server. SELECT @cols = STUFF((SELECT ',' + QUOTENAME(col+cast(rn as Nvarchar(max))) from ( SELECT row_number() over(partition by ...
0
votes
1answer
310 views

percona-online-schema-change is taking a lot of time

We have a table with 600M+ records and using AWS Aurora with master-slave replication. Requirement: We need to add two columns with index in customer table. Aurora Instance Specs: Ram: 30.5 GB ...
2
votes
1answer
62 views

How to optimize this select with join and order-by?

We have two tables: CREATE TABLE `messages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `created` int(10) unsigned DEFAULT '0', `user_id` int(11) DEFAULT '0', .... `subject_id` int(11) unsigned ...
3
votes
1answer
4k views

Stale table lock in AWS Aurora?

We have an AWS Aurora (MySQL engine, r3.large) we are using to test a migration. We have noticed a couple of queries that simply don't appear to run. When I run show engine innodb status; it ...
2
votes
1answer
2k views

MySQL default wait_timeout is 28800 but in my server I can see more than that value

Im using AWS MySQL Aurora, the current wait_timeout is 28800 which is the default one, and interactive_waitimeout is also 28800. But I can see more than the default value.
0
votes
1answer
305 views

What are the advantages of going with AWS aurora DB with Mysql backend over AWS aurora DB with Postgresql backend [closed]

What are the advantages of going with AWS Aurora DB with Mysql backend over AWS Aurora DB with Postgresql backend? It's great if someone can share your experience or point out a document.