Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [amazon-ec2]

Amazon Elastic Compute Cloud (EC2)

130 questions
32
votes
2 answers

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 to migrate our database to its own server for one…
Mark Amery
  • 1,106
  • 3
  • 14
  • 24
28
votes
3 answers

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: "mongoadmin" , pwd: "mongoadmin", roles:…
Robert
  • 705
  • 3
  • 12
  • 20
24
votes
3 answers

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 instance that we can manage ourselves. Running…
jason.zissman
  • 343
  • 1
  • 2
  • 6
15
votes
2 answers

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 vCPUs and 4GB of memory on demand for $0.132 per hour…
kev
  • 397
  • 1
  • 4
  • 12
15
votes
3 answers

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 remotely and successfully runs the create database foo;…
Tim Abell
  • 294
  • 1
  • 3
  • 11
13
votes
7 answers

"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 AWS because the Oracle database is located inside…
Karl Johnson
  • 371
  • 1
  • 2
  • 6
9
votes
3 answers

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 role replicator replication; ALTER ROLE db=> However,…
Evan
  • 199
  • 1
  • 4
8
votes
2 answers

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. on EC2)? If we write our data files to RAID (e.g.…
VitalyB
  • 183
  • 1
  • 5
7
votes
3 answers

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 backups Tran Logs every 15 mins (would do more if can…
sheldonhull
  • 280
  • 2
  • 11
6
votes
6 answers

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?
Nisarg
  • 113
  • 1
  • 1
  • 7
6
votes
1 answer

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 done the following commands. mysql>CALL…
hhhyungyu
  • 61
  • 1
  • 2
6
votes
4 answers

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/init.d/mongod: line 60: ulimit: max user…
ed-ta
  • 463
  • 2
  • 6
  • 10
6
votes
0 answers

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 of DB connections suddenly, in some cases it drops…
Arjun Komath
  • 111
  • 1
  • 4
5
votes
2 answers

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 for max_connections, but I can change it through…
brazuka
  • 151
  • 3
4
votes
1 answer

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 reason this doesn't work neither. The log file…
Machinerium
  • 41
  • 1
  • 2
1
2 3
…
8 9