¥µ¥Ý¡¼¥È
PostgreSQL/PowerGres ¥µ¥Ý¡¼¥È&Êݼ饵¡¼¥Ó¥¹
PostgreSQL¤Î10ǯ¥µ¥Ý¡¼¥È¡¢¥µ¡¼¥É¥Ñ¡¼¥Æ¥£¥½¥Õ¥È¥¦¥§¥¢¤Î¥µ¥Ý¡¼¥È¤ò³«»Ï¤·¤Þ¤·¤¿¡£
ÂåɽŪ¤Ê¥ª¡¼¥×¥ó¥½¡¼¥¹¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ç¤¢¤ë PostgreSQL ¤ÎÍøÍѤò»Ù±ç¤¹¤ë¥µ¥Ý¡¼¥È¥µ¡¼¥Ó¥¹¤Ç¤¹¡£
PostgreSQL ¤òÍøÍѤ·¤¿¥·¥¹¥Æ¥à¤Î³«È¯»þ¤«¤é±¿ÍѤޤǡ¢Éý¹¤¯³èÍѤ¤¤¿¤À¤±¤ë¥µ¡¼¥Ó¥¹ÆâÍÆ¤È¤Ê¤Ã¤Æ¤ª¤ê¤Þ¤¹¡£
ÆüËܤǺǽé¤Ë PostgreSQL ¤Î¥µ¥Ý¡¼¥È¤ò³«»Ï¤·¤¿Åö¼Ò¤¬¡¢Ä¹Ç¯¤Î·Ð¸³¤ò³è¤«¤·¤Æ¡¢ ¹âÉʼÁ¤«¤Ä¿×®¤ÊÂбþ¤ò¼Â»Ü¤·¤Æ¤¤¤Þ¤¹¡£
Ä̾ï¤Î¥µ¥Ý¡¼¥È¤Ç¤ÏÂоݳ°¤È¤Ê¤ë¡¢À߷פä¥Á¥å¡¼¥Ë¥ó¥°¤È¤¤¤Ã¤¿¹âÅÙ¤ÊÆâÍÆ¤â¥µ¥Ý¡¼¥È¤Ë´Þ¤ó¤Ç¤ª¤ê¡¢
PostgreSQL ¤Î³«È¯¤Ë´Ø¤ï¤ëÅö¼Ò¤¬¥½¡¼¥¹¥³¡¼¥É¥ì¥Ù¥ë¤ÇÂбþ¤µ¤»¤Æ¤¤¤¿¤À¤¯¡¢ÉʼÁ½Å»ë¤Î¥µ¡¼¥Ó¥¹¤Ç¤¹¡£
SRA OSS ¤Î¥µ¡¼¥Ó¥¹¤Ï¤³¤³¤¬°ã¤¦¡ª
- ¥½¡¼¥¹¥³¡¼¥É¥ì¥Ù¥ë¤ÇÄ´ºº³Îǧ¤ò¹Ô¤¦¡¢¹âÉʼÁ¤Ê¥Ø¥ë¥×¥Ç¥¹¥¯¥µ¡¼¥Ó¥¹
- PostgreSQL ÍѤΥ¯¥é¥¹¥¿¥½¥Õ¥È¥¦¥§¥¢¤â¥µ¥Ý¡¼¥È
- ¥Ê¥ì¥Ã¥¸¥Ù¡¼¥¹¡¢¥Ë¥å¡¼¥¹ÇÛ¿®¤Ê¤É¡¢¼þÊÕ¥µ¡¼¥Ó¥¹¤â½¼¼Â
¥µ¡¼¥Ó¥¹ÆâÍÆ (³µÍ×)
¥Ø¥ë¥×¥Ç¥¹¥¯
¡ã ¥Ç¡¼¥¿¥Ù¡¼¥¹¥µ¡¼¥Ð¤Î¥Ø¥ë¥×¥Ç¥¹¥¯ÂбþÈÏ°Ï ¡ä
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¥µ¡¼¥ÐËÜÂΡ¢¥¤¥ó¥¹¥È¡¼¥ë¡¢ÀßÄê¡¢´ÉÍý¥Ä¡¼¥ë¤Î»È¤¤Êý¡ÊPowerGres¤Î¾ì¹ç¡Ë¡¢¥Þ¥Ë¥å¥¢¥ë¥ì ¥Ù¥ë¤Î¤ªÌ䤤¹ç¤ï¤»¡¢¥½¡¼¥¹¥³¡¼¥É²òÀÏ¡¢
¥Ç¡¼¥¿¥Ù¡¼¥¹À߷ס¢¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹¥Á¥å¡¼¥Ë¥ó¥°¡¢¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×¤Ë´Ø¤¹¤ë¤ªÌä¹ç¤»¡Ê°Ü¹Ô´ü´Ö ¤Ë¸Â¤ë¡Ë - contrib¥Ä¡¼¥ë(PostgreSQL¤ËƱº¤·¤ÆÇÛÉÛ¤µ¤ì¤ëÄÍÄ󶡥⥸¥å¡¼¥ë·²)
¥¤¥ó¥¹¥È¡¼¥ë¡¢ÀßÄê¡¢¥Þ¥Ë¥å¥¢¥ë¥ì¥Ù¥ëÌ䤤¹ç¤ï¤»¡¢¥½¡¼¥¹¥³¡¼¥É²òÀÏ - ¥µ¡¼¥É¥Ñ¡¼¥Æ¥£¥½¥Õ¥È¥¦¥§¥¢
pg_statsinfo,pg_rman,pg_reorg,pg_bulkload,pgFounie,pgfincore,pgAdmin3
¥¤¥ó¥¹¥È¡¼¥ë¡¢ÀßÄê¡¢¥Þ¥Ë¥å¥¢¥ë¥ì¥Ù¥ëÌ䤤¹ç¤ï¤»¡¢¥½¡¼¥¹¥³¡¼¥É²òÀÏ - ¥Ç¡¼¥¿¥Ù¡¼¥¹¥µ¡¼¥Ð¤ËÀܳ¤¹¤ë API
C¡Êlibpq¡Ë, JDBC, ODBC¡ÊpsqlODBC¡Ë, PHP, Npgsql
¡ã ¥¯¥é¥¹¥¿¥½¥Õ¥È¥¦¥§¥¢¤Î¥Ø¥ë¥×¥Ç¥¹¥¯ÂбþÈÏ°Ï ¡ä
- ¥¯¥é¥¹¥¿¥½¥Õ¥È¥¦¥§¥¢¤Ë´Ø¤¹¤ë¤ªÌä¹ç¤»
¹½À®À߷ס¢¥¤¥ó¥¹¥È¡¼¥ë¡¢ÀßÄê¡¢´ÉÍý¥Ä¡¼¥ë¤Î»È¤¤Êý¡ÊÉÕ°¥Ä¡¼¥ë¤Ë¸Â¤ë¡Ë¡¢¥Þ¥Ë¥å¥¢¥ë¥ì¥Ù¥ë¤Î¤ªÌ䤤¹ç¤ï¤»¡¢
¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹¥Á¥å¡¼¥Ë¥ó¥°¡¢¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×¤Ë´Ø¤¹¤ë¤ªÌä¹ç¤»¡Ê°Ü¹Ô´ü´Ö¤Ë¸Â¤ë¡Ë
¾ã³²Âбþ
¾ã³²¸¶°ø¤òÄ´ºº¤·¡¢²þÁ±ºö¤ò¤´Ä󼨤¤¤¿¤·¤Þ¤¹¡£²þÁ±ºö¤ÎÄ󼨤ÏÉüµìÊýË¡¡¢²óÈòÊýË¡¤òÃæ¿´¤È¤·¤Þ¤¹¤¬¡¢
¥½¥Õ¥È¥¦¥§¥¢¤Î½¤Àµ¤Ç¤·¤«Âбþ¤Ç¤¤Ê¤¤¾ì¹ç¡¢²Äǽ¤Ê¸Â¤ê¥½¥Õ¥È¥¦¥§¥¢ËÜÂΤؤν¤Àµ¤ò¹Ô¤¤¤Þ¤¹¡£
¾ðÊóÇÛ¿®¥µ¡¼¥Ó¥¹
¥µ¥Ý¡¼¥ÈÂоݤΥ½¥Õ¥È¥¦¥§¥¢¤Ë´Ø¤¹¤ë¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×¾ðÊó¤äºÇ¿·¾ðÊó¤ò¿ï»þ¡¢ÅŻҥ᡼¥ë¤Ë¤Æ¤ªÃΤ餻¤·¤Þ¤¹¡£
¥Ê¥ì¥Ã¥¸¡¦¥Ç¡¼¥¿¥Ù¡¼¥¹
¤´·ÀÌó¤Î¥½¥Õ¥È¥¦¥§¥¢¤Ë´Ø¤¹¤ë¡¢¤è¤¯¤¢¤ë¤´¼ÁÌä¤ä¡¢²áµî¤Î²óÅú»öÎã¤Ê¤É¤ò±ÜÍ÷¤¤¤¿¤À¤±¤ë¥µ¡¼¥Ó¥¹¤Ç¤¹¡£
¥µ¥Ý¡¼¥È¤ªÌ䤤¹ç¤ï¤»ÍѤÎWeb¥·¥¹¥Æ¥à¤«¤é»²¾È¤¤¤¿¤À¤±¤Þ¤¹¡£
¡¡¡¡¡¡
¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×¥½¥Õ¥È¥¦¥§¥¢¤ÎÄó¶¡
¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×¥½¥Õ¥È¥¦¥§¥¢¤ò̵½þ¤Ç¤´Ä󶡤¤¤¿¤·¤Þ¤¹¡£
¥µ¡¼¥Ó¥¹¥á¥Ë¥å¡¼
3 ¼ïÎà¤Î¥á¥Ë¥å¡¼¤È¡¢¤½¤ì¤¾¤ì¤Ë¥Ó¥¸¥Í¥¹¥¿¥¤¥à¥µ¥Ý¡¼¥È¤È24 »þ´Ö 365 Æü¡Ê°Ê¹ß 24¡ß365¡Ë¥µ¥Ý¡¼¥È¤¬ÍѰդµ¤ì¤Æ¤¤¤Þ¤¹¡£
¡Ê¥Ó¥¸¥Í¥¹¥¿¥¤¥à¥µ¥Ý¡¼¥È¤È 24¡ß365¥µ¥Ý¡¼¥È¤Ë¤Ä¤¤¤Æ¤Ï¡¢¤´°ÆÆâ PDF ¤Î
¡Ö3.¼õÉÕÊýË¡¤ÈÂбþ»þ´Ö¡×¤ò¤´»²¾È¤¯¤À¤µ¤¤¡£¡Ë
Âоݥ½¥Õ¥È¥¦¥§¥¢¤ª¤è¤Ó¥×¥é¥Ã¥È¥Õ¥©¡¼¥à¤Î¥Ð¡¼¥¸¥ç¥ó¤Ë¤Ä¤¤¤Æ¤Ï¡¢¤´°ÆÆâ(ÊÌ»æ¡Ë¤ÎÄ̤ê¤È¤Ê¤ê¤Þ¤¹¡£
| ¥µ¡¼¥Ó¥¹¥á¥Ë¥å¡¼ | ¥×¥é¥Á¥Ê | ¥´¡¼¥ë¥É | ¥·¥ë¥Ð¡¼ |
|---|---|---|---|
| Âбþ¥Ç¡¼¥¿¥Ù¡¼¥¹ ¥½¥Õ¥È¥¦¥§¥¢ |
PostgreSQL¢¨3 PowerGres on Windows PowerGres on Linux |
||
| Âбþ¥¯¥é¥¹¥¿ ¥½¥Õ¥È¥¦¥§¥¢ |
pgpool-II,Slony-I,pgpool-HA,¢¨4 Corosync/Heartbeat¢¨5,DRBD¢¨5 |
- | |
| Âбþ¥×¥é¥Ã¥È¥Õ¥©¡¼¥à | PostgreSQL |
¡Ú Linux ¡Û |
|
| DB ¥µ¡¼¥Ð¥Î¡¼¥É¿ô ¢¨ 1 | 20 | 4 | 1 |
| ¼ÁÌäôÅö¼Ô¿ô | 20̾ | 4̾ | 1̾ |
| ¥¤¥ó¥·¥Ç¥ó¥È¿ô ¢¨ 2 | ̵À©¸Â | ||
| ·ÀÌó´ü´Ö | 1 ǯ´Ö | ||
| ɸ½à¥á¥Ë¥å¡¼ Àǹþ²Á³Ê | ¥Ó¥¸¥Í¥¹¥¿¥¤¥à 2,100,000±ß | ¥Ó¥¸¥Í¥¹¥¿¥¤¥à 840,000±ß | ¥Ó¥¸¥Í¥¹¥¿¥¤¥à 420,000±ß |
| 24¡ß365 4,200,000±ß | 24¡ß365 1,680,000±ß | 24¡ß365 840,000±ß | |
| pgpool-HA ¥ª¥×¥·¥ç¥ó ²Á³Ê ¢¨6 | ¥Ó¥¸¥Í¥¹¥¿¥¤¥à 787,500 ±ß | ¥Ó¥¸¥Í¥¹¥¿¥¤¥à 315,000 ±ß | - |
| 24¡ß365 1,575,000±ß | 24¡ß365 630,000±ß | - | |
| Pacemaker / Heartbeat + DRBD ¥ª¥×¥·¥ç¥ó ²Á³Ê ¢¨7 | ¥Ó¥¸¥Í¥¹¥¿¥¤¥à 1,050,000 ±ß | ¥Ó¥¸¥Í¥¹¥¿¥¤¥à 420,000 ±ß | - |
| 24¡ß365 2,100,000±ß | 24¡ß365 840,000±ß | - | |
- ¢¨ 1
- DB¥µ¡¼¥Ð¥Î¡¼¥É¿ô¤È¤Ï¡¢1¤Ä¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¥µ¡¼¥Ð¥×¥í¥°¥é¥à¤Î¥¤¥ó¥¹¥È¡¼¥ë¿ô¤ò¤µ¤·¤Þ¤¹¡£
¥¯¥é¥¹¥¿¥½¥Õ¥È¥¦¥§¥¢¤òÍøÍѤ·¤¿¾ì¹ç¤â¡¢¥Ç¡¼¥¿¥Ù¡¼¥¹¥µ¡¼¥Ð¥×¥í¥°¥é¥à¤Î¥¤¥ó¥¹¥È¡¼¥ë¿ô¤Î¤ß¤Ç¥«¥¦¥ó¥È¤·¤Þ¤¹¡£ - ¢¨ 2
- ¥¤¥ó¥·¥Ç¥ó¥È¿ô¤Ï1¤Ä¤Î¼ÁÌ䤬´°Î»¤¹¤ë¤Þ¤Ç¤Î°ìÏ¢¤Îή¤ì¤ò¤µ¤·¤Þ¤¹¡£
- ¢¨ 3
- PostgreSQL¤Ï³«È¯¥³¥ß¥å¥Ë¥Æ¥£¤è¤ê¥ê¥ê¡¼¥¹¤µ¤ì¤Æ¤¤¤ë¤â¤Î¤¬Âоݤˤʤê¤Þ¤¹¡£
- ¢¨ 4
- pgpool-HA¥ª¥×¥·¥ç¥óÄɲä¬É¬Í×
- ¢¨ 5
- Pacemaker/Heartbeat+DRBD¥ª¥×¥·¥ç¥óÄɲä¬É¬Í×
- ¢¨ 6
- Pacemaker/Heartbeat¤Ë¤è¤ë¹â²ÄÍÑÀ¥¯¥é¥¹¥¿¤Ç pgpool-HA ¥ê¥«¥Ð¥ê¥¨¡¼¥¸¥§¥ó¥È¤ò»È¤¤pgpool-II¤òÊݸ¤ë¹½À® ¡¡¡¡
- ¢¨ 7
- Pacemaker/Heartbeat ¤Ë¤è¤ë¹â²ÄÍÑÀ¥¯¥é¥¹¥¿¤Ç DRBD ¤Ë¤è¤ë¥ì¥×¥ê¥±¡¼¥·¥ç¥ó¤Ç PostgreSQ L ¤òÊݸ¤ë¹½À®
IBM Power Systems ¤Ø¤ÎÂбþ¤Ë¤Ä¤¤¤Æ
IBM Power Systems
¤Ø¤ÎÂбþ¤Ë¤Ä¤¤¤Æ¡¢¤è¤ê´Ê°×¤Ë¤´ÍøÍѤ¤¤¿¤À¤¯¤¿¤á¤Ë¡¢
ËÜ¥µ¥Ý¡¼¥È¤ÎÂоݥ½¥Õ¥È¥¦¥§¥¢¤Î RPM ¥Ñ¥Ã¥±¡¼¥¸¤òÄ󶡤·¤Æ¤ª¤ê¤Þ¤¹¡£
Red Hat Enterprise Linux 6 for IBM POWER ÍÑ PostgreSQL ´ØÏ¢¥½¥Õ¥È¥¦¥§¥¢ RPM ¥Ñ¥Ã¥±¡¼¥¸¥À¥¦¥ó¥í¡¼¥É
¤½¤Î¾¤Î¥ß¥É¥ë¥¦¥§¥¢¡¦Äɲå⥸¥å¡¼¥ë¤È¤ÎÁȤ߹ç¤ï¤»
PostgreSQL ¤ÈÁȤ߹ç¤ï¤»¤ÆÍøÍѤ¹¤ë¤½¤Î¾¥ß¥É¥ë¥¦¥§¥¢¤äÄɲå⥸¥å¡¼¥ë¤ò»È¤¦¾ì¹ç¤Ë
¤½¤ì¤é¤ËÂФ¹¤ë¥µ¥Ý¡¼¥È¤â¤´Ä󶡤¤¤¿¤·¤Þ¤¹¡£
¸ÄÊ̤ˤªÌ䤤¹ç¤ï¤»¤¯¤À¤µ¤¤¡£
¥µ¥Ý¡¼¥È¾ÜºÙ
¾Ü¤·¤¤¥µ¥Ý¡¼¥ÈÆâÍÆ¤Ï¡ÖPostgreSQL/PowerGres ¥µ¥Ý¡¼¥È&Êݼ饵¡¼¥Ó¥¹¤Î¤´°ÆÆâ (
PDF ·Á¼°/260 KB)¡×¤ª¤è¤Ó¡ÖPostgreSQL/PowerGres¥µ¥Ý¡¼¥È&Êݼ饵¡¼¥Ó¥¹¤Î¤´°ÆÆâ¡ÊÊÌ»æ¡Ë¡×
¡ÊPDF·Á¼°/210KB)¤ò¤´Í÷¤¯¤À¤µ¤¤¡£
¾åµ°Ê³°¤Ë¡¢¥½¥Õ¥È¥¦¥§¥¢¥Ù¥ó¥À¡¼Íͤ䥢¥×¥ê¥±¡¼¥·¥ç¥ó¥µ¡¼¥Ó¥¹¥×¥í¥Ð¥¤¥À¡¼Í͸þ¤±¤Î¡Ö¥Ù¥ó¥À¡¼¥¢¥é¥¤¥¢¥ó¥¹¥×¥í¥°¥é¥à¡×¤â¤´ÍѰդ·¤Æ¤ª¤ê¤Þ¤¹¡£
¾ÜºÙ¤Ï
¤Þ¤Ç¤ªÌ䤤¹ç¤ï¤»¤¯¤À¤µ¤¤¡£
¤ª¿½¤·¹þ¤ß
Web ¥Ú¡¼¥¸¤«¤é¤ª¿½¤·¹þ¤ß¤ò¼õ¤±ÉÕ¤±¤Æ¤ª¤ê¤Þ¤¹¡£
¤ª¸«ÀѤâ¤ê¤¬É¬Íפʾì¹ç¤Ï
¤Þ¤Ç¤ªÌ䤤¹ç¤ï¤»¤¯¤À¤µ¤¤¡£
µì¥Ð¡¼¥¸¥ç¥ó¤Î¥µ¥Ý¡¼¥È¤ä¥µ¥Ý¡¼¥ÈÂоݳ°¤Î¥×¥é¥Ã¥È¥Õ¥©¡¼¥à¤Ë¤Ä¤¤¤Æ¤â¤´ÁêÃ̤¯¤À¤µ¤¤¡£







