cdh5-MariaDB 配置（暂未排版）

在多数分布MariaDB的设施默认设置使用保守的缓冲区的大小和内存使用。


使用保守的缓冲区大小和内存使用率
















Cloudera的数据库管理服务器，监控活动，报告管理，Cloudera 导航，Hive 的元数据




二进制日志提供的好处例如：在MariaDB 恢复后的复制或者点对点回复




这配置文件是Cloudera 推荐的设置












1. 如果 MariaDB 服务正在启动，先停止它。
$ sudo service mariadb stop
2. 将旧的 InnoDB 日志被分到 /var/lib/mysql/ 以外的路径
日志文件地址： /var/lib/mysql/ib_logfile0
/var/lib/mysql/ib_logfile1
3. 确定 marigDB 配置文件 my.cnf 的地址：
4. 修改 my.cnf 使他满足下列要求:
o 为了防止死锁，设置隔离级别为read committed。
o 在多数分布式系统中MariaDB 默认使用保守的缓冲区大小和内存使用率。 Cloudera Management Service roles need high write throughput because they might insert many records in the database. Cloudera recommends that you set theinnodb_flush_method property to O_DIRECT.
o Set the max_connections property according to the size of your cluster:
 Small clusters (fewer than 50 hosts) - You can store more than one database (for example, both the Activity Monitor and Service Monitor) on the same host. If you do this, you should:
 Put each database on its own storage volume.
 Allow 100 maximum connections for each database and then add 50 extra connections. For example, for two databases, set the maximum connections to 250. If you store five databases on one host (the databases for Cloudera Manager Server, Activity Monitor, Reports Manager, Cloudera Navigator, and Hive metastore), set the maximum connections to 550.
 Large clusters (more than 50 hosts) - Do not st