Questions tagged [amazon-ec2]
Amazon Elastic Compute Cloud (EC2)
130
questions
31
votes
2
answers
23k
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 ...
- 1,045
26
votes
2
answers
157k
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:...
- 665
23
votes
3
answers
19k
views
Get WAL files from AWS RDS PostgreSQL instance
We have a Postgres RDS instance on Amazon Web Services. We have automatic backups enabled, and we take snapshots on a daily basis. We would like to generate a local 'up-to-date' backup of the RDS ...
- 333
15
votes
2
answers
12k
views
Why use RDS over EC2 for Postgres?
I have a database currently running on EC2. As I have to move it to a bigger machine the question of using RDS came up.
Pricing:
I can get an EC2 c3.large instance with two SSDs (16GB each), two ...
- 395
13
votes
7
answers
31k
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 ...
- 361
13
votes
3
answers
16k
views
db_owner unable to drop database - Error 615, SQL Server
I have a SQL Server 2012 database running on amazon EC2. I've created a user to be able to create, edit and drop databases. I gave the new user with dbcreator server role.
My user can connect ...
- 274
8
votes
2
answers
5k
views
MongoDB - Should I separate the journal and the data to different drives?
I have seen and heard from multiple sources that it can be a good idea, performance-wise, to write your db journal and your data files to separate disks.
What's the recommended way to do this (e.g. ...
- 183
8
votes
3
answers
8k
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 ...
- 89
6
votes
6
answers
17k
views
Amazon: How to change database name in Amazon RDS MySQL?
I want to change MYSQL database name of the DB instance of Amazon RDS.
How it can be possible?
- 113
6
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 ...
- 270
6
votes
1
answer
6k
views
Disable MySQL replication on rds
I want set up replication between an Amazon RDS MySQL DB instance and a MySQL instance that is external to Amazon RDS.
but Slave_IO_Running: Connecting
how to solve this problem?
I have already ...
- 61
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 ...
- 111
5
votes
2
answers
817
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 ...
- 151
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 ...
- 151
4
votes
4
answers
28k
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/...
- 413
4
votes
3
answers
6k
views
Amazon AWS RDS Aurora Row size too large (VB5)
We're trying to import our vbulletin 5 database into RDS/Aurora and getting this:
ERROR 1118 (42000) at line 5733: Row size too large (> 8126). Changing
some columns to TEXT or BLOB or using ...
- 171
4
votes
1
answer
8k
views
MongoDB Insufficient free space for journal files
I have installed a standalone mongo 2.6 in amazon ec2. The instance has reach the limit of disk space and it doesnt run now. I have set before the smallfiles=true in mongod.conf file, but for some ...
- 41
4
votes
1
answer
2k
views
AWS performance of RDS with provisioned IOPS vs EC2
Has anyone done a performance comparison of AWS RDS with the new provisioned IOPS vs EC2? I've found plenty of non-high IOPS RDS vs EC2 but nothing with the new high IOPS feature in RDS.
- 61
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
4
votes
1
answer
2k
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. ...
- 41
4
votes
1
answer
912
views
Migrating development and production databases to AWS
After careful thinking and asking on meta.stackoverflow, I'm posting this question on the DBA site. If anyone thinks this question should be on serverfault or any other site, feel free to close and ...
- 2,816
4
votes
2
answers
2k
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
[...
- 141
4
votes
0
answers
402
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 ...
- 141
3
votes
1
answer
591
views
Where to store data on AWS?
I'm using AWS to host my application, and I'm using mongodb as db. I have installed mongodb on amazon ec2, but now I have no idea about where I should store all of my data. Can I store all of my data ...
- 163
3
votes
2
answers
5k
views
MySQL replication lagging behind with log_slave_updates
I'm in the process of setting up replication in this topology:
/--B
A-
\--C--D
In order to achieve this I need log_slave_updates to be enabled on C, so D will also get the changes from A.
C ...
- 151
3
votes
1
answer
1k
views
Synchronizing data from AWS Sql Server to local database
I have a situation when I need to synchronize some tables from Sql Server database to my local Sql Server database and vice versa. What are my options? I can not find any useful information about ...
- 172
3
votes
2
answers
1k
views
Deciding EC2 Instance type & Volume IOPS for Mongo DB
We have 500GB data in our Mongo(v2.6.3) including the indexes.
We currently run this on AWS m3.large(8GB RAM) instance. Yes, Single
machine.
Our MongoDB Cloud Manager shows these stats:
...
3
votes
2
answers
1k
views
SQL Server hangs during backup on EC2
Once and then our SQL Server will "hang" during its weekly full backup. When this happens, external connections start to timeout. The symptoms are:
Connections timeout
The sqlservr.exe process sits ...
- 1,465
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 ...
- 1,322
3
votes
2
answers
241
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 ...
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 ...
3
votes
2
answers
947
views
SQL Server Express Freezes for a couple minutes
I have SQL Server Express on an AWS micro instance. These instances have only 615MB of RAM. For the most part it performs fine. My application can make up to about 15 db connections. However, every ...
- 143
3
votes
2
answers
836
views
Is this amount of disk IO expected with MySQL?
I am running MySQL 5.5.34 on an Amazon EC2 micro instance with EBS (elastic block storage). The instance has been running for around 10 days and according to Amazon I've accumulated around 8.5 ...
- 31
3
votes
0
answers
532
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 ...
- 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 ...
- 949
2
votes
1
answer
968
views
Good ratio for data, journal, and log drive sizes for MongoDB?
Is there a good ratio for drive sizes for MongoDB?
For example if you have a 8Gig drive for the data, then how big should my drive for the log be? How about the drive for the journal?
Just a little ...
- 285
2
votes
1
answer
4k
views
Server warnings on MongoDB startup
I recently installed MongoDB on an AWS EC2 instance running Ubuntu.
When I'm starting the MongoDB service, I get some warnings:
$ mongo
MongoDB shell version: 3.0.11
connecting to: test
Server has ...
- 123
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 ...
2
votes
2
answers
1k
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 ...
2
votes
3
answers
450
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
110
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
2
votes
1
answer
346
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
2
votes
1
answer
60
views
How to make most of aws?
I'm new to aws (just one day old). I'm impressed with aws free tier and want to utilize to its best. As of now I'm done with installing mongodb on aws micro instances and mongod EC2 instances are ...
- 245
2
votes
1
answer
405
views
Improving concurrency in MongoDB via sharding
Our current setup:
Cluster of ~500 ec2 c1.xLarge worker nodes with 8 threads on each running scientific simulations
Results temporarily stored at runtime on each worker node's local MongoDB, using ...
- 121
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
2
votes
0
answers
532
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
2
votes
2
answers
99
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
0
answers
178
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
2
votes
0
answers
207
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 ...
- 4,448
2
votes
0
answers
523
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 ...
- 143