Optimize Mysql Server

Nina Prasetyo · 28 Jan 2016

mustafaramadhan said:
Ini sedang bahas memcache atau memcached?. Itu kan module yang berbeda di php.

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]

mustafaramadhan · 28 Jan 2016

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

Php punya module memcache dan memcached. Ini 2 module berbeda.

Nina Prasetyo · 28 Jan 2016

mustafaramadhan said:
Php punya module memcache dan memcached. Ini 2 module berbeda.

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

pedagang · 28 Jan 2016

gelar tikar lagi,

Bu Nina ngasih kuliah umum

mustafaramadhan · 28 Jan 2016

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.

Nina Prasetyo · 28 Jan 2016

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.

Om Mustafa bingung yaaaaa

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.

mustafaramadhan · 28 Jan 2016

Nina Prasetyo said:
Om Mustafa bingung yaaaaa
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.

Ya tidak bingung. Saya sih selalu pakai memcached.

pangeran1995 · 28 Jan 2016

saya nyimak dulu ya

makasih banyak ilmu dan diskusinya
jadi banyak belajar atas diskusi ini

arissety · 29 Jan 2016

mustafaramadhan said:
Ya tidak bingung. Saya sih selalu pakai memcached.

Betul memang ada 2 cliet library utk memcache server di PHP.

http://php.net/manual/en/book.memcache.php
http://php.net/manual/en/book.memcached.php

Dan php-memcached, lbh banyak fitur nya.
Di php-memcache, sy g nemuin cara seting HASH nya, yg libketama.

dondyb · 1 Feb 2016

Nina Prasetyo said:
itu reddit trouble krn pake memcache cluster, lalu salahsatu server memcachenya down.

jadi, kl ga pake cluster, ya jgn khawatir

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

colek om @dondyb

Uhuk.. ada apa ini gw dicolek

Optimize Mysql Server

Nina Prasetyo

Expert 2.0

mustafaramadhan

Hosting Guru

Nina Prasetyo

Expert 2.0

pedagang

Hosting Guru

mustafaramadhan

Hosting Guru

Nina Prasetyo

Expert 2.0

mustafaramadhan

Hosting Guru

pangeran1995

Hosting Guru

arissety

Apprentice 1.0

dondyb

Poster 2.0