Amazon RDS interview questions

61. How to get Amazon MySQL RDS certificates ?
Download ca cert file from here: https://s3.amazonaws.com/rds-downloads/mysql-ssl-ca-cert.pem
curl -O https://s3.amazonaws.com/rds-downloads/mysql-ssl-ca-cert.pem
Connect to mysql:
mysql -uusername -p –host=host –ssl-ca=mysql-ssl-ca-cert.pem
Check that your connection is really encrypted:
mysql> SHOW STATUS LIKE ‘Ssl_cipher’;
+—————+————+
| Variable_name | Value |
+—————+————+
| Ssl_cipher | AES256-SHA |
+—————+————+
1 row in set (0.00 sec)
Optionally force SSL for a specific user to connect to MySQL
mysql> ALTER USER ‘username’@’host|%’ REQUIRE SSL

62. ‘Got minus one from a read call’ error when connecting to an Amazon RDS Oracle instance . What can be the cause ?
Can be any one of the reason
If the remote server has been configured (e.g. in the “SQLNET.ora” file) to not accept connections from your IP.
If the JDBC url is incorrect, you could be attempting to connect to something that isn’t a database.
If there are too many open connections to the database service, it could refuse new connections.

Author: user

Leave a Reply