예제 #1
0
        public void UploadUDBParamGroupTest()
        {
            #region 配置内容
            var config = @"[client]
 port = 3306
 socket = /tmp/mysql.sock
 [myisamchk]
 key_buffer_size = 20M
 read_buffer = 2M
 sort_buffer_size = 20M
 write_buffer = 2M
 [mysql]
 no-auto-rehash
 [mysqld]
 back_log = 2000
 basedir = /opt/udb/program/mysql/mysql-5.6.20
 bind-address = 10.4.4.168
 binlog-format = MIXED
 character_set_server = utf8
 datadir = /opt/udb/instance/mysql-5.6/17e34f69-84df-4dfe-9318-4f5a5d824472/data
 event_scheduler = ON
 expire_logs_days = 7
 general-log-file = /opt/udb/instance/mysql-5.6/17e34f69-84df-4dfe-9318-4f5a5d824472/log/mysqld.log
 innodb_buffer_pool_size = 629145600
 innodb_data_file_path = ibdata1:100M:autoextend
 innodb_data_home_dir = /opt/udb/instance/mysql-5.6/17e34f69-84df-4dfe-9318-4f5a5d824472/data
 innodb_file_per_table = 1
 innodb_flush_log_at_trx_commit = 2
 innodb_flush_method = O_DIRECT
 innodb_io_capacity = 2000
 innodb_log_buffer_size = 8388608
 innodb_log_file_size = 512M
 innodb_log_files_in_group = 2
 innodb_log_group_home_dir = /opt/udb/instance/mysql-5.6/17e34f69-84df-4dfe-9318-4f5a5d824472/data
 innodb_max_dirty_pages_pct = 50
 innodb_open_files = 1024
 innodb_read_io_threads = 8
 innodb_thread_concurrency = 20
 innodb_write_io_threads = 8
 key_buffer_size = 33554432
 local_infile = 0
 log-bin = /opt/udb/instance/mysql-5.6/17e34f69-84df-4dfe-9318-4f5a5d824472/binlog/mysql-bin.log
 log-error = /opt/udb/instance/mysql-5.6/17e34f69-84df-4dfe-9318-4f5a5d824472/log/mysqld.log
log_bin_trust_function_creators = 1
 log_output = TABLE
 long_query_time = 3
 max_allowed_packet = 16777216
 max_connect_errors = 1000000
 max_connections = 2000
 myisam_sort_buffer_size = 8388608
 net_buffer_length = 8192
 pid-file = /opt/udb/instance/mysql-5.6/17e34f69-84df-4dfe-9318-4f5a5d824472/mysqld.pid
 port = 3306
 query_cache_size = 16777216
 read_buffer_size = 262144
 read_rnd_buffer_size = 524288
 relay-log = /opt/udb/instance/mysql-5.6/17e34f69-84df-4dfe-9318-4f5a5d824472/relaylog/mysql-relay.log
 secure-file-priv = /opt/udb/instance/mysql-5.6/17e34f69-84df-4dfe-9318-4f5a5d824472/tmp
 server-id = 168035496
 skip-slave-start
 skip_name_resolve
 slave-load-tmpdir = /opt/udb/instance/mysql-5.6/17e34f69-84df-4dfe-9318-4f5a5d824472/tmp
 slow-query-log-file = /opt/udb/instance/mysql-5.6/17e34f69-84df-4dfe-9318-4f5a5d824472/log/mysql-slow.log
 slow_query_log = 1
 socket = /opt/udb/instance/mysql-5.6/17e34f69-84df-4dfe-9318-4f5a5d824472/mysqld.sock
 sort_buffer_size = 524288
 sync_binlog = 1
 table_open_cache = 128
 thread_cache_size = 50
 tmpdir = /opt/udb/instance/mysql-5.6/17e34f69-84df-4dfe-9318-4f5a5d824472/tmp
 user = mysql
 [mysqld_safe]
 log-error = /opt/udb/instance/mysql-5.6/17e34f69-84df-4dfe-9318-4f5a5d824472/log/mysqld.log
 pid-file = /opt/udb/instance/mysql-5.6/17e34f69-84df-4dfe-9318-4f5a5d824472/mysqld.pid
 [mysqldump]
 max_allowed_packet = 16M
 quick
 [mysqlhotcopy]
 interactive-timeout
 /opt/udb/instance/mysq";
            #endregion
            var entity   = new UploadUDBParamGroupRequest(Config.region, "mysql-5.1", "ICYGMA", "icyuup", config);
            var response = udb.UploadUDBParamGroup(entity);
            Assert.AreEqual(response.RetCode, 0);
        }