Questions tagged [amazon-ec2]

Amazon Elastic Compute Cloud (EC2)

39 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6 votes
0 answers
3k views

Random Spikes in DB Connections - Amazon RDS

I'm running an EC2 instance (c3.large) with an RDS instance (db.t2.small). I'm frequently having issues with DB Connections spikes all of a sudden. PROBLEM: As you can see, I'm getting huge amounts ...
Arjun Komath's user avatar
5 votes
1 answer
4k views

What to do when I get “mysqld dead but subsys locked” in my amazon ec2 micro instance?

I have an Amazon ec2 micro instance that holds a WordPress site. Since yesterday, my mysql db keep crashing saying: [ec2-user@ip-xxx-xx-xx-xxx ~]$ sudo service mysqld status mysqld dead but subsys ...
Arun Antony's user avatar
4 votes
2 answers
3k 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 [...
Bhavin Chauhan's user avatar
4 votes
0 answers
405 views

How to copy SQL Server log shipping files to AWS EC2 instance

I am using SQL Server 2008 R2 and would like to log ship from my local data center SQL Server instance to a log shipping target SQL Server running in AWS EC2. What is the best way to copy the log ...
Pete Lunenfeld's user avatar
3 votes
0 answers
583 views

SSRS 2016 Generates SQL Server log entry daily

First, a bit about our environment. We run two instances of SQL Server 2016 Enterprise (13.0.4435.0) on Windows 2016 Servers. To save money, we run SSRS 2016 alongside SQL Server on both servers We ...
ChrisK's user avatar
  • 43
3 votes
0 answers
1k views

Slony with Amazon's RDS service?

Is it actually possible to somehow use Slony with Amazon’s RDS service? I’m aware that there’s no such thing as a host that you can log into to make Slony’s configurations, but perhaps it can be done ...
Gonzalo Vasquez's user avatar
2 votes
0 answers
4k views

DBeaver connection via SSH tunnel

Using DBeaver, I'm trying to connect to my AWS ec2 instance where I've installed a MariaDB database. I've created a new connection as: Connection: AWS / Maria DB Server Host: localhost (because I'm ...
Tommy's user avatar
  • 121
2 votes
0 answers
200 views

AWS RDS PostgreSQL: Significant query runtime difference between two (identical?) instances

TL;DR: Solution The problem was that one instance hat magnetic storage attached and was therefore significantly slower. Original Question I have two identical AWS RDS PostgreSQL 10.6 databases ...
jurgispods's user avatar
2 votes
0 answers
218 views

AWS - SQL Server Agent "white dot" problem

I'm trying to setup a SQL Server 2016 installation in AWS EC2 and can't seem to get the security group settings right. Please note the "white dot" in the screen cap below - I am unable to administer ...
Peter Vandivier's user avatar
2 votes
0 answers
579 views

InnoDB IO Capacity on Amazon AWS EBS GP2 Volumes

I have MariaDB pointing to a data directory that's a mounted Amazon AWS EBS GP2 volume. No other process will be using that volume. The AWS console lists the volume as having 120 / 3000 IOPS. My ...
Sonny's user avatar
  • 143
2 votes
0 answers
38 views

Migrating EC2 SQL Server to HyperV On Premise

I'm wondering if any of you have migrated SQL servers from EC2 to on-premise? I'm toying with doing backup and restore on new onprem server, however the file copy test took over 24 hours. Given that I'...
Trisha Laich's user avatar
1 vote
0 answers
89 views

Connecting to SQL in docker in EC2 becoming slower

I am now running a PostgreSQL inside a Docker inside a EC2, and a Node.js instance is connecting to it. I recently found that the connection is becoming slower. Before, restarting the instance only ...
Terry Windwalker's user avatar
1 vote
0 answers
262 views

Calculating IOPS in a SQL Server EC2 - RDS migration

I'm evaluating costs for a possible migration of a SQL Server that is currently running on Amazon EC2 to Amazon RDS. On the EC2 instance I have six volumes, described as follows: type size IOPS gp2 ...
Gerardo Filho's user avatar
1 vote
0 answers
373 views

What would cause slow disk access on an AWS EBS SQL Server? (PAGEIOLATCH_SH)

I have an EC2 instance (r5a.4xlarge) which should be able to do 2Gbps+ in EBS access. This machine has a 7TB mounted gp2 volume, with 16,000 IOPS, which is mounted and contains a SQL Server database ...
user113242's user avatar
1 vote
1 answer
105 views

MySQL cpu at 400% on c5.xlarge box

Box is running only mysql and CPU is at 400% constantly. I can't seem to find anything that would be causing it. I've changed a few values in my.cnf based on some research, but had no luck reducing ...
user avatar
1 vote
0 answers
591 views

Unable to connect to postgresql EC2 instance from VPN

I have an EC2 instance of timescaledb running on AWS. For security purposes, my team members and I are using OpenVPN so that we have access to it and the same IP address has been defined in the ...
reinhardt's user avatar
  • 111
1 vote
0 answers
173 views

Mongodb is taking almost 100% of CPU

Good Morning, I have installed MongoDB on an EC2 machine with 2CPU. At the first time when I SSH Login I See this error message, System information disabled due to load higher than 2.0 However, ...
Ahmed Ibrahim's user avatar
1 vote
0 answers
170 views

Cassandra slow read performance after migrating to new AWS instance class

Cluster of 3 cassandra nodes as a dev environment. Used to run in AWS on i3.2xlarge; migrated as a test to i3en.2xlarge to evaluate for later migrating production cluster to. When running cassandra-...
user5416's user avatar
1 vote
0 answers
515 views

Mongodb won't start after adding 2nd net option to mongod.conf file

I try to add another net with the its corresponding bind ip and port to my AMI ec2 mongod.conf file so I will be able to create a 2 node replica set but when I run the command "sudo service mongos ...
tom dinh's user avatar
1 vote
0 answers
337 views

SQL Server with peer-to-peer replication migration from on-prem to AWS EC2 instances

I need to move three on-prem servers with peer-to-peer replication to AWS. SQL Server version is 2012. The AWS SQL Server will be on EC2 instances as the SQL Server RDS doesn't support replication yet....
Pravs_thedataguy's user avatar
1 vote
0 answers
282 views

How to connect to a SQL Server from another computer using SSMS with only hostname?

I set up a VM server computer on AWS EC2 and got a SQL Express Server running on it on port 1433. I made sure to allow TCP/IP requests and allowed TCP port 1433 through the firewall along with UDP ...
Goalaso's user avatar
  • 33
1 vote
0 answers
273 views

Improve qps for postgres write

I am trying to improve the performance of my postgres instance in aws. I am using aws rds db.t2.large Here is my table structure CREATE TABLE public.my_test ( test_index1 text COLLATE ...
J L's user avatar
  • 59
1 vote
0 answers
2k views

How to execute Stored Procedure of MS SQL server through Amazon Lambda?

I have one stored procedure which is too long and occurs more than a thousand times with different variables. Normal execution on Server takes around 3-4 hours to complete. That is why I want to ...
Jaimin's user avatar
  • 11
1 vote
1 answer
2k views

MySQL GTID error 1236

I am try to reduce machine come to live in production.. MySQL is making bottleneck. What i trying. I update code in one machine and also MySQL restore everything is working fine after this i am making ...
Obivan's user avatar
  • 119
1 vote
0 answers
169 views

SQL server Read scaling on Amazon AWS

SQL server Read scaling on Amazon AWS Let me know if this is a good idea. We create a small server that essentially is running all the time. This is the one to which we would be pushing data. (...
Santhosh S's user avatar
0 votes
0 answers
797 views

How to connect PgAdmin4 to postgresql 9.5 database process running on AWS EC2 server

I have a postgres database running on a linux EC2 instance. I want to view the data inside the tables, and currently the only way I can do that is via command line on the host server by: sudo su ...
jabroni's user avatar
  • 101
0 votes
0 answers
165 views

Сan't automatically connect to RDS via the script?

I'm using script on ec2 user data, that connects to rds. But the script doesn`t work. #! /bin/bash yum update -y yum install -y httpd service httpd start usermod -a -G apache centos chown -R centos:...
Steve Angelo's user avatar
0 votes
1 answer
46 views

Where to install SQL on EC2

If SQL Server and it's system databases are installed on an EC2 local drive, will they be recovered in a crash? My understanding is nothing but temporary files and the OS should be on the local ...
Sandy Skaar's user avatar
0 votes
1 answer
1k views

How to update mysql 5.7 to 8.0 Amazon linux 1, ec2

I'm using MySQL 8.0.14 for my project and I want to use it for my AWS ec2 server. I updated from 5.5 to 5.7 by following this link: Upgrade MySQL to 5.6 on ec2 But don't have any information to update ...
user avatar
0 votes
0 answers
25 views

Migrating data to new mysql rds instance

I have 1TB size mysql database for production . Now i want to migrate this database on new mysql RDS instance . Please suggest me which backup policy should i apply here like Mysqldump,XtraBackup . ?
Uday Raj Gupta's user avatar
0 votes
1 answer
29 views

how to setup mongodb replica on cloud server?

I want to setup mongodb repicaset on my cloud server(AWS ec2) but I have only one IP address. Currently I have make /etc/hosts two entries 127.0.0.1 dbnode1 and xx.xx.xx.xx dbnode2 but when I try to ...
Priyanka Sankhala's user avatar
0 votes
0 answers
76 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 ...
Simon Ernesto Cardenas Zarate's user avatar
0 votes
1 answer
94 views

Mongo DB Memory Utilisation freezes app needs restart

I am running a project using Mongo DB and Django, I have 2 separate instance for my Django project and database each 16GB ram t2xlarge ubuntu ec2 instances. I am facing issue that within a day or two ...
user3743879's user avatar
0 votes
1 answer
287 views

Can't bring up slave from ec2-consistent-snapshot due to uncommitted prepared transaction

I'm struggling with bringing up a slave instance using a snapshot created by ec2-consistent-snapshot, in my log it's describing the fact that an unprocessed transaction exists, but isn't that what ec2-...
oucil's user avatar
  • 506
0 votes
1 answer
52 views

I have an instance of RDS of MySQL 5.7.10

I do not understand why memory bar seems to exceed to the red zone with 24.5 MB while RDS server should be with 1Gib
simhachalam cloud admin's user avatar
0 votes
2 answers
32 views

Move MySQL Database to Amazon EC2 Servers

I have a website which has a 5 GB big mysql database. I am thinking if it is a good idea to move only the database to amazon, all front-end etc. (PHP) will remain. I've red already a lot about my ...
Roman's user avatar
  • 1
0 votes
1 answer
2k views

Help with Galera Cluster Auto_Increment

We're currently running a Galera cluster of 3 DB nodes. The way we're set up (due to ORM and automagical locking), we only have one of the 3 DB nodes being written to, and the other two provisioned ...
Flatout42's user avatar
0 votes
0 answers
32 views

Prevent Reconnections During Application Cluster Restart

I have a large cluster of application processes (>5000) spread out over multiple EC2 servers. When I attempt to restart them or deploy new code (with a restart), they all attempt to reconnect to the ...
silvamerica's user avatar
0 votes
1 answer
898 views

adding node to existing availability group

Currently have a 2 node availability group, trying to add a 3rd. Added Node3 to the Windows Cluster. Node3 appears as UP in "Nodes" on the Failover Cluster Manager console. However I have the ...
Peter's user avatar
  • 1,490