June 18, 2013

Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80

… provide help. To get started, here is what you need (prices in AU$): The Raspberry Pi itself (about $36) Make sure… Pi got (likely the first available address in your DHCP range), you can always check your router’s DHCP table which…

Comment: What CPU Architecture do you prefer for running MySQL In production

… 5×20 type CPUs, i.e. low end of the mid-range CPUs, usually the slowest/lowest we can get hyperthreading with… waiting for 8-10 core CPUs to come down in price. New R420s with 24 HT cores, 128-256GB of RAM…

Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark

….76 75 GB109457295.24 So gain is in 5-7x range, which is quite decent. One thing to pay attention is… not significant. Conclusion In conclusion I see that for its price (around $2000 on date of publishing) Intel SSD 910 handles…

Comment: Intel 320 SSD read performance

…, but you should consider price also. For many users $10K+ for PCI-E cards is out of budget range, while 300-500…

Post: Product to try: MySQL/MariaDB-Galera 0.8

… latency of round-trip transactions should be in an acceptable range. It opens the possibility for active master – active master setups… be affected (and not towards better side). But this is price to pay for synchronous not-getting-behind slaves. With additional…

Comment: Percona Server scalability on multi-cores server

… each (~300$/dimm) will give you 15000$. So price should be in X0.000 range where 2 <= X <= 9 . I do not…

Comment: Should I buy a Fast SSD or more memory?

… around a 16G box on Fusion IO, and for the price of one Fusion IO card, I can buy a lot… before I considered upgrading the storage system. Even a mid range 2U dell server will take > 128G of memory these days…

Post: FusionIO 320GB MLC benchmarks

… of two cards. This card is also not cheap, the price I can find on dell.com is $6,829.99… are impressive, very often it is < 1ms (in hundreds microseconds range) Sequential writes still behave strange, dropping throughput with increased concurrency…