Questions tagged [amazon-ec2]

Amazon Elastic Compute Cloud (EC2)

Filter by
Sorted by
Tagged with
0
votes
2answers
64 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 ...
0
votes
1answer
29 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
1answer
34 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 ...
0
votes
0answers
16 views

Connect to RDS from EC2 that uses Elastic IP. Access denied for user

SHORT: I want to access my RDS MySQL from my EC2 instance. The EC2 has an associated Elastic IP address. I associated an Elastic IP address so the EC2 has a static IP. I can create a MYSQL user ...
0
votes
0answers
14 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
1answer
27 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 ...
0
votes
0answers
22 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 ...
1
vote
0answers
35 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 ...
0
votes
1answer
11 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
1answer
22 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
2answers
41 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 ...
0
votes
0answers
13 views

Redash metadata DB migrate

I am using Redash v5.0.0 and PostgreSQL for metadata in an EC2 instance. I can create Redash v8.x container on ECS and PostgreSQL on RDS, however how can I migrate metadata in EC2 for Redash v5 to RDS ...
0
votes
0answers
14 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, ...
2
votes
1answer
141 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
2answers
40 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 ...
2
votes
1answer
70 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 ...
1
vote
0answers
80 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
1answer
1k 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....
1
vote
0answers
224 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 ...
2
votes
0answers
69 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
2answers
529 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 ...
0
votes
1answer
415 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 ...
0
votes
1answer
21 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 ...
-1
votes
2answers
2k 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, ...
1
vote
0answers
246 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....
3
votes
2answers
156 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
0answers
144 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 ...
0
votes
0answers
54 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
0answers
107 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 ...
0
votes
1answer
2k 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
448 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 ...
1
vote
0answers
853 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 ...
0
votes
0answers
140 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 ...
1
vote
1answer
31 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 ...
0
votes
1answer
410 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 ...
0
votes
1answer
529 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 ...
0
votes
0answers
241 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
2answers
92 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 ...
0
votes
1answer
66 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 ...
2
votes
0answers
366 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 ...
4
votes
1answer
1k views

SQL Server AG Listener issues in an AWS VPC

I'm experimenting with creating a 2-node SQL Server Availability Group following Guy Glantser's excellent guide at MadeiraData where he describes a configuration with no AD domain or internal DNS. ...
2
votes
0answers
180 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 ...
5
votes
2answers
594 views

Amazon RDS MySQL limitations

I intend to use Amazon RDS MySQL with one db.t2.micro instance. Are there any limitations of max_connections and max_questions ? I searched on the Internet and I found that there is a default value ...
10
votes
6answers
21k views

“ORA-24454: client host name is not set” when connecting from Ubuntu instance on AWS EC2

Some background: I am attempting to connect to an Oracle database. I have a username, password, IP address, port, and service name. I only have access to this database from an Ubuntu EC2 instance on ...
0
votes
1answer
2k views

What could be causing this rogue CPU spike on MS SQL Server running on EC2?

We've just had a rogue CPU spike on one of our main SQL boxes, and we're struggling to work out what caused it. We use Red Gate SQL Monitor to track various performance metrics, and we saw a couple of ...
1
vote
1answer
851 views

AWS - MySQL server “Service CPU Usage” stuck at 50% / being throttled?

I have a c4.large EC2 instance which is running Windows Server 2012 and MySQL. When I look at the CPU usage on the machine it seems that MySQL is capping out at 50% CPU usage when the system is under ...
0
votes
1answer
32 views

Getting started with AWS: Price for large databases?

At the moment, I have a database that isn't accessed very often, but has 400 million rows and totals out to be 100gb disk space. I'm worried that, despite the low usage, I'll have to shell out for a ...
1
vote
0answers
304 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
1answer
206 views

Move mssql db Amazon RDS to EC2 [closed]

I have my 200 gb database. I want to move EC2 from RDS. I work on a research to prevent the problems that you may see,but it has not been done before. There may be problems; *Security weaknesses, ...
2
votes
0answers
33 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'...