Skip to main content

MYSQL TO MARIA DB SWITCH

What is MariaDB ?
MariaDB is a binary drop in replacement of the same MySQL version (for example MySQL 5.1 -> MariaDB 5.1, MariaDB 5.2 & MariaDB 5.3 are compatible. MySQL 5.5 will be compatible with MariaDB 5.5). What this means is that:
* Data and table definition files (.frm) files are binary compatible.
* All client APIs, protocols and structs are identical.
* All filenames, binaries, paths, ports, sockets, and etc… should be the same.
* All MySQL connectors (PHP, Perl, Python, Java, .NET, MyODBC, Ruby, MySQL C connector etc) work unchanged with MariaDB.
* The mysql-client package also works with MariaDB server.
* The shared client library is binary compatible with MySQL’s client library.


*There are some installation issues with PHP5 that you should be aware of ( REF:https://mariadb.com/kb/en/installation-issues-with-php5 ).


#mysqldump --all-databases --routines --triggers > /home/db_dump/alldb.sql
# service mysql stop
# cp -r /var/lib/mysql/mysql /home/db_dump/
# service mysql start



# /scripts/update_local_rpm_versions --edit target_settings.MySQL50 uninstalled
# /scripts/update_local_rpm_versions --edit target_settings.MySQL51 uninstalled
# /scripts/update_local_rpm_versions --edit target_settings.MySQL55 uninstalled


Disable the targets so cPanel no longer handles MySQL updates ONLY FOR cPanel 11.36+

# /scripts/check_cpanel_rpms --fix --targets=MySQL50,MySQL51,MySQL55


 Above command remove rpms

 
#nano /etc/yum.repos.d/MariaDB.repo

---------
# MariaDB 5.5 CentOS repository list - created 2013-06-23 21:13 UTC
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/5.5/centos6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=

--------

 Create yum repo , Edit the mariadb version and os distribution by checking current statistics

 

 yum install MariaDB-server MariaDB-client MariaDB-devel
# /etc/init.d/mysql start
# mysql_upgrade
# /etc/init.d/mysql restart


# /scripts/easyapache --build

















































Comments











Post a Comment




















Popular posts from this blog



















Modsecurity block rule for XMLRPC and wp-login attack




























 SecAction phase:1,nolog,pass,initcol:ip=%{REMOTE_ADDR},initcol:user=%{REMOTE_ADDR},id:5000134  <Locationmatch "/wp-login.php">  SecRule user:bf_block "@gt 0" "deny,status:401,log,id:5000135,msg:'ip address blocked for 5 minutes, more than 10 login attempts in 3 minutes.'"  SecRule RESPONSE_STATUS "^302" "phase:5,t:none,nolog,pass,setvar:ip.bf_counter=0,id:5000136"  SecRule RESPONSE_STATUS "^200" "phase:5,chain,t:none,nolog,pass,setvar:ip.bf_counter=+1,deprecatevar:ip.bf_counter=1/180,id:5000137"  SecRule ip:bf_counter "@gt 10" "t:none,setvar:user.bf_block=1,expirevar:user.bf_block=300,setvar:ip.bf_counter=0"  </Locationmatch>  SecAction phase:1,nolog,pass,initcol:ip=%{REMOTE_ADDR},initcol:user=%{REMOTE_ADDR},id:5000234  <Locationmatch "/xmlrpc.php">  SecRule user:bf_block "@gt 0" "deny,status:401,log,id:5000235,msg:'ip address blocked for 5 m...




















Post a Comment









Read more






























How to tweak linux server harddisk using hdparm




























 hdparm switches explained http://manpages.ubuntu.com/manpages/intrepid/man8/hdparm.8.html       First of all you have to install hdparm in linux.   apt-get install hdparm  #hdparm /dev/sda  /dev/sda:  readonly = 0 (off)  readahead = 120 (on)  geometry = 8850/255/63, sectors = 142182912, start = 0    Hard disk Performance Information   # hdparm -tT /dev/hda  /dev/hdd:  Timing cached reads: 496 MB in 2.00 seconds = 247.42 MB/sec  Timing buffered disk reads: 60 MB in 3.03 seconds = 19.81 MB/sec    Hard drive set to low, slow settings   # hdparm -cuda /dev/hda  /dev/hda:  IO_support = 0 (default 16-bit)  unmaskirq = 0 (off)  using_dma = 0 (off)  readahead = 256 (on)   Use below tweaks to increase disk read write performance.   For sda drive   ~]# hdparm -a 2048 /dev/sda  /dev/sda:  setting fs readahead to 2048  readahead = 2048 (on)   For sdb drive   [root@439298a ~]# hdparm -a 2048 /dev/sdb  /dev/sdb:  setting fs readahead to 2048  readahead = 2048 (on)    ]# echo “anticipatory” >...




















Post a Comment









Read more




























Apache tuning documentation




























 Apache bench marking  =======================   Things or checklist to be considered before the test       CPU: avoid power-saving mode. cpufreq-set -g performance.      File descriptors: raise the limit to (at least) the number of concurrent connections you wish to handle, using ulimit -n in your shell, or setrlimit(RLIMIT_NOFILE) in your server. Beware, some systems forbid you to raise the limit, you might need to investigate a bit to find how to unlock it.      Disable the logs of your server (you do not want to lose time logging thousands of requests instead of answering them).      Raise /proc/sys/net/somaxconn to the number of concurrent connections you want to handle. To understand why this is necessary, read the technical report or the excellent paper Measuring the Capacity of a Web Server (Banga and Druschel, Usenix 97). More on the fascinating topic of the accept() queue can be found in accept()able Strategies for Im...




















Post a Comment









Read more