DB:
- DB selection matrix
- Mysql benchmark
- Nosql sols benchmark It seems like Mongo is shaking whenever the throughputs reach around 1k/sec. Plus, Mysql’s seems pretty decent.
- Simple mysql installation/conf on ubuntu #1
- Simple mysql installation/conf on ubuntu #2
- Install benchmarking tool: dbt2
- Install dev tools
sudo apt-get install automake autoconf - Install PHPMyAdmin
sudo ln -s /usr/share/phpmyadmin /var/www/html/How to save ur day if you (or sbelse) accidentally change root’s pwd (and u realy want it back)?
Follow this first, for every ‘permission-demied’ issues, try chown (to mysql:mysql) & sudo
Test urself through dbt2
Benchmark result#1
Benchmark result#2 (through sysbench)
Seems pretty decent so far.
- Corresponding mannual
Origin of Sysbench’s OLTP benchmark toolkit & details