blender gameengine mysql interface for render farm visualization

Hello and happy new year 2010!
With a new year comes new ideas, and one of those (actually since a long time in my mind) was to develop a fun visualization of the render farm datas like rendernode status etc.
Unfortunately i never had time to dig into python and the gameengine. But christmas holiday brings its amount of free days to study new things.
first of all here is a quick video showing it at work:

you can see a bit how it works. In fact it is quiet simple the script is linked to an “always” actuator with a pulse mode of 20 so it updates about every second.
using the MySQLdb python module it creates a connection to the renderfarm database where it gets a list of clients and there actual status (which can be idle, disabled or rendering) then it tries to see if an object with the name of the renderclient exists in the gamengine scene. If an object exists then the script assigns the status of the client to the corresponding object property called “status” (line ob[‘status’]=row[2]) .

the second part of the script (brenderdb.execute (“select round(sum(end-current)/sum(end-start)*100) as frames from jobs where status=’rendering’ or status=’waiting’ or status=’pause’;”) tries to find out how many renders there are still left to render and assigns that value to an object’s property.

Then the rest is just Game Engine logic bricks, although more powerfull (and only limited by imagination) could be done in scripting. Each fireball has 3 actions that are played when the value of “status” changes to the corresponding action (idle, rendering and disabled)

Now I will try to see what if i could adapt this to 2.5 and the NetRender…maybe during the next holidays 🙂

Feel free to ask for questions here or by email (oenvoyageATgmaaaiil.com)

Advertisements

6 Responses to “blender gameengine mysql interface for render farm visualization”


  1. 1 Blenderman January 13, 2010 at 11:54 pm

    hmm this is very interesting thanks for the post.

  2. 2 Richard January 24, 2010 at 4:08 pm

    Could you build a beach scene like the one in Madagascar?

  3. 3 Anomonus June 1, 2010 at 1:29 pm

    what render farm software are you using

    • 4 oenvoyage June 10, 2010 at 11:00 am

      i use an inhouse software called brender, i am working on a version 2.0 adapted for blender 2.5.
      I will release the sources when it is a bit more ready to be used by others.

  4. 5 davidgreen August 24, 2010 at 10:45 am

    I am a new bie in this field. I am trying to setup my own render farm at home using a couple of old Pc’s. I googled out for good render farm sites. This is a pretty good site. Can you guys help me out with some more sites? Any help will be appreciated

  5. 6 felix November 19, 2011 at 12:48 am

    How to install Mysqldb in Blender 2.5x? in windows? or linux(ubuntu). i install with nautilus and it is ok in python console. but in blender console not present because blender console is python 3.2.2 and python ubuntu console is 2.7.2. how to import mysqldb man????


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




Categories

Flickr Photos

Darth Vader menacing Imperial Officer - Lego

Maranola, Cinque Terre, Italy

Kids at sunset in Cinque Terre, Italy

More Photos

@oenvoyage latest Twitter


%d bloggers like this: