Questions tagged [aws]

Amazon Web Services.

Filter by
Sorted by
Tagged with
0
votes
1answer
3k views

Mysql Alter table add column with ALGORITHM=INPLACE, LOCK=NONE

Am running below query Query Alter table dbname.tablename add column column1 varchar(50), add column column2 text , ALGORITHM=INPLACE, LOCK=NONE; It takes more time to execute. Ideally running ...
3
votes
2answers
2k views

change character_set_connection utf8mb4 mysql

I want to change character_set_connection utf8mb4. Its showing me utf8. I have follow this https://mathiasbynens.be/notes/mysql-utf8mb4 article and changed [client] default-character-set = utf8mb4 [...
-1
votes
0answers
8 views

how to import aws s3 data dump to mysql

I have a aws s3 database dump and I need to import it into mysql on my local machine. can some one help me with this. thank you.
4
votes
1answer
2k 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 ...
0
votes
0answers
12 views

Percona MySQL Server: Unrecognized network connections

I recently setup a basic two-node master/slave replication database using Percona's MySQL Server version 8.0.25-15, and during testing I ran pt-summary and noticed an IP I don't recognize in the "...
0
votes
0answers
14 views

Intermittent SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'server.here' (110)

I'm suddenly having intermittent 2003 connection errors and I can't find anything that has changed that can explain it. These servers have been running smoothly for years and suddenly two days ago ...
0
votes
0answers
7 views

how to sync one table of AWS RDS to another RDS

I have requirement like need to synchronize one table of data (contain user list) in AWS RDS instance to another RDS Instance. only particular user's table need to synchronize. ex: RDS-1 have schema ...
0
votes
1answer
284 views

What is the difference between Aurora Mysql 5.7.x and Aurora 2.x.x

I have an RDS instance with Aurora Mysql 5.7.12 and I noticed that there are other versions of Aurora Mysql 5.7, but I don't understand what is the difference between them. Some of the version ...
-1
votes
1answer
12 views

How to temporarily disable foreign keys in Amazon RDS Aurora PostgreSQL? [duplicate]

Hi I am using DMS to load data from physical server to AWS Aurora PostgreSQL, but I am getting error for foreign key constraint. I want to disable using any sp / function. Could you please help me?
0
votes
1answer
366 views

Replication external Master to RDS Slave: Connection issue

I am trying to set up replication between my external database (master) to an AWS RDS database (slave). Both are MySQL 5.6. Please don't mark this as a duplicate. I know others have asked a similar ...
0
votes
0answers
10 views

Local SQL server replication to AWS RDS

I have a local licensed SQL server, I need to have an online replica for one of the local databases I have been reading and checking Amazon Web Service (AWS). I tried to do SQL Server Replication ...
0
votes
1answer
1k views

Access or modify tnsnames.ora on AWS Oracle RDS

I have an Oracle RDS instance running on AWS and I need to access the tnsnames.ora file and check its configuration since I am getting this error Caused by: oracle.net.ns.NetException: Listener ...
0
votes
2answers
52 views

database changes are lost in the next session

We just move to Amazon RDS. Now all the CREATE, UPDATE, and INSERT commands are reverting in the next session. All the tables are InnoDB and query caching is on. What could be the problem?
6
votes
3answers
6k views

SSL connection to AWS RDS Postgresql instance from windows client

I am trying to connect to a PG instance hosted on AWS RDS using a secure SSL connection. Where do I store the public key on windows so that it is automatically applied to the connection? Please note ...
1
vote
4answers
2k views

MongoDB: Server sockets closed after a few minutes

I am working with multiple AWS intances connected to the same MongoDB database (inside Compose.io Elastic deployment). But i am getting the error server <url>:<port> sockets closed after a ...
1
vote
0answers
31 views

Any thoughts on what crashed my database?

A few days ago, our database server, (see specs below), spiked to 4800% CPU usage. The database is about 100GB. For 3 hours we tried to figure out what the issue was. We finally figured out a feature ...
0
votes
1answer
106 views

My Galera Cluster does not connect across AWS regions

I am building a MariaDB Galera Cluster, on AWS, EC2. Using MariaDB 10.5 and Galera 4. I have two nodes in the California region, named galera_ca and galera_ca2, and a third node in Oregon name ...
0
votes
1answer
96 views

Snowflake/S3 Pipeline: ETL architecture Questions

I am trying to build a pipeline which is sending data from Snowflake to S3 and then from S3 back into Snowflake (after running it through a production ML model on Sagemaker). I am new to Data ...
0
votes
1answer
1k views

Script to install Oracle client 12c2 on Redhat linux 7.5

Can someone help me to provide a script which I can use to install the Oracle client as part of the server build or AMI. Below script I was able to pull out from the guide in the Oracle site. But ...
0
votes
0answers
55 views

psql connects to AWS RDS instance for co-worker, but not for me

We're on an EC2 VM (the same EC2 VM on the same subnet as the RDS instance) running vanilla PostgreSQL 12.5, and using psql to connect to an AWS RDS PostgreSQL 12.5 instance. My co-worker and I run ...
0
votes
0answers
23 views

Aurora I/O IOPS vs Billed Volume IOPS

Here is a AWS Aurora PostgreSQL 12 database. The database is an r5.4xlarge and average load is ~16. Over 3 hours, the average "Write IOPS" was 40,000 and the average "Read IOPS" ...
1
vote
2answers
1k views

AWS RDS MariaDB replication to GCP Cloud SQL or Azure SQL DB

For disaster recovery, I need to replicate an Amazon Multi-AZ RDS instance currently using MariaDB to a different platform like Google Cloud Platform or Azure. If AWS is down for more than 30 minutes, ...
0
votes
1answer
129 views

AWS Aurora Mysql different instance types for writer/reader

I have a db.r5.large for the master/writer. I want to add some readers. Do they need to be the same instance type as the master? Or can i add for example 3x db.t3.medium ?
0
votes
0answers
8 views

AWS glue - load data by a dynamic condition

I have a concern to apply AWS Glue to my project for below case to see is it possiple on Glue -I have a AWS RDS Postgresql db and a Resdhift DW -I want to load data from Postgresql to Redshift but not ...
1
vote
0answers
12 views

Container is running beyond physical memory and killed on request (code 143) [closed]

I ran a query which involved a JOIN and an AVG operation: SELECT AVG(user_amount) AS average_user_per_game FROM ( SELECT start_time ,end_time ,COUNT(DISTINCT ID) AS ...
4
votes
2answers
655 views

Postgres "session variables" kludge on AWS RDS

I am trying to migrate a PostgreSQL database to AWS RDS. The problem I ran into was that the database in question makes extensive use of the SET kludge.variable TO 'foo' hack, that is, it uses the ...
0
votes
1answer
80 views

Postgres Database flagged as STORAGE FULL whereas there's 45 Gb available

I will start this post by stating that I am not very experienced in database administration, please accept my apologies for any unclear explanation you may find below. We have a replica postgresql ...
0
votes
1answer
306 views

Mongo slow startup after upgrade to 4.2.5

I have upgraded the MongoDB replica set, which consists of 3 members, from 4.0.11 to 4.2.5. After upgrading, startup lasts about 5 minutes. Before upgrading it was instant. It is related to ...
0
votes
1answer
430 views

Master slave replication with different mysql version is on both slave and master

Currently, we have MySQL master-slave replication. Both master and slave servers have Mysql 5.5 Currently I need to add one more Master server having version 5.7. Is it possible to add Multiple ...
0
votes
0answers
29 views

Remote Nodes is not detecting in cluster validate configuration in sql server 2019

I am not a professional DBA. In my organization, we are trying to implement active active node always on clustering. We have 2 nodes, primary and secondary. After installing WSFC, and during ...
0
votes
2answers
288 views

Create a New AWS RDS Instance of only one database from a snapshot

I'm trying to Create a new AWS RDS SQL Server instance of only one database from a snapshot. I've gone through the AWS documentation, but according to it when I restore from a snapshot it will create ...
0
votes
2answers
596 views

AWS KMS Encryption enable for SQL Server Columns?

Is it possible MSSQL on EC2 with a key in AWS KMS to encrypt columns
0
votes
1answer
103 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. ...
1
vote
1answer
322 views

How to tell if I'm connected to an Amazon Aurora PostgreSQL cluster?

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
2k views

Why are my postgres logical replication workers crashing after syncing a certain amount of data?

I am trying to setup a logical replication between two postgresql 12 DBs run in Docker containers on AWS ECS. I gave the task 2 vCPU and 6 GB of ram so quite luxurious for a DB with ~1e7 rows in two ...
0
votes
0answers
24 views

RDS PostgreSQL -> aws_lambda.invoke error: 'Unable to connect to endpoint'

SELECT * FROM aws_lambda.invoke( 'arn:aws:lambda:us-west-2:123456789012:function:spark-ods-lambda-preprod-myETLTest', '{"body": "Hello from Postgres!"}'::JSON, 'us-west-2', ...
1
vote
1answer
106 views

AWS iops vs disk iops?

Recently devops guy from our company told me that our local mysql stage environment are much faster than aws, because local disk has 10k iops, but our aws rds has only 500 iops. As far as I ...
0
votes
1answer
377 views

Is it possible to spin up a free development / test instance of an AWS Redshift server to run test queries on?

I have a traditional MS SQL Server background and am interested in looking into AWS Redshift. Microsoft offers a free download of their development version installer of SQL Server, and I was wondering ...
1
vote
1answer
125 views

Copy postgis layer from S3 to Heroku

I have a dump of a postgis layer (layer.dump), which I am trying to add to my heroku database (mydatabase). The postgis layer is stored on S3 (https://s3.amazonaws.com/layer.dump). I would like to add ...
3
votes
1answer
4k views

AWS RDS responds with (Got an error reading communication packets). Works locally

I've been on this issue for a couple of days now, I will cover things I've tried at the end. So I'm running a NodeJS server from a GitHub repo using netlify-lamda. I am connecting to an Amazon RDS (...
0
votes
1answer
287 views

Debuging import of a large dump file to MySQL

I'm trying to import a 50GB dump file to AWS RDS instance and have an issue. I get the following error: ERROR 2013 (HY000) at line 15850: Lost connection to MySQL server during query In the beaning ...
2
votes
2answers
225 views

website performing slow once mysql connection RDS reached 50

Below the rds parameter group config, please help me to resolve this issue. I am using 4 web server having 2 CPU and 8 GB ram and rds having 4 cpu and 16 GB ram. Once the connection reached 50 site ...
0
votes
2answers
302 views

Give third-party access to AWS hosted MySQL

I have a production MySQL database hosted on AWS for an eCommerce store I work with. Employees in the firm are requesting access to our live SQL database to use with BI tools like Tableau/Qlikview. ...
0
votes
1answer
2k views

Change in bind_ip value is not reflecting

I have mongo installed on Centos instance in AWS and I am connecting to the mongoDB server from my system. To connect from remote system we need to change bind_ip value to 0.0.0.0 in /etc/mongod.conf ...
0
votes
0answers
15 views

Timestamp is off by an hour When Migrating from Mysql to Sql server AWS DMS

We are trying to migrate a MySQL database on AWS RDS to SQL Server Database on AWS. Both the Source and Target Database are created in PST Time zone. Replication Instance Version : 3.4.4 Mysql Version:...
0
votes
1answer
827 views

Schema replication Postgresql AWS

Is there a way to replicate Postgres Schemas in AWS into one location for reporting purposes? I have 3 postgres databases (up to date with current version) running in AWS that I would like to ...
1
vote
2answers
136 views

GRANT permission ON database TO user not working on AWS

I'm having trouble granting a user permission on AWS. mysql> GRANT CREATE ON *.* TO 'hmrex_db'@'%'; Query OK, 0 rows affected (0.01 sec) mysql> SHOW GRANTS FOR 'hmrex_db'@'%'; +----------------...
1
vote
1answer
2k views

AWS RDS mysql deadlock

Everything in our production environment was working well. Yesterday, suddenly out of no where we were getting "lock wait" on any transaction related to a specific row. Same transaction on another row ...
2
votes
1answer
542 views

Should I switch my database LOG volumes from IO1 to ST1

I've got a SQL 2014 database that's been running in AWS for a couple of years now, in a dual-server mirrored configuration, using separate EBS volumes for data, logs, etc. When the system was created,...
2
votes
1answer
46 views

Backup TO URL S3

Can I do a SQL backup to AWS S3 URL from an EC2 machine I know that Azure side is possible but I do not know if it is possible AWS side thank you for your advice

1
2 3 4 5
9