Tutorial Ngoprek

[MY_SQL]
DRIVER = /usr/lib/libmyodbc5.so
SERVER = 10.15.5.71
UID = username
PWD = password
DATABASE = my_database
PORT = 3306

HS_FDS_CONNECT_INFO = MY_SQL
HS_FDS_TRACE_LEVEL = OFF
HS_FDS_SHAREABLE_NAME = /usr/lib/libmyodbc5.so

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = MYSQL_DB)
      (ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
      (PROGRAM = hsodbc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

MYSQL_DB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SID = MYSQL_DB)
    )
    (HS = OK)
  )

lsnrctl reload

sqlplus / as sysdba
create database link mysql connect to "username" identified by "password" using 'MYSQL_DB';
select * from m_kota@mysql

1. Unduh installer MySQL Cluster dari mysql.com. Pilih Linux-Generic, sesuaikan arsitekturnya dengan distro Linux yang digunakan.
2. Ekstrak tarball berisi installer biner MySQL Cluster.

tar -xzvf mysql-cluster-gpl-7.2.4-linux2.6-x86_64.tar.gz
mv mysql-cluster-gpl-7.2.4-linux2.6-x86_64 mysqlc

3. Buat direktori untuk menampung data dan konfigurasi MySQL Cluster.

mkdir -p my_cluster/{conf,mysqld_data,ndb_data}

4. Buat konfigurasi untuk mysql.

vim my_cluster/conf/my.cnf

Salin tempel pengaturan berikut ke berkas tersebut.

[mysqld]
ndbcluster
datadir=~/my_cluster/mysqld_data
basedir=~/mysqlc
port=5000

5. Buat konfigurasi untuk cluster yang akan dijalankan. Di contoh ini kita akan menjalankan dua node.

   vim my_cluster/conf/config.ini

   Contoh konfigurasi paling sederhana untuk satu server MySQL (mysqld), dua node data (ndbd), dan satu node manajemen (ndb_mgmd).

   [ndb_mgmd]
   hostname=localhost
   datadir=~/mysql_cluster/ndb_data
   NodeId=1
   
   [ndbd default]
   noofreplicas=2
   datadir=~/mysql_cluster/ndb_data
   
   [ndbd]
   hostname=localhost
   NodeId=3
   
   [ndbd]
   hostname=localhost
   NodeId=4
   
   [mysqld]
   NodeId=50

6. Jalankan skrip mysql_install_db untuk mempopulasikan basis data yang dibutuhkan MySQL.

./mysqlc/scripts/mysql_install_db --no-defaults --datadir=~/mysql_cluster/mysqld_data/

7. Jalankan node manajemen, lalu node data secara berurutan.

./mysqlc/bin/ndb_mgmd -f ~/mysql_cluster/conf/config.ini --initial --configdir=~/mysql_cluster/conf
./mysqlc/bin/ndbd -c localhost:1186
./mysqlc/bin/ndbd -c localhost:1186

Hasilnya tampak seperti pada screen shot berikut.

8. Cek status node data.

./mysqlc/bin/ndb_mgm -e show

Pastikan proses start up node-node ini sudah selesai.

9. Jalankan server MySQL (mysqld).

./mysqlc/bin/mysqld --defaults-file=~mysql_cluster/conf/my.cnf

10. Login ke server MySQL dan cobalah untuk mebuat basis data dan tabel menggunakan storage engine ndb.

./mysqlc/bin/mysql -h 127.0.0.1 -P 5000 -u root
create database coba_cluster;
use coba_cluster;
create table coba(id int not null primary key) engine=ndb;
insert into coba values (1), (2), (3), (4), (5);
select * from coba

wget http://prdownloads.sourceforge.net/saprfc/saprfc-1.4.1.tar.gz
tar -xzvf saprfc-1.4.1.tar.gz

cd saprc-1.4.1
/opt/bin/phpize

export CC=gcc34
export CFLAGS=-I/usr/lib/i386-redhat-linux4E/include:-B/usr/lib/i386-redhat-linux4E/lib/

./configure --with-php-config=/opt/bin/php-config

make

make test

make install

wget http://id.php.net/distributions/php-5.4.0.tar.bz2

tar -xjf php-5.4.0.tar.bz2

yum install httpd-devel

 cd php-5.4.0
./configure --prefix=/opt --with-apxs2=/usr/sbin/apxs

make

make test

su
make install

mkdir public_html
echo <? infophp() ?> > index.php

/opt/bin/php -S 10.15.5.241:8080

su
service vboxdrv start

service vboxdrv setup

Network controller: Broadcom Corporation BCM43228 802.11a/b/g/n

3.2.0-1-amd64

su
aptitude purge broadcom-sta-common broadcom-sta-modules-3.1.0-1-amd64 broadcom-sta-source

aptitude install broadcom-sta-dkms

aptitude install linux-headers-3.2.0-1-amd64

dd if=/dev/sda1 of=/media/data/image4recovery.img

sudo aptitude install scalpel

sudo nano /etc/scalpel/scalpel.conf

mkdir output
scalpel -o output image4recovery.img

yum install cinnamon

rpm -ivh muffin-1.0.1-1.fc16.x86_64.rpm

rpm -ivh cinnamon-1.3.1-1.fc16.x86_64.rpm

cinnamon --replace