# This is an automatically generated code sample.
# To make this code sample work in your Oracle Cloud tenancy,
# please replace the values for any parameters whose current values do not fit
# your use case (such as resource IDs, strings containing ‘EXAMPLE’ or ‘unique_id’, and
# boolean, number, and enum parameters with values not fitting your use case).

require 'oci'

# Create a default config using DEFAULT profile in default location
# Refer to https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File for more info
config = OCI::ConfigFileLoader.load_config

# Initialize service client with default config file
mysql_client = OCI::Mysql::MysqlaasClient.new(config: config)

# Send the request to service, some parameters are not required, see API doc for more info
create_configuration_response =
  mysql_client.create_configuration(
    OCI::Mysql::Models::CreateConfigurationDetails.new(
      compartment_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value',
      shape_name: 'EXAMPLE-shapeName-Value',
      description: 'EXAMPLE-description-Value',
      display_name: 'EXAMPLE-displayName-Value',
      init_variables:
        OCI::Mysql::Models::InitializationVariables.new(
          lower_case_table_names: 'CASE_SENSITIVE'
        ),
      variables:
        OCI::Mysql::Models::ConfigurationVariables.new(
          completion_type: 'CHAIN',
          big_tables: true,
          character_set_server: 'ASCII',
          collation_server: 'UTF16_SPANISH2_CI',
          connection_memory_chunk_size: 301_848_735,
          connection_memory_limit: 5_470_040_209_086_029_824,
          default_authentication_plugin: 'mysql_native_password',
          global_connection_memory_limit: 6_369_579_504_287_762_432,
          global_connection_memory_tracking: true,
          transaction_isolation: 'READ-UNCOMMITTED',
          innodb_ft_server_stopword_table:
            'EXAMPLE-innodbFtServerStopwordTable-Value',
          mandatory_roles: 'EXAMPLE-mandatoryRoles-Value',
          autocommit: true,
          foreign_key_checks: false,
          group_replication_consistency: 'BEFORE_ON_PRIMARY_FAILOVER',
          group_concat_max_len: 6_786_329_548_635_256_836,
          innodb_ft_enable_stopword: false,
          innodb_log_writer_threads: true,
          local_infile: false,
          mysql_firewall_mode: false,
          mysqlx_enable_hello_notice: true,
          sql_require_primary_key: false,
          sql_warnings: false,
          binlog_expire_logs_seconds: 680,
          binlog_row_metadata: 'MINIMAL',
          binlog_row_value_options: 'EXAMPLE-binlogRowValueOptions-Value',
          binlog_transaction_compression: false,
          innodb_buffer_pool_size: 7_383_476_128_685_575_168,
          innodb_ft_result_cache_limit: 1_273_138_214,
          max_binlog_cache_size: 62_449_674_704_690,
          max_connect_errors: 5_282_117_595_576_105_985,
          max_heap_table_size: 600_492_214_157_382_656,
          max_connections: 44_482,
          max_prepared_stmt_count: 705_989,
          connect_timeout: 18_587_749,
          cte_max_recursion_depth: 1_013_045_287,
          generated_random_password_length: 126,
          information_schema_stats_expiry: 22_254_005,
          innodb_buffer_pool_dump_pct: 19,
          innodb_buffer_pool_instances: 51,
          innodb_ddl_buffer_size: 2_034_787_692,
          innodb_ddl_threads: 32,
          innodb_ft_max_token_size: 76,
          innodb_ft_min_token_size: 13,
          innodb_ft_num_word_optimize: 914,
          innodb_lock_wait_timeout: 735_064_670,
          innodb_max_purge_lag: 2_296_495_387,
          innodb_max_purge_lag_delay: 426_405,
          interactive_timeout: 21_842_006,
          innodb_stats_persistent_sample_pages: 414_980_989_442_976_769,
          innodb_stats_transient_sample_pages: 1_986_501_974_961_737_729,
          innodb_strict_mode: true,
          max_allowed_packet: 624_094_741,
          max_execution_time: 6_730_401_751_565_655_040,
          mysqlx_connect_timeout: 40_456_499,
          mysqlx_document_id_unique_prefix: 2357,
          mysqlx_idle_worker_thread_timeout: 3130,
          mysqlx_interactive_timeout: 1_871_655,
          mysqlx_max_allowed_packet: 354_140_031,
          mysqlx_min_worker_threads: 96,
          mysqlx_read_timeout: 1_199_445,
          mysqlx_wait_timeout: 2_146_668,
          mysqlx_write_timeout: 519_583,
          net_read_timeout: 22_406_079,
          net_write_timeout: 29_574_187,
          parser_max_mem_size: 4_477_923_907_796_279_424,
          query_alloc_block_size: 2_534_154_462,
          query_prealloc_size: 7_946_287_164_000_253_952,
          regexp_time_limit: 65_957_739,
          sql_mode: 'EXAMPLE-sqlMode-Value',
          tmp_table_size: 2_718_399_858_237_197_824,
          mysqlx_deflate_default_compression_level: 4,
          mysqlx_deflate_max_client_compression_level: 8,
          mysqlx_lz4_max_client_compression_level: 11,
          mysqlx_lz4_default_compression_level: 11,
          mysqlx_zstd_max_client_compression_level: 7,
          mysqlx_zstd_default_compression_level: 1,
          mysql_zstd_default_compression_level: 3,
          sort_buffer_size: 1_473_136_740_859_267_072,
          wait_timeout: 775_212,
          thread_pool_dedicated_listeners: false,
          thread_pool_max_transactions_limit: 63_479,
          time_zone: 'EXAMPLE-timeZone-Value',
          block_encryption_mode: 'EXAMPLE-blockEncryptionMode-Value',
          binlog_group_commit_sync_delay: 933_979,
          binlog_group_commit_sync_no_delay_count: 61_001,
          replica_net_timeout: 24_319_004,
          require_secure_transport: true,
          innodb_redo_log_capacity: 29_292_644_607,
          thread_pool_transaction_delay: 70_080,
          thread_pool_query_threads_per_group: 1479,
          explain_format: 'JSON',
          explicit_defaults_for_timestamp: true,
          sql_generate_invisible_primary_key: true,
          temptable_max_ram: 3_808_768_589_298_262_528,
          innodb_change_buffering: 'NONE',
          innodb_adaptive_hash_index: true,
          innodb_undo_log_truncate: true,
          table_definition_cache: 340_499,
          table_open_cache: 131_208,
          relay_log_space_limit: 4_762_162_299_060_474_880,
          optimizer_switch: 'EXAMPLE-optimizerSwitch-Value',
          replica_type_conversions: 'EXAMPLE-replicaTypeConversions-Value',
          replica_parallel_workers: 780,
          skip_name_resolve: true,
          max_user_connections: 1_296_565_297,
          join_buffer_size: 2_597_465_071_700_839_552,
          max_seeks_for_key: 8_272_236_807_126_123_521,
          range_optimizer_max_mem_size: 444_155_385_074_831_360,
          auto_increment_increment: 43_961,
          auto_increment_offset: 13_091,
          innodb_autoinc_lock_mode: 21,
          innodb_rollback_on_timeout: false,
          innodb_online_alter_log_max_size: 760_804_923_084_334_848,
          innodb_sort_buffer_size: 57_352_371,
          innodb_numa_interleave: false,
          thread_pool_size: 78,
          long_query_time: 29_206_794
        ),
      parent_configuration_id:
        'ocid1.test.oc1..<unique_ID>EXAMPLE-parentConfigurationId-Value',
      freeform_tags: {
        'EXAMPLE_KEY_oJHai' => 'EXAMPLE_VALUE_0u500TVJo67hIH2JQ6kP'
      },
      defined_tags: {
        'EXAMPLE_KEY_GRdFa' => { 'EXAMPLE_KEY_vd2DN' => 'EXAMPLE--Value' }
      }
    )
  )

# Get the data from response
puts "#{create_configuration_response.data}"