½Ã½ºÅÛ°ü¸®ÀÚÀÇ ½°ÅÍ Ä¿ÇǴнº Ä¿ÇÇÇâÀÌ ³ª´Â *NIX
Ä¿ÇǴнº
½Ã½ºÅÛ/³×Æ®¿÷/º¸¾ÈÀ» ´Ù·ç´Â °÷
 FAQFAQ   °Ë»ö°Ë»ö   ¸â¹ö¸®½ºÆ®¸â¹ö¸®½ºÆ®   »ç¿ëÀÚ ±×·ì»ç¿ëÀÚ ±×·ì   »ç¿ëÀÚ µî·ÏÇϱâ»ç¿ëÀÚ µî·ÏÇϱâ 
 °³ÀÎ Á¤º¸°³ÀÎ Á¤º¸   ºñ°ø°³ ¸Þ½ÃÁö¸¦ È®ÀÎÇÏ·Á¸é ·Î±×ÀÎÇϽʽÿÀºñ°ø°³ ¸Þ½ÃÁö¸¦ È®ÀÎÇÏ·Á¸é ·Î±×ÀÎÇϽʽÿÀ   ·Î±×Àηα×ÀΠ

°¡ÀÔ¾øÀÌ ´©±¸³ª ±ÛÀ» ¾µ ¼ö ÀÖ½À´Ï´Ù. °øÁö»çÇ׿¡ ´ëÇÑ ´ñ±Û±îÁöµµ..




BBS >> ¼³Ä¡, ¿î¿µ Q&A | ³×Æ®¿÷, º¸¾È Q&A | ÀÏ¹Ý Q&A || Á¤º¸¸¶´ç | AWS || ÀÚÀ¯°Ô½ÃÆÇ | ±¸Àα¸Á÷ || °øÁö»çÇ× | ÀÇ°ßÁ¦½Ã
MySQLº¸´Ù ºü¸¥ MemSQL, ¾ÕÀ¸·Î ±â´ëµÇ´Â ¹°°Ç

 
±Û ¾²±â   ´äº¯ ´Þ±â    Ä¿ÇǴнº, ½Ã½ºÅÛ ¿£Áö´Ï¾îÀÇ ½°ÅÍ °Ô½ÃÆÇ À妽º -> *NIX / IT Á¤º¸
ÀÌÀü ÁÖÁ¦ º¸±â :: ´ÙÀ½ ÁÖÁ¦ º¸±â  
±Û¾´ÀÌ ¸Þ½ÃÁö
truefeel
Ä«Æä °ü¸®ÀÚ


°¡ÀÔ: 2003³â 7¿ù 24ÀÏ
¿Ã¸° ±Û: 1277
À§Ä¡: ´ëÇѹα¹

¿Ã¸®±â¿Ã·ÁÁü: 2012.6.26 È­, 7:06 pm    ÁÖÁ¦: MySQLº¸´Ù ºü¸¥ MemSQL, ¾ÕÀ¸·Î ±â´ëµÇ´Â ¹°°Ç Àοë°ú ÇÔ²² ´äº¯

ÀüÁ÷ ÆäÀ̽ººÏ(facebook) °³¹ßÀÚ Eric Frenkiel°ú Nikita Shamgunov°¡ ¸¸µç MemSQL.



1. Ư¡À» °£´ÜÈ÷ »ìÆ캸ÀÚ.

1) °³¹ßÀÚ°¡ ÁÖÀåÇϱâ´Â MemSQL °³¹ßÀÚ¿¡ µû¸¥ disk±â¹Ý DBº¸´Ù 30¹è±îÁö ºü¸£´Ù°í ÇÑ´Ù.
MemSQLÀº ÃÊ´ç 8¸¸Äõ¸®¸¦ ó¸®Çß°í MySQLÀº ÃÊ´ç 3õ500Äõ¸®¸¦ ó¸®Çؼ­ MySQLº¸´Ù´Â 23¹è ºü¸£´Ù°í.

2) MemSQLÀº ¸Þ¸ð¸®¿¡ µ¥ÀÌÅ͸¦ À¯ÁöÇÏ°í À־ ºü¸¥ ¼º´ÉÀ» ´Þ¼ºÇß´Ù.

ÆäÀ̽ººÏÀÌ PHPÄڵ带 C·Î º¯È¯ÇÏ¿© ¼º´ÉÀ» Çâ»ó½ÃÄ״µ¥, ÀÌ ¶§ PHP -> C++·Î º¯È¯ÇÑ ÅøÀÌ 'HipHop'ÀÌ´Ù. ÀÌ HipHopÅøó·³ MemSQLÀº SQLÀ» C++·Î º¯È¯ÇÏ¿©
¼º´ÉÀ» ±Þ°ÝÈ÷ ³ô¿´´Ù. °³¹ßÀÚÀÎ FrenkielÀº ÀÌ·¸°Ô ¸»Çß´Ù. "This is like HipHop for SQL"

