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¡£
Èç¹û¿´µ½ÏÂͼËùʾµÄÈÕÖ¾£¬¾Í±íÃ÷ÄúµÄÓ¦ÓÃÒѾ³É¹¦²¿Êðµ½ 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 Éϲ¿Êð¸ü¶àµÄÓ¦ÓÃÖ§³Ö²»Í¬µÄÊý¾Ý¿â¡£
|