Celoteh Harian + *nix

1. Create a repo configuration file vi /etc/yum.repos.d/mariadb.repo Paste the following [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.0/centos6-amd64 gpgkey= https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1   Or you can create your own configuration from MariaDB repo creator https://downloads.mariadb.org/mariadb/repositories/#mirror=neusoft 2. Install MariaDB server and client yum install MariaDB-server MariaDB-client 3. Start service mysql start 4. Enable on boot chkconfig mysql on 5. Run mysql_secure_installation program to secure and check your installation. /usr/bin/mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB       SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY! In order to log into MariaDB to secure it, we'll need the current password for the root user.  If you've just installed MariaDB, and you haven't set the root password yet,...

Ever since MariaDB exists, I really like to install and test the performance but time consume for my daily work stopped me to try MariaDB, today I plan to update my MySQL server that serve lot of data in and out to MariaDB 10.0 (today latest version :P ) So there's a few step that should be considered before we can proceed further. 1. BACKUP - Always backup your data at the first place. - Save it to the proper place so that if anything goes wrong, you can export back your data. mysqldump -u root -pYOURPASSWORD --all-databases > allbackup.sql & If you don't want to wait and you know that the current database is big, just put the process at the background so that you can monitor the process using top :) - Backup your current configuration files cp /etc/my.cnf /tmp/my.cnf.bak 2. Let's go If you're installing mysql from webtatic and made a replacing package name , you may encountered an error like Error: mysql55w conflicts with MariaDB-server-5.5....

On 22nd Oct there's a news about the gunshots at Canadian Parliament and the suspected person is a drug addicted which converted to Islam before the incident occur. My point of view, this issue can lead towards people seeing Islam as a bad religion which encourage the follower to commit suicide and kill people. I would like to stress out that Islam not allowed to kill people without any proof and Islam now allowed to kill public citizens.