Yadda ake haɓaka MariaDB 5.5 zuwa MariaDB 10.1 akan CentOS/RHEL 7 da Tsarin Debian

MariaDB sanannen cokali mai yatsu na al'umma ne na MySQL wanda ya sami shahara sosai bayan siyan Oracle na aikin MySQL. A ranar 24 ga Disamba, 2015 an fitar da sabon sigar kwanciyar hankali wanda shine MariaDB 10.1.10.

Me ke faruwa

An ƙara sabbin abubuwa kaɗan a cikin wannan sigar kuma kuna iya ganin su a ƙasa:

  1. Galera, maganin tari mai yawa a yanzu shine daidaitaccen ɓangaren MariaDB.
  2. An ƙara sabbin allunan tsare-tsare na bayanai guda biyu waɗanda aka ƙara don ingantaccen binciken bayanan wsrep. Teburin da ake tambaya sune WSREP_MEMBERSHIP da WSREP_STATUS.
  3. Matsin shafi na InnoDB da XtraDB. Matsawar shafi yayi kama da tsarin InnoDB COMPRESSED.
  4. Matsin shafi na FusionIO.
  5. An haɗa tweaks ingantattu sun haɗa da:
    1. Kada a ƙirƙiri fayilolin frm don tebur na wucin gadi
    2. Ayi amfani da MAX_STATEMENT_TIME don kawar da doguwar tambayoyin ta atomatik
    3. malloc() aikin ba a yi amfani da shi kaɗan kuma ana aiwatar da tambayoyi masu sauƙi da sauri
    4. Faci na yanar gizo

    A cikin wannan koyawa za mu nuna muku yadda ake haɓaka MariaDB 5.5 zuwa MariaDB 10.1 sabuwar barga. Kuna buƙatar samun tushen damar zuwa injin, inda za ku yi haɓakawa.

    Lura cewa idan kuna gudanar da sigar farko ta MariaDB shawarar da aka ba da shawarar haɓakawa shine ta hanyar kowace sigar. Misali MariaDB 5.1 -> 5.5 -> 10.1.

    Mataki 1: Ajiyayyen ko Jujjuya Duk Databases na MariaDB

    Kamar koyaushe lokacin yin haɓaka ƙirƙira madadin bayanan bayananku na yanzu yana da mahimmanci. Kuna iya ko dai zubar da bayanan bayanai tare da umarni kamar:

    # mysqldump -u root -ppassword --all-databases > /tmp/all-database.sql

    Ko kuma, zaku iya dakatar da sabis na MariaDB tare da:

    # systemctl stop mysql

    Kuma kwafi kundin bayanan bayanai a cikin babban fayil daban kamar haka:

    # cp -a /var/lib/mysql/ /var/lib/mysql.bak

    Idan an gaza haɓakawa, zaku iya amfani da ɗaya daga cikin kwafin da ke sama don dawo da bayananku.

    Mataki 2: Ƙara Ma'ajiyar MariaDB

    Kyakkyawan aiki shine tabbatar da fakitinku na zamani kafin yin kowane canje-canje ga fayilolin ajiyar ku. Kuna iya yin haka da:

    # yum update          [On RHEL/CentOS 7]
# apt-get update      [On Debian/Ubuntu]

    Idan kuna da wasu tsoffin fakiti, jira shigarwa don gamawa. Na gaba, kuna buƙatar ƙara MariaDB 10.1 repo don rarrabawar CentOS/RHEL 7/. Don yin wannan, yi amfani da editan rubutu da kuka fi so kamar vim ko nano kuma buɗe fayil mai zuwa:

    # vim /etc/yum.repos.d/MariaDB10.repo

    Ƙara rubutu mai zuwa a ciki:

    # MariaDB 10.1 CentOS repository list - created 2016-01-18 09:58 UTC
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

    Sa'an nan ajiye kuma fita fayil (don vim :wq)

    Gudun waɗannan jerin umarni don ƙara MariaDB PPA akan tsarin ku:

    # apt-get install software-properties-common
# apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
# add-apt-repository 'deb [arch=amd64,i386] http://kartolo.sby.datautama.net.id/mariadb/repo/10.1/ubuntu wily main'

    Muhimmi: Kar a manta da maye gurbin ubuntu wily tare da sunan rarraba ku da sakin ku.

    Mataki 3: Cire MariaDB 5.5

    Idan kun ɗauki ajiyar bayanan bayananku kamar yadda aka ba da shawara a Mataki na 1, yanzu kun shirya don ci gaba da cire shigarwar MariaDB data kasance.

    Don yin wannan, kawai gudanar da umarni mai zuwa:

    # yum remove mariadb-server mariadb mariadb-libs         [On RHEL/CentOS 7]
# apt-get purge mariadb-server mariadb mariadb-libs      [On Debian/Ubuntu]

    Na gaba, tsaftace ma'ajiyar ma'ajiyar:

    # yum clean all          [On RHEL/CentOS 7]
# apt-get clean all      [On Debian/Ubuntu]

    Mataki 4: Shigar da MariaDB 10.1

    Yanzu lokaci ya yi da za a shigar da sabon sigar MariaDB, ta amfani da:

    # yum -y install MariaDB-server MariaDB-client      [On RHEL/CentOS 7]
# apt-get install mariadb-server MariaDB-client     [On Debian/Ubuntu]

    Da zarar an gama shigarwa, zaku iya fara sabis na MariaDB tare da:

    # systemctl start mariadb

    Idan kuna son MariaDB ta fara kai tsaye bayan tsarin tsarin, gudu:

    # systemctl enable mariadb

    A ƙarshe gudanar da umarnin haɓakawa don haɓaka MariaDB tare da:

    # mysql_upgrade

    Don tabbatar da cewa haɓakawa ya yi nasara, gudanar da umarni mai zuwa:

    # mysql -V

    Taya murna, an gama haɓakawa!

    Kammalawa

    MariaDB/MySQL haɓakawa koyaushe ayyuka ne waɗanda yakamata a yi tare da ƙarin taka tsantsan. Ina fatan naku ya kammala lafiya. Idan kun ci karo da wata matsala, don Allah kada ku yi shakka a yi sharhi.