OpenVZ Cheatsheet

:: VPS Creation Walkthrough ::

Create VPS from template:
vzctl create id --ostemplate osname

Set VPS to boot on host startup:
vzctl set id --onboot yes --save

Start VPS for further configuration:
vzctl start id

Set VPS hostname:
vzctl set id --hostname --save
Read the rest of this entry »

Disable Menu Remote Mysql di cPanel

Umumnya ketika koneksi remote mysql dinonaktifkan, di cpanel masih muncul menu remote mysql. Untuk mendisable menu Remote MySQL, asumsi menggunakan theme paper_lantern, silakan edit file /usr/local/cpanel/base/frontend/paper_lantern/dynamicui/dynamicui_hide_icon.conf
tambahkan item

MySQL Tuning and Optimization

MySQL is a powerful open-source database. With more and more database driven applications, people have been pushing MySQL to its limits. Here are some tips for tuning and optimizing your MySQL install. Some tips are specific to the environment they are installed on, but the concepts are universal.

MySQL Server Hardware and OS Tuning:
1. Have enough physical memory to load your entire InnoDB file into memory – InnoDB is much faster when the file can be accessed in memory rather than from disk.
2. Avoid Swap at all costs – swapping is reading from disk, its slow.
3. Use Battery-Backed RAM.
4. Use an advanced RAID – preferably RAID10 or higher. Read the rest of this entry »