Updating mysql server
You can create these databases on the host where the Cloudera Manager Server will run, or on any other hosts in the cluster.
For performance reasons, you should install each database on the host on which the service runs, as determined by the roles you assign during installation or upgrade.
The data from user’s input is typically not what we expected.
The database must be configured to support UTF-8 character set encoding.
Install My SQL and NDOutils # yum -y install mysql mysql-devel mysql-server gcc-c # yum -y install ndoutils* # chkconfig mysqld on # service mysqld start # chkconfig ndo2db on Start a shell to My SQL and create and grant access to a database # mysql -uroot -p mysql in “EVENT BROKER MODULE(S)” section broker_module=/usr/lib64/nagios/brokers/config_file=/etc/nagios/Configure the /etc/nagios/ndo2file, and change the below three lines db_user=root db_pass=password debug_level=-1 Start ndo2db # service ndo2db start Restart Nagios # service nagios restart Check the log file if it works # tail -f /var/log/messages From the above, it did not work Disable SElinux, restart ndo2db and nagios, check the log file again. # setenforce 0 # service ndo2db restart # service nagios restart # tail -f /var/log/messages # tail -f /var/log/ndoutils/ndo2db.debug After it worked, configured the /etc/nagios/ndo2file, set “debug_level=1”, restart ndu2db and nagios.
[mysqld] transaction-isolation = READ-COMMITTED # Disabling symbolic-links is recommended to prevent assorted security risks; # to do so, uncomment this line: # symbolic-links = 0 key_buffer_size = 32M max_allowed_packet = 32M thread_stack = 256K thread_cache_size = 64 query_cache_limit = 8M query_cache_size = 64M query_cache_type = 1 max_connections = 550 #expire_logs_days = 10 #max_binlog_size = 100M #log_bin should be on a disk with enough free space.
For more information, see Importing and Exporting SQL Server Databases.
Amazon RDS supports the following settings for the Native Backup and Restore option.