Prophet is well known Relational DB which is accessible in the amazon RDS administrations with its undertaking version highlights. Pretty much every component of Oracle can be utilized in the RDS stage. The following is a concise portrayal on MYSQLs significant highlights in RDS stage.
Upheld Versions
The adaptations 11.2 and 12.1 are the significant variants upheld in the RDS stage. On the off chance that no form is referenced during the DB creation, it defaults to the latest rendition by then. The following is an illustration of how to get the upheld DB Engine forms utilizing AWS API in a python SDK program.
import boto3
client = boto3.client('rds')
response = client.describe_db_engine_versions(
DBParameterGroupFamily='oracle-ee-12.1',
DefaultOnly=True,
Engine='',
EngineVersion='',
ListSupportedCharacterSets=False, #True,
)
print(response)
At the point when we run the above program, we get the accompanying yield −
{
"ResponseMetadata": {
"RetryAttempts": 0,
"HTTPStatusCode": 200,
"RequestId": "f6805635-3e16-4014-83cd-dfdaf3f17950",
"HTTPHeaders": {
"x-amzn-requestid": "f6805635-3e16-4014-83cd-dfdaf3f17950",
"date": "Fri, 14 Sep 2018 03:46:38 GMT",
"content-length": "1455",
"content-type": "text/xml"
}
},
"u'DBEngineVersions'": [
{
"u'Engine'": "oracle-ee",
"u'DBParameterGroupFamily'": "oracle-ee-12.1",
"u'SupportsLogExportsToCloudwatchLogs'": true,
"u'SupportsReadReplica'": false,
"u'DefaultCharacterSet'": {
"u'CharacterSetName'": "AL32UTF8",
"u'CharacterSetDescription'": "Unicode 5.0 UTF-8 Universal character set"
},
"u'DBEngineDescription'": "Oracle Database Enterprise Edition",
"u'EngineVersion'": "12.1.0.2.v12",
"u'DBEngineVersionDescription'": "Oracle 12.1.0.2.v12",
"u'ExportableLogTypes'": [
"alert",
"audit",
"listener",
"trace"
],
"u'ValidUpgradeTarget'": []
}
]
}
Prophet Licensing
There are two choices for utilizing prophet licenses in RDS. They are License Included and Bring Your Own License.
Permit Included Model
In this model Amazon holds the permit for the product you will utilize. Likewise AWS itself offers the help for both AWS and Oracle programming thorugh its help program. So the client doesn't buy any different permit. The stage evaluating incorporates the charges for authorizing cost the client pays. The two releases upheld in this model are Standard Edition One and Standard Edition Two.
Present to Your Own License (BYOL)
In this model the client acquires the permit she holds into RDS stage. It is the client's obligation to keep up the similarity between the permit, information base occurrence class and data set version. The client straightforwardly contacts the Oracle uphold channel for any need. In this model the upheld versions are Enterprise Edition (EE), Standard Edition (SE), Standard Edition One (SE1) and Standard Edition Two (SE2).
For a multi A-Z organization, the client ought to have permit for both essential DB case and the auxiliary DB occasion.
Prophet DB Parameter Group
The prophet DB includes numerous DB boundaries to be designed for different highlights and execution needs of the data set. Aws makes these boundaries noticeable through CLI orders, which the client can use to inquiry for the boundary esteems. The following is the CLI order and the example yield.
aws rds describe-engine-default-parameters --db-parameter-group-family oracle-ee-12.1
{
"EngineDefaults": {
"Parameters": [
{
"AllowedValues": "TRUE,FALSE",
"ParameterName": "_allow_level_without_connect_by",
"ApplyType": "dynamic",
"Description": "_allow_level_without_connect_by",
"IsModifiable": true,
"Source": "engine-default",
"DataType": "boolean"
},
{
"AllowedValues": "CHOOSE,OFF,CUBE,NESTED_LOOPS,MERGE,HASH",
"ParameterName": "_always_semi_join",
"ApplyType": "dynamic",
"Description": "_always_semi_join",
"IsModifiable": true,
"Source": "engine-default",
"DataType": "string"
},
{
"AllowedValues": "TRUE,FALSE",
"ParameterName": "_b_tree_bitmap_plans",
"ApplyType": "dynamic",
"Description": "_b_tree_bitmap_plans",
"IsModifiable": true,
"Source": "engine-default",
"DataType": "boolean"
},
{
"AllowedValues": "TRUE,FALSE",
"ParameterName": "parallel_automatic_tuning",
"ApplyType": "static",
"Description": "enable intelligent defaults for parallel execution parameters",
"IsModifiable": true,
"Source": "engine-default",
"DataType": "boolean"
},
{
"AllowedValues": "ENABLE,DISABLE",
"ParameterName": "xml_db_events",
"ApplyType": "dynamic",
"Description": "are XML DB events enabled",
"IsModifiable": false,
"Source": "engine-default",
"DataType": "string"
}
]
}
}