All Questions
1,006 questions
2
votes
2
answers
1k
views
How to detect whether MySQL server is running as Amazon RDS
I am writing an application wherein I want to detect whether MySQL server is running as Amazon RDS instance?
Can somebody help me out how to detect it?
auto_increment_increment1
...
- 3,076
1
vote
0
answers
313
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 ...
- 111
10
votes
2
answers
7k
views
Amazon RDS I/O requests - 1 query = 1 billable I/O?
I have an InnoDB database that I'd like to migrate onto Amazon RDS.
My current implementation, hosted on my own server, shows roughly 8M queries per month.
The RDS site say that
I/O Rate $0.10 ...
- 101
3
votes
1
answer
2k
views
innodb_flush settings on Amazon RDS
Setting innodb_flush_log_at_trx_commit = 2 improves my application performance considerably on my local development environment. The response time and number of requests per second on a 40 concurrent ...
- 328
16
votes
3
answers
9k
views
Replicate RDS-MySQL to a non-amazon host?
I have a fairly large MySQL (5.1) database running in Amazon as an RDS instance. I'm working on migrating it out of Amazon. To do that smoothly I'd like to set up the new hardware as a read-only ...
- 825
3
votes
1
answer
2k
views
Keeping MySQL staging database on same server updated from production
I just migrated my MySQL 5.5.20 to Amazon RDS from MySQL on EC2. The one thing I'm having difficulty with is how to keep my staging database updated from production. Before, I just ran a nightly ...
- 195