import * as pulumi from "@pulumi/pulumi"; import * as inputs from "../types/input"; import * as outputs from "../types/output"; /** * This resource provides the Mysql Configuration resource in Oracle Cloud Infrastructure MySQL Database service. * Api doc link for the resource: https://docs.oracle.com/iaas/api/#/en/mysql/latest/MysqlConfiguration * * Example terraform configs related to the resource : https://github.com/oracle/terraform-provider-oci/tree/master/examples/mysql * * Creates a new Configuration. * * ## Example Usage * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as oci from "@pulumi/oci"; * * const testMysqlConfiguration = new oci.mysql.MysqlConfiguration("test_mysql_configuration", { * compartmentId: compartmentId, * shapeName: testShape.name, * definedTags: { * "foo-namespace.bar-key": "value", * }, * description: mysqlConfigurationDescription, * displayName: mysqlConfigurationDisplayName, * freeformTags: { * "bar-key": "value", * }, * initVariables: { * lowerCaseTableNames: mysqlConfigurationInitVariablesLowerCaseTableNames, * }, * options: [{ * name: mysqlConfigurationOptionsName, * value: mysqlConfigurationOptionsValue, * }], * parentConfigurationId: testConfiguration.id, * variables: { * autoIncrementIncrement: Number(mysqlConfigurationVariablesAutoIncrementIncrement), * autoIncrementOffset: Number(mysqlConfigurationVariablesAutoIncrementOffset), * autocommit: mysqlConfigurationVariablesAutocommit === "true", * bigTables: mysqlConfigurationVariablesBigTables === "true", * binlogExpireLogsSeconds: Number(mysqlConfigurationVariablesBinlogExpireLogsSeconds), * binlogGroupCommitSyncDelay: Number(mysqlConfigurationVariablesBinlogGroupCommitSyncDelay), * binlogGroupCommitSyncNoDelayCount: Number(mysqlConfigurationVariablesBinlogGroupCommitSyncNoDelayCount), * binlogRowMetadata: mysqlConfigurationVariablesBinlogRowMetadata, * binlogRowValueOptions: mysqlConfigurationVariablesBinlogRowValueOptions, * binlogTransactionCompression: mysqlConfigurationVariablesBinlogTransactionCompression === "true", * blockEncryptionMode: mysqlConfigurationVariablesBlockEncryptionMode, * characterSetServer: mysqlConfigurationVariablesCharacterSetServer, * collationServer: mysqlConfigurationVariablesCollationServer, * completionType: mysqlConfigurationVariablesCompletionType, * connectTimeout: Number(mysqlConfigurationVariablesConnectTimeout), * connectionMemoryChunkSize: Number(mysqlConfigurationVariablesConnectionMemoryChunkSize), * connectionMemoryLimit: mysqlConfigurationVariablesConnectionMemoryLimit, * cteMaxRecursionDepth: mysqlConfigurationVariablesCteMaxRecursionDepth, * defaultAuthenticationPlugin: mysqlConfigurationVariablesDefaultAuthenticationPlugin, * explainFormat: mysqlConfigurationVariablesExplainFormat, * explicitDefaultsForTimestamp: mysqlConfigurationVariablesExplicitDefaultsForTimestamp === "true", * foreignKeyChecks: mysqlConfigurationVariablesForeignKeyChecks === "true", * generatedRandomPasswordLength: Number(mysqlConfigurationVariablesGeneratedRandomPasswordLength), * globalConnectionMemoryLimit: mysqlConfigurationVariablesGlobalConnectionMemoryLimit, * globalConnectionMemoryTracking: mysqlConfigurationVariablesGlobalConnectionMemoryTracking === "true", * groupConcatMaxLen: mysqlConfigurationVariablesGroupConcatMaxLen, * groupReplicationConsistency: mysqlConfigurationVariablesGroupReplicationConsistency, * informationSchemaStatsExpiry: Number(mysqlConfigurationVariablesInformationSchemaStatsExpiry), * innodbAdaptiveHashIndex: mysqlConfigurationVariablesInnodbAdaptiveHashIndex === "true", * innodbAutoincLockMode: Number(mysqlConfigurationVariablesInnodbAutoincLockMode), * innodbBufferPoolDumpPct: Number(mysqlConfigurationVariablesInnodbBufferPoolDumpPct), * innodbBufferPoolInstances: Number(mysqlConfigurationVariablesInnodbBufferPoolInstances), * innodbBufferPoolSize: mysqlConfigurationVariablesInnodbBufferPoolSize, * innodbChangeBuffering: mysqlConfigurationVariablesInnodbChangeBuffering, * innodbDdlBufferSize: mysqlConfigurationVariablesInnodbDdlBufferSize, * innodbDdlThreads: Number(mysqlConfigurationVariablesInnodbDdlThreads), * innodbFtEnableStopword: mysqlConfigurationVariablesInnodbFtEnableStopword === "true", * innodbFtMaxTokenSize: Number(mysqlConfigurationVariablesInnodbFtMaxTokenSize), * innodbFtMinTokenSize: Number(mysqlConfigurationVariablesInnodbFtMinTokenSize), * innodbFtNumWordOptimize: Number(mysqlConfigurationVariablesInnodbFtNumWordOptimize), * innodbFtResultCacheLimit: mysqlConfigurationVariablesInnodbFtResultCacheLimit, * innodbFtServerStopwordTable: mysqlConfigurationVariablesInnodbFtServerStopwordTable, * innodbLockWaitTimeout: Number(mysqlConfigurationVariablesInnodbLockWaitTimeout), * innodbLogWriterThreads: mysqlConfigurationVariablesInnodbLogWriterThreads === "true", * innodbMaxPurgeLag: mysqlConfigurationVariablesInnodbMaxPurgeLag, * innodbMaxPurgeLagDelay: Number(mysqlConfigurationVariablesInnodbMaxPurgeLagDelay), * innodbNumaInterleave: mysqlConfigurationVariablesInnodbNumaInterleave === "true", * innodbOnlineAlterLogMaxSize: mysqlConfigurationVariablesInnodbOnlineAlterLogMaxSize, * innodbRedoLogCapacity: mysqlConfigurationVariablesInnodbRedoLogCapacity, * innodbRollbackOnTimeout: mysqlConfigurationVariablesInnodbRollbackOnTimeout === "true", * innodbSortBufferSize: Number(mysqlConfigurationVariablesInnodbSortBufferSize), * innodbStatsPersistentSamplePages: mysqlConfigurationVariablesInnodbStatsPersistentSamplePages, * innodbStatsTransientSamplePages: mysqlConfigurationVariablesInnodbStatsTransientSamplePages, * innodbStrictMode: mysqlConfigurationVariablesInnodbStrictMode === "true", * innodbUndoLogTruncate: mysqlConfigurationVariablesInnodbUndoLogTruncate === "true", * interactiveTimeout: Number(mysqlConfigurationVariablesInteractiveTimeout), * joinBufferSize: mysqlConfigurationVariablesJoinBufferSize, * localInfile: mysqlConfigurationVariablesLocalInfile === "true", * longQueryTime: Number(mysqlConfigurationVariablesLongQueryTime), * mandatoryRoles: mysqlConfigurationVariablesMandatoryRoles, * maxAllowedPacket: Number(mysqlConfigurationVariablesMaxAllowedPacket), * maxBinlogCacheSize: mysqlConfigurationVariablesMaxBinlogCacheSize, * maxConnectErrors: mysqlConfigurationVariablesMaxConnectErrors, * maxConnections: Number(mysqlConfigurationVariablesMaxConnections), * maxExecutionTime: mysqlConfigurationVariablesMaxExecutionTime, * maxHeapTableSize: mysqlConfigurationVariablesMaxHeapTableSize, * maxPreparedStmtCount: Number(mysqlConfigurationVariablesMaxPreparedStmtCount), * maxSeeksForKey: mysqlConfigurationVariablesMaxSeeksForKey, * maxUserConnections: mysqlConfigurationVariablesMaxUserConnections, * mysqlFirewallMode: mysqlConfigurationVariablesMysqlFirewallMode === "true", * mysqlZstdDefaultCompressionLevel: Number(mysqlConfigurationVariablesMysqlZstdDefaultCompressionLevel), * mysqlxConnectTimeout: Number(mysqlConfigurationVariablesMysqlxConnectTimeout), * mysqlxDeflateDefaultCompressionLevel: Number(mysqlConfigurationVariablesMysqlxDeflateDefaultCompressionLevel), * mysqlxDeflateMaxClientCompressionLevel: Number(mysqlConfigurationVariablesMysqlxDeflateMaxClientCompressionLevel), * mysqlxDocumentIdUniquePrefix: Number(mysqlConfigurationVariablesMysqlxDocumentIdUniquePrefix), * mysqlxEnableHelloNotice: mysqlConfigurationVariablesMysqlxEnableHelloNotice === "true", * mysqlxIdleWorkerThreadTimeout: Number(mysqlConfigurationVariablesMysqlxIdleWorkerThreadTimeout), * mysqlxInteractiveTimeout: Number(mysqlConfigurationVariablesMysqlxInteractiveTimeout), * mysqlxLz4defaultCompressionLevel: Number(mysqlConfigurationVariablesMysqlxLz4defaultCompressionLevel), * mysqlxLz4maxClientCompressionLevel: Number(mysqlConfigurationVariablesMysqlxLz4maxClientCompressionLevel), * mysqlxMaxAllowedPacket: Number(mysqlConfigurationVariablesMysqlxMaxAllowedPacket), * mysqlxMinWorkerThreads: Number(mysqlConfigurationVariablesMysqlxMinWorkerThreads), * mysqlxReadTimeout: Number(mysqlConfigurationVariablesMysqlxReadTimeout), * mysqlxWaitTimeout: Number(mysqlConfigurationVariablesMysqlxWaitTimeout), * mysqlxWriteTimeout: Number(mysqlConfigurationVariablesMysqlxWriteTimeout), * mysqlxZstdDefaultCompressionLevel: Number(mysqlConfigurationVariablesMysqlxZstdDefaultCompressionLevel), * mysqlxZstdMaxClientCompressionLevel: Number(mysqlConfigurationVariablesMysqlxZstdMaxClientCompressionLevel), * netReadTimeout: Number(mysqlConfigurationVariablesNetReadTimeout), * netWriteTimeout: Number(mysqlConfigurationVariablesNetWriteTimeout), * optimizerSwitch: mysqlConfigurationVariablesOptimizerSwitch, * parserMaxMemSize: mysqlConfigurationVariablesParserMaxMemSize, * queryAllocBlockSize: mysqlConfigurationVariablesQueryAllocBlockSize, * queryPreallocSize: mysqlConfigurationVariablesQueryPreallocSize, * rangeOptimizerMaxMemSize: mysqlConfigurationVariablesRangeOptimizerMaxMemSize, * regexpTimeLimit: Number(mysqlConfigurationVariablesRegexpTimeLimit), * relayLogSpaceLimit: mysqlConfigurationVariablesRelayLogSpaceLimit, * replicaNetTimeout: Number(mysqlConfigurationVariablesReplicaNetTimeout), * replicaParallelWorkers: Number(mysqlConfigurationVariablesReplicaParallelWorkers), * replicaTypeConversions: mysqlConfigurationVariablesReplicaTypeConversions, * requireSecureTransport: mysqlConfigurationVariablesRequireSecureTransport === "true", * skipNameResolve: mysqlConfigurationVariablesSkipNameResolve === "true", * sortBufferSize: mysqlConfigurationVariablesSortBufferSize, * sqlGenerateInvisiblePrimaryKey: mysqlConfigurationVariablesSqlGenerateInvisiblePrimaryKey === "true", * sqlMode: mysqlConfigurationVariablesSqlMode, * sqlRequirePrimaryKey: mysqlConfigurationVariablesSqlRequirePrimaryKey === "true", * sqlWarnings: mysqlConfigurationVariablesSqlWarnings === "true", * tableDefinitionCache: Number(mysqlConfigurationVariablesTableDefinitionCache), * tableOpenCache: Number(mysqlConfigurationVariablesTableOpenCache), * temptableMaxRam: mysqlConfigurationVariablesTemptableMaxRam, * threadPoolDedicatedListeners: mysqlConfigurationVariablesThreadPoolDedicatedListeners === "true", * threadPoolMaxTransactionsLimit: Number(mysqlConfigurationVariablesThreadPoolMaxTransactionsLimit), * threadPoolQueryThreadsPerGroup: Number(mysqlConfigurationVariablesThreadPoolQueryThreadsPerGroup), * threadPoolSize: Number(mysqlConfigurationVariablesThreadPoolSize), * threadPoolTransactionDelay: Number(mysqlConfigurationVariablesThreadPoolTransactionDelay), * timeZone: mysqlConfigurationVariablesTimeZone, * tmpTableSize: mysqlConfigurationVariablesTmpTableSize, * transactionIsolation: mysqlConfigurationVariablesTransactionIsolation, * waitTimeout: Number(mysqlConfigurationVariablesWaitTimeout), * }, * }); * ``` * * ## Import * * MysqlConfigurations can be imported using the `id`, e.g. * * ```sh * $ pulumi import oci:Mysql/mysqlConfiguration:MysqlConfiguration test_mysql_configuration "configurations/{configurationId}" * ``` */ export declare class MysqlConfiguration extends pulumi.CustomResource { /** * Get an existing MysqlConfiguration resource's state with the given name, ID, and optional extra * properties used to qualify the lookup. * * @param name The _unique_ name of the resulting resource. * @param id The _unique_ provider ID of the resource to lookup. * @param state Any extra arguments used during the lookup. * @param opts Optional settings to control the behavior of the CustomResource. */ static get(name: string, id: pulumi.Input, state?: MysqlConfigurationState, opts?: pulumi.CustomResourceOptions): MysqlConfiguration; /** * Returns true if the given object is an instance of MysqlConfiguration. This is designed to work even * when multiple copies of the Pulumi SDK have been loaded into the same process. */ static isInstance(obj: any): obj is MysqlConfiguration; /** * The OCID of the compartment. */ readonly compartmentId: pulumi.Output; /** * (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: `{"foo-namespace.bar-key": "value"}` */ readonly definedTags: pulumi.Output<{ [key: string]: string; }>; /** * (Updatable) User-provided data about the Configuration. */ readonly description: pulumi.Output; /** * (Updatable) The display name of the Configuration. */ readonly displayName: pulumi.Output; /** * (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: `{"bar-key": "value"}` */ readonly freeformTags: pulumi.Output<{ [key: string]: string; }>; /** * DEPRECATED -- please use the `options` field instead. User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime. * * @deprecated The 'init_variables' field has been deprecated. Please use 'options' instead. */ readonly initVariables: pulumi.Output; /** * The MySQL options defined in the Configuration. */ readonly options: pulumi.Output; /** * The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration. */ readonly parentConfigurationId: pulumi.Output; /** * The name of the associated Shape. */ readonly shapeName: pulumi.Output; /** * The current state of the Configuration. */ readonly state: pulumi.Output; /** * Usage of system tag keys. These predefined keys are scoped to namespaces. Example: `{"orcl-cloud.free-tier-retained": "true"}` */ readonly systemTags: pulumi.Output<{ [key: string]: string; }>; /** * The date and time the Configuration was created, as described by [RFC 3339](https://tools.ietf.org/rfc/rfc3339). */ readonly timeCreated: pulumi.Output; /** * The date and time the Configuration was last updated, as described by [RFC 3339](https://tools.ietf.org/rfc/rfc3339). */ readonly timeUpdated: pulumi.Output; /** * The Configuration type, DEFAULT or CUSTOM. */ readonly type: pulumi.Output; /** * DEPRECATED -- please use the `options` field instead. User-defined service variables. * * @deprecated The 'variables' field has been deprecated. Please use 'options' instead. */ readonly variables: pulumi.Output; /** * Create a MysqlConfiguration resource with the given unique name, arguments, and options. * * @param name The _unique_ name of the resource. * @param args The arguments to use to populate this resource's properties. * @param opts A bag of options that control this resource's behavior. */ constructor(name: string, args: MysqlConfigurationArgs, opts?: pulumi.CustomResourceOptions); } /** * Input properties used for looking up and filtering MysqlConfiguration resources. */ export interface MysqlConfigurationState { /** * The OCID of the compartment. */ compartmentId?: pulumi.Input; /** * (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: `{"foo-namespace.bar-key": "value"}` */ definedTags?: pulumi.Input<{ [key: string]: pulumi.Input; } | undefined>; /** * (Updatable) User-provided data about the Configuration. */ description?: pulumi.Input; /** * (Updatable) The display name of the Configuration. */ displayName?: pulumi.Input; /** * (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: `{"bar-key": "value"}` */ freeformTags?: pulumi.Input<{ [key: string]: pulumi.Input; } | undefined>; /** * DEPRECATED -- please use the `options` field instead. User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime. * * @deprecated The 'init_variables' field has been deprecated. Please use 'options' instead. */ initVariables?: pulumi.Input; /** * The MySQL options defined in the Configuration. */ options?: pulumi.Input[] | undefined>; /** * The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration. */ parentConfigurationId?: pulumi.Input; /** * The name of the associated Shape. */ shapeName?: pulumi.Input; /** * The current state of the Configuration. */ state?: pulumi.Input; /** * Usage of system tag keys. These predefined keys are scoped to namespaces. Example: `{"orcl-cloud.free-tier-retained": "true"}` */ systemTags?: pulumi.Input<{ [key: string]: pulumi.Input; } | undefined>; /** * The date and time the Configuration was created, as described by [RFC 3339](https://tools.ietf.org/rfc/rfc3339). */ timeCreated?: pulumi.Input; /** * The date and time the Configuration was last updated, as described by [RFC 3339](https://tools.ietf.org/rfc/rfc3339). */ timeUpdated?: pulumi.Input; /** * The Configuration type, DEFAULT or CUSTOM. */ type?: pulumi.Input; /** * DEPRECATED -- please use the `options` field instead. User-defined service variables. * * @deprecated The 'variables' field has been deprecated. Please use 'options' instead. */ variables?: pulumi.Input; } /** * The set of arguments for constructing a MysqlConfiguration resource. */ export interface MysqlConfigurationArgs { /** * The OCID of the compartment. */ compartmentId: pulumi.Input; /** * (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: `{"foo-namespace.bar-key": "value"}` */ definedTags?: pulumi.Input<{ [key: string]: pulumi.Input; } | undefined>; /** * (Updatable) User-provided data about the Configuration. */ description?: pulumi.Input; /** * (Updatable) The display name of the Configuration. */ displayName?: pulumi.Input; /** * (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: `{"bar-key": "value"}` */ freeformTags?: pulumi.Input<{ [key: string]: pulumi.Input; } | undefined>; /** * DEPRECATED -- please use the `options` field instead. User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime. * * @deprecated The 'init_variables' field has been deprecated. Please use 'options' instead. */ initVariables?: pulumi.Input; /** * The MySQL options defined in the Configuration. */ options?: pulumi.Input[] | undefined>; /** * The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration. */ parentConfigurationId?: pulumi.Input; /** * The name of the associated Shape. */ shapeName: pulumi.Input; /** * DEPRECATED -- please use the `options` field instead. User-defined service variables. * * @deprecated The 'variables' field has been deprecated. Please use 'options' instead. */ variables?: pulumi.Input; } //# sourceMappingURL=mysqlConfiguration.d.ts.map