3) MemSQLÀº MySQL API¿Í ÀÎÅÍÆäÀ̽º¸¦ »ç¿ëÇÑ´Ù.

±×·¡¼­ °ü¸®Àû À̽´µµ ¾ø°í, ¾î¶²°Íµµ »õ·Î ¹è¿ï °ÍÀÌ ¾ø´Ù.

4) ÇÏÁö¸¸, ¾ÆÁ÷ Áö¿ø ¾ÈµÇ´Â°Ô ÀÖ´Ù. ±×·¡µµ ³ª¿ÂÁö ¾ó¸¶¾ÈµÈ DB°¡ À§ÀÇ ¸»´ë·ÎÀÇ ¼º´É¸¸ ³»Áشٸé, ¾ÕÀ¸·Î ¾öû³­ ¹°°ÇÀÌ µÉ°Ô ºÐ¸íÇÏ´Ù.

UNSUPPORTED FEATURES

Àοë:

- Views
- Prepared Queries
- Stored procedures
- User Defined Functions
- Triggers
- Foreign keys
- Charsets other than utf8


5) MemSQL ÅõÀÚÀÚ¿¡ ¾Ö½¬Æ° Ä¿ÃÄ(Ashton Kutcher)°¡ ÀÖ´Ù.

¾Ö½¬Æ° Ä¿ÃÄ´Â IT¿¡ °ü½ÉÀÌ ¸¹Àº °Í °°´Ù. »çÁø °øÀ¯ SNSÀÎ Path(¡Ø Path °øµ¿Ã¢¾÷ÀÚ ÁßÀÇ ÇѸíÀÌ ³À½ºÅÍÀÇ °øµ¿Â÷¾÷ÀÚ '¼ð Æд×')¿¡µµ ÅõÀÚ¸¦ Çß´Ù. flipboard¿¡µµ ÅõÀÚÇÏ°í.

2. ½ÇÁ¦ »ç¿ëÇغ¸±â

