Questions tagged [amazon-ec2]
Amazon Elastic Compute Cloud (EC2)
132
questions
-2
votes
0
answers
50
views
What can be done to speed up database file shrinks in SQL Server? [closed]
I am trying to migrate data into files in the same filegroup EMPTY. This is progressing at an unusually slow pace. The files begin as multi-100GB files and get down to 10s of GB but hang for hours ...
Tom Marshall
0
votes
0
answers
24
views
Using AWS DMS for EC2 MariaDB instance to MariaDB RDS instance
After combing through AWS documentation, I am still unclear if DMS supports migration from EC2 instances running latest mariadb version to RDS mariadb instance?I see that MySQL is supported, but am I ...
- 95
0
votes
0
answers
192
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 ...
- 1
0
votes
1
answer
29
views
MySQL Not Resolving % in Host
Running MySql server 8.0.31 on an Amazon EC2 instance (52.99.189.74) in Ubuntu 22.04. When I log in to the mysql prompt with sudo, this is how the user and host columns of the mysql.user table look ...
- 73
0
votes
0
answers
14
views
Are AWS Lambda functions actually EC2 instances under the hood?
I’ve heard that AWS security groups are essentially firewalls that can be applied to EC2 instances. Since you can apply security groups to many things in AWS, including Lambdas, I’m wondering if many ...
- 171
0
votes
0
answers
79
views
Loading a csv file in to remote Mysql DB
I have a 70Mb csv with 1.5 million rows with 270 columns and I would like to put it into a MySQL database that is hosted on AWS RDS with the minimum layer. I try to do it with the MySQL Workbench ...
0
votes
0
answers
93
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:...
0
votes
1
answer
44
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 ...
1
vote
0
answers
169
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
...
2
votes
3
answers
380
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
2
votes
1
answer
104
views
QuasarDB cluster stuck in IOWAIT on AWS EC2 instances
I am experiencing a system freeze in IOWAIT on my QuasarDB cluster.
I am continuously ingesting data at 10 GBit/s using the QuasarDB batch API. After a couple of hours, I have all the qdb threads in ...
- 21
0
votes
1
answer
482
views
How to ensure backups are successfully persisted to S3 when using Ola Hallengren solution on AWS EC2 Instances
Improving Existing Backup Approach By Using Ola Hallengren Backup Solution
Deploying a new backup approach to eliminate dependency on a vendor tool (Cloudberry) that I've leveraged before. In my ...
- 270
2
votes
0
answers
3k
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 ...
- 121
1
vote
0
answers
231
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 ...
- 11
0
votes
2
answers
41k
views
How to solve Vendor Code 17002 when connecting to a remote Oracle database?
I have an Oracle database 12c standard edition release 12.2.0.1.0 running on a Linux instance of AWS ec2. When I try to connect to it remotely from my machine (macOS) using SQL Developer I get an IO ...
- 153
0
votes
1
answer
1k
views
How to upgrade Mysql 5.5 to 5.6 without data loss on aws-ec2?
MySQL server (5.5) is running on aws-ec2 instance with following linux details
NAME="Amazon Linux AMI"
VERSION="2015.09"
ID="amzn"
ID_LIKE="rhel fedora"
...
0
votes
1
answer
905
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 ...
An Dương
0
votes
0
answers
20
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 . ?
1
vote
1
answer
74
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 ...
George McCann
1
vote
0
answers
518
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 ...
- 111
2
votes
0
answers
517
views
SQL Server for Linux 2019 - Windows Authentication not working
Hoping to pick the brains of those more knowledgeable than me. I've been trying to set up a SQL Server 2019 instance on Linux; specifically on AWS using AMI amzn2-x86_64-SQL_2019_Standard-2019.11.12
...
- 21
0
votes
1
answer
26
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 ...
-1
votes
1
answer
145
views
Connecting to RDS MySQL from command line sometimes fails -- why?
I have used RDS for many years, and MySQL for even longer, so I am very familiar with both -- yet, I am running into an odd thing that I cannot figure out. Wondering if someone can help.
I have 2 ...
1
vote
2
answers
238
views
Wordpress UPDATE queries on MySQL database stuck
I have an Amazon 24XL server
96 Cores
378 GB RAM
Database size 5.7G
Debian GNU/Linux 9 (stretch)
PHP 7.3.16
mysql Ver 15.1 Distrib 10.3.22-MariaDB
I have only one WordPress site where users read ...
- 11
1
vote
0
answers
150
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, ...
- 111
2
votes
1
answer
993
views
Why does my MySQL page cleaner thread step up its minimum CPU usage over time and never decrease back to zero?
I’m running a MySQL 5.7.29 instance on Ubuntu 16.04 on a dedicated Amazon EC2 t3a.XLARGE instance (4 vCPUS, 16 GiB Memory connected to an iOPS optimized EBS volume with 1000 provisioned iOPS) and have ...
2
votes
2
answers
96
views
Will our application server have issues connecting to a Postgres 11.4 server with a 9.6 client?
Our application server is on EC2 running on Amazon Linux 1. Postgres dropped support for Amazon Linux and so we depend on Amazon providing the postgres client.
The client is 9.6 and our Amazon ...
- 185
2
votes
1
answer
315
views
SQL Server Installation - TempDB not created in the directory specified in ConfigurationFile.ini
I'm attempting to install SQL Server 2016 SP2 on a newly created EC2 instance. I'm using a configuration file I previously generated. In the configuration file I've specified where I'd like the TempDB ...
- 31
1
vote
0
answers
149
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-...
- 11
1
vote
1
answer
3k
views
connecting to mongodb on ec2 instance using the private IP address
Im trying to connect to my MongoDB that is on my EC2 instance. I am able to connect to using the public dns with this statement:
mongoClient = new
MongoClient("ec2-3-92-197-163.compute-1....
- 79
1
vote
0
answers
454
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 ...
- 79
2
votes
0
answers
169
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 ...
- 121
4
votes
2
answers
2k
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 ...
- 41
0
votes
1
answer
842
views
How to remotely manage (with PhpMyAdmin) a MySQL RDS on a load-balanced AWS Elastic Beanstalk setup?
Although there are similar questions and topics, I can't find a solution that currently works.
I specifically wrote remotely manage because I'd like to use my home computer's PhpMyAdmin to directly ...
- 101
0
votes
1
answer
48
views
Do I need SQS queues to store remote data in the Amazon Web Services (AWS) cloud?
My first question is, do I need SQS queues to receive my remote data, or can it go directly into an Amazon cloud storage solution like S3 or EC2?
Currently, my company uses a third-party vendor to ...
- 123
0
votes
2
answers
5k
views
MySQL on Windows or Linux [closed]
I am new to the Database region while have to migrate the company's database from AWS RDS to AWS EC2 and subscribe MySQL Enterprise edition.
What I am confused now is which OS should I choose, ...
- 21
1
vote
0
answers
317
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....
- 505
3
votes
2
answers
237
views
MySQL 5.7.21 not releasing memory after writing partition to disk
I've been testing extracting with SELECT * from a partition in a partitioned table in MySQL 5.7.21 and 5.7.22
I'm out of ideas and hitting my head on a wall. The goal is to write the data to S3 for ...
1
vote
0
answers
254
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 ...
- 33
0
votes
0
answers
75
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 ...
1
vote
0
answers
224
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 ...
- 59
1
vote
1
answer
4k
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 everything ...
- 215
0
votes
1
answer
694
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 ...
- 215
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 ...
- 11
0
votes
0
answers
205
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 ...
- 103
1
vote
1
answer
38
views
Database Schema design of server running status log
I am working with 4 AWS EC2 instances (servers). Each Instance has Instance ID and Instance Name. Instance ID is unique. Each of them having multiple application servers, like on of them is running ...
- 113
0
votes
1
answer
625
views
How to take advantage of AWS EC2 instance store (SSD) in a database environment?
I am trying to set up a database environment with Ubuntu and PostgreSQL (I didn't want to use RDS because I'm a Ubuntu person).
I looked at description for the R3 instance type:
Use Cases
...
- 3,105
0
votes
1
answer
775
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 ...
- 1,480
0
votes
2
answers
142
views
MongoDB Production Amazon - 3 data nodes per replica set, or 2 data nodes plus a shared arbiter
I have an Amazon EC2 deployment of mongodb (3.4). Things are going well, but the DB size is growing quickly. I am about to shard a large collection in order to begin horizontal scaling (total space ...
- 175
0
votes
1
answer
86
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 ...
