Amazon Relational Database Service is a web service that makes it easy to set up, operate, and scale a relational database in the cloud.
2
votes
2answers
770 views
Connecting to AWS RDS DBInstance with MySQL workbench
I am trying to evaluate AWS RDS to use as possible DB for our application. I have created a DBInstance(micro) and added IP security group. I am able to connect to the DBInstance from Xampp shell ...
1
vote
2answers
248 views
SUPER privilege not defined for master user in Amazon MySQL RDS
I have created one medium instance on amazon rds in asia pecific (singapore) region. i have created my master user with master password. and it is working/connecting fine with workbench installed on ...
2
votes
1answer
88 views
Backing up a 400-500 GB database on MySQL/Amazon RDS?
We have an Amazon RDS small instance for a MySQL datawarehousing database.
Database size will be around 400-500 GB very shortly.
What is the best way to backup our database?
Can it be done ...
2
votes
1answer
136 views
Database Link from Oracle 10g on Windows over to MySQL database
Didn't see any answers on this subject so hoping for a miracle! :-)
I've got an Oracle 10g database running on Windows Server 2003 and I'd like to create a database link to an external MySQL database ...
2
votes
1answer
293 views
Is there a way to do data export from Amazon Web Services RDS for SQL Server to On-Premises SQL Server?
We have a large Amazon Web Services RDS for SQL Server instance and we would like to do incremental data transfers from RDS to On-Premesis SQL Server on a regular basis.
The On-prem server will be ...
1
vote
1answer
55 views
Should I increase max_connections in AWS RDS t1-micro for MySQL?
I have an AWS RDS t1-micro running MySQL 5.5. It gives me too many connections error. I checked and it allows 34 maximum connections concurrently. What I have read is that i can increase this max ...
0
votes
1answer
216 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.
2
votes
0answers
751 views
'Access Denied' in MySQL on AWS RDS
I'm trying to use an ETL (in my current case, the free version of Talend). I've successfully set up a MySQL on Amazon RDS, logged in through the MySQL Workbench for Mac, and uploaded my company's ...
2
votes
0answers
2k views
Amazon RDS MySQL 5.5 Innodb Lock wait timeout exceeded
Ever since we've moved to Amazon RDS, we've had some pretty crazy performance issues, and today we started having locking issues. Because of that, I figured it was just a timeout issue, and went to ...
1
vote
0answers
93 views
Enforce a hard limit on write execution time during Amazon RDS write stalls
I am trying to recover from the situation where Amazon RDS write operations stall (some discussion on why this is here). If I show full processlist, I will see something like this:
318263 myapp1 ...
0
votes
0answers
13 views
Monitor For Disabled Queue On RDS SQL Server
I would like to somehow get notification of a queue being disabled due to poisoned messages. (The issue is occasional resource contention. Until we solve it, monitoring would help us be aware.) In my ...
0
votes
0answers
37 views
RDS MySQL instance swapping lots of temp tables
I have an application that has few concurrent connections but does a lot of uncacheable fulltext searches sorting, limit with offset, etc. I have an xlarge instance with innodb buffer pool size @ 75% ...
0
votes
0answers
180 views
What to do to reduce first byte time after removing slow queries?
I've set long_query_time to 1 sec and found only 2 query which took 1 sec to execute at 2 different points of time since yesterday. So I don't suppose such 2 queries cause my first byte time to be 3 ...
0
votes
0answers
196 views
MySQL Amazon RDS DIY Sharding Strategy (plug-n-play)
I'm creating my own sharding solution with MySQL. I develop my application in ASP.NET 4.5.
My idea is to create a document wit the available shards for every table:
components_servers[
{shard_id: ...
0
votes
0answers
111 views
MySQL show status results
I'm looking at the results of SHOW STATUS, as interpreted by mysqlreport, on my amazon RDS server that's being used to store an installation of Joomla. Should I be concerned by either of the ...
