Skip to main content

Upgrading MySQL to MariaDB

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.41-1.el6.i686
Error: mysql55w-libs conflicts with MariaDB-compat-5.5.41-1.el6.i686

You can try my work around :

yum replace mysql55w-libs --replace-with mysql-libs

Proceed with the step below :

https://mariadb.com/blog/upgrading-mysql-51-mariadb-100-centos-6

Comments

Post a Comment

Popular posts from this blog

Building a KVM Proxy

Traditionally we seldomly connect our KVM from the port directly to the server that consists of usb for keyboard and mouse, vga cable for display purposes. More advanced you may have an experience using the iKVM which connect all you kvm port from the internet where you can have a remote location as long as you have the internet connection. When technology evolve, physical server are becoming obsolete since we have the virtualization technology. Since that to access your virtual machine (vm) are more easier. Instead of using SSH, like a Xen hypervisor, the Xen itself can host as a KVM server and map to the vm on different port as configured from the config file.
Post a Comment
Read more

Warning Nuffnanger's!

Dear Nuffnangers, As you might already know, there are 2 different types of campaigns from Nuffnang: Metered (mCPM) Campaigns , which pay according to the number of visitors who see the ads; and Cost-Per-Click (CPC) campaigns, which pay bloggers based on the number of clicks generated on the ads. It has come to our attention that certain groups have been committing click fraud, which is defined as clicking on CPC advertisements intentionally just to generate earnings for a blog's owner. Do note that this act is an abuse of our Terms & Conditions under Section 6. Banner ads are only supposed to be clicked on if the viewer is interested to find out more about the advertising campaign, and not for the intention of earning extra money. Should this situation worsen, the frequency of ad campaigns might be significantly reduced as we'll only be able to sell ad spaces on blogs with no click fraud record. Our system is capable of tracking these illegal actions...
2 comments
Read more

Python - Xen and libvirt

more function can be found in python dir libvirtclass.txt shell> find / -name libvirtclass.txt Generated Classes for libvir-python # # Global functions of the module # # functions from module libvirt open() openReadOnly() virEventRegisterImpl() virInitialize() # functions from module virterror virGetLastError() virResetLastError() # # Set of classes of the module # Class virDomain()     # functions from module libvirt     ID()     OSType()     XMLDesc()     attachDevice()     blockPeek()     connect()     coreDump()     create()     destroy()     detachDevice()     maxMemory()     maxVcpus()     memoryPeek() migrate()     name()     reboot()     ref()     resume()  ...
Post a Comment
Read more