Questions tagged [amazon-ec2]

Amazon Elastic Compute Cloud (EC2)

Filter by
Sorted by
Tagged with
6
votes
1answer
3k 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 ...
3
votes
2answers
3k 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 ...
3
votes
2answers
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 [...
2
votes
1answer
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 ...
0
votes
1answer
42 views

I have an instance of RDS of MySQL 5.7.10

I do not understand why memory bar seems to exceed to the red zone with 24.5 MB while RDS server should be with 1Gib
1
vote
1answer
1k views

Amazon RDS low in memory no mysql connections

I'm running the free instance of amazon RDS connection to a t2.medium ec2 instace. We are running a wordpress website with 20 active plugins and about 800 pages. I can see that I am low in memory (...
1
vote
1answer
1k 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 ...
0
votes
1answer
5k views

MySQL2::Error: BLOB/TEXT column can't have a default value

I am trying to run a rails mysql migration on Amazon Elastic Beanstalk. It fails with this error message: Mysql2::Error: BLOB/TEXT column 'description' can't have a default value: ALTER TABLE ...
1
vote
1answer
238 views

Postgres latency issues during memory compaction on EC2 (Ubuntu 14.04)

We've recently upgraded our EC2 instance that hosts our Postgres database to an i2.8xlarge with 244GB of memory (this is to utilise the large amounts of ephemeral storage it comes with). Since ...
1
vote
1answer
52 views

Is this work flow suitable for Amazon RDS?

I am considering to set up a MySQL database via amazon web services (AWS). Consider the following steps which characterize my workflow: There is a daily data inflow into several AWS EC2 instances On ...
0
votes
0answers
45 views

Scaling MongoDB netwrok peformance

I have two question which are rally about the same thing - how to read more documents per second? I'm running a MongoDB cluster on Amazon EC2 and I'm load testing it from 10 servers (on Amazon EMR). ...
2
votes
1answer
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 ...
4
votes
3answers
19k 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/...
0
votes
2answers
31 views

Move MySQL Database to Amazon EC2 Servers

I have a website which has a 5 GB big mysql database. I am thinking if it is a good idea to move only the database to amazon, all front-end etc. (PHP) will remain. I've red already a lot about my ...
1
vote
1answer
85 views

Can we create Fail over clustering for SQL Server 2012 standard edition on amazon EC2?

We are planing to move on amazon's EC2 services. So my question is that can we create fail over clustering on amazon EC2 using SQL Server 2012 standard edition ?
1
vote
3answers
590 views

Mysql 5.5.45 crashing after refreshing web page rapidly(Too Many Connection warning)

I am using ec2 aws instance for my wordpress webiste.after every 5 to 10 minute and randomly my website going down i tried lots of things like increasing buffer memory ,memory limit but that not ...
0
votes
1answer
34 views

Scenarios in which you might need to restore large number of databases at once?

I've seen several online sources mentioning that you should always have a restore script automated for the possible need to restore a large number of databases at once and quickly get back up and ...
5
votes
1answer
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 ...
0
votes
1answer
760 views

AWS EBS I/O Bottleneck

I'm hoping someone can help me understand some EBS Bottlenecks that we are experiencing with a new Windows SQL Server instance we're configuring. We're running some tests by conducting a full backup ...
1
vote
1answer
48 views

AWS Webapp tutorial: how to choose source in database security group?

I am following the AWS tutorial to create a Webapp here: http://docs.aws.amazon.com/gettingstarted/latest/wah-linux/getting-started-create-rds.html I am stuck at the part 'Create a Security Group for ...
3
votes
0answers
862 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 ...
2
votes
1answer
58 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 ...
3
votes
2answers
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
1answer
1k 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 ...
0
votes
2answers
3k views

Cannot Access New Installation of MySQL on an Amazon EC2 Instance [closed]

I installed MySQL server on an Amazon EC2 instance and started it. Seems like it started, but when I try to do mysql -u root I get this error. mysql -u root ERROR 1045 (28000): Access denied for ...
1
vote
1answer
153 views

Mysql (Ver 14.14/Redhat): is a new column with default values efficient on column creation?

I want to add a new column to my production database. I would like to add a default value in order to prevent all the if not null and ... business in all my queries (both new and old). What order of ...
4
votes
0answers
2k 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 ...
1
vote
2answers
940 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 ...
1
vote
2answers
2k views

Connecting to a new RDS instance from an EC2 instance

I'm trying to use MediaWiki and WP to connect to two MySQL databases. The databases are working properly and so are the forms but when I try to establish a connection to the database with MediaWiki ...
3
votes
1answer
546 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 ...
1
vote
1answer
190 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 ...
3
votes
3answers
4k 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 ...
18
votes
2answers
83k 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:...
0
votes
2answers
1k views

Import a sample database into SQL Server on AWS RDS free tier

I asked this on stack overflow but someone there suggested I try here as I might get better answers. So here goes... I'm signed up to Amazon Web Service (AWS) free tier, which allows you to run some ...
1
vote
1answer
239 views

Moved a MySQL Database to another server, but socket keeps pointing to localhost

I know I shouldn't bother with this, maybe I should disable the old mysql, but this is a Magento virtual appliance from Bitnami thats work as a whole (application and database on the same server). I ...
0
votes
1answer
75 views

restoring a EC2 snapshot on RDS

Is it possible to restore our database snapshot on ec2 directly on RDS as our database is very big ? If not can we restore using csv files. ?
0
votes
2answers
168 views

EC2 and setting up MYSQL Replication

my database size is very big around 100gb and when I restore it takes 3 days to restore. I am using amazon ec2. My question is I want to setup a new slave to MYSQL master, can I take a snapshot of ...
2
votes
1answer
745 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 ...
0
votes
3answers
1k 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 ...
3
votes
2answers
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
vote
1answer
1k views

Can't connect to EC2 Postgresql instance unless I change the default port 5432 [closed]

I just created a brand new EC2 instance with a default security group allowing All Traffic from Anywhere. My listen_address is set to * I can SSH to it but I can't connect to the pgsql instance ...
1
vote
1answer
4k views

Can I Upgrade SQL Server 2008 R2 Express to SQL Server 2014 Developer edition

I currently have SQL server 2008 R2 Express installed for my QA/Dev environment on Amazon EC2 instance. Now my database is growing beyond the 10GB limitation of Express edition, so am planning to buy ...
0
votes
1answer
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 ...
2
votes
1answer
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 ...
4
votes
1answer
7k 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 ...
0
votes
1answer
1k views

mySQL running on 100% CPU both on RDS and EC2

How do we troubleshoot an issue with Amazon wherein my database queries (PHP/MySQL) are eating 100% CPU most of the day? Traffic=200 connections average mySQL version = 5.5.40 The following specific ...
1
vote
1answer
324 views

SQL CLR very slow on Amazon EC2 Instance (SQL Server 2014 CU6)

I am running a SQL Server 2014 Standard Edition (Cumulative Updates 6) instance on an r3.large Amazon EC2 box. I noticed that the CPU usage of SQL Server skyrockets to 100% while executing pretty much ...
0
votes
0answers
29 views

Prevent Reconnections During Application Cluster Restart

I have a large cluster of application processes (>5000) spread out over multiple EC2 servers. When I attempt to restart them or deploy new code (with a restart), they all attempt to reconnect to the ...
3
votes
0answers
362 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 ...
1
vote
0answers
161 views

SQL server Read scaling on Amazon AWS

SQL server Read scaling on Amazon AWS Let me know if this is a good idea. We create a small server that essentially is running all the time. This is the one to which we would be pushing data. (...