Froscon Day 1

Filed under
OSS

This year I decided to go to Froscon. And I must admit that I like it very much. The differences with for example Fosdem are huge. The developer tracks are really of the level of Getting Things Done instead of talking about it. Also the location is quite ok. The rooms are tidy, I can sit perfectly (something I can't say about Fosdem), the heat in the rooms is bearable and also the acoustic is very good. Most tracks are in German, but some are in English. Just the right ones.

The rest of this blog is about the presentations I saw, so if you don't need those details, skip the rest Wink. The first presentation I saw was about the Spider engine for MySQL. Most of you know MyISAM and InnoDB. Spider is another one. This one makes it possible to store tables on different servers. The spider enabled server forwards the request to the remote server and passes it back to the requester. Not so useful you might think. Well, it also has the ability to forward sections of a table to different servers. Say you have 2000 records, you can store id 0-1000 on one server and 1000-2000 on another one. When a client requests id 1500, it will be passed on to the right server. As that server only holds 1000 records, the record is easily found and returned. For the client this whole process is transparent. You can imagine that searching for a keyword on two servers with half the records in parallel is much faster than searching it in one server which holds all records.

rest here