MemSQL »çÀÌÆ®( http://memsql.com/ )¿¡¼­ ¸ÞÀÏÁÖ¼Ò ÀÔ·ÂÇÏ°í ´Ù¿î·Îµå ¹ÞÀ¸¸é µÈ´Ù.

- 64ºñÆ®¸¸ Áö¿ø
- RHEL(¶Ç´Â CentOS)ÀÇ °æ¿ì 6.0 ÀÌ»ó

¹ÙÀ̳ʸ® ¹Þ¾Æ¼­ ¾ÐÃุ Ç®¸é ³¡. ±×¸®°í, MySQL client ·Î Á¢¼ÓÇÏ´Ï Á¤¸» Àß µÇ´õ¶ó.

Àοë:

# ./memsqld -u root --port 3307 & <-- MemSQL µ¥¸ó ½ÇÇà
#
# mysql -u root -h 127.0.0.1 -P 3307 --prompt="memsql> "
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 250
Server version: 5.5.8 MemSQL source distribution


Äõ¸®¸¦ ½ÇÇàÇÏ¸é ¾Æ·¡Ã³·³ Äõ¸®¸¦ C++·Î ÄÄÆÄÀÏÇÏ°Ô µÈ´Ù. ±×·¡¼­ Ãʱâ Äõ¸®´Â ½ÇÇà½Ã°£ÀÌ Á» °É¸®°í, ±× ÀÌÈÄ´Â MySQLº¸´Ù ³ªÀº ¼º´ÉÀ» º¸ÀδÙ.
¾Æ·¡ 'miliseconds'¼ýÀÚ´Â »ý°¢º¸´Ù ³ô±äÇѵ¥, ½ÇÁ¦ ¿î¿µÇÏ´Â DB¼­¹ö¶ó¸é ÈξÀ ³·Àº ¼öÄ¡¸¦ º¸ÀÏ °ÍÀÌ´Ù.
¸Àº¸±â Å×½ºÆ®¸¦ ÇÏ·Á°í µà¾óÄÚ¾î, 4G ¼­¹ö¿¡¼­ ¼³Ä¡ÇÑ °ÍÀÌ´Ù.

ÄÚµå:

1688649195 2012-06-26 16:22:23 INFO: Query test.'select count(*) from test2' compiled in 669 miliseconds
2140046715 2012-06-26 16:29:55 INFO: Query test.'INSERT INTO test2(name, date) values (?, now())' compiled in 1369 miliseconds
3317465154 2012-06-26 16:49:32 INFO: Query test.'select name from test2 where id = @' compiled in 714 miliseconds
9867440156 2012-06-26 18:38:42 INFO: Query test.'update test2 set name = ^ where id = @' compiled in 1390 miliseconds


3. ¼º´ÉÀº?

- php 5.3¿¡¼­ microtimeÀ¸·Î ½Ã°£ üũ. °¢ Äõ¸®º°·Î 5¸¸È¸ ½ÇÇàÇÑ ½Ã°£ üũ. Å×½ºÆ®´Â 3ȸ¾¿.
- insert : INSERT INTO test2(name, date) VALUES ('aaaaa', now())
- select : SELECT name FROM test2 WHERE id = $i
- update : UPDATE test2 SET name = 'bbbbb' WHERE id = $i

Å×½ºÆ® ȯ°æÀº?

- ¼³Á¤ Æ©´×ÀÌ Á¦´ë·Î µÇÁö ¾ÊÀº »óÅ¿¡¼­ Å×½ºÆ®°¡ ÀÌ·ïÁ³°í,
- MemSQLÀÇ ±ÇÀå ¸Þ¸ð¸®ÀÎ 8Gº¸´Ù ÀûÀº 4G¿¡¼­ Å×½ºÆ®¸¦ Çß´Ù.
- ¼­ºñ½º¿¡ ÅõÀÔÇÒ ¼öµµ ¾ø´Â »óȲÀÌ°í,
- ¼­ºñ½º ȯ°æ¿¡ ±ÙÁ¢ÇÏ°Ô Å×½ºÆ® ¿äûÀ» ÇÒ ¼öµµ ¾øÀ¸¹Ç·Î

¾Æ·¡ ¼öÄ¡´Â ¼º´ÉÀÌ MySQLº¸´Ù ³´±ä ³´±¸³ª¶ó´Â Á¤µµ·Î¸¸ ÀÌÇØÇØ¾ß ÇÑ´Ù. Àý´ëÀûÀÎ °ÍÀ¸·Î ºÁ¼­´Â ¾ÈµÈ´Ù. Á¤¸» Âü°í¸¸.
¼öÄ¡»óÀ¸·Î´Â 1.5~2¹èÁ¤µµ. ¾Æ·¡ ¼öÄ¡ ´ÜÀ§´Â ÃÊ.
¼­ºñ½º¿¡¼­´Â Äõ¸®µµ º¹ÀâÇÏ°í, ´Ù¾çÇÑ Äõ¸®°¡ ÇѲ¨¹ø¿¡ ÀÌ·ïÁö¹Ç·Î ¿ÀÈ÷·Á Å×½ºÆ® °á°úº¸´Ù ¼º´ÉÀÌ ´õ ³ªÀ» ¼ö ÀÖÀ» °Í °°´Ù.

ÄÚµå:

1. INSERT

MemSQL 2.715 2.371 2.491
MySQL  4.004 3.974 3.982

2. SELECT

MemSQL 2.484 2.772 2.741
MySQL  4.271 4.296 4.088

3. UPDATE

MemSQL 2.380 2.527 2.177
MySQL  4.283 3.975 3.968


* Âü°í±Û :
Ex-Facebookers launch MemSQL to make your database fly ( 2012.6.18 )
À§·Î
»ç¿ëÀÚ Á¤º¸ º¸±â ºñ¹Ð ¸Þ½ÃÁö º¸³»±â ±Û ¿Ã¸°ÀÌÀÇ À¥»çÀÌÆ® ¹æ¹®
ÀÌÀü ±Û Ç¥½Ã:   
±Û ¾²±â   ´äº¯ ´Þ±â    Ä¿ÇǴнº, ½Ã½ºÅÛ ¿£Áö´Ï¾îÀÇ ½°ÅÍ °Ô½ÃÆÇ À妽º -> *NIX / IT Á¤º¸ ½Ã°£´ë: GMT + 9 ½Ã°£(Çѱ¹)
ÆäÀÌÁö 1 Áß 1

 
°Ç³Ê¶Ù±â:  
»õ·Î¿î ÁÖÁ¦¸¦ ¿Ã¸± ¼ö ÀÖ½À´Ï´Ù
´ä±ÛÀ» ¿Ã¸± ¼ö ÀÖ½À´Ï´Ù
ÁÖÁ¦¸¦ ¼öÁ¤ÇÒ ¼ö ¾ø½À´Ï´Ù
¿Ã¸° ±ÛÀ» »èÁ¦ÇÒ ¼ö ¾ø½À´Ï´Ù
ÅõÇ¥¸¦ ÇÒ ¼ö ¾ø½À´Ï´Ù


Powered by phpBB © 2001, 2005 phpBB Group