Questions tagged [aurora]

The tag has no usage guidance.

20 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
690 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 ...
3
votes
0answers
1k 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
0answers
223 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 ...
1
vote
1answer
147 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
0answers
50 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 ...
1
vote
0answers
129 views

MySQL partition on 2 tables one with millions of rows the other with 100's of millions

I have two mostly de-normalized tables in Amazon Aurora (MySQL). The first table had mostly dimensions that are used for selecting the proper data. Examples might be station, program name, operator, ...
0
votes
0answers
11 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
0answers
21 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
28 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
0answers
35 views

Aurora Global Database Multi-AZ

When setting up a global database for Aurora I get the following option: Multi AZ: Create an Aurora Replica/Reader node in a different AZ (recommended for scaled availability) Will this create a ...
0
votes
0answers
10 views

Amazon aurora run without read replica?

If my application can run with 10 minutes of downtime on instance crash do I need a read replica for production aurora instance? It is important I never lose data. A read replica would reduce downtime ...
0
votes
0answers
24 views

Disable aurora failover

I will be stopping replication on a reader instance for aurora and want to prevent failover to this reader or any reader in cluster How do I do this?
0
votes
0answers
27 views

estimating I/O for aurora from current mysql rds instance

If I have the following averages over the last 4 weeks for mysql rds instance db 1 77.7 writes/second, 8.54 reads/second db 2 108 writes second, 8.56 reads/second (2629746 = seconds in a month) ...
0
votes
0answers
45 views

amazon aurora read_only {TrueIfReplica}

I have {TrueIfReplica} for read_only in parameter group for Aurora. I setup my aurora to replicate from an external master but it is 0 when I look at read_only in show variables. Why is this?
0
votes
1answer
223 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 ...
0
votes
0answers
111 views

Finding Aurora functions (PostgreSQL)

On Amazon Aurora in the PostgreSQL (10) flavor there is a function names aurora_replica_status() documented. I can use the function and look at its definition: postgres=> select * from ...
0
votes
1answer
55 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 ...
0
votes
1answer
36 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 ...
0
votes
1answer
53 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
811 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/...