centos 7.5 手动安装oceanbase2.2报错
[2020-10-06 01:56:30.567956] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=5] | server_cpu_quota_min
= 2.5 [2020-10-06 01:56:30.567976] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | system_cpu_quota
= 10 [2020-10-06 01:56:30.567980] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=4] | tenant_cpu_variation_pe r_server = 50 [2020-10-06 01:56:30.567984] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=4] | rebuild_replica_data_la g_threshold = 0 [2020-10-06 01:56:30.568009] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=25] | tableapi_transport_com press_func = none [2020-10-06 01:56:30.568013] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=4] | chunk_row_store_mem_li mit = 0B [2020-10-06 01:56:30.568018] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=4] | enable_sql_operator_dum p = True [2020-10-06 01:56:30.568022] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | autoinc_cache_refresh_i nterval = 3600s [2020-10-06 01:56:30.568026] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=4] | memory_chunk_cache_size = 0M [2020-10-06 01:56:30.568030] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=4] | cache_wash_threshold
= 4GB [2020-10-06 01:56:30.568034] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | memory_limit_percentage = 80 [2020-10-06 01:56:30.568038] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | enable_syslog_recycle
= False [2020-10-06 01:56:30.568042] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | enable_syslog_wf
= True [2020-10-06 01:56:30.568046] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | enable_async_syslog
= True [2020-10-06 01:56:30.568049] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | max_syslog_file_count
= 0 [2020-10-06 01:56:30.568069] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=20] | syslog_io_bandwidth_li mit = 30MB [2020-10-06 01:56:30.568073] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | syslog_level
= INFO [2020-10-06 01:56:30.568076] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | obconfig_url
= [2020-10-06 01:56:30.568101] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=24] | cluster_id
= 20201006 [2020-10-06 01:56:30.568105] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | cluster
= obdemo [2020-10-06 01:56:30.568109] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | rootservice_list
= 192.168.3.105:2882:2881;192.168.3.115:2882:2881;192.168.3.125:2882:2881 [2020-10-06 01:56:30.568113] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | weak_read_version_refre sh_interval = 50ms [2020-10-06 01:56:30.568116] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | partition_balance_stra tegy = auto [2020-10-06 01:56:30.568121] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=4] | default_compress
= archive [2020-10-06 01:56:30.568125] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=4] | default_row_format
= dynamic [2020-10-06 01:56:30.568129] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | default_compress_func
= zstd_1.0 [2020-10-06 01:56:30.568149] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=19] | schema_history_expire time = 7d [2020-10-06 01:56:30.568153] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | enable_upgrade_mode
= False [2020-10-06 01:56:30.568179] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=26] | enable_separate_sys_cl og = False [2020-10-06 01:56:30.568183] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=4] | enable_perf_event
= True [2020-10-06 01:56:30.568187] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=4] | dead_socket_detection_t imeout = 10s [2020-10-06 01:56:30.568191] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=4] | debug_sync_timeout
= 0 [2020-10-06 01:56:30.568195] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=4] | enable_rich_error_msg
= False [2020-10-06 01:56:30.568199] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | enable_record_trace_id = True [2020-10-06 01:56:30.568202] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | enable_sql_audit
= True [2020-10-06 01:56:30.568207] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=4] | sql_audit_queue_size
= 10000000 [2020-10-06 01:56:30.568211] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | sql_audit_memory_limit = 3G [2020-10-06 01:56:30.568215] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | max_string_print_length = 500 [2020-10-06 01:56:30.568219] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | system_trace_level
= 1 [2020-10-06 01:56:30.568222] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | enable_record_trace_log = False [2020-10-06 01:56:30.568226] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | enable_pg
= False [2020-10-06 01:56:30.568230] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | enable_one_phase_commit = True [2020-10-06 01:56:30.568234] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | trace_log_slow_query_wa termark = 100ms [2020-10-06 01:56:30.568237] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | trace_log_sampling_inte rval = 10ms [2020-10-06 01:56:30.568257] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=4] | cpu_reserved
= 2 [2020-10-06 01:56:30.568261] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=4] | cpu_count
= 0 [2020-10-06 01:56:30.568265] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | minor_deferred_gc_leve l = 1 [2020-10-06 01:56:30.568268] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | minor_deferred_gc_time = 0s [2020-10-06 01:56:30.568272] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | minor_warm_up_duration time = 30s [2020-10-06 01:56:30.568278] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=4] | system_memory
= 50G [2020-10-06 01:56:30.568285] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=4] | rootservice_memory_limi t = 2G [2020-10-06 01:56:30.568291] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | memory_limit
= 0 [2020-10-06 01:56:30.568296] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | tenant_task_queue_size = 65536 [2020-10-06 01:56:30.568299] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | high_priority_net_threa d_count = 0 [2020-10-06 01:56:30.568303] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=4] | net_thread_count
= 12 [2020-10-06 01:56:30.568307] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | internal_sql_execute_ti meout = 30s [2020-10-06 01:56:30.568311] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | zone
= zone1 [2020-10-06 01:56:30.568316] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=5] | devname
= ens33 [2020-10-06 01:56:30.568320] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | mysql_port
= 2881 [2020-10-06 01:56:30.568323] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | rpc_port
= 2882 [2020-10-06 01:56:30.568327] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | leak_mod_to_check
= NONE [2020-10-06 01:56:30.568330] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | config_additional_dir
= /data/1/obdemo/etc3;/data/log1/obdemo/etc2 [2020-10-06 01:56:30.568334] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | memory_reserved
= 500M [2020-10-06 01:56:30.568338] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | datafile_disk_percentag e = 90 [2020-10-06 01:56:30.568341] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | datafile_size
= 10G [2020-10-06 01:56:30.568345] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | redundancy_level
= NORMAL [2020-10-06 01:56:30.568348] INFO ob_server_config.cpp:242 [1660][0][Y0-0000000000000000] [lt=3] | data_dir
= /home/admin/oceanbase/store/obdemo [2020-10-06 01:56:30.568354] INFO ob_server_config.cpp:245 [1660][0][Y0-0000000000000000] [lt=3] ===================== st op server config report ======================= [2020-10-06 01:56:30.568412] INFO ob_config.cpp:917 [1660][0][Y0-0000000000000000] [lt=3] succ to format_option_str(src="O PTIONAL", dest="OPTIONAL") [2020-10-06 01:56:30.568619] ERROR [SERVER] set_running_mode (ob_server.cpp:912) [1660][0][Y0-0000000000000000] [lt=5] memo ry limit too small(ret=-4624, memory_limit=6682365132) BACKTRACE:0x8ede32a 0x8e5735e 0x443f86 0xb39c05 0x402bacc 0x402e0ab 0x4033ab6 0x332cabe 0x2ace2982b445 0x3378145 [2020-10-06 01:56:30.568857] INFO ob_server.cpp:920 [1660][0][Y0-0000000000000000] [lt=233] mini mode: false [2020-10-06 01:56:30.568865] ERROR [SERVER] init_config (ob_server.cpp:866) [1660][0][Y0-0000000000000000] [lt=5] set runni ng mode failed(ret=-4624) BACKTRACE:0x8ede32a 0x8e5735e 0x443ab7 0xb35ec0 0x402e660 0x4033ab6 0x332cabe 0x2ace2982b445 0x33 78145 [2020-10-06 01:56:30.568886] ERROR [SERVER] init (ob_server.cpp:142) [1660][0][Y0-0000000000000000] [lt=15] init config fai l(ret=-4624) BACKTRACE:0x8ede32a 0x8e5735e 0x443ab7 0xb39a40 0x403484e 0x332cabe 0x2ace2982b445 0x3378145 [2020-10-06 01:56:30.568901] INFO [LIB] achunk_mgr.cpp:37 [1660][0][Y0-0000000000000000] [lt=11] set large page param(larg e_page_type=0) [2020-10-06 01:56:30.568908] INFO [SERVER] ob_service.cpp:250 [1660][0][Y0-0000000000000000] [lt=3] [NOTICE] observice nee d stop now [2020-10-06 01:56:30.568914] WARN [SERVER] destroy (ob_server.cpp:343) [1660][0][Y0-0000000000000000] [lt=4] destroy obser ver begin [2020-10-06 01:56:30.568933] INFO [SHARE] ob_backup_info_mgr.cpp:95 [1660][0][Y0-0000000000000000] [lt=6] ObBackupInfoMgr: :destroy [2020-10-06 01:56:30.568941] WARN [SERVER] destroy (ob_server.cpp:346) [1660][0][Y0-0000000000000000] [lt=4] backup info d estroyed [2020-10-06 01:56:30.568949] WARN [SERVER] destroy (ob_server.cpp:348) [1660][0][Y0-0000000000000000] [lt=5] backup file l ock mgr detroy [2020-10-06 01:56:30.568998] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=5] create tg succeed(tg_id=0, tg=0x2 ace2dbe94e0, thread_cnt=1, tg->attr_={name:"test1", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569004] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=1, tg=0x2 ace2dbe9920, thread_cnt=1, tg->attr_={name:"test2", desc:"", scope:1, type:5}) [2020-10-06 01:56:30.569010] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=2, tg=0x2 ace34627440, thread_cnt=1, tg->attr_={name:"test3", desc:"", scope:1, type:6}) [2020-10-06 01:56:30.569020] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=6] create tg succeed(tg_id=3, tg=0x2 ace34628b60, thread_cnt=1, tg->attr_={name:"test4", desc:"", scope:1, type:1}) [2020-10-06 01:56:30.569028] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=4, tg=0x2 ace2dbd6970, thread_cnt=1, tg->attr_={name:"test5", desc:"", scope:1, type:7}) [2020-10-06 01:56:30.569033] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=5, tg=0x2 ace346294b0, thread_cnt=2, tg->attr_={name:"test6", desc:"", scope:1, type:4}) [2020-10-06 01:56:30.569038] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=6, tg=0x2 ace2dbd74b0, thread_cnt=1, tg->attr_={name:"memDump", desc:"", scope:1, type:1}) [2020-10-06 01:56:30.569043] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=7, tg=0x2 ace2dbd7570, thread_cnt=1, tg->attr_={name:"IOFDetector", desc:"", scope:1, type:5}) [2020-10-06 01:56:30.569050] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=8, tg=0x2 ace34631670, thread_cnt=1, tg->attr_={name:"SchemaRefTask", desc:"", scope:1, type:6}) [2020-10-06 01:56:30.569056] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=9, tg=0x2 ace34632d90, thread_cnt=1, tg->attr_={name:"ConfigMgr", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569061] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=10, tg=0x 2ace346331d0, thread_cnt=1, tg->attr_={name:"ReqMemEvict", desc:"", scope:2, type:3}) [2020-10-06 01:56:30.569068] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=11, tg=0x 2ace2dbd94e0, thread_cnt=65, tg->attr_={name:"IOMGR", desc:"", scope:1, type:1}) [2020-10-06 01:56:30.569073] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=12, tg=0x 2ace2dbd95a0, thread_cnt=32, tg->attr_={name:"IODISK", desc:"", scope:2, type:1}) [2020-10-06 01:56:30.569078] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=13, tg=0x 2ace34628c20, thread_cnt=1, tg->attr_={name:"TimezoneMgr", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569086] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=14, tg=0x 2ace34629060, thread_cnt=1, tg->attr_={name:"testObTh", desc:"", scope:1, type:2}) [2020-10-06 01:56:30.569093] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=15, tg=0x 2ace34629120, thread_cnt=1, tg->attr_={name:"Blacklist", desc:"", scope:1, type:2}) [2020-10-06 01:56:30.569101] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=16, tg=0x 2ace346291e0, thread_cnt=128, tg->attr_={name:"SqlDistSched", desc:"", scope:1, type:5}) [2020-10-06 01:56:30.569109] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=17, tg=0x 2ace2dbd4900, thread_cnt=4, tg->attr_={name:"PartSerMigRetryQt", desc:"", scope:1, type:5}) [2020-10-06 01:56:30.569115] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=18, tg=0x 2ace2dbd4b00, thread_cnt=20, tg->attr_={name:"PartSerCb", desc:"", scope:1, type:5}) [2020-10-06 01:56:30.569121] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=19, tg=0x 2ace2dbd4d00, thread_cnt=20, tg->attr_={name:"PartSerLargeCb", desc:"", scope:1, type:5}) [2020-10-06 01:56:30.569130] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=20, tg=0x 2ace2dbd4f00, thread_cnt=4, tg->attr_={name:"PartSerSlogWr", desc:"", scope:1, type:5}) [2020-10-06 01:56:30.569137] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=21, tg=0x 2ace346336e0, thread_cnt=16, tg->attr_={name:"LogScan", desc:"", scope:1, type:4}) [2020-10-06 01:56:30.569144] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=22, tg=0x 2ace2dbd5100, thread_cnt=1, tg->attr_={name:"ReplayEngine", desc:"", scope:1, type:5}) [2020-10-06 01:56:30.569152] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=5] create tg succeed(tg_id=23, tg=0x 2ace2dbd5300, thread_cnt=1, tg->attr_={name:"LogCb", desc:"", scope:1, type:5}) [2020-10-06 01:56:30.569157] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=24, tg=0x 2ace2dbd5500, thread_cnt=1, tg->attr_={name:"SpLogCb", desc:"", scope:1, type:5}) [2020-10-06 01:56:30.569162] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=25, tg=0x 2ace2dbd9660, thread_cnt=8, tg->attr_={name:"STableChecksumUp", desc:"", scope:2, type:2}) [2020-10-06 01:56:30.569167] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=26, tg=0x 2ace2dbd2890, thread_cnt=1, tg->attr_={name:"CLogAdapter", desc:"", scope:2, type:5}) [2020-10-06 01:56:30.569172] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=27, tg=0x 2ace2dbd2a90, thread_cnt=4, tg->attr_={name:"ClogAggre", desc:"", scope:2, type:5}) [2020-10-06 01:56:30.569177] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=28, tg=0x 2ace2dbd2c90, thread_cnt=8, tg->attr_={name:"PurgeWorker", desc:"", scope:1, type:2}) [2020-10-06 01:56:30.569183] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=29, tg=0x 2ace2dbd2d50, thread_cnt=4, tg->attr_={name:"TransMigrate", desc:"", scope:1, type:5}) [2020-10-06 01:56:30.569188] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=30, tg=0x 2ace3463b8a0, thread_cnt=4, tg->attr_={name:"UsrLocUpdTask", desc:"", scope:2, type:6}) [2020-10-06 01:56:30.569193] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=31, tg=0x 2ace3463cfc0, thread_cnt=1, tg->attr_={name:"WeakReadService", desc:"", scope:2, type:2}) [2020-10-06 01:56:30.569200] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=32, tg=0x 2ace3463d080, thread_cnt=8, tg->attr_={name:"TransTaskWork", desc:"", scope:1, type:5}) [2020-10-06 01:56:30.569205] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=33, tg=0x 2ace3463d280, thread_cnt=1, tg->attr_={name:"DDLTaskExecutor1", desc:"", scope:1, type:2}) [2020-10-06 01:56:30.569209] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=34, tg=0x 2ace3463d340, thread_cnt=4, tg->attr_={name:"DDLTaskExecutor2", desc:"", scope:1, type:2}) [2020-10-06 01:56:30.569216] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=35, tg=0x 2ace3463d400, thread_cnt=8, tg->attr_={name:"FetchLogEngine", desc:"", scope:1, type:5}) [2020-10-06 01:56:30.569222] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=36, tg=0x 2ace3463d600, thread_cnt=8, tg->attr_={name:"GTSWorker", desc:"", scope:1, type:5}) [2020-10-06 01:56:30.569227] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=37, tg=0x 2ace3463d800, thread_cnt=9, tg->attr_={name:"BRPC", desc:"", scope:1, type:2}) [2020-10-06 01:56:30.569232] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=38, tg=0x 2ace2dbd9720, thread_cnt=3, tg->attr_={name:"LeaseQueueTh", desc:"", scope:1, type:2}) [2020-10-06 01:56:30.569236] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=39, tg=0x 2ace2dbd2f50, thread_cnt=1, tg->attr_={name:"DDLQueueTh", desc:"", scope:1, type:2}) [2020-10-06 01:56:30.569241] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=40, tg=0x 2ace2dbd3010, thread_cnt=6, tg->attr_={name:"MysqlQueueTh", desc:"", scope:1, type:2}) [2020-10-06 01:56:30.569246] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=41, tg=0x 2ace2dbd30d0, thread_cnt=2, tg->attr_={name:"DiagnoseQueueTh", desc:"", scope:1, type:2}) [2020-10-06 01:56:30.569255] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=6] create tg succeed(tg_id=42, tg=0x 2ace2dbd3190, thread_cnt=2, tg->attr_={name:"RLogQuery", desc:"", scope:1, type:5}) [2020-10-06 01:56:30.569263] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=43, tg=0x 2ace2dbd0820, thread_cnt=16, tg->attr_={name:"IdxBuild", desc:"", scope:1, type:7}) [2020-10-06 01:56:30.569270] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=44, tg=0x 2ace2dbd1360, thread_cnt=3, tg->attr_={name:"ClogHisRep", desc:"", scope:1, type:2}) [2020-10-06 01:56:30.569277] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=45, tg=0x 2ace2dbce7b0, thread_cnt=1, tg->attr_={name:"IntermResGC", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569283] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=46, tg=0x 2ace2dbcebf0, thread_cnt=1, tg->attr_={name:"ServerGTimer", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569288] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=47, tg=0x 2ace2dbcf030, thread_cnt=1, tg->attr_={name:"FreezeTimer", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569293] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=48, tg=0x 2ace2dbcc740, thread_cnt=1, tg->attr_={name:"SqlMemTimer", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569298] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=49, tg=0x 2ace2dbccb80, thread_cnt=1, tg->attr_={name:"ServerTracerTimer", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569305] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=50, tg=0x 2ace2dbccfc0, thread_cnt=1, tg->attr_={name:"RSqlPool", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569311] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=51, tg=0x 2ace2dbca6d0, thread_cnt=1, tg->attr_={name:"KVCacheWash", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569315] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=52, tg=0x 2ace2dbcab10, thread_cnt=1, tg->attr_={name:"KVCacheRep", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569323] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=53, tg=0x 2ace2dbcaf50, thread_cnt=1, tg->attr_={name:"ObHeartbeat", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569328] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=54, tg=0x 2ace2dbc8660, thread_cnt=1, tg->attr_={name:"PlanCacheEvict", desc:"", scope:2, type:3}) [2020-10-06 01:56:30.569334] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=55, tg=0x 2ace2dbc8aa0, thread_cnt=1, tg->attr_={name:"MinorScan", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569340] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=56, tg=0x 2ace2dbc8ee0, thread_cnt=1, tg->attr_={name:"MajorScan", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569345] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=57, tg=0x 2ace2dbc65f0, thread_cnt=1, tg->attr_={name:"EXTLogWash", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569350] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=58, tg=0x 2ace2dbc6a30, thread_cnt=1, tg->attr_={name:"LineCache", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569356] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=59, tg=0x 2ace2dbc6e70, thread_cnt=1, tg->attr_={name:"LocalityReload", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569361] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=60, tg=0x 2ace2dbc4580, thread_cnt=1, tg->attr_={name:"MemstoreGC", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569366] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=61, tg=0x 2ace2dbc49c0, thread_cnt=1, tg->attr_={name:"CLOGReqMinor", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569374] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=5] create tg succeed(tg_id=62, tg=0x 2ace2dbc4e00, thread_cnt=1, tg->attr_={name:"CKPTLogRep", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569379] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=63, tg=0x 2ace2dbc2510, thread_cnt=1, tg->attr_={name:"RebuildRetry", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569385] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=64, tg=0x 2ace2dbc2950, thread_cnt=1, tg->attr_={name:"TableMgrGC", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569393] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=65, tg=0x 2ace2dbc2d90, thread_cnt=1, tg->attr_={name:"IndexSche", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569398] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=66, tg=0x 2ace2dbc04a0, thread_cnt=1, tg->attr_={name:"FreInfoReload", desc:"", scope:2, type:3}) [2020-10-06 01:56:30.569403] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=67, tg=0x 2ace2dbc08e0, thread_cnt=1, tg->attr_={name:"HAGtsMgr", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569409] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=68, tg=0x 2ace2dbc0d20, thread_cnt=1, tg->attr_={name:"HAGtsHB", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569414] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=69, tg=0x 2ace2dbbe430, thread_cnt=1, tg->attr_={name:"RebuildTask", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569418] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=70, tg=0x 2ace2dbbe870, thread_cnt=1, tg->attr_={name:"LogDiskMon", desc:"", scope:2, type:3}) [2020-10-06 01:56:30.569426] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=71, tg=0x 2ace2dbbecb0, thread_cnt=1, tg->attr_={name:"ILOGFlush", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569432] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=72, tg=0x 2ace2dbbc3c0, thread_cnt=1, tg->attr_={name:"ILOGPurge", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569437] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=73, tg=0x 2ace2dbbc800, thread_cnt=1, tg->attr_={name:"RLogClrCache", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569444] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=74, tg=0x 2ace2dbbcc40, thread_cnt=1, tg->attr_={name:"TableStatRpt", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569453] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=75, tg=0x 2ace2dbf6d30, thread_cnt=1, tg->attr_={name:"MacroMetaMgr", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569460] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=76, tg=0x 2ace2dbf7170, thread_cnt=1, tg->attr_={name:"StoreFileGC", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569464] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=77, tg=0x 2ace2dbf75b0, thread_cnt=1, tg->attr_={name:"LeaseHB", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569469] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=78, tg=0x 2ace2dbf79f0, thread_cnt=1, tg->attr_={name:"CFC", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569474] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=3] create tg succeed(tg_id=79, tg=0x 2ace3463d910, thread_cnt=1, tg->attr_={name:"LogMysqlPool", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569479] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=80, tg=0x 2ace3463dd50, thread_cnt=1, tg->attr_={name:"TblCliSqlPool", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569484] INFO thread_mgr.h:718 [1660][0][Y0-0000000000000000] [lt=4] create tg succeed(tg_id=81, tg=0x 2ace3463e190, thread_cnt=1, tg->attr_={name:"QueryExecCtxGC", desc:"", scope:1, type:2}) [2020-10-06 01:56:30.569499] INFO thread_mgr.cpp:70 [1660][0][Y0-0000000000000000] [lt=4] destroy tg(tg_id=46, tg=0x2ace2d bcebf0, tg->attr_={name:"ServerGTimer", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569504] WARN [SERVER] destroy (ob_server.cpp:351) [1660][0][Y0-0000000000000000] [lt=4] timer destroy ed [2020-10-06 01:56:30.569512] INFO thread_mgr.cpp:70 [1660][0][Y0-0000000000000000] [lt=6] destroy tg(tg_id=47, tg=0x2ace2d bcf030, tg->attr_={name:"FreezeTimer", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569515] WARN [SERVER] destroy (ob_server.cpp:353) [1660][0][Y0-0000000000000000] [lt=3] freeze timer destroyed [2020-10-06 01:56:30.569522] INFO thread_mgr.cpp:70 [1660][0][Y0-0000000000000000] [lt=5] destroy tg(tg_id=48, tg=0x2ace2d bcc740, tg->attr_={name:"SqlMemTimer", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569526] WARN [SERVER] destroy (ob_server.cpp:355) [1660][0][Y0-0000000000000000] [lt=3] sql memory ma nager timer destroyed [2020-10-06 01:56:30.569532] INFO thread_mgr.cpp:70 [1660][0][Y0-0000000000000000] [lt=5] destroy tg(tg_id=49, tg=0x2ace2d bccb80, tg->attr_={name:"ServerTracerTimer", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.569536] WARN [SERVER] destroy (ob_server.cpp:357) [1660][0][Y0-0000000000000000] [lt=3] server trace timer destroyed [2020-10-06 01:56:30.569799] INFO thread_mgr.cpp:70 [1660][0][Y0-0000000000000000] [lt=3] destroy tg(tg_id=43, tg=0x2ace2d bd0820, tg->attr_={name:"IdxBuild", desc:"", scope:1, type:7}) [2020-10-06 01:56:30.569839] ERROR stop (ob_ddl_task_executor.cpp:176) [1660][0][Y0-0000000000000000] [lt=3] invalid tg id BACKTRACE:0x8ede32a 0x8e5735e 0x3379f9c 0x223cc2e 0x6d406c5 0x5936be5 0x5b1be57 0x40337d3 0x4034755 0x332cabe 0x2ace2982b44 5 0x3378145 [2020-10-06 01:56:30.569937] ERROR wait (ob_ddl_task_executor.cpp:181) [1660][0][Y0-0000000000000000] [lt=97] invalid tg id BACKTRACE:0x8ede32a 0x8e5735e 0x3379f9c 0x223cc7a 0x6d40815 0x5936bed 0x5b1be57 0x40337d3 0x4034755 0x332cabe 0x2ace2982b4 45 0x3378145 [2020-10-06 01:56:30.570001] WARN [SERVER] destroy (ob_server.cpp:359) [1660][0][Y0-0000000000000000] [lt=3] root service destroyed [2020-10-06 01:56:30.570010] WARN [SERVER] destroy (ob_service.cpp:291) [1660][0][Y0-0000000000000000] [lt=5] not init(ret =-4006) [2020-10-06 01:56:30.570017] WARN [SERVER] destroy (ob_server.cpp:361) [1660][0][Y0-0000000000000000] [lt=7] ob service de stroyed [2020-10-06 01:56:30.570028] WARN [SERVER] destroy (ob_server.cpp:363) [1660][0][Y0-0000000000000000] [lt=5] sql engine de stroyed [2020-10-06 01:56:30.570036] WARN [SERVER] destroy (ob_server.cpp:365) [1660][0][Y0-0000000000000000] [lt=5] sql engine de stroyed [2020-10-06 01:56:30.570046] WARN [SERVER] destroy (ob_server.cpp:367) [1660][0][Y0-0000000000000000] [lt=5] ob dag schedu ler destroyed [2020-10-06 01:56:30.570057] INFO [STORAGE] ob_partition_service.cpp:1186 [1660][0][Y0-0000000000000000] [lt=5] partition service destory [2020-10-06 01:56:30.570061] WARN [SERVER] destroy (ob_server.cpp:369) [1660][0][Y0-0000000000000000] [lt=4] partition ser vice destroyed [2020-10-06 01:56:30.570078] WARN [SERVER] destroy (ob_server.cpp:371) [1660][0][Y0-0000000000000000] [lt=5] gc partition adapter destroyed [2020-10-06 01:56:30.570108] WARN [SERVER] destroy (ob_server.cpp:373) [1660][0][Y0-0000000000000000] [lt=6] location cach e destroyed [2020-10-06 01:56:30.570128] INFO [STORAGE.TRANS] ob_weak_read_service.cpp:48 [1660][0][Y0-0000000000000000] [lt=13] [WRS] weak read service begin destroy [2020-10-06 01:56:30.570135] INFO [STORAGE.TRANS] ob_weak_read_service.cpp:55 [1660][0][Y0-0000000000000000] [lt=5] [WRS] weak read service destroy succ [2020-10-06 01:56:30.570139] WARN [SERVER] destroy (ob_server.cpp:375) [1660][0][Y0-0000000000000000] [lt=3] weak read ser vice destroyed [2020-10-06 01:56:30.570148] WARN [SERVER] destroy (ob_server.cpp:377) [1660][0][Y0-0000000000000000] [lt=5] oss storage d estroyed [2020-10-06 01:56:30.570217] INFO [COMMON] ob_io_manager.cpp:477 [1660][0][Y0-0000000000000000] [lt=7] start destroy io ma nager [2020-10-06 01:56:30.570226] INFO [COMMON] ob_io_disk.cpp:692 [1660][0][Y0-0000000000000000] [lt=5] io_fault_detector_ sto pped [2020-10-06 01:56:30.570234] INFO thread_mgr.cpp:70 [1660][0][Y0-0000000000000000] [lt=3] destroy tg(tg_id=0, tg=0x2ace2db e94e0, tg->attr_={name:"test1", desc:"", scope:1, type:3}) [2020-10-06 01:56:30.570483] INFO [COMMON] ob_io_manager.cpp:489 [1660][0][Y0-0000000000000000] [lt=3] finish destroy io m anager [2020-10-06 01:56:30.570488] WARN [SERVER] destroy (ob_server.cpp:379) [1660][0][Y0-0000000000000000] [lt=5] io manager de stroyed [2020-10-06 01:56:30.570500] WARN [COMMON] get_instance (memory_dump.cpp:85) [1660][0][Y0-0000000000000000] [lt=5] memory dump not init [2020-10-06 01:56:30.570506] WARN [SERVER] destroy (ob_server.cpp:381) [1660][0][Y0-0000000000000000] [lt=6] memory dump d estroyed [2020-10-06 01:56:30.570514] WARN [SERVER] destroy (ob_server.cpp:383) [1660][0][Y0-0000000000000000] [lt=5] net frame des troyed [2020-10-06 01:56:30.570533] WARN [SERVER] destroy (ob_server.cpp:385) [1660][0][Y0-0000000000000000] [lt=5] tenant timezo ne manager destroyed [2020-10-06 01:56:30.570539] WARN [SERVER] destroy (ob_server.cpp:386) [1660][0][Y0-0000000000000000] [lt=6] destroy obser ver end [2020-10-06 01:56:30.570545] ERROR [SERVER] main (main.cpp:456) [1660][0][Y0-0000000000000000] [lt=5] observer init fail(re t=-4624) BACKTRACE:0x8ede32a 0x8e5735e 0x443ab7 0x44347e 0x332d246 0x2ace2982b445 0x3378145 [2020-10-06 01:56:30.570571] INFO [COMMON] ob_kv_storecache.cpp:214 [1660][0][Y0-0000000000000000] [lt=13] Begin destroy t he ObKVGlobalCache! [2020-10-06 01:56:30.570582] INFO [COMMON] ob_kv_storecache.cpp:232 [1660][0][Y0-0000000000000000] [lt=4] The ObKVGlobalCa che has been destroyed! [2020-10-06 01:56:30.570618] INFO [SERVER] main.cpp:470 [1660][0][Y0-0000000000000000] [lt=3] observer is exit
写回答
-
、安装前的准备 1. 安装方式选择 OceanBase是一个集群数据库，至少要三个节点。通常三个节点是要在三台机器上。有关OceanBase的介绍请参考官网 http://oceanbase.alipay.com/docs 。
官网上提供了一个安装包的下载，地址是： OceanBase安装包下载链接 。 这个安装包里的内容很多。很大一部分是OCP的安装包以及相关安装说明。详细查看 安装包组件说明 。 我们只需要里面的2个文件。
$unzip ocp-release.zip $cd ocp-release/ $tar zxvf ocp-setup.tar.gz $cd ocp_yh
$ls -lrth obproxy-1.3.3-1506155.el7.x86_64.rpm oceanbase-1.4.60-1571952.el7.x86_64.rpm
-rwxr-xr-x 1 admin admin 36M May 11 2018 oceanbase-1.4.60-1571952.el7.x86_64.rpm -rwxr-xr-x 1 admin admin 5.4M May 11 2018 obproxy-1.3.3-1506155.el7.x86_64.rpm
这两个文件就是我们后面安装需要的。一个是observer的安装包，一个是obproxy的安装包。
由于环境的权限限制，服务器之间不能直接打通ssh通道，并且默认也不允许开启80端口和图形化界面，导致我无法使用官网推荐的2种方式安装。于是，我就一步步从命令行下安装OceanBase集群。从这个步骤里也可以看出一些OceanBase的原理。 实际过程并不复杂，很容易掌握。
- 部署要求
项目 描述 机型要求 建议物理机。如果是vmware虚拟出来的虚拟机也行，只是cpu、内存和磁盘不要太低。 操作系统 推荐redhat 7.2, centos 7.2 。 7.x 应该也可以。具体问题具体分析。 内存 推荐64G以上，生产环境建议256G以上。如果只是研究功能 8G以上。比这个还小，后面使用不熟悉的话，会误以为有很多问题。 磁盘 推荐普通ssd即可，生产环境也不需要高密度ssd盘。如果只是研究功能，用sata或sas也行。就是性能会不怎么好（其他数据库同理）。 磁盘空间 内存的4倍以上。生产环境建议1T以上。 如果只是研究功能，至少也要100G以上。比这个还小，后面使用不熟悉的话，会误以为有问题。 文件系统 ext4， xfs都可以。 网卡 推荐千兆互联以上。生产环境建议万兆互联。节点间的网络延时对OB的性能会有很大影响，所有的分布式产品都如此。 CPU 至少16核以上，生产环境建议32核以上。cpu太少，没法体验OB的多租户功能。 3. OS环境准备
这里就参见官方文档 修改操作系统配置 ，挑几个重要的提一下。
ulimit用于限制shell启动进程所占用的资源。有两种方法可以修改资源限制，一种是通过启动时session级别指定，另外一种是修改/etc/security/limits.conf配置文件，全局生效。 OBServer进程涉及的几个限制包括线程最大栈空间大小（stack），最大文件句柄数（openfiles），core文件大小（core file size）。
[size=font-size: 10.5pt,10.5pt]$vi /etc/security/limits.conf添加 [size=font-size: 10.5pt,10.5pt]* soft nofile 655350 [size=font-size: 10.5pt,10.5pt]* hard nofile 655350 [size=font-size: 10.5pt,10.5pt]* soft stack 20480 [size=font-size: 10.5pt,10.5pt]* hard stack 20480 [size=font-size: 10.5pt,10.5pt]* soft nproc 655360 [size=font-size: 10.5pt,10.5pt]* hard nproc 655360 [size=font-size: 10.5pt,10.5pt]* soft core unlimited [size=font-size: 10.5pt,10.5pt]* hardcore unlimited
稍微提一下的是目录准备。每个节点都会写数据和日志。根据经验数据和日志盘在底层要分离。如果能在raid层面隔离是最好的。如果做不好，那就用LVM在逻辑层面做隔离（即做不同的LV） 下面是我的环境
$sudo lvs -a LV VG Attr LSize Pool Origin Data% Meta% Move Log Cpy%Sync Convert data vgob -wi-ao---- 10.97t log vgob -wi-ao---- 1.05t
$cat /etc/fstab
LABEL=log1 /data/log1 ext4 defaults,noatime,nodiratime,nodelalloc,barrier=0 0 0 LABEL=data1 /data/1 xfs defaults,noatime,nodiratime,barrier=0 0 0
sysctl.conf修改
for oceanbase
net.core.somaxconn = 2048 net.core.netdev_max_backlog = 10000 net.core.rmem_default = 16777216 net.core.wmem_default = 16777216 net.core.rmem_max = 16777216 net.core.wmem_max = 16777216
net.ipv4.ip_local_port_range = 3500 65535 net.ipv4.ip_forward = 0 net.ipv4.conf.default.rp_filter = 1 net.ipv4.conf.default.accept_source_route = 0 net.ipv4.tcp_syncookies = 0 net.ipv4.tcp_rmem = 4096 87380 16777216 net.ipv4.tcp_wmem = 4096 65536 16777216 net.ipv4.tcp_max_syn_backlog = 16384 net.ipv4.tcp_fin_timeout = 15 net.ipv4.tcp_max_syn_backlog = 16384 net.ipv4.tcp_tw_reuse = 1 net.ipv4.tcp_tw_recycle = 1 net.ipv4.tcp_slow_start_after_idle=0
vm.swappiness = 0 kernel.core_pattern = /data/1/core-%e-%p-%t vm.min_free_kbytes = 2097152 vm.max_map_count=655360
- 机器准备
IP Zone 描述 xxx.xxx.171.187 zone1 observer 节点，rootservice 所在机器之一 xxx.xxx.241.129 zone1 observer 节点 xxx.xxx.240.24 zone2 observer 节点，rootservice 所在机器之一 xxx.xxx.241.145 zone2 observer 节点 xxx.xxx.241.125 zone3 observer 节点，rootservice 所在机器之一 xxx.xxx.241.159 zone3 observer 节点 xxx.xxx..242.22 NA obproxy 机器，一台就够了，可以部署多台，也可以复用 observer节点。 zone 是对机器的划分。一个oceanbase集群的机器至少划分为三个zone。通常数据至少有三份，分布在每个zone里面。二、安装启动OBServer
- 安装软件包
OceanBase是一个集群，但是安装却很简单，只需要在每个节点安装一个observer的rpm包(有2个依赖包 snappy和lzo需要先安装一下)，然后启动即可。
$sudo yum -y install snappy lzo $sudo rpm -ivh oceanbase-1.4.60-1571952.el7.x86_64.rpm
- 准备数据库目录
在启动 OBServer之前，需要准备一些数据目录。并且启动用户建议是 admin。 admin需要sudo权限。假设我要搭建的数据库集群叫 obdemo 。下面目录里会用到这个名字。 关于目录结构不多解释，待OB集群搭建成功后大家可以再去研究其目录。
su - admin mkdir -p /data/1/obdemo/ cd /data/1/obdemo/ mkdir -p etc3 sort_dir sstable mkdir -p /data/log1/obdemo/ cd /data/log1/obdemo/ mkdir -p clog etc2 ilog oob_clog slog mkdir -p /home/admin/oceanbase/store/obdemo cd /home/admin/oceanbase/store/obdemo/ ln -s /data/1/obdemo/sort_dir /home/admin/oceanbase/store/obdemo/sort_dir ln -s /data/1/obdemo/sstable /home/admin/oceanbase/store/obdemo/sstable ln -s /data/log1/obdemo/clog /home/admin/oceanbase/store/obdemo/clog ln -s /data/log1/obdemo/ilog /home/admin/oceanbase/store/obdemo/ilog ln -s /data/log1/obdemo/oob_clog /home/admin/oceanbase/store/obdemo/oob_clog ln -s /data/log1/obdemo/slog /home/admin/oceanbase/store/obdemo/slog $ls -lrth /home/admin/oceanbase/store/obdemo/ total 0 lrwxrwxrwx 1 admin admin 23 Oct 6 21:10 sort_dir -> /data/1/obdemo/sort_dir lrwxrwxrwx 1 admin admin 22 Oct 6 21:10 sstable -> /data/1/obdemo/sstable lrwxrwxrwx 1 admin admin 22 Oct 6 21:10 clog -> /data/log1/obdemo/clog lrwxrwxrwx 1 admin admin 22 Oct 6 21:10 ilog -> /data/log1/obdemo/ilog lrwxrwxrwx 1 admin admin 26 Oct 6 21:10 oob_clog -> /data/log1/obdemo/oob_clog lrwxrwxrwx 1 admin admin 22 Oct 6 21:10 slog -> /data/log1/obdemo/slog
从这个目录结构里就可以看出数据和日志是分开存储了。
- 启动observer
此前规划的6台机器，分属于3个zone。 启动参数 大部分相同，只是zone的名字要改一改。
$bin/observer --help bin/observer --help observer [OPTIONS] -h,--help print this help -z,--zone ZONE zone -p,--mysql_port PORT mysql port -P,--rpc_port PORT rpc port -N,--nodaemon don't run in daemon -n,--appname APPNAME application name -c,--cluster_id ID cluster id -d,--data_dir DIR OceanBase data directory -i,--devname DEV net dev interface -o,--optstr OPTSTR extra options string -r,--rs_list RS_LIST root service list -l,--log_level LOG_LEVEL server log level
所有zone1 机器的observer启动命令：
cd /home/admin/oceanbase && /home/admin/oceanbase/bin/observer -i bond0 -P 2882 -p 2881 -z zone1 -d /home/admin/oceanbase/store/obdemo -r 'xx.xxx.171.187:2882:2881;xx.xxx.240.24:2882:2881;xx.xxx.241.125:2882:2881' -c 2018100601 -n obdemo -o "datafile_disk_percentage=50,config_additional_dir=/data/1/obdemo/etc3;/data/log1/obdemo/etc2"
高亮部分都是可以改的。在没有理解之前不要修改。 -n 指定的 appname，就是集群名，后面都会用到。 -r 后面列表里的ip 就是被选为rootservice的三台机器ip。 observer的启动目录必须是 /home/admin/oceanbase 。所以cd 那个命令不要忘记了。
datafile_disk_percentage=50 这个比例可以调整，默认是90（表示90%的磁盘分区空间会被OB占用）。如果你的磁盘空间想留一点给其他应用用。就缩小这个比例。当data和log目录是共用的时候，更要调小这个比例。否则observer启动会因为clog空间不足而失败。
$ps -ef | grep observer admin 62603 1 99 Oct06 ? 2-00:59:16 /home/admin/oceanbase/bin/observer -i bond0 -P 2882 -p 2881 -z zone1 -d /home/admin/oceanbase/store/obdemo -r xx.xxx.171.187:2882:2881;xx.xxx.240.24:2882:2881;xx.xxx.241.125:2882:2881 -c 2018100601 -n obdemo -o config_additional_dir=/data/1/obdemo/etc3;/data/log1/obdemo/etc2 admin 108165 61410 0 11:30 pts/1 00:00:00 grep --color=auto observer
所有zone2 机器的启动命令：
cd /home/admin/oceanbase && bin/observer -i bond0 -P 2882 -p 2881 -z zone2 -d /home/admin/oceanbase/store/obdemo -r 'xx.xxx.171.187:2882:2881;xx.xxx.240.24:2882:2881;xx.xxx.241.125:2882:2881' -c 2018100601 -n obdemo -o "config_additional_dir=/data/1/obdemo/etc3;/data/log1/obdemo/etc2" ps -ef | grep observer
所有zone3机器的启动命令
cd /home/admin/oceanbase && bin/observer -i bond0 -P 2882 -p 2881 -z zone3 -d /home/admin/oceanbase/store/obdemo -r 'xx.xxx.171.187:2882:2881;xx.xxx.240.24:2882:2881;xx.xxx.241.125:2882:2881' -c 2018100601 -n obdemo -o "config_additional_dir=/data/1/obdemo/etc3;/data/log1/obdemo/etc2" ps -ef | grep observer
此时，只是在每个机器上启动了observer，还并没有形成一个OceanBase集群。后面会初始化一个OceanBase集群。
备注：上面每个observer的启动参数很长，实际上只有第一次启动的时候需要这么写。等后面初始化OceanBase集群成功后，每个observer会自动把它所有参数写到一个配置文件里。默认在 /home/admin/oceanbase/etc/observer.config.bin 里， 这个配置文件很重要，所以observer允许额外通过参数config_additional_dir 指定存储多份，类似于oracle的控制文件。 三、初始化OceanBase集群
前面在每个机器节点上都启动了一个observer，其参数独特之处是都指定了一个 rootservice list。
-r 'xx.xxx.171.187:2882:2881;xx.xxx.240.24:2882:2881;xx.xxx.241.125:2882:2881'
这里面有3个ip，是被设计为存储rootservice 的机器。 在初始化oceanbase集群之前，这三台机器里至少有两台机器的observer必须启动，并且以同样的参数启动。初次安装我们默认三台机器的observer都启动了。
- 清空所有数据文件（第一次不需要）
pkill observer 等待几秒钟 /bin/rm /home/admin/oceanbase/log/log cd /data/log1/obdemo && /bin/rm -rf clog etc2 ilog oob_clog slog mkdir clog etc2 ilog oob_clog slog cd /data/1/obdemo && /bin/rm -rf etc3 sort_dir sstable mkdir etc3 sort_dir sstable ll ~/oceanbase/store/obdemo
这个命令是用于清空数据文件，重新执行后面步骤。第一次做的时候不需要（没有历史数据文件）。要做的时候，需要先到所有observer机器上 kill掉 observer，再跑该脚本。
- 登录observer 选rootservice里任意一个机器登录，登录observer
$mysql -h127.1 -uroot -P2881 -p 空密码
此时进来之后，还不能执行 show database命令，因为元数据还没有构建好。
- 执行 bootstrap 然后在mysql命令行下执行 bootstrap
mysql>alter system bootstrap ZONE 'zone1' SERVER 'xxx.xxx.171.187:2882', ZONE 'zone2' SERVER 'xxx.xxx.240.24:2882', ZONE 'zone3' SERVER 'xxx.xxx.241.125:2882';
这个命令通常几秒钟就返回了。如果没有返回或者很久以后报错timeout了，那说明前面有observer启动参数指定不对。看看是不是zone名称不对，或者rootservicelist里的ip和port跟 -P和-p 指定的port不一致等等。 找到原因解决问题后，执行第1步清空历史数据文件，重头来过。
这一步成功后，一个 1-1-1的OceanBase集群就初始化成功了。此时退出mysql命令行，重新登录的时候就要换下面命令了。
$mysql -h127.1 -uroot@sys -P2881 oceanbase -p 空密码
MySQL [oceanbase]> show databases; +--------------------+ | Database | +--------------------+ | oceanbase | | information_schema | | mysql | | test | +--------------------+
然而我准备了6台机器用于部署oceanbase集群，所以还需要把其他三台机器加入到 当前集群里。也就是扩容命令了。
- 扩容oceanbase集群
ALTER SYSTEM ADD SERVER 'ip:port' [,'ip:port'…] [ZONE=’zone_name’];
mysql> alter system add server 'xxx.xxx.241.129:2882' zone='zone1'; mysql> alter system add server 'xxx.xxx.241.145:2882' zone='zone2'; mysql> alter system add server 'xxx.xxx.241.159:2882' zone='zone3';
注意端口号只需要指定 rpc port（2882）， 以及zone不要加错。 加成功后，查看当前server列表
MySQL [oceanbase]> select zone,svr_ip,svr_port,with_rootserver ,build_version from __all_server order by zone, with_rootserver desc; +-------+----------------+----------+-----------------+-------------------------------------------------------------------------------+ | zone | svr_ip | svr_port | with_rootserver | build_version | +-------+----------------+----------+-----------------+-------------------------------------------------------------------------------+ | zone1 | xxx.xxx.171.187 | 2882 | 1 | 1.4.60_1571952-758a58e85846f9efb907b1c14057204cb6353846(Mar 9 2018 14:32:07) | | zone1 | xxx.xxx.241.129 | 2882 | 0 | 1.4.60_1571952-758a58e85846f9efb907b1c14057204cb6353846(Mar 9 2018 14:32:07) | | zone2 | xxx.xxx.240.24 | 2882 | 0 | 1.4.60_1571952-758a58e85846f9efb907b1c14057204cb6353846(Mar 9 2018 14:32:07) | | zone2 | xxx.xxx.241.145 | 2882 | 0 | 1.4.60_1571952-758a58e85846f9efb907b1c14057204cb6353846(Mar 9 2018 14:32:07) | | zone3 | xxx.xxx.241.125 | 2882 | 0 | 1.4.60_1571952-758a58e85846f9efb907b1c14057204cb6353846(Mar 9 2018 14:32:07) | | zone3 | xxx.xxx.241.159 | 2882 | 0 | 1.4.60_1571952-758a58e85846f9efb907b1c14057204cb6353846(Mar 9 2018 14:32:07) | +-------+----------------+----------+-----------------+-------------------------------------------------------------------------------+ 6 rows in set (0.00 sec)
备注：上面默认root@sys密码是空，生产环境一定要设置复杂密码。
MySQL [oceanbase]> alter user root identified by 'root';四、安装启动反向代理OBProxy
前面装好了一个 2-2-2的OceanBase集群，但是客户端要连接这个数据库集群，前面那种连接方式还不够好。因为要考虑到某个observer节点宕机问题。直连这个observer肯定不好。 此外，由于OceanBase是一个分布式数据库，数据可能分布在多个节点上，但具体在哪个机器上客户端是不知道的，所以需要一个反向代理OBProxy 来负责数据访问路由。
理论上obproxy可以安装在任何机器上。如安装在observer上，或者独立的机器上，或者应用服务器上。并且obproxy由于只做路由功能，非常轻量，无状态，支持安装多个obproxy。安装多个obproxy的时候，可以再前面再通过负载均衡机制（F5或者lvs，slb等）做一个vip，肩负起 obproxy的高可用和负载均衡作用。这样就不怕某个obproxy挂掉或者压力过大了。
- 安装obproxy rpm包
sudo rpm -ivh obproxy-1.3.3-1506155.el7.x86_64.rpm 目录权限改到admin用户下。 chown -R admin.admin /opt/taobao/install/obproxy
- 初始化obproxy用户
mysql> CREATE USER proxyro IDENTIFIED BY password '*e9c2bcdc178a99b7b08dd25db58ded2ee5bff050' ; mysql> GRANT SELECT ON . to proxyro;
proxyro是个连接observer的只读帐号，obproxy会用到这个帐号。
- 启动obproxy
第一次启动obproxy的时候，也需要指定一些参数。如rootservice 列表。以及指定监听端口（2883，也可以写别的任意端口，不跟已有端口冲突即可）
cd /opt/taobao/install/obproxy && bin/obproxy -r "xxx.xxx.171.187:2881; xxx.xxx.240.24:2881; xxx.xxx.241.125:2881" -p 2883 -o "enable_strict_kernel_release=false,enable_cluster_checkout=false" -c obdemo
查看日志确认是否有异常。
cd /opt/taobao/install/obproxy tail -f log/obproxy.进程号.log
通过obproxy连接一下OceanBase集群
$mysql -h xxx.xxx.242.22 -uroot@sys#obdemo -P2883 -p oceanbase
或者
$mysql -h xxx.xxx.242.22 -uobdemo:sys:root -P2883 -p oceanbase
可以看出 跟连接mysql很像，区别在于 user的格式。 oceanbase的user格式是 “用户名@租户名#集群名” 或者 "集群名:租户名:用户名“ 等。五、分配租户（实例）
前面用6台机器搭建了一个2-2-2的OceanBase集群。现在某个应用需要申请一个数据库。我们并不会直接把这个OceanBase集群给到应用使用。 实际上刚初始化的OceanBase集群默认只有一个sys租户，其规格很小（cpu/memory/disk）。
MySQL [oceanbase]> select * from __all_unit_config where name='sys_unit_config'; +----------------------------+----------------------------+----------------+-----------------+---------+---------+-------------+-------------+----------+----------+----------------+---------------------+ | gmt_create | gmt_modified | unit_config_id | name | max_cpu | min_cpu | max_memory | min_memory | max_iops | min_iops | max_disk_size | max_session_num | +----------------------------+----------------------------+----------------+-----------------+---------+---------+-------------+-------------+----------+----------+----------------+---------------------+ | 2018-10-06 21:05:49.881126 | 2018-10-06 21:05:49.881126 | 1 | sys_unit_config | 5 | 2.5 | 19423884214 | 16186570178 | 10000 | 5000 | 18578870894592 | 9223372036854775807 | +----------------------------+----------------------------+----------------+-----------------+---------+---------+-------------+-------------+----------+----------+----------------+---------------------+ 1 row in set (0.00 sec)
这个sys租户只有 2.5-5个cpu，15-18 G内存的规格。 所以要给业务帐号单独分配一个租户。这也是OceanBase使用的正确姿势。
有关租户、资源池等概念，详情参见 OceanBase开发和运维漫谈
- 创建资源池规格
create resource unit unit_2c10g512g, max_cpu=2, max_memory='10G', min_memory='10G', max_iops=10000, min_iops=1000, max_session_num=1000000, max_disk_size=536870912; create resource unit unit_4c20g1024g, max_cpu=4, max_memory='20G', min_memory='20G', max_iops=20000, min_iops=5000, max_session_num=1000000, max_disk_size=1073741824; create resource unit unit_8c40g2048g, max_cpu=8, max_memory='40G', min_memory='40G', max_iops=50000, min_iops=10000, max_session_num=1000000, max_disk_size=2147483648;
查看资源规格
select * from __all_unit_config;
因为我的测试机器都是物理机，cpu和内存很大，所以我的多个规格定义的资源都比较大。大家可以根据自己情况修改。
- 分配资源池
create resource pool pool_demo unit = 'unit_16c50g4096g', unit_num = 1; select * from __all_resource_pool order by resource_pool_id desc ;
资源池分配后，只有创建租户并关联它才可以被使用。
- 创建租户
create tenant t_obdemo resource_pool_list=('pool_demo'); ---- alter tenant t_obdemo set variables ob_tcp_invited_nodes='xxx.xxx.0.0/16,127.0.0.1';
租户名可以自定义。
注释的alter语句是设置租户连接的白名单，安全性跟高。不过只有在1.4.7版本以后才有。 新租户默认root密码为空。老规矩，首先改密码。
mysql -h xxx.xxx.242.22 -uroot@t_obdemo#obdemo -P2883 oceanbase -A -p alter user root identified by 'root';
- 创建应用数据库和帐号
create database sbtest; grant all privileges on sbtest.* to sbuser@'%' identified by 'sbtest';
连接应用数据库
mysql -h127.1 -usbuser@t_obdemo#obdemo -P2883 sbtest -A -psbtest MySQL [sbtest]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | sbtest | +--------------------+ 2 rows in set (0.02 sec) 总结
- OceanBase的安装首先是在各个机器上安装并启动observer，第一次启动时指定rootservice list和相关参数。
- 初始化OceanBase集群。成功后，就可以逐台机器 重启一下observer。关闭方式就是 pkill 或者kill。 着急的话就kill -9 。 启动方式就是 cd /home/admin/oceanbase; bin/observer 第二次启动不需要指定参数，参数都在参数文件里。初始化proxyro用户。
- 安装obproxy软件并启动。第一次启动也要指定rootservice和相关参数。启动成功后可以重启obproxy。关闭方式就是pkill或者kill。启动方式就是 cd /opt/taobao/install/obproxy; bin/obproxy 第二次启动不需要指定参数，参数都在参数文件里。
- 分配资源创建租户
- 在租户里创建业务数据库和帐号。
2021-02-24 11:12:22赞同 展开评论 打赏
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
相关文章
相关电子书
更多
