MySQL is a mainstream Relational DB which is accessible in the amazon RDS administrations with its local area release highlights. Pretty much every element of MYSQL can be utilized in the RDS stage with just a few limitations dependent on districts and accessibility zones. The following is a short portrayal on MYSQLs significant highlights in the RDS platform.Supported Versions
The forms 5.5, 5.6 and 5.7 are the significant variants upheld in the RDS stage. Aside from 5.6.27 all renditions are upheld in all AWS areas. On the off chance that no rendition is referenced during the DB creation, it defaults to the latest variant by then. The following is an illustration of how to get all upheld DB Engine variants utilizing AWS API in a python SDK program.
import boto3
client = boto3.client('rds')
response = client.describe_db_engine_versions(
DBParameterGroupFamily='mysql5.6',
DefaultOnly=True,
Engine='mysql',
EngineVersion='5.6',
ListSupportedCharacterSets=True,
)
print(response)
At the point when the above code is run we get a yield as beneath −
{
"ResponseMetadata": {},
"DBEngineVersions'": [
{
"Engine'": "mysql",
"DBParameterGroupFamily'": "mysql5.6",
"SupportsLogExportsToCloudwatchLogs'": true,
"SupportedCharacterSets'": [],
"SupportsReadReplica'": true,
"DBEngineDescription'": "MySQL Community Edition",
"EngineVersion'": "5.6.40",
"DBEngineVersionDescription'": "MySQL 5.6.40",
"ExportableLogTypes'": [
"audit",
"error",
"general",
"slowquery"
],
"ValidUpgradeTarget'": [
{
"Engine'": "mysql",
"IsMajorVersionUpgrade'": true,
"AutoUpgrade'": false,
"Description'": "MySQL 5.7.22",
"EngineVersion'": "5.7.22"
}
]
}
]
}
Rendition Upgrade
There MySQL adaptation number is kept up as MYSQL A.B.C. In this documentation, A.B shows the significant form and C demonstrates the minor adaptation. The redesign approach is distinctive among minor and significant form updates.
Minor Version Upgrade
The DB occurrences are naturally moved up to new minor adaptations at whatever point they are upheld by Amazon RDS. This fixing happens during a timetables support window which you can handle. You can likewise physically move up to new forms in the event that you like to kill the programmed update.
Significant Version overhaul
Significant adaptation overhauls are not accessible as programmed redesign. It should be finished by the record client physically by altering the DB occasion. Underneath flowchart showed the means in accomplishing the significant adaptation overhaul. This methodology guarantees that the redesign cycle is completely tried before it is applied on the live creation data set.
Information base Security
The security for RDS MYSQL DB is overseen at three layers.
Utilizing IAM
In this methodology the IAM client ought to have suitable arrangements and consents. Allowing of such authorizations is chosen by the record holder or the super client who concedes these consents.
Utilizing VPC
You either utilize a VPC security gathering or DB security gathering to choose which EC2 examples can open associations with the endpoint and port of a DB case. These associations can likewise be made utilizing SSL.
Utilizing IAM Database Authentication
In this methodology you utilize an IAM job and a confirmation token. The validation token creates a novel worth which is applicable to the IAM job that is utilized in the entrance cycle. Here similar arrangement of accreditations are utilized for data set just as other aws assets, as EC2 and S3 and so on