Sentry元数据mysql_hive相关元数据迁移（mysql）

[mysqld]

#transaction-isolation=READ-COMMITTED

# Disabling symbolic-links is recommended to prevent assorted security risks;

# to do so, uncomment this line:

# symbolic-links=0

socket=/var/lib/mysql/mysql.sock

key_buffer = 16M

key_buffer_size = 32M

max_allowed_packet = 16M

thread_stack = 256K

thread_cache_size = 64

query_cache_limit = 8M

query_cache_size = 64M

query_cache_type = 1

# Important: see Configuring the Databases and Setting max_connections

max_connections = 2000

default-storage-engine=InnoDB

# log-bin should be on a disk with enough free space

#log-bin=/var/log/mysql/binary/mysql_binary_log

# For MySQL version 5.1.8 or later. Comment out binlog_format for older versions.

#binlog_format = mixed

#read_buffer_size = 2M

#read_rnd_buffer_size = 16M

#sort_buffer_size = 8M

#join_buffer_size = 8M

# InnoDB settings

innodb_file_per_table = 1

innodb_flush_log_at_trx_commit = 2

innodb_log_buffer_size = 64M

innodb_buffer_pool_size = 4G

innodb_thread_concurrency = 8

innodb_flush_method = O_DIRECT

innodb_log_file_size = 512M

lower_case_table_names = 1

[mysqld_safe]

socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

show variables like 'lower%';

注意迁移时查看系统大小写参数，如果大小写敏感参数不一致可能报如下错误

Query for candidates of org.apache.hadoop.hive.metastore.model.MVersionTable and subclasses resulted in no possible candidates

Required table missing : "`VERSION`" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables"

org.datanucleu