Questions tagged [amazon-ec2]
Amazon Elastic Compute Cloud (EC2)
130
questions
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
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
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
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
0
votes
1
answer
3k
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 ...
- 119
1
vote
1
answer
1k
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 ...
- 135
0
votes
1
answer
39
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 ...
- 133
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
1
vote
1
answer
300
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,
...
- 1,071
2
votes
0
answers
38
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'...
- 21
0
votes
1
answer
279
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-...
- 506
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
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
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
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
0
votes
1
answer
50
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
1
answer
2k
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 (...
- 11
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 ...
- 119
0
votes
1
answer
10k
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
1
answer
265
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 ...
- 23
1
vote
1
answer
58
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 ...
- 113
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
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
0
votes
2
answers
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
1
vote
1
answer
93
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 ?
- 53
1
vote
3
answers
720
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
1
answer
39
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 ...
- 270
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
0
votes
1
answer
874
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 ...
- 131
1
vote
1
answer
51
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 ...
- 13
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
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
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:
...
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
0
votes
2
answers
7k
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 ...
- 101
1
vote
1
answer
187
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 ...
- 247
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
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 ...
1
vote
2
answers
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 ...
- 11
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
1
vote
1
answer
216
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 ...
- 86
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
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
0
votes
2
answers
2k
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 ...
- 115
1
vote
1
answer
261
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 ...
- 13
0
votes
1
answer
78
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. ?
- 357
0
votes
2
answers
182
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 ...
- 357
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
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 ...
- 101
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