Äú¿ÉÒÔ¾èÖú£¬Ö§³ÖÎÒÃǵĹ«ÒæÊÂÒµ¡£

1Ôª 10Ôª 50Ôª





ÈÏÖ¤Â룺  ÑéÖ¤Âë,¿´²»Çå³þ?Çëµã»÷Ë¢ÐÂÑéÖ¤Âë ±ØÌî



  ÇóÖª ÎÄÕ ÎÄ¿â Lib ÊÓÆµ iPerson ¿Î³Ì ÈÏÖ¤ ×Éѯ ¹¤¾ß ½²×ù Modeler   Code  
»áÔ±   
 
   
 
 
     
   
 ¶©ÔÄ
  ¾èÖú
ÔÚ Bluemix ÉϹÜÀí MySQL ºÍ PostgreSQL Êý¾Ý¿â
 
×÷Õߣº³µ öÎ À´Ô´£ºIBM ·¢²¼ÓÚ£º2015-5-21
  3039  次浏览      30
 

Bluemix ÌṩÁË MySQL ºÍ PostgreSQL µÄÊý¾Ý¿â·þÎñ£¬Óû§¿ÉÒÔÖ±½Óµ÷ÓÃÊý¾Ý¿â£¬´øÀ´ÁËʹÓÃÉϵıãÀû£¬µ«Óû§Ä¿Ç°ÔÚ Bluemix ÉÏÎÞ·¨×÷Ϊ¹ÜÀíÔ±Ö±½Ó¹ÜÀíÊý¾Ý¿â¡£±¾ÎÄÖ÷Òª½éÉÜÈçºÎÔÚ Bluemix µÄÔÆÆ½Ì¨ÉϹÜÀíÄúµÄÊý¾Ý¿â¡£

±¾ÎÄÊÊÓ÷¶Î§

Bluemix ²¢Ã»ÓÐÌṩһ¸ö·½°¸ÓÃÀ´ÔÚÏß¹ÜÀíÄú´´½¨µÄÊý¾Ý¿â£¬Èç MySQL£¬PostgreSQL µÈ¡£µ±Óû§ÔÚ Bluemix ÉÏ´´½¨ÁËÊý¾Ý¿â£¬ÎÒÃÇÐèÒªÒ»¸ö½â¾ö·½°¸È¥ÔÚÏß¹ÜÀíÊý¾Ý¿â¡£±¾ÎÄÖ÷Òª½â¾öÔÚÈçºÎ Bluemix ÔÆÆ½Ì¨ÉÏÖ±½Ó¹ÜÀíÄú´´½¨µÄ MySQL ºÍ PostgreSQL ºǫ́Êý¾Ý¿â£¬ÅäÖÃÍê³Éºó£¬¿ÉÒÔÍê³ÉÊý¾Ý¿âµÄÔö¼Ó¡¢É¾³ý¡¢Ð޸ĺͲéѯµÈ»ù±¾ÈÎÎñ£¬¿ÉÒÔÔÊÐíÄúÔËÐÐ SQL ½Å±¾¡£

Bluemix µÄÊý¾Ý¿â·þÎñ¼ò½é

Bluemix ƽ̨Èÿª·¢ÈËÔ±¡¢ÆóÒµºÍ×îÖÕÓû§¿ÉÒÔ̽Ë÷ÔÆÓ¦ÓóÌÐòµÄ¹¦ÄÜ£¬ÕâЩ¹¦Äܽ«Íƶ¯ÏÂÒ»´úµÄÔÆÓ¦ÓóÌÐòºÍ·þÎñ¡£Ó¦ÓóÌÐò¿ÉÒÔÊÇ´«Í³Ó¦ÓóÌÐò¡¢Éç½»Ó¦ÓóÌÐò¡¢Òƶ¯Ó¦ÓóÌÐò»òÈýÕߵĽáºÏ£¬²¢°üÀ¨´óÊý¾ÝµÄÒªÇó¡£ÎÞÂÛ¹¦ÄÜÈçºÎ×éºÏ£¬¹¹½¨ÓÚ Bluemix Ö®ÉϵÄÓ¦ÓóÌÐò¶¼½«°üº¬ÒÔÏÂÊôÐÔ£º

