MySQLIntegra: dbfiller & wiki

Posted by Ktoso on 10/02/2010 – 00:06

I passed all my exams at my first attempt and should have now some time to relax, right? Well something like that, I’m actually doing quite a lot these days. We’re on the roll with MySQL Integra.

Our server “Kopiec” is somewhat online (running CentOS off course) – we’re able to start/stop if thanks to a tool that’s called “remote insight”, and I’ve put 3 databases on there. MariaDB, InfiniDB and a clean MySQL instalation. We’re somewhat having problems with TokuDB, but that’s going to be our 4th database of interest. If you want to keep track of our test’s you can take a look at: http://mysqlintegra.project13.pl/.

The first step in getting things tested is filling those db’s with some data, and I mean a LOT of data. So we hacked up a more or less quick and dirty python script called dbfiller (source code avaiable on github) that would simulate a very simple table generation scheme (people working on shifts and checking in when they’re finished or start some activity). If you’re interested, our task is specyfied in the /doc/Opis.pdf file (sorry, only in polish). After a few days it’s up and running and we’re moving on to filling up those databases with some gigabytes of data.

Next we’re going to write some SQL Views/Procedures and then we’ll use Apache JMeter to run some performance benchmarks of some interesting data storage engines.

PS: If you’re wondering about my GWT-Crossword project – yeah, it’s still actual, and I’ll get right on it when done with some of the stuff here.
PPS: Yes, an Linux powered phone AT LAST in my hands! The HTC HERO is comming to me really soon – never again shall I use a ShitOS like WindowsMobile 6.5.

Tags: , , , , , , , , , , , , , ,

This post is under “coding, null” and has no respond so far.

Post a reply