阿里云 PolarDB MySQL 版V2.0快速部署指南

法律声明阿里云提醒您在阅读或使用本文档之前仔细自身的合法合规的业务活动。本文档的内容视为阿里云的保密保密义务；未经阿里云事先书面同意，您不得向任何第三方披何通知或者提示下对本文档的内容进行修改的权利，更新后的用户文档。您应当实时关注用户文档的版本状”、“有缺陷”和“当前功能”的状态提供本文档。阿里最大努力提供相应的介绍及操作指引，但阿里云在此明确性、完整性、适用性、可靠性等不作任何明示或暗示因为下载、使用或信赖本文档而发生任何差错或经济责任。在任何情况下，阿里云均不对任何间接性、后或刑罚性的损害，包括用户使用或信赖本文档而遭受架构、网站画面的安排、网页设计，均由阿里云和/或其关联权，包括但不限于商标权、专利权、著作权、商业秘密等。非公司书面同意，任何人不得擅自使用、修改、复制、公开传播得为了任何营销、广告、促销或其他目的使用、公布或复制阿限于单独或以组合形式包含“阿里云”、“Aliyun”、“万网服务名称、域名、图案标示、标志、标识或通过特定描述使第2通用约定3法律声明 通用约定 1关于本手册 2安装PolarDBMySQL 2.1准备工作 2.2安装PolarDBMySQL 3准备PolarDBMySQL的配置文件 4创建PolarDBMySQL实例 5License授权（购买后申请） 5.1获取数据库识别码和Mac地址 5.2License获取方式 5.3启用License 6启动实例 4本手册介绍了PolarDB数据库管理软件（MySQL版）快速部署的方法52安装PolarDBMySQL2.1准备工作根据对应的CPU和OS架构，确定需要安装的RPM包版本,主机的gl2.2安装PolarDBMySQL1.执行如下命令安装PolarDBMy63准备PolarDBMySQL的配置文件数据目录、端口等参数，注意如果是拷贝下面的内容，检查格式是否正确，参数是否有datadir=/home/mysql/dattmpdir=/home/mysqmax_connections=20520max_user_connections=20000max_heap_table_size=671088max_binlog_size=500Mwait_timeout=86400read_rnd_buffer_size=transaction_isolation=log_bin_trust_function_creators=1log-bin=/home/mysql/data3020/mysqlog-bin-index=/home/mysql/data3020/mysqlog-error=/home/mysql/data3020/mysql/mrelay-log=/home/mysql/data3020/mysql/slave-relay.logrelay-log-info-file=/home/mysql/data3020/mysql/slave-relay-lrelay-log-index=/home/mysql/data3020/mysql/slave-relay-log.inmaster-info-file=/home/mysql/data3020/mysql/7binlog_cache_size=slow_query_log_file=/home/mysql/data3020/mybulk_insert_buffer_size=41myisam_sort_buffer_size=262myisam_max_sort_file_size=20myisam_recover_options=FORinnodb_data_home_dir=/hominnodb_log_group_home_dir=/hominnodb_data_file_path=master_info_repository=TABrelay_log_info_repository=default-authentication-plugin=mysql_na8loose_rpl_semi_sync_master_trace_level=1max_sp_recursion_depth=0innodb_compression_failure_threshloose_innodb_parallel_read_threads=1max_points_in_geometry=65536preload_buffer_size=3loose_persist_binlog_to_redoloose_xengine_max_background_coloose_xengine_db_write_transaction_write_set_extractkey_cache_age_threshold=max_execution_time=0slave_rows_search_algorithms=INDnet_write_timeout=loose_innodb_undo_space_loose_rpl_semi_sync_mastenet_read_timeout=30mysql_native_password_proxy_users=max_seeks_for_key=18446744073709500explicit_defaults_for_tim9loose_validate_passwoloose_session_track_transaction_infobinlog_rows_query_log_events=relay_log_recoverydefault_week_formatoptimizer_trace_max_mem_sloose_multi_blocks_dsql_mode='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DASION_BY_ZERO,NO_ENGINE_SUBloose_log_error_suppreloose_xengine_write_loose_rpl_semi_sync_delayed_insert_timemax_error_count=64innodb_buffer_pool_binlog_checksum=Clog_throttle_queries_not_usingmax_binlog_stmt_cache_size=18446744073709547range_optimizer_max_mem_size=8query_alloc_block_siloose_session_track_sinnodb_stats_transient_satransaction_alloc_blockloose_recycle_scheduler_puinnodb_purge_rseg_truncate_disconnect_on_expired_pasmax_join_size=184467440737095516loose_optimizer_trace_features=greedy_search=on,range_optimizer=on,dyna_subselect=onloose_innodb_multi_bloose_xengine_db_total_write_character_set_filesysloose_xengine_block_updatable_views_with_limit=innodb_online_alter_lloose_optimizer_switch=index_merge=on,index_merge_union=on,index_merge_erge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mt_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijcan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_loose_slave_paralleloose_innodb_fatal_semaphore_waavoid_temporal_upgradngram_token_size=2binlog_order_commits=loose_innodb_adaptivebinlog_row_image=floose_ccl_max_waitiloose_xengine_max_backgrounmax_binlog_cache_size=18446744073709547table_open_cache_instancetransaction_preallocloose_rpl_semi_sync_masterloose_innodb_log_wrimin_examined_row_limit=0loose_optimizer_trace=enaloose_thread_pool_ovebinlog_stmt_cache_size=loose_rpl_semi_sync_master_wadisabled_storage_engines=myisam,mft_query_expansion_limmaster_verify_checksum=innodb_buffer_pool_dudefault_authentication_plugin=mysql_naloose_recovery_inconsblock_encryption_mode="aes-12loose_internal_tmp_mem_stsocket=/home/mysql/data3max_prepared_stmt_count=1048576loose_innodb_undo_spaceloose_information_schemainnodb_max_dirty_pageoptimizer_search_deptdiv_precision_incremeloose_recycle_schedulebinlog_transaction_dependency_tracking=WRIloose_xengine_base_backgrange_alloc_block_sizeinnodb_stats_persistentbinlog_expire_logs_seconds=performance_agent_enabmax_allowed_packet=64Mwrite_buffer=8Mbasedir=/u01/mysql80_202basedir=/u01/mysql80_2024创建PolarDBMySQL实例假设配置文件目录是/etc/f，执行如下命令，即可创建PolarDBMySQL实例。rm-rf/home/mysql/dmkdir-p/home/mysql/data3020/dbs3mkdir-p/home/mysql/data3020/mkdir-p/home/mysql/data3020/mychown-Rmysql:mysql/home/m#检查/home/mysql下面的目录权限是否都为mysql/u01/mysql80_20241121/bin/mysqld--defaults-file=/etc/f--initialize-insecur#检查/home/mysql/data3020/mysql/master-error.log文5License授权（购买后申请）•License用于限定客户是否可以正常使用PolarDB数据库，License通过宿主机的MAC地址、数据库系统识别码与使用时长进行可用性控制，License过期后数5.1获取数据库识别码和Mac地址#cat/disk0/chongmu/local/需要提交databaseidentifer、宿主•产品经理确认购买订单后，为客户生成License文件（内部操作）；•如果实例主机因为迁移或故障等原LicenseSerialNo=7faeceb3d4b89906f13f1fa5cCreatedTime=2025-03-2319:0LicenseExpiredTime=2055-07-010LicenseExpiredTime=2055-07-010MacAddress=98:03:9b:46:c4:DatabaseIdentifier=74849581841432实例启动以后会读取license文件，如果license验证成功mas 如果license认证失败，实例启动时master-error.log会有如下的错误或告警日志： /bin/sh/u01/mysql80_20241121/bin/mysqld_safe--defaults-file=/etc/f&查看启动进程，会有mysqld_safe和m/u01/mysql80_20241121/bin/mysqld_safe--defaults-file=/etc/mymysql78404782931120:47pts/3300:00:01/u01/mydefaults-file=/etc/f--basedir=/u01/mysql80_2datadir=/home/mysql/data3020/dbs3020--plugin-dir=/u01/mysql80_20241121/libuser=root--log-error=/home/mysql/d