Questions tagged [amazon-ec2]

Amazon Elastic Compute Cloud (EC2)

38 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
1answer
3k 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 ...
4
votes
2answers
4k views

How to configure replication from PostgreSQL (RDS) to vanilla PostgreSQL?

I have an Amazon RDS Postgres DB and I created a "replicator" user and granted it the "replication" privilege. db=> create role replicator login password 'something'; CREATE ROLE db=> alter ...
3
votes
2answers
1k 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 [...
3
votes
0answers
722 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 ...
3
votes
0answers
2k 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 ...
3
votes
0answers
334 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 ...
2
votes
0answers
32 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 ...
2
votes
0answers
221 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 ...
2
votes
0answers
132 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 ...
2
votes
0answers
32 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'...
2
votes
1answer
1k views

Configuring slave from EC2 master to Amazon RDS slave

I am configuring replication from EC2 master to Amazon RDS instance. After starting the slave, I don't see any errors but I see slave_IO: _thread is connecting. Master version:5.6.23 Slave ...
1
vote
0answers
13 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-...
1
vote
0answers
37 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 ...
1
vote
2answers
82 views

MySQL hitting IOPS wall in AWS, not able to utilize full volume IOPS level

We are scaling up an existing MySQL 5.6.41 (with Galera) based system running in AWS on EC2, and are hitting a wall in performance, which we believe is narrowed down to storage IOPS. Please note for ...
1
vote
0answers
155 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....
1
vote
0answers
79 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 ...
1
vote
0answers
67 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 ...
1
vote
0answers
452 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 ...
1
vote
0answers
236 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 ...
1
vote
2answers
613 views

Export and Import large database from one rds of amazon to newly created amazon rds

We are facing some issue. We would like to export and import mysql database "xyz" from old rds say xyz-rds to newly created rds say abc-rds (mysql). We are approaching common method taking full ...
1
vote
1answer
183 views

Table does not exist even if there is one

I have MySQL master-slave replication setup in Amazon EC2. For the sake of resilience, I have set up LVM on RAID 10 array, on both master as well as slave. I have been using ec2-consistent-snapshot ...
1
vote
0answers
157 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. (...
0
votes
0answers
49 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 ...
0
votes
1answer
1k views

Binding specific ips with Mongodb

I am using Mongodb 3.6.3 on Centos 7. I am running the below command: sudo mongod --storageEngine wiredTiger --dbpath /data --bind_ip_all --logpath /var/log/mongodb/mongod.log --fork and ...
0
votes
1answer
295 views

Mongodb 3.6.3 disappears after 2 weeks on centos 7 ec2 instance

My Mongodb has disappeared 2 times, after 2 weeks, over the weekend within a 4 week time period. I had a snapshot to recover from but I can't keep on recovering my db every 2 weeks. In an ec2 ...
0
votes
0answers
84 views

Oracle 11g - stuck while creating tables

I have EC2 instance with 60GB Ram, 8 CPU and over 50GB space. Tried to create 75K empty tables with sqlplus -s / as sysdba @script.sql and it works fine up to 48K tables (they are created fine with ...
0
votes
0answers
212 views

Backing up large databases in AWS EC2

Does it make sense to back up SQL Server databases locally in the cloud, particularly AWS? "SQL Server Timeouts During Backups and CHECKDB" is an article on brentozar.com which points out the fact ...
0
votes
1answer
46 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 ...
0
votes
1answer
214 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-...
0
votes
1answer
37 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
0
votes
0answers
44 views

Scaling MongoDB netwrok peformance

I have two question which are rally about the same thing - how to read more documents per second? I'm running a MongoDB cluster on Amazon EC2 and I'm load testing it from 10 servers (on Amazon EMR). ...
0
votes
2answers
30 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 ...
0
votes
2answers
1k views

Cannot Access New Installation of MySQL on an Amazon EC2 Instance

I installed MySQL server on an Amazon EC2 instance and started it. Seems like it started, but when I try to do mysql -u root I get this error. mysql -u root ERROR 1045 (28000): Access denied for ...
0
votes
2answers
155 views

EC2 and setting up MYSQL Replication

my database size is very big around 100gb and when I restore it takes 3 days to restore. I am using amazon ec2. My question is I want to setup a new slave to MYSQL master, can I take a snapshot of ...
0
votes
1answer
1k 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 ...
0
votes
0answers
29 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 ...
0
votes
0answers
1k views

mongodb configuration issue

I am editing the configuration of running mongodb in an 'amazon ubuntu instance' (with more than 30 GB data), and I attached some volumes for data, log, and journal I followed mongodb-ec2: formatted ...
0
votes
1answer
298 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 ...