±â¼ú ÀÚ·á½Ç
[Linux] ¿ìºÐÅõ Ubuntu MariaDB 10 ¼³Ä¡ |
---|
Date : 2021-07-01
Name : ¼¹ö¸ó
Hits : 3479
|
¾È³çÇϼ¼¿ä. ÁÖ½Äȸ»ç ¼¹ö¸ó ÀÔ´Ï´Ù. ¿À´ÃÀº Ubuntu OS ¿¡ MariaDB ¼³Ä¡ ¹æ¹ý¿¡ ´ëÇØ ¾Ë¾Æ º¸°Ú½À´Ï´Ù. 1. MariaDB ·¹Æ÷ ¼³Á¤ https://downloads.mariadb.org/mariadb/repositories/#distro=Ubuntu&mirror=yongbok À§ »çÀÌÆ®¿¡ Á¢¼ÓÇÏ¿© ÀÚ½ÅÀÇ ¹èÆ÷ÆÇ¿¡ ¸Â´Â ·¹Æ÷ÁöÅ丮 ¼³Á¤À» Âü°í ÇÕ´Ï´Ù. apt-get ¸í·ÉÀ» ÀÌ¿ëÇÏ´Â ¾Æ·¡ ¸Þ´º¾óÀ» Âü°í ÇÏ¿© ¾Æ·¡ ¸í·ÉÀ» ¼øÂ÷ÀûÀ¸·Î ÁøÇà ÇÕ´Ï´Ù. -- ¸í·É¾î -- sudo apt-get install software-properties-common sudo apt-key adv --fetch-keys 'https://mariadb.org/mariadb_release_signing_key.asc' sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] https://mirror.yongbok.net/mariadb/repo/10.3/ubuntu bionic main' sudo apt update sudo apt install mariadb-server 2. MariaDB ¼³Ä¡ À§ ¸í·ÉÀ» ¼öÇàÈÄ root »ç¿ëÀÚÀÇ ºñ¹Ð¹øÈ£ ÁöÁ¤ÈÄ DB ¼³Ä¡°¡ ¿Ï·á µË´Ï´Ù. mysql -u root -p DB¿¡ Á¢¼Ó ¿©ºÎ¸¦ È®ÀÎ ÇÕ´Ï´Ù. 3. DB ÀúÀå °æ·Î º¯°æ DB ¿¡ Á¢¼ÓÇÏ¿© ¾Æ·¡ Äõ¸®¸¦ ÅëÇØ ±âº» ÀúÀå °æ·Î¸¦ È®ÀÎ ÇÕ´Ï´Ù. select @@datadir; /var/lib/mysql ¿¡ ÀúÀåµÇ´Â µ¥ÀÌÆ®¸¦ /db °æ·Î·Î º¯°æ ÇÕ´Ï´Ù. DB °æ·Î »ý¼º mkdir -p /db/ MariaDB ÁßÁö sudo systemctl stop mysql Rsync ¸¦ ÀÌ¿ëÇÏ¿© ±âÁ¸ µ¥ÀÌÅ͸¦ /db °æ·Î·Î º¹»ç ÇÕ´Ï´Ù. sudo rsync -av /var/lib/mysql /db/ Vim À» ÀÌ¿ëÇÏ¿© my.cnf ¸¦ ¼öÁ¤ÇÕ´Ï´Ù. sudo vim /etc/mysql/my.cnf ¾Æ·¡ »çÁø°ú °°ÀÌ "datadir" ÀÇ °æ·Î¸¦ ¿øÇÏ´Â µð·ºÅ丮·Î º¯°æÇÕ´Ï´Ù. sudo vim /etc/apparmor.d/tunables/alias aparmor ¸ðµâÀ» »ç¿ëÇÏ¿© »çÁø°ú °°ÀÌ ±âÁ¸ °æ·ÎÀÇ alias ¼³Á¤À» ÁøÇàÇÕ´Ï´Ù. apparmor Àç½ÃÀÛ sudo systemctl restart apparmor MariaDB Àç½ÃÀÛ sudo systemctl restart mysql DB °æ·Î°¡ ¹Ù²ï°ÍÀ» È®ÀÎÇÕ´Ï´Ù. HPE, ·¹³ë¹ö, µ¨ ¼¹ö, ¿öÅ©½ºÅ×À̼Ç, ±â¾÷¿ë ³ëÆ®ºÏ µî IT Á¦Ç°Àº ¼¹ö¸ó¿¡¼ °ßÀû¹Þ¾Æº¸¼¼¿ä~ Á¦Ç°¿¡ ´ëÇÑ »ó´ãÀ» Èñ¸ÁÇϽøé, 02-2026-5062 or sales@servermon.co.kr·Î ¹®ÀÇ ÁÖ¼¼¿ä. ¼¹ö¸ó¿¡¼ ¿î¿µÇÏ´Â IT ¼îÇθôÀ» ±¸°æÇϽ÷Á¸é, ÇÏ´ÜÀÇ ·Î°í¸¦ Ŭ¸¯ÇØÁÖ¼¼¿ä. ¼¹ö¸ó/¼¹ö¸ó±â¼úÁö¿ø/½ºÀ§Ä¡/½ºÀ§Ä¡ ±â¼úÁö¿øºñ(ºñ¿ë)/½ºÀ§Ä¡ ¼³Ä¡ºñ/¹æȺ®/¹æȺ® ±â¼úÁö¿øºñ(ºñ¿ë)/¹æȺ® ¼³Ä¡ºñ/·¢/·¢(RACK) ±â¼úÁö¿øºñ(ºñ¿ë)/·¢(RACK) ¼³Ä¡ºñ/KVM/KVM ±â¼úÁö¿øºñ(ºñ¿ë)/KVM ¼³Ä¡ºñ/½ºÅ丮Áö/½ºÅ丮Áö ±â¼úÁö¿øºñ(ºñ¿ë)/½ºÅ丮Áö ¼³Ä¡ºñ/½ºÅ丮Áö ·¢¸¶¿îÆ®ºñ¿ë/½ºÅ丮Áö Àå¾ÖÁ¶Ä¡ºñ¿ë/¼¹ö/¼¹ö ±â¼úÁö¿øºñ(ºñ¿ë)/¼¹ö ¼³Ä¡ºñ/¼¹ö ·¢¸¶¿îÆ®ºñ¿ë/¼¹ö Àå¾ÖÁ¶Ä¡ºñ¿ë/À©µµ¿ì¼¹ö/À©µµ¿ìÁî ±â¼úÁö¿øºñ(ºñ¿ë)/À©µµ¿ìÁî ¼³Ä¡ºñ/¸®¿í½º/Linux/¸®´ª½º ±â¼úÁö¿øºñ(ºñ¿ë)/¸®´ª½º ¼³Ä¡ºñ/DB/µ¥ÀÌÅͺ£À̽º/MySQL ±â¼úÁö¿øºñ(ºñ¿ë)/MySQL ¼³Ä¡ºñ/MSSQL ±â¼úÁö¿øºñ(ºñ¿ë)/MSSQL ¼³Ä¡ºñ/¹é¾÷ ±â¼úÁö¿øºñ(ºñ¿ë)/HPE¼¹öºñ¿ë/HPE/DL20/DL20GEN10/ML30/ML30GEN10/ML360/ML350GEN10/DL360/DL360Gen10/DL380/DL380Gen10/LENOVO¼¹ö/·¹³ëº¸¼¹ö/µ¨¼¹ö/µ¨¼¹öºñ¿ë/DELLR540/DELLR750/HP¼¹ö/¼¹ö¿£Áö´Ï¾î/¼¹ö±â¼úÁö¿ø/¼¹öµð½ºÅ©Àå¾Öó¸®/¹æȺ®/¹æȺ®¿£Áö´Ï¾î/APC UPS/UPS/UPS¼³Ä¡/UPS±â¼úÁö¿ø/UPS³³Ç°/¼¹ö·º¸¶¿îÆ®/HPE Service Pack for Proliant/HPE SPP/SPP/Intelligent Provisioning/½Ã³î·ÎÁö³ª½º/³ª½º±â¼úÁö¿ø/SYNOLOGY/SYNOLOGY³ª½º/½Ã³î·ÎÁöDS918/½Ã³î·ÎÁöÇÏÀÌÆÛ¹é¾÷/HYPER BACKUP/½Ã³î·ÎÁöHyperBackup/½Ã³î·ÎÁö³ª½º¹é¾÷/¼¹ö¹é¾÷/¼¹öÆ®·¯ºí½´ÆÃ/¸®´ª½ºÆ®·¯ºí½´ÆÃ/º¸¾È¼Ö·ç¼Ç/½ÃÅ¥¾îµð½ºÅ©/ÀÎÅͳݵð½ºÅ©/À̽ºÆ®¼ÒÇÁÆ®/¾Ë¾à/Ä«½ºÆÛ½ºÅ°/ESTSOFT/V3/¾È·¦/¼ÒÆ÷½º/SOPHOS/Ä«º¸³ªÀÌÆ®/´õºíÅ×ÀÌÅ©/ÀÌÁßȼַç¼Ç/HA¼Ö·ç¼Ç/Windows¼¹ö¼³Ä¡/¿Þµµ¿ì¼¹ö¼³Ä¡/À©µµ¿ì¼¹ö2019/À©µµ¿ì¼¹ö2016/MSSQL/MYSQL/µðÆ÷±×·¢/DEFOG·¢/µðÆ÷½º·¢°¡°Ý/EDFOG·¢°¡°Ý/RMS·¢/¼¹ö³³Ç°/·¢³³Ç°¼³Ä¡/·¢¼³Ä¡/³ª½º¼³Ä¡Áö¿ø/½ºÅ丮Áö³³Ç°¼³Ä¡/À©µµ¿ì¼¹öÆ®·¯ºí½´ÆÃ/¸®´ª½º¼¹öÆ®·¯ºí½´ÆÃ/HPE¼¹öÆß¿þ¾î/HP¼¹öÆß¿þ¾î/HPE¼¹ö/FIRMWARE/DELL¼¹öÆß¿þ¾î/µ¨¼¹öÆß¿þ¾î¾÷µ¥ÀÌÆ®/·¹³ëº¸¼¹öÆß¿þ¾î/LENOVOÆß¿þ¾î¾÷µ¥ÀÌÆ®/HPE¼¹öµå¶óÀ̹ö¼³Ä¡/HPE¼¹ö±¸¸Å/DELL¼¹ö±¸¸Å/LENOVO¼¹ö±¸¸Å/º¸¾È¼Ö·ç¼Ç±¸¸Å/ÀÌÁßȼַç¼Ç±¸¸Å/º¸¾È¼Ö·ç¼Ç¼³Ä¡/ÀÌÁßȼַç¼Ç¼³Ä¡/HPE¼¹ö°¡°Ýºñ±³/DELL¼¹ö°¡°Ýºñ±³/LENOVO¼¹ö°¡°Ýºñ±³/HPE¼¹ö°¡°Ýºñ±³°ßÀû/DELL¼¹ö°¡°Ýºñ±³°ßÀû/LENOVO¼¹ö°¡°Ýºñ±³°ßÀû/HPE¼¹ö°ßÀû/DELL¼¹ö°ßÀû/LENOVO¼¹ö°ßÀû/HPE¼¹öµð½ºÅ©±³Ã¼/DELL¼¹öµð½ºÅ©±³Ã¼/LENOVO¼¹öµð½ºÅ©±³Ã¼/HPE¼¹öRAIDÄÁÆ®·Ñ·¯/HPE¼¹öRAIDÄÁÆ®·Ñ·¯/DELL¼¹öRAIDÄÁÆ®·Ñ·¯/LENOVO¼¹öRAIDÄÁÆ®·Ñ·¯/HP¼¹öÇϵåµð½ºÅ©/HPE¼¹öÇϵåµð½ºÅ©±¸¸Å/DELL¼¹öÇϵåµð½ºÅ©±¸¸Å/LENOVO¼¹öÇϵåµð½ºÅ©±¸¸Å/HPE¼¹öSASÇϵåµð½ºÅ©/DELL¼¹öSASÇϵåµð½ºÅ©/LENONO¼¹öSASÇϵåµð½ºÅ©/HPE¼¹ö¸Þ¸ð¸®/DELL¼¹ö¸Þ¸ð¸®/LENOVO¼¹ö¸Þ¸ð¸®/HP¼¹ö¸Þ¸ð¸®/HPE¼¹öCPU/DELL¼¹öCPU/LENOVO¼¹öCPU/¼¹öCPU/¼¹ö¸Þ¸ð¸®/¼¹öMEMORY/ECC¸Þ¸ð¸®/¼¹ö¿ë¸Þ¸ð¸®/¼¹ö¿ëÇϵåµð½ºÅ©/¼¹ö¿ë±×·¡ÇÈÄ«µå/Äõµå·ÎP400/QUADRO±×·¡ÇÈÄ«µå/QUADRO/¿ìºÐÅõ¼³Ä¡/¼¹öº¸¾È/³×Æ®¿öÅ©Àåºñ/³×Æ®¿öÅ©½ºÀ§Ä¡/L2½ºÀ§Ä¡/L3½ºÀ§Ä¡/OS¼³Ä¡/¼¹öOS¼³Ä¡/¸®´ª½º¼¹ö¼³Ä¡/¿ìºÐÅõ¼³Ä¡/Æäµµ¶ó¼³Ä¡/·¹µåÇò¼³Ä¡/RHEL¼³Ä¡/ |
Content |
Name |
Date |
Hits |
---|---|---|---|
|
2021-07-01 |
3479 |