1.½µµÍÅäÖÃÒªÇó£¨Ó¦ÓóÌÐò»ò»ù´¡¼Ü¹¹£©

2.Áé»îµÄÈÝÁ¿

3.×Ô¶¯µÄ¼¼ÊõÈÎÎñ

4.¶àÖÖ¹¤×÷¸ºÔØÀàÐÍ

ÆäÖÐ Bluemix ƽ̨ÌṩÁ˶àÖֿɹ©Óû§Ñ¡ÔñµÄÊý¾Ý¿â·þÎñ£¬ÈçÏÂͼËùʾ£º

ͼ 1.Bluemix Êý¾Ý¿â·þÎñ

¹ÜÀí MySQL Êý¾Ý¿â

°²×°²¿Êð phpMyadmin µ½ Bluemix

phpMyadmin ÊÇÓà PHP ¿ª·¢µÄÒ»¸öÃâ·ÑµÄ¹¤¾ß£¬ÓÃÀ´Í¨¹ý Web ¹ÜÀí MySQL Êý¾Ý¿â¡£phpMyadmin Ö§³ÖºÜ¶à°æ±¾µÄ MySQL Êý¾Ý¿â¡£Í¨¹ý phpMyadmin µÄ Web Óû§½çÃæ¿ÉÒÔʵÏֺܶೣÓõÄÊý¾Ý¿â²Ù×÷£¬Èç¹ÜÀíÊý¾Ý¿â£¨database£©¡¢±í¸ñ£¨table£©¡¢ÁУ¨column£©¡¢¹ØÏµ£¨relation£©¡¢Ë÷Òý£¨index£©¡¢Óû§£¨user£©¡¢È¨ÏÞ£¨permission£©µÈµÈ£¬Äú»¹¿ÉÒÔÖ±½ÓÖ´ÐÐ SQL Óï¾ä¡£

ÓÉÓÚ Bluemix Ìṩ·þÎñµÄĿ¼ÖУ¬²¢Ã»ÓÐ PHP runtime µÄÖ§³Ö£¬ËùÒÔÎÒÃÇÐèҪʹÓõÚÈý·½ÌṩµÄ buildpack È¥Ö§³Ö PHP ÔËÐС£ÏÂÃæ½«Áгö¼¸¸öÏêϸ²½ÖèÈ¥²¿Êð phpMyadmin Ó¦ÓóÌÐò¡£

ÓÉÓÚÎÒÃÇÐèÒªÓõ½ cf ¹¤¾ßÈ¥²¿Êð Bluemix Ó¦Óã¬Ê×ÏÈÐèÒªÏÂÔØ cf ¹¤¾ß£¬¿ÉÒÔ´ÓÏÂÃæÍøÖ·ÏÂÔØÒ»¸ö¡£https://github.com/cloudfoundry/cli/releases

ÏÂÔØ phpMyadmin Ó¦Óðü£¬¿ÉÒԲο¼ÏÂÃæµÄÍøÖ·¡£½¨ÒéʹÓÃ×îа汾¡£http://www.phpmyadmin.net/home_page/downloads.php

ÉÏ´« phpMyadmin µ½ Bluemix ·þÎñÆ÷£¬±¾ÎĽ¨ÒéʹÓà mainifest.yml À´ÉÏ´«ÄúµÄÓ¦Ó㬽« mainifest.xml ±à¼­ºó·Åµ½ phpMyadmin µÄ¸ùĿ¼Ï¡£

mainifest.xml ÄÚÈݿɲο¼ÈçÏ£º

---
applications:
- name: phpadmin-demo
memory: 128M
instances: 1
host: phpadmin-demo
domain: mybluemix.net
path: .
buildpack: https://github.com/dmikusa-pivotal/cf-php-build-pack.git

ÄÚÈݽâÊÍ£º

name: app µÄÃû×Ö

memory: ·ÖÅäµÄÄÚ´æ

host£ºapp µÄÖ÷»úÃû

domain£º Bluemix Óò

buildpack: php µÄ buildpack ·¾¶

´ò¿ª CMD ÃüÁîÐй¤¾ß£¬½øÈëµ½ phpMyadmin µÄĿ¼£¬ÔËÐÐÃüÁî cf push¡£

