Mysql on Host and real-time update

Hy Nathan, thank you for this plugin.

We are going to use your plugin in or Workshop, connecting 4 different clusters (design groups).

As far as we are not really good in databases, I want to ask you for a good advice.

We need to establish a server and it looks better to make it on host in the internet.

But can Slingshot connect to hosted server, and i wonder if it will be as quick as a local server (anyway via wi-fi )

Second question is abour speed of update. we are dreaming to make a real-time data flow. But As i see in your tutorials, even update of a hundred of points is quite long process (abour 5 seconds) well, 5 seconds is ok, maybe. But can you advice how to deal with databases through grasshopper in a most rapid way?

For example. is it better to make 4 different flows through one database wih 4 tables, or for databases, or one table?

Replies to This Discussion

Permalink Reply by Nathan Miller on July 26, 2011 at 9:41am

Hello Philipp,

Thank you for your interest in Slingshot!

First... your set-up/speed question:

The configuration I have been running the tutorials on is not an ideal set-up from a performance standpoint. I am basically setting up a connection via an okay wi-fi connection on a network at home. The computer hosting MySQL is an older computer also. So my performance is probably taking a hit. If you have a nicer wi-fi network and server for your workshop (likely) you will have better performance.

Second your remote access question:

When you install MySQL, you can specify if you want to allow remote access to your server... I do this right off the bat. You can also configure it after install... a quick Google for "MySQL remote access" will give you plenty of resources. I have been doing root access, but you can also start setting up permissions for different users. http://dev.mysql.com/doc/refman/5.1/en/adding-users.html

Third, your workflow question:

Without knowing what kind of design problem you are attempting it is hard to say what would be most appropriate. I would imagine you would want to have 4 groups working on different tables in one database... especially if you want to the other groups to be able to query information from the other groups and relate it to their own tables.

Are the different groups working on different parts of the same design? or different designs?

I hope this is helpful...

-Nate

Permalink Reply by Philipp on July 26, 2011 at 3:04pm

Thank you Natan!

Well, yess, as we decided, there are interactive group, lanscape urbanism group, object (architecture) group and skin/favrication group, and the idea is that we are working on the same place and each group`s resulting algorithm depends on feeds from all other groups. So we`ll connect 4 definitions to each other through database. Moreover, ve are going to understand different feeds, number and type of feeds only there, on the workshop.

Permalink Reply by Nathan Miller on July 26, 2011 at 7:46pm

Excellent. Sounds like a fun activity! Let me know how everything works under that scenario and if there is any feedback from your group. I have tested a few scenarios which allow for separated definitions to be linked together via a DB system. It works quite well.

If you need any more guidance or thoughts on set-up, let me know!

-Nate

Permalink Reply by Philipp on July 27, 2011 at 3:50pm

Natan, thank you for you help.

Dont you have in plans to add MongoDb support?

in you plugin. Our DB advicer said it is pretty faster and simpler than mySQL

Permalink Reply by Nathan Miller on July 27, 2011 at 4:52pm

I might be looking at some 'NoSQL' DBs (like Mongo) for future plug-ins. But for right now the plug-in is geared towards RDBMS.

The challenges with NoSQL tools, like Mongo, are that they are still very young, specific to certain needs, and not nearly as broadly supported.

RDBMS, on the other hand, are everywhere and the systems are well battle tested.

Have a look at the following...

http://www.techrepublic.com/blog/10things/10-things-you-should-know...

Best,

-Nathan

Permalink Reply by Philipp on July 29, 2011 at 3:32pm

Hi Nathan I am trying to connect to Mysql on host and have few problems. I have this problem message every time I connect MyCstring to MyDBlist components. What that means?

Permalink Reply by Nathan Miller on July 29, 2011 at 4:16pm

The error refers to the version of the .NET connector for MySQL. The plug-in calls for version 6.3.6. check that you have this version installed. This thread contains more info and a download link....

http://www.grasshopper3d.com/group/slingshot/forum/topics/installation

Permalink Reply by Philipp on July 30, 2011 at 6:03am

Ok thank you!

I instelled this connecter and ewerithing looks cool exept that I cannot connect tp hosted db.

Is there any possibility to understant what is going wrong?

mean maybe I use wrong password or nickname, donnow

Can you sometime make a tutorial to connect to hosted server?

Permalink Reply by Philipp on July 30, 2011 at 7:45am

the resulit is null...,

Permalink Reply by Nathan Miller on July 30, 2011 at 8:34am

Philipp,

The image shows that you have not supplied a user ID or password. Did you specify a 'root' password when you installed the MySQL server?

The component is set to a default UID=root; Password=password

If you changed the root access password or have it set up additional user ids, then those should work. As of right now the component is giving you an error because you are supplying blank information which makes it so the connection string isn't formatted properly.

I assume you set-up the MySQL server to allow remote access? This is something you specify at installation. I will try to post a set-up and installation video this weekend.

Permalink Reply by Philipp on July 30, 2011 at 9:17am

heh, Natan, there is a UD and a pass, I just was afraid to post all this stuff in public. I`l send you the file - I just cannot understand whatever there is a problem on server-login side or on grasshopper side...

Permalink Reply by Nathan Miller on July 30, 2011 at 11:50am

I suspect it is something on the mysql side and remote access...

one test you can try....

do you have Rhino and GH installed on the remote machine that is hosting the server? If so, you can try logging in to mysql using 'localhost' instead of the IP. If it works locally, that might tell you that remote access is disabled. In that case, you may need to do some additional config.