¾Æ¸¶Á¸ AWS¿¡ MariaDB ¼³Ä¡Çϱâ
¾Æ¸¶Á¸ AWSÀÇ EC2 ¼¹ö¿¡ ÀÌ°ÍÀú°Í Çϳª¾¿ ¼ÂÆÃÇÏ°í ÀÖ½À´Ï´Ù. ¾Õ¼± ÀÛ¾÷µéÀº ´ÙÀ½°ú °°½À´Ï´Ù.
2020/12/31 - [ÄïÁî Server/AWS] - [AWS] ¾Æ¸¶Á¸ À¥ ¼ºñ½º(Amazon Web Services) °¡ÀÔÇÏ´Â ¹æ¹ý
2021/01/01 - [ÄïÁî Server/AWS] - [AWS] ¾Æ¸¶Á¸ EC2 ¼¹ö ¸¸µå´Â ¹æ¹ý
2021/01/02 - [ÄïÁî Server/AWS] - [AWS] ¾Æ¸¶Á¸ EC2 ÀνºÅͽº¿¡ SSH Á¢¼ÓÇÏ´Â ¹æ¹ý
2021/01/03 - [ÄïÁî Server/AWS] - [AWS] ¾Æ¸¶Á¸ EC2 ¼¹ö¿¡ NginX ¼³Ä¡ÇÏ´Â ¹æ¹ý
2021/01/04 - [ÄïÁî Server/AWS] - [AWS] ¾Æ¸¶Á¸ EC2 ¼¹ö¿¡ NodeJS ¼³Ä¡ÇÏ´Â ¹æ¹ý
¸®´ª½º ¼¹ö¸¦ Çϳª ±¸¼ºÇß°í ÀÌ ¼¹ö¿¡ À¥ ¼¹öÀÎ NginX¿Í ¾îÇø®ÄÉÀ̼ÇÀ» ½ÇÇàÇÒ ¼ö ÀÖ´Â Ç÷§ÆûÀÎ Node.js¸¦ ¼³Ä¡Çß½À´Ï´Ù. ÀÌÁ¦ ¼¹ö ÇÁ·Î±×·¥À̶ó¸é ÇÊ¿äÇÑ ±¸¼º¿ä¼ÒÁß ÇϳªÀÎ DB¸¦ »ç¿ëÇØ º¼ ÇÊ¿ä°¡ ÀÖ½À´Ï´Ù. DB´Â µ¥ÀÌÅͺ£À̽º¸¦ ÀǹÌÇÏ¸ç ¿äÁòÀº MongoDBµµ ¸¹ÀÌ »ç¿ëÇÏÁö¸¸ ±âº»ÇüÀÎ RDBMS¸¦ ¼³Ä¡ÇÒ ¿¹Á¤ÀÔ´Ï´Ù.
À̹ø Æ÷½ºÆÿ¡¼´Â RDBMS Áß¿¡¼ MariaDB¸¦ ¼³Ä¡ÇÏ´Â ¹æ¹ýÀ» ¾Ë¾Æº¸°Ú½À´Ï´Ù.
MariaDB¶õ ¹«¾ùÀΰ¡
MariaDB´Â ¿ÀÇ ¼Ò½º·Î ¸¸µé¾îÁø °ü°èÇü µ¥ÀÌÅͺ£À̽º °ü¸® ½Ã½ºÅÛ(RDBMS)À» ¸»ÇÕ´Ï´Ù. »ç½Ç MariaDB´Â MySQL°ú µ¿ÀÏÇÑ ¼Ò½ºÄÚµå ±â¹ÝÀ¸·Î ¸¸µé¾îÁø µ¥ÀÌÅͺ£À̽ºÀÔ´Ï´Ù.
±âÁ¸¿¡ ¿ÀÇ ¼Ò½ºÀÌ°í ¹«·á·Î »ç¿ë °¡´ÉÇß´ø MySQLÀÌ ¿À¶óŬ ¼ÒÀ¯·Î ³Ñ¾î°¡¸é¼ ¶óÀ̼¾½º°¡ º¯°æµÇ¾ú½À´Ï´Ù. ÀÌ ¶óÀ̼¾½º »óÅ¿¡ ¹Ý¹ßÇÏ¿© ¸¸µé¾îÁø µ¥ÀÌÅͺ£À̽º°¡ MariaDBÀÔ´Ï´Ù. µû¶ó¼ MariaDB´Â MySQL°ú °ÅÀÇ Èí»çÇÏ¸ç ³ôÀº ȣȯ¼ºÀ» À¯ÁöÇÏ°í ÀÖ½À´Ï´Ù.
¾Æ¸¶Á¸ AWS¿¡ MariaDB ¼³Ä¡Çϱâ
¼³Ä¡ ¹æ¹ýÀº °£´ÜÇÕ´Ï´Ù. ·¹µåÇò °è¿ÀÇ ¸®´ªÀÎ AMI Linux¸¦ ÇÁ¸®Æ¼¾î·Î ÀÌ¿ëÇÏ°í Àֱ⠶§¹®¿¡ ¼³Ä¡ ¸í·É¾î´Â yumÀ» ÀÌ¿ëÇÕ´Ï´Ù. MariaDB¸¦ ¼³Ä¡ÇÏ´Â ¸í·É¾î´Â ¾Æ·¡¿Í °°½À´Ï´Ù.
$ sudo yum install mariadb-server
MariaDB¸¦ ¼³Ä¡ÇÏ´Â ÆÐÅ°Áö À̸§Àº mariadb-serverÀÔ´Ï´Ù. yumÀ» ÀÌ¿ëÇؼ ¼³Ä¡°¡ ¿Ï·áµÇ¸é ÀÌÁ¦ MariaDB¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
MariaDB ¼ºñ½º ½ÇÇà
MariaDB¸¦ ½ÇÇàÇϱâ À§ÇÑ ¼ºñ½º À̸§Àº mariadbÀÔ´Ï´Ù.
$ sudo systemctl start mariadb
systemctl ¼ºñ½º ¸Å´ÏÀú¸¦ ÀÌ¿ëÇؼ mariaDB¸¦ ½ÇÇàÇÕ´Ï´Ù.
±×¸®°í ÃÖÃÊ ½ÇÇàÇß´Ù¸é °ü¸®ÀÚ ºñ¹Ð¹øÈ£¸¦ óÀ½ ¼ÂÆÃÀ» ÇØÁà¾ß ÇÕ´Ï´Ù. ±×·¡¼ ¾Æ·¡ ¸í·É¾î¸¦ ÀÌ¿ëÇؼ °ü¸®ÀÚ(root)ÀÇ ºñ¹Ð¹øÈ£¸¦ ¸¸µé¾î ÁÝ´Ï´Ù.
$ mysqladmin -u root -p password 'ºñ¹Ð¹øÈ£';
°ü¸®ÀÚ ºñ¹Ð¹øÈ£¸¦ º¯°æÇß´Ù¸é ¾Æ·¡ ¸í·É¾î¸¦ ÀÌ¿ëÇؼ DB¿¡ Á¢±ÙÇÏ¸é µË´Ï´Ù. DB¿¡ Á¢±ÙÇÏ´Â ¸í·É¾î´Â MySQL°ú µ¿ÀÏÇÕ´Ï´Ù. ¸í·É¾î´Â ¾Æ·¡¿Í °°½À´Ï´Ù.
$ mysql -u root -p
À§¿Í °°ÀÌ ÀÔ·ÂÇϸé Password¸¦ ÀÔ·ÂÇ϶ó´Â ¸Þ¼¼Áö°¡ ³ªÅ¸³³´Ï´Ù. À̶§ À§¿¡¼ ¸¸µç ºñ¹Ð¹øÈ£¸¦ ÀÔ·ÂÇÏ¸é µ¥ÀÌÅͺ£À̽º¿¡ Á¢±ÙÀÌ °¡´ÉÇÕ´Ï´Ù.
À̹ø Æ÷½ºÆÿ¡¼´Â MariaDB¸¦ ¼³Ä¡ÇÏ°í ID, Password¸¦ ÀÌ¿ëÇؼ Á¢±ÙÇÏ´Â ¹æ¹ýÀ» ¾Ë¾Æº¸¾Ò½À´Ï´Ù. ½ÇÁ¦·Î µ¥ÀÌÅͺ£À̽º¸¦ ¿î¿µÇÒ ¶§¿¡´Â root·Î´Â Á¢±ÙÇÏÁö ¾Ê½À´Ï´Ù. Linuxµµ ¸¶Âù°¡Áö°í DBµµ ¸¶Âù°¡Áö·Î root(ÃÖ»óÀ§)°èÁ¤À¸·Î´Â µÇµµ·ÏÀ̸é Á¢±ÙÇÏÁö ¾ÊÀ¸¸ç µ¥ÀÌÅͺ£À̽º¸¦ ¸¸µé°í ½ÇÁ¦ Á¢±ÙÇؼ ¿î¿µÇÏ´Â °èÁ¤À» ¸¸µé¾î¼ Á¢±ÙÇÕ´Ï´Ù. ÀÌ»óÀÔ´Ï´Ù.
2021/01/02 - [ÄïÁî Server/Database] - [Database] MariaDB character set º¯°æ ¹æ¹ý
'ÄïÁî Server > AWS' Ä«Å×°í¸®ÀÇ ´Ù¸¥ ±Û
[AWS] ¾Æ¸¶Á¸ ec2 ¹«·á Ƽ¾î ¸Þ¸ð¸® ºÎÁ· Çö»ó (2) | 2021.02.15 |
---|---|
[AWS] ¾Æ¸¶Á¸ EC2 ¼¹ö¿¡ MariaDB ¼³Ä¡ (0) | 2021.01.07 |
[AWS] ¾Æ¸¶Á¸ EC2 ¼¹ö¿¡ NodeJS ¼³Ä¡ÇÏ´Â ¹æ¹ý (0) | 2021.01.05 |
[AWS] ¾Æ¸¶Á¸ EC2 ¼¹ö¿¡ NginX ¼³Ä¡ÇÏ´Â ¹æ¹ý (2) | 2021.01.04 |
[AWS] ¾Æ¸¶Á¸ EC2 ÀνºÅͽº¿¡ SSH Á¢¼ÓÇÏ´Â ¹æ¹ý (0) | 2021.01.03 |
[AWS] ¾Æ¸¶Á¸ EC2 ¼¹ö ¸¸µå´Â ¹æ¹ý (0) | 2021.01.01 |