Questions tagged [amazon-ec2]
Amazon Elastic Compute Cloud (EC2)
132
questions
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 ...
CommunityBot
- 1
0
votes
1
answer
23
views
How to transfer precomputed mogodb index to another machine?
I have a local mongodb database that i want to transfer to a free tier aws ec2 t3.micro instance.
The problem is that one collection in the db is a bit larger(1.2 GB, 24M docs), so there is no way i ...
- 503
0
votes
1
answer
46
views
automating backups to S3 with SQL Server 2022
Not a DBA so please bear with me.
I have an EC2 instance running SQL Server 2022 and I'm trying to automate database backups to S3 using the native S3 connector in this version of SQL Server. The ...
- 1,746
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 ...
CommunityBot
- 1
0
votes
0
answers
40
views
DB2 on CIS Amazon Linux 2023 Benchmark - Level 1 [closed]
By following an tutorial blog of installing DB2 on Amazon Linux, after solving many dependencies error, in the end I'm facing an issue where I can't start the DB2.
Some troubleshooting steps I did on ...
- 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 ...
CommunityBot
- 1
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
[...
CommunityBot
- 1
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 ...
CommunityBot
- 1
0
votes
1
answer
290
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-...
CommunityBot
- 1
6
votes
4
answers
30k
views
How to run MongoDB as a non root user in Linux?
I can start MongoDB as $sudo service mongod start. When I start without sudo it gives me this error:
/etc/init.d/mongod: line 58: ulimit: open files: cannot modify limit: Operation not permitted
/etc/...
- 151
2
votes
1
answer
721
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
...
- 5,884
0
votes
1
answer
498
views
Connecting to AWS RDS succeeds via terminal but fails in pgAdmin 4. Why?
I can establish an SSH tunnel using ssh -L 2222:<RDS-Endpoint>:5432 ec2-user@<EC2-IP> -i ~/.ssh/key.pem and then connect to my RDS using psql "host=localhost port=2222 user=postgres ...
- 40.6k
1
vote
0
answers
117
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 ...
- 113
0
votes
3
answers
2k
views
Best Approach to Migrating Oracle to MySQL - Run on EC2 in AWS
I'm trying to migrate an Oracle schema as well as all of the data within the DB to a MySQL database. I want to then make an EC2 app on AWS to kick off whatever I've written for this. Are there any ...
- 1
0
votes
1
answer
108
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 ...
- 26.6k
0
votes
2
answers
939
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 ...
- 383
0
votes
1
answer
786
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 ...
CommunityBot
- 1
2
votes
3
answers
962
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
- 746
0
votes
1
answer
177
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
1
vote
2
answers
271
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 ...
CommunityBot
- 1
3
votes
1
answer
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 ...
CommunityBot
- 1
1
vote
1
answer
217
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 ...
CommunityBot
- 1
13
votes
7
answers
32k
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 ...
- 105
0
votes
0
answers
169
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
2k
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"
...
CommunityBot
- 1
0
votes
1
answer
47
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 ...
- 3,406
28
votes
2
answers
170k
views
Mongo Create a user as admin for any database raise an error
I am trying to create a simple user with the rights permission to access to any database and can do any actions. When I trying to execute the createUser command I got this error:
db.createUser({ user:...
- 103
1
vote
0
answers
276
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
...
0
votes
1
answer
2k
views
Architecture for low-latency RESTful server on Amazon EC2 with Node.js and a database
This is a question for DBAs with a lot of practical experience with large scale deployments.
We are trying to build an app with very low latency. (We really want to create the best user experience, ...
- 126
2
votes
1
answer
140
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 ...
- 111
7
votes
3
answers
2k
views
Recommended mirroring alternative?
SETUP
2 Amazon EC2 SQL 2014 servers in different availability regions.
Synchronous mirroring
S3 for archiving full backups & logs at night
Right now for simplicity, nightly full compressed ...
3
votes
1
answer
3k
views
Replication from EC2 Master to RDS Slave - Connecting to master
I am migrating my company's database from an EC2 instance to an RDS instance. I have already migrated a snapshot of data and am now trying to set up replication to get the data that has been added ...
- 184k
32
votes
2
answers
24k
views
Amazon RDS for MySQL vs installing MySQL on an Amazon EC2 instance
At work, we host all our webservers on Amazon EC2 and usually have used MySQL databases installed on the same box as our Apache webserver, and communicated with them on localhost. We now face a need ...
- 184k
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 ...
0
votes
1
answer
100
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 ...
CommunityBot
- 1
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 ...
- 121
2
votes
0
answers
425
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 ...
- 88k
9
votes
3
answers
9k
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 ...
CommunityBot
- 1
2
votes
2
answers
2k
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 ...
CommunityBot
- 1
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 ...
- 235
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 ...
CommunityBot
- 1
1
vote
2
answers
68k
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 ...
- 7,754
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 . ?
1
vote
1
answer
112
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
604
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
0
votes
1
answer
30
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 ...
- 5,723
-1
votes
1
answer
169
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 ...
- 14
0
votes
1
answer
953
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
1
vote
0
answers
179
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
1k
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 ...
