Optimize Mysql Server


Status
Not open for further replies.
mustafaramadhan said:
Ini sedang bahas memcache atau memcached?. Itu kan module yang berbeda di php.
Click to expand...

memcached itu daemonnya/servernya.
memcache di php itu module php sbg client utk bisa konek dengan memcached.

http://php.net/manual/en/intro.memcache.php

[QUOTE
Introduction
Memcache module provides handy procedural and object oriented interface to memcached, highly effective caching daemon, which was especially designed to decrease database load in dynamic web applications.[/QUOTE]
 
Ini hasil yum list:
Code: 
> yum list php54-*
Loaded plugins: fastestmirror, priorities, protectbase, replace
Loading mirror speeds from cached hostfile
* base: mirror.hostduplex.com
* extras: mirrors.syringanetworks.net
* mratwork-epel: linux.mirrors.es.net
* mratwork-ius-stable: mirror.symnds.com
* mratwork-webtatic: us-east.repo.webtatic.com
* updates: centos.sonn.com
0 packages excluded due to repository protections
Available Packages
php54.x86_64                       5.4.45-1.ius.el6         mratwork-ius-archive
php54-apc-panel.noarch             3.1.15-0.4.20130912.el6.centos.alt
                                                            scl                 
php54-bcmath.x86_64                5.4.45-1.ius.el6         mratwork-ius-archive
php54-build.x86_64                 1.1-5.el6.centos.alt     scl                 
php54-cli.x86_64                   5.4.45-1.ius.el6         mratwork-ius-archive
php54-common.x86_64                5.4.45-1.ius.el6         mratwork-ius-archive
php54-dba.x86_64                   5.4.45-1.ius.el6         mratwork-ius-archive
php54-debuginfo.x86_64             5.4.45-1.ius.el6         mratwork-ius-archive
php54-devel.x86_64                 5.4.45-1.ius.el6         mratwork-ius-archive
php54-embedded.x86_64              5.4.45-1.ius.el6         mratwork-ius-archive
php54-enchant.x86_64               5.4.45-1.ius.el6         mratwork-ius-archive
php54-fpm.x86_64                   5.4.45-1.ius.el6         mratwork-ius-archive
php54-gd.x86_64                    5.4.45-1.ius.el6         mratwork-ius-archive
php54-imap.x86_64                  5.4.45-1.ius.el6         mratwork-ius-archive
php54-interbase.x86_64             5.4.45-1.ius.el6         mratwork-ius-archive
php54-intl.x86_64                  5.4.45-1.ius.el6         mratwork-ius-archive
php54-ioncube-loader.x86_64        5.0.18-1.ius.el6         mratwork-ius-archive
php54-ioncube-loader-debuginfo.x86_64
                                   5.0.18-1.ius.el6         mratwork-ius-archive
php54-ldap.x86_64                  5.4.45-1.ius.el6         mratwork-ius-archive
php54-litespeed.x86_64             5.4.45-1.ius.el6         mratwork-ius-archive
php54-mbstring.x86_64              5.4.45-1.ius.el6         mratwork-ius-archive
php54-mcrypt.x86_64                5.4.45-1.ius.el6         mratwork-ius-archive
php54-mssql.x86_64                 5.4.45-1.ius.el6         mratwork-ius-archive
php54-mysql.x86_64                 5.4.45-1.ius.el6         mratwork-ius-archive
php54-mysqlnd.x86_64               5.4.45-1.ius.el6         mratwork-ius-archive
php54-odbc.x86_64                  5.4.45-1.ius.el6         mratwork-ius-archive
php54-pdo.x86_64                   5.4.45-1.ius.el6         mratwork-ius-archive
php54-pear.noarch                  1:1.9.5-2.ius.el6        mratwork-ius-archive
php54-pecl-apc.x86_64              3.1.14-1.ius.el6         mratwork-ius-archive
php54-pecl-apc-debuginfo.x86_64    3.1.14-1.ius.el6         mratwork-ius-archive
php54-pecl-geoip.x86_64            1.0.8-3.ius.el6          mratwork-ius-archive
php54-pecl-geoip-debuginfo.x86_64  1.0.8-3.ius.el6          mratwork-ius-archive
php54-pecl-imagick.x86_64          3.1.2-2.ius.el6          mratwork-ius-archive
php54-pecl-imagick-debuginfo.x86_64
                                   3.1.2-2.ius.el6          mratwork-ius-archive
php54-pecl-lzf.x86_64              1.6.3-1.ius.el6          mratwork-ius-archive
php54-pecl-lzf-debuginfo.x86_64    1.6.3-1.ius.el6          mratwork-ius-archive
php54-pecl-memcache.x86_64         3.0.8-1.ius.el6          mratwork-ius-archive
php54-pecl-memcache-debuginfo.x86_64
                                   3.0.8-1.ius.el6          mratwork-ius-archive
php54-pecl-memcached.x86_64        2.2.0-1.ius.el6          mratwork-ius-archive
php54-pecl-memcached-debuginfo.x86_64
                                   2.2.0-1.ius.el6          mratwork-ius-archive
php54-pecl-mongo.x86_64            1.6.11-1.ius.el6         mratwork-ius-archive
php54-pecl-mongo-debuginfo.x86_64  1.6.11-1.ius.el6         mratwork-ius-archive
php54-pecl-mysqlnd-ms.x86_64       1.5.2-1.ius.el6          mratwork-ius-archive
php54-pecl-mysqlnd-ms-debuginfo.x86_64
                                   1.5.2-1.ius.el6          mratwork-ius-archive
php54-pecl-mysqlnd-ms-devel.x86_64 1.5.2-1.ius.el6          mratwork-ius-archive
php54-pecl-redis.x86_64            2.2.7-1.ius.el6          mratwork-ius-archive
php54-pecl-redis-debuginfo.x86_64  2.2.7-1.ius.el6          mratwork-ius-archive
php54-pecl-xdebug.x86_64           2.3.3-1.ius.el6          mratwork-ius-archive
php54-pecl-xdebug-debuginfo.x86_64 2.3.3-1.ius.el6          mratwork-ius-archive
php54-pecl-zendopcache.x86_64      7.0.5-1.el6              mratwork-ius-archive
php54-pecl-zendopcache-debuginfo.x86_64
                                   7.0.5-1.el6              mratwork-ius-archive
php54-pgsql.x86_64                 5.4.45-1.ius.el6         mratwork-ius-archive
php54-pgsql84.x86_64               5.4.45-1.ius.el6         mratwork-ius-archive
php54-pgsql84-debuginfo.x86_64     5.4.45-1.ius.el6         mratwork-ius-archive
php54-php.x86_64                   5.4.16-22.el6.centos.alt scl                 
php54-php-bcmath.x86_64            5.4.16-22.el6.centos.alt scl                 
php54-php-cli.x86_64               5.4.16-22.el6.centos.alt scl                 
php54-php-common.x86_64            5.4.16-22.el6.centos.alt scl                 
php54-php-dba.x86_64               5.4.16-22.el6.centos.alt scl                 
php54-php-devel.x86_64             5.4.16-22.el6.centos.alt scl                 
php54-php-enchant.x86_64           5.4.16-22.el6.centos.alt scl                 
php54-php-fpm.x86_64               5.4.16-22.el6.centos.alt scl                 
php54-php-gd.x86_64                5.4.16-22.el6.centos.alt scl                 
php54-php-imap.x86_64              5.4.16-22.el6.centos.alt scl                 
php54-php-intl.x86_64              5.4.16-22.el6.centos.alt scl                 
php54-php-ldap.x86_64              5.4.16-22.el6.centos.alt scl                 
php54-php-mbstring.x86_64          5.4.16-22.el6.centos.alt scl                 
php54-php-mysqlnd.x86_64           5.4.16-22.el6.centos.alt scl                 
php54-php-odbc.x86_64              5.4.16-22.el6.centos.alt scl                 
php54-php-pdo.x86_64               5.4.16-22.el6.centos.alt scl                 
php54-php-pear.noarch              1:1.9.4-10.el6.centos.alt
                                                            scl                 
php54-php-pecl-apc.x86_64          3.1.15-0.4.20130912.el6.centos.alt
                                                            scl                 
php54-php-pecl-apc-devel.x86_64    3.1.15-0.4.20130912.el6.centos.alt
                                                            scl                 
php54-php-pecl-memcache.x86_64     3.0.8-3.el6.centos.alt   scl                 
php54-php-pecl-zendopcache.x86_64  7.0.2-4.el6.centos.alt   scl                 
php54-php-pgsql.x86_64             5.4.16-22.el6.centos.alt scl                 
php54-php-process.x86_64           5.4.16-22.el6.centos.alt scl                 
php54-php-pspell.x86_64            5.4.16-22.el6.centos.alt scl                 
php54-php-recode.x86_64            5.4.16-22.el6.centos.alt scl                 
php54-php-snmp.x86_64              5.4.16-22.el6.centos.alt scl                 
php54-php-soap.x86_64              5.4.16-22.el6.centos.alt scl                 
php54-php-tidy.x86_64              5.4.16-22.el6.centos.alt scl                 
php54-php-xml.x86_64               5.4.16-22.el6.centos.alt scl                 
php54-php-xmlrpc.x86_64            5.4.16-22.el6.centos.alt scl                 
php54-process.x86_64               5.4.45-1.ius.el6         mratwork-ius-archive
php54-pspell.x86_64                5.4.45-1.ius.el6         mratwork-ius-archive
php54-recode.x86_64                5.4.45-1.ius.el6         mratwork-ius-archive
php54-runtime.x86_64               1.1-5.el6.centos.alt     scl                 
php54-scldevel.x86_64              1.1-5.el6.centos.alt     scl                 
php54-snmp.x86_64                  5.4.45-1.ius.el6         mratwork-ius-archive
php54-soap.x86_64                  5.4.45-1.ius.el6         mratwork-ius-archive
php54-suhosin.x86_64               0.9.38-1.ius.el6         mratwork-ius-archive
php54-suhosin-debuginfo.x86_64     0.9.38-1.ius.el6         mratwork-ius-archive
php54-tidy.x86_64                  5.4.45-1.ius.el6         mratwork-ius-archive
php54-xcache.x86_64                3.2.0-1.ius.el6          mratwork-ius-archive
php54-xcache-debuginfo.x86_64      3.2.0-1.ius.el6          mratwork-ius-archive
php54-xml.x86_64                   5.4.45-1.ius.el6         mratwork-ius-archive
php54-xmlrpc.x86_64                5.4.45-1.ius.el6         mratwork-ius-archive

Coba perhatikan ada php54-pecl-memcache dan php54-pecl-memcached. Silahkan pelajari beda keduanya.
 
mustafaramadhan said:
Ini hasil yum list:
Code: 
> yum list php54-*
Loaded plugins: fastestmirror, priorities, protectbase, replace
Loading mirror speeds from cached hostfile
* base: mirror.hostduplex.com
* extras: mirrors.syringanetworks.net
* mratwork-epel: linux.mirrors.es.net
* mratwork-ius-stable: mirror.symnds.com
* mratwork-webtatic: us-east.repo.webtatic.com
* updates: centos.sonn.com
0 packages excluded due to repository protections
Available Packages
php54.x86_64                       5.4.45-1.ius.el6         mratwork-ius-archive
php54-apc-panel.noarch             3.1.15-0.4.20130912.el6.centos.alt
                                                            scl               
php54-bcmath.x86_64                5.4.45-1.ius.el6         mratwork-ius-archive
php54-build.x86_64                 1.1-5.el6.centos.alt     scl               
php54-cli.x86_64                   5.4.45-1.ius.el6         mratwork-ius-archive
php54-common.x86_64                5.4.45-1.ius.el6         mratwork-ius-archive
php54-dba.x86_64                   5.4.45-1.ius.el6         mratwork-ius-archive
php54-debuginfo.x86_64             5.4.45-1.ius.el6         mratwork-ius-archive
php54-devel.x86_64                 5.4.45-1.ius.el6         mratwork-ius-archive
php54-embedded.x86_64              5.4.45-1.ius.el6         mratwork-ius-archive
php54-enchant.x86_64               5.4.45-1.ius.el6         mratwork-ius-archive
php54-fpm.x86_64                   5.4.45-1.ius.el6         mratwork-ius-archive
php54-gd.x86_64                    5.4.45-1.ius.el6         mratwork-ius-archive
php54-imap.x86_64                  5.4.45-1.ius.el6         mratwork-ius-archive
php54-interbase.x86_64             5.4.45-1.ius.el6         mratwork-ius-archive
php54-intl.x86_64                  5.4.45-1.ius.el6         mratwork-ius-archive
php54-ioncube-loader.x86_64        5.0.18-1.ius.el6         mratwork-ius-archive
php54-ioncube-loader-debuginfo.x86_64
                                   5.0.18-1.ius.el6         mratwork-ius-archive
php54-ldap.x86_64                  5.4.45-1.ius.el6         mratwork-ius-archive
php54-litespeed.x86_64             5.4.45-1.ius.el6         mratwork-ius-archive
php54-mbstring.x86_64              5.4.45-1.ius.el6         mratwork-ius-archive
php54-mcrypt.x86_64                5.4.45-1.ius.el6         mratwork-ius-archive
php54-mssql.x86_64                 5.4.45-1.ius.el6         mratwork-ius-archive
php54-mysql.x86_64                 5.4.45-1.ius.el6         mratwork-ius-archive
php54-mysqlnd.x86_64               5.4.45-1.ius.el6         mratwork-ius-archive
php54-odbc.x86_64                  5.4.45-1.ius.el6         mratwork-ius-archive
php54-pdo.x86_64                   5.4.45-1.ius.el6         mratwork-ius-archive
php54-pear.noarch                  1:1.9.5-2.ius.el6        mratwork-ius-archive
php54-pecl-apc.x86_64              3.1.14-1.ius.el6         mratwork-ius-archive
php54-pecl-apc-debuginfo.x86_64    3.1.14-1.ius.el6         mratwork-ius-archive
php54-pecl-geoip.x86_64            1.0.8-3.ius.el6          mratwork-ius-archive
php54-pecl-geoip-debuginfo.x86_64  1.0.8-3.ius.el6          mratwork-ius-archive
php54-pecl-imagick.x86_64          3.1.2-2.ius.el6          mratwork-ius-archive
php54-pecl-imagick-debuginfo.x86_64
                                   3.1.2-2.ius.el6          mratwork-ius-archive
php54-pecl-lzf.x86_64              1.6.3-1.ius.el6          mratwork-ius-archive
php54-pecl-lzf-debuginfo.x86_64    1.6.3-1.ius.el6          mratwork-ius-archive
php54-pecl-memcache.x86_64         3.0.8-1.ius.el6          mratwork-ius-archive
php54-pecl-memcache-debuginfo.x86_64
                                   3.0.8-1.ius.el6          mratwork-ius-archive
php54-pecl-memcached.x86_64        2.2.0-1.ius.el6          mratwork-ius-archive
php54-pecl-memcached-debuginfo.x86_64
                                   2.2.0-1.ius.el6          mratwork-ius-archive
php54-pecl-mongo.x86_64            1.6.11-1.ius.el6         mratwork-ius-archive
php54-pecl-mongo-debuginfo.x86_64  1.6.11-1.ius.el6         mratwork-ius-archive
php54-pecl-mysqlnd-ms.x86_64       1.5.2-1.ius.el6          mratwork-ius-archive
php54-pecl-mysqlnd-ms-debuginfo.x86_64
                                   1.5.2-1.ius.el6          mratwork-ius-archive
php54-pecl-mysqlnd-ms-devel.x86_64 1.5.2-1.ius.el6          mratwork-ius-archive
php54-pecl-redis.x86_64            2.2.7-1.ius.el6          mratwork-ius-archive
php54-pecl-redis-debuginfo.x86_64  2.2.7-1.ius.el6          mratwork-ius-archive
php54-pecl-xdebug.x86_64           2.3.3-1.ius.el6          mratwork-ius-archive
php54-pecl-xdebug-debuginfo.x86_64 2.3.3-1.ius.el6          mratwork-ius-archive
php54-pecl-zendopcache.x86_64      7.0.5-1.el6              mratwork-ius-archive
php54-pecl-zendopcache-debuginfo.x86_64
                                   7.0.5-1.el6              mratwork-ius-archive
php54-pgsql.x86_64                 5.4.45-1.ius.el6         mratwork-ius-archive
php54-pgsql84.x86_64               5.4.45-1.ius.el6         mratwork-ius-archive
php54-pgsql84-debuginfo.x86_64     5.4.45-1.ius.el6         mratwork-ius-archive
php54-php.x86_64                   5.4.16-22.el6.centos.alt scl               
php54-php-bcmath.x86_64            5.4.16-22.el6.centos.alt scl               
php54-php-cli.x86_64               5.4.16-22.el6.centos.alt scl               
php54-php-common.x86_64            5.4.16-22.el6.centos.alt scl               
php54-php-dba.x86_64               5.4.16-22.el6.centos.alt scl               
php54-php-devel.x86_64             5.4.16-22.el6.centos.alt scl               
php54-php-enchant.x86_64           5.4.16-22.el6.centos.alt scl               
php54-php-fpm.x86_64               5.4.16-22.el6.centos.alt scl               
php54-php-gd.x86_64                5.4.16-22.el6.centos.alt scl               
php54-php-imap.x86_64              5.4.16-22.el6.centos.alt scl               
php54-php-intl.x86_64              5.4.16-22.el6.centos.alt scl               
php54-php-ldap.x86_64              5.4.16-22.el6.centos.alt scl               
php54-php-mbstring.x86_64          5.4.16-22.el6.centos.alt scl               
php54-php-mysqlnd.x86_64           5.4.16-22.el6.centos.alt scl               
php54-php-odbc.x86_64              5.4.16-22.el6.centos.alt scl               
php54-php-pdo.x86_64               5.4.16-22.el6.centos.alt scl               
php54-php-pear.noarch              1:1.9.4-10.el6.centos.alt
                                                            scl               
php54-php-pecl-apc.x86_64          3.1.15-0.4.20130912.el6.centos.alt
                                                            scl               
php54-php-pecl-apc-devel.x86_64    3.1.15-0.4.20130912.el6.centos.alt
                                                            scl               
php54-php-pecl-memcache.x86_64     3.0.8-3.el6.centos.alt   scl               
php54-php-pecl-zendopcache.x86_64  7.0.2-4.el6.centos.alt   scl               
php54-php-pgsql.x86_64             5.4.16-22.el6.centos.alt scl               
php54-php-process.x86_64           5.4.16-22.el6.centos.alt scl               
php54-php-pspell.x86_64            5.4.16-22.el6.centos.alt scl               
php54-php-recode.x86_64            5.4.16-22.el6.centos.alt scl               
php54-php-snmp.x86_64              5.4.16-22.el6.centos.alt scl               
php54-php-soap.x86_64              5.4.16-22.el6.centos.alt scl               
php54-php-tidy.x86_64              5.4.16-22.el6.centos.alt scl               
php54-php-xml.x86_64               5.4.16-22.el6.centos.alt scl               
php54-php-xmlrpc.x86_64            5.4.16-22.el6.centos.alt scl               
php54-process.x86_64               5.4.45-1.ius.el6         mratwork-ius-archive
php54-pspell.x86_64                5.4.45-1.ius.el6         mratwork-ius-archive
php54-recode.x86_64                5.4.45-1.ius.el6         mratwork-ius-archive
php54-runtime.x86_64               1.1-5.el6.centos.alt     scl               
php54-scldevel.x86_64              1.1-5.el6.centos.alt     scl               
php54-snmp.x86_64                  5.4.45-1.ius.el6         mratwork-ius-archive
php54-soap.x86_64                  5.4.45-1.ius.el6         mratwork-ius-archive
php54-suhosin.x86_64               0.9.38-1.ius.el6         mratwork-ius-archive
php54-suhosin-debuginfo.x86_64     0.9.38-1.ius.el6         mratwork-ius-archive
php54-tidy.x86_64                  5.4.45-1.ius.el6         mratwork-ius-archive
php54-xcache.x86_64                3.2.0-1.ius.el6          mratwork-ius-archive
php54-xcache-debuginfo.x86_64      3.2.0-1.ius.el6          mratwork-ius-archive
php54-xml.x86_64                   5.4.45-1.ius.el6         mratwork-ius-archive
php54-xmlrpc.x86_64                5.4.45-1.ius.el6         mratwork-ius-archive

Coba perhatikan ada php54-pecl-memcache dan php54-pecl-memcached. Silahkan pelajari beda keduanya.
Click to expand...

Om Mustafa bingung yaaaaa :D
memcache dan memcached itu sama aja Om.

MemcacheD (pakai D) adalah versi advanced-nya dari Memcache (tanpa D).

MemcacheD bisa dicluster. Sedangkan Memcache tidak.

Basic code nya dan fungsinya sama saja.
 
Nina Prasetyo said:
Om Mustafa bingung yaaaaa :D
memcache dan memcached itu sama aja Om.

MemcacheD (pakai D) adalah versi advanced-nya dari Memcache (tanpa D).

MemcacheD bisa dicluster. Sedangkan Memcache tidak.

Basic code nya dan fungsinya sama saja.
Click to expand...
Ya tidak bingung. Saya sih selalu pakai memcached.
 
Nina Prasetyo said:
itu reddit trouble krn pake memcache cluster, lalu salahsatu server memcachenya down.

jadi, kl ga pake cluster, ya jgn khawatir :D

Mau tau ga, knp itu salahsatu memcachenya reddit down ?

Karena reddit pake Amazon AWS, dan node yg dipakai oleh memcache server itu down. Hehe, jadi ga jaminan cloud itu bebas down :D

colek om @dondyb
Click to expand...

Uhuk.. ada apa ini gw dicolek :D
 
Status
Not open for further replies.
Back
Top