cf push

Èç¹û¿´µ½ÏÂͼËùʾµÄÈÕÖ¾£¬¾Í±íÃ÷ÄúµÄÓ¦ÓÃÒѾ­³É¹¦²¿Êðµ½ Bluemix ·þÎñÆ÷¡£

ͼ 2.ÉÏ´« phpadmin-demo Ó¦ÓÃ

µÇ¼µ½ÄúµÄ Bluemix ÕË»§£¬Ó¦¸Ã¿ÉÒÔ¿´µ½Ó¦ÓÃÒѾ­³É¹¦ÔËÐС£

ͼ 3.phpadmin-demo Ó¦ÓÃÒѾ­ÔËÐÐ

´´½¨Ò»¸ö MySQL ·þÎñ

ÎÒÃÇÐèÒª´´½¨Ò»¸ö MySQL µÄÊý¾Ý¿â·þÎñ£¬²¢°ó¶¨µ½Äú¸Õ¸Õ´´½¨µÄ phpadmin-demo µÄ³ÌÐòÉÏ£¬Í¨¹ý¼òµ¥µÄÅäÖÃÄú¾Í¿ÉÒÔ¹ÜÀíÄúµÄÊý¾Ý¿â¡£

´´½¨ mysql ·þÎñ£¬ÔÚ CMD ´°¿Ú£¬ÇëÔËÐÐ cf create-service SERVICE PLAN SERVICE_INSTANCE¡£SERVICE ¿ÉÒÔÊÇ mysql£¬PLAN ¿ÉÒÔÊÇ 100£¬SERVICE_INSTANCE ÊÇÄúµÄÊý¾Ý¿âÃû×Ö£¬Èç mysql-100¡£ÃüÁîÐÐÈçÏÂËùʾ¡£±¾ÎÄʹÓÃÃüÁîÐд´½¨ MySQL Êý¾Ý¿â£¬ÄúÒ²¿ÉÒÔͨ¹ý Web UI À´Íê³ÉÕâÒ»¸ö²Ù×÷¡£

cf create-service mysql 100 mysql-100

°ó¶¨ mysql-100 µ½ÄúµÄÓ¦ÓóÌÐò£¬ÇëÔËÐÐÃüÁîcf bind-service phpadmin-demo mysql-100 ¼´¿É¡£

µÇ½µ½ÄúµÄ Bluemix ÕË»§£¬¿ÉÒÔ»ñÈ¡µ½ mysql µÄ¹ÜÀíÔ±Óû§Æ¾¾Ý£¬¼´¿ÉÓÃÀ´¹ÜÀíÄúµÄ mysql Êý¾Ý¿â¡£

ͼ 4. MySQL ƾ¾Ý

·ÃÎÊÄúµÄÓ¦ÓóÌÐòµÄ URL http://phpadmin-demo.pngx.mybluemix.net/£¬Ê¹ÓÃÉÏÃæµÃµ½µÄ MySQL ƾ¾ÝµÇ½£¬¾Í¿ÉÒÔ¹ÜÀíÄúµÄ MySQL Êý¾Ý¿â¡£ÈçÏÂͼËùʾ£º

ͼ 5.phpMyadmin µÇ½½çÃæ

ͼ 6. phpMyadmin ¹ÜÀí½çÃæ

¹ÜÀí PostgreSQL Êý¾Ý¿â

°²×°²¿Êð WebSQL µ½ Bluemix »·¾³

WebSQL ÊÇÒ»¸öͨ¹ý web ¹ÜÀíÊý¾Ý¿âµÄ×î¼Ñ½â¾ö·½°¸£¬ÆäÓû§µÄ²Ù×÷½çÃæ¼¸½üºÍ×ÀÃæ¶Ë³ÌÐòÏàͬ£¬Äú²»ÓÃÏñʹÓà Web ³ÌÐòͨ¹ýÇл»Ò³ÃæÀ´¹ÜÀíÊý¾Ý¿â£¬ºÍÄúƽʱʹÓÃ×ÀÃæµÄ³ÌÐò²Ù×÷ÍêȫһÑù¡£Äú½ö½öÐèÒªµÇ½µ½¹ÜÀíÒ³Ãæ£¬¼È¿ÉÒÔÇáËɵÄÍê³É¶ÔÊý¾Ý¿âµÄ²Ù×÷ºÍά»¤¡£Ä¿Ç° WebSQL Ö§³ÖÈýÖÖÊý¾Ý¿âƽ̨£¬Èç MySQL¡¢SQLite ºÍ PostgreSQL¡£

Äú¿ÉÒÔ´ÓÈçÏÂÍøÖ·ÏÂÔØ×îÐ嵀 WebSQL ³ÌÐò£¬http://sourceforge.net/projects/mywebsql/files/stable/mywebsql-3.4.zip/download¡£

ÓÉÓÚ²¿Êð WebSQL ͬÑùÐèÒª PHP µÄÖ§³Ö£¬¿ÉÒÔ²ÎÕÕ֮ǰµÄ phpMyadmin ²¿Êð³ÌÐòµ½ Bluemix ·þÎñÆ÷£¬²½Öè»ù±¾Ïàͬ£¬¾Í²»ÔÚ´Ë׸Êö¡£ÎªÁËÖ§³Ö PostgreSQL£¬ÄúÐèÒªÐÞ¸Ä config Ï嵀 servers.php ÎļþÒÔ´ïµ½Ö§³Ö PostgreSQL¡£ÐèÒªÌí¼Ó´úÂë´Ó Bluemix »·¾³È¥»ñµÃÊý¾Ý¿âµÄµÇ½ƾ¾Ý£¬²¢×¢Ê͵ôÆäËûÊý¾Ý¿â·þÎñ£¬Èç¹ûÐèҪʹÓÃÆäËûÊý¾Ý¿â·þÎñ£¬È¥µô×¢ÊÍ×Ö·û¼´¿É¡£

´úÂëʾÀýÈçÏÂËùʾ£º

/*
* Read MySQL service properties from _ENV['VCAP_SERVICES']
*/
$services = json_decode($_ENV['VCAP_SERVICES'], true);
//$service = $services['mysql-5.5'][0]; // if you choose the mysql service
$service = $services['postgresql-9.1'][0];//if use choose the postgresql-9.1
$host = $service['credentials']['hostname'];
$port=$service['credentials']['port'];
$SERVER_LIST = array(
/*'Localhost MySQL' => array(
'host' => 'localhost',
'driver' => extension_loaded('mysqli') ? 'mysqli' : 'mysql5'
),
'SQLite Databases' => array(
'host' => 'c:/sqlitedb/',
'driver' => 'sqlite',
'user' => 'root', // set this yourself
'password' => 'sqlite' // set this yourself
),
*/
'Localhost PostgreSQL' => array(
'host' => 'localhost',
'driver' => 'pgsql'
),
/*'MySQL Proxy Server' => array(
'host' => 'localhost:4040',
'driver' => 'mysql5'
),
'MySQL 4' => array(
'host' => 'localhost',
'driver' => 'mysql4'
),
*/
);

´´½¨Ò»¸ö PostgreSQL ·þÎñ

¸úÉÏÃæµÄ MySQL Ò»ÑùÐèÒª´´½¨Ò»¸ö PostgreSQL ·þÎñ£¬¿ÉÒÔͨ¹ý cf ¹¤¾ßµÄÃüÁîÐд´½¨£¬Ò²¿ÉÒÔͨ¹ý Web UI ´´½¨£¬ÃüÁîÐÐÈçÏÂËùʾ£º

cf create-service postgresql 100 postgresql-100

°ó¶¨´Ë·þÎñµ½ÄúÒѾ­²¿ÊðµÄ WebSQL Ó¦Ó㬾ͿÉÒÔͨ¹ý WebSQL µÄ¹ÜÀí½çÃæÀ´¹ÜÀíÄúµÄÊý¾Ý¿âÁË¡£

ͨ¹ýÇ°Ãæ 2 ¸ö°¸ÀýµÄ˵Ã÷£¬Äú¿ÉÒÔÔËÓÃͬÑùµÄ·½·¨ÔÚ Bluemix Éϲ¿Êð¸ü¶àµÄÓ¦ÓÃÖ§³Ö²»Í¬µÄÊý¾Ý¿â¡£

 

   
3039 ´Îä¯ÀÀ       30
Ïà¹ØÎÄÕÂ

»ùÓÚEAµÄÊý¾Ý¿â½¨Ä£
Êý¾ÝÁ÷½¨Ä££¨EAÖ¸ÄÏ£©
¡°Êý¾Ýºþ¡±£º¸ÅÄî¡¢ÌØÕ÷¡¢¼Ü¹¹Óë°¸Àý
ÔÚÏßÉ̳ÇÊý¾Ý¿âϵͳÉè¼Æ ˼·+Ч¹û
 
Ïà¹ØÎĵµ

GreenplumÊý¾Ý¿â»ù´¡Åàѵ
MySQL5.1ÐÔÄÜÓÅ»¯·½°¸
ijµçÉÌÊý¾ÝÖÐ̨¼Ü¹¹Êµ¼ù
MySQL¸ßÀ©Õ¹¼Ü¹¹Éè¼Æ
Ïà¹Ø¿Î³Ì

Êý¾ÝÖÎÀí¡¢Êý¾Ý¼Ü¹¹¼°Êý¾Ý±ê×¼
MongoDBʵս¿Î³Ì
²¢·¢¡¢´óÈÝÁ¿¡¢¸ßÐÔÄÜÊý¾Ý¿âÉè¼ÆÓëÓÅ»¯
PostgreSQLÊý¾Ý¿âʵսÅàѵ
×îл¼Æ»®
DeepSeek´óÄ£ÐÍÓ¦Óÿª·¢ 6-12[ÏÃÃÅ]
È˹¤ÖÇÄÜ.»úÆ÷ѧϰTensorFlow 6-22[Ö±²¥]
»ùÓÚ UML ºÍEA½øÐзÖÎöÉè¼Æ 6-30[±±¾©]
ǶÈëʽÈí¼þ¼Ü¹¹-¸ß¼¶Êµ¼ù 7-9[±±¾©]
Óû§ÌåÑé¡¢Ò×ÓÃÐÔ²âÊÔÓëÆÀ¹À 7-25[Î÷°²]
ͼÊý¾Ý¿âÓë֪ʶͼÆ× 8-23[±±¾©]

MySQLË÷Òý±³ºóµÄÊý¾Ý½á¹¹
MySQLÐÔÄܵ÷ÓÅÓë¼Ü¹¹Éè¼Æ
SQL ServerÊý¾Ý¿â±¸·ÝÓë»Ö¸´
ÈÃÊý¾Ý¿â·ÉÆðÀ´ 10´óDB2ÓÅ»¯
oracleµÄÁÙʱ±í¿Õ¼äдÂú´ÅÅÌ
Êý¾Ý¿âµÄ¿çƽ̨Éè¼Æ

²¢·¢¡¢´óÈÝÁ¿¡¢¸ßÐÔÄÜÊý¾Ý¿â
¸ß¼¶Êý¾Ý¿â¼Ü¹¹Éè¼ÆÊ¦
HadoopÔ­ÀíÓëʵ¼ù
Oracle Êý¾Ý²Ö¿â
Êý¾Ý²Ö¿âºÍÊý¾ÝÍÚ¾ò
OracleÊý¾Ý¿â¿ª·¢Óë¹ÜÀí

GE Çø¿éÁ´¼¼ÊõÓëʵÏÖÅàѵ
º½Ìì¿Æ¹¤Ä³×Ó¹«Ë¾ Nodejs¸ß¼¶Ó¦Óÿª·¢
ÖÐÊ¢Òæ»ª ׿Խ¹ÜÀíÕß±ØÐë¾ß±¸µÄÎåÏîÄÜÁ¦
ijÐÅÏ¢¼¼Êõ¹«Ë¾ PythonÅàѵ
ij²©²ÊITϵͳ³§ÉÌ Ò×ÓÃÐÔ²âÊÔÓëÆÀ¹À
ÖйúÓÊ´¢ÒøÐÐ ²âÊÔ³ÉÊì¶ÈÄ£Ðͼ¯³É(TMMI)
ÖÐÎïÔº ²úÆ·¾­ÀíÓë²úÆ·¹ÜÀí