It would be great to see a native PgSQL interface. Especially in the grid services.<br><br><br><div class="gmail_quote">On Tue, Nov 24, 2009 at 12:36 PM, J Ross Nicoll <span dir="ltr"><<a href="mailto:jrn2005@cs.st-andrews.ac.uk">jrn2005@cs.st-andrews.ac.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Two virtual machines is not what we mean by scalable. Would any of the<br>
handy Lindens like to give me a ballpark figure for the number of<br>
servers in the asset cluster? I'd guess in the hundreds...<br>
<br>
In terms of speed, no experience with MS SQL, but moving from MySQL<br>
(MyISAM) to Oracle on Linux (OpenSUSE) and Solaris doubled our<br>
performance...<br>
<div class="im"><br>
Impalah Shenzhou wrote:<br>
> I completelly disagree with:<br>
><br>
> "MySQL is notoriously not scalable and a load monster"<br>
><br>
> Then MSSql is not scalable and a superload monster... and Oracle, even<br>
> worse...<br>
><br>
><br>
> Which O.S.? Which MySQL configuration? Which hardware configuration?<br>
><br>
> Personally I have 2 ubuntu server, each one with one mysql instance<br>
> (complete server) working in master-slave... and all of this running<br>
> over virtual box (installed on windows XP) in the same machine, a 1.75<br>
> GHz dual core with 4 Gb of RAM... and it works smoothly.<br>
><br>
><br>
><br>
><br>
><br>
> 2009/11/24 Marc Adored <<a href="mailto:marc@inworlddesigns.com">marc@inworlddesigns.com</a><br>
</div>> <mailto:<a href="mailto:marc@inworlddesigns.com">marc@inworlddesigns.com</a>>><br>
<div><div></div><div class="h5">><br>
> I suggest a centralized system thats decentralized :P kind of like a<br>
> cloud computing setup. It all seems centralized to the naked eye but a<br>
> lot of decentralized things go on. This can be done 2 ways as I see<br>
> it. Both ways require OpenSim to allow multiple authentication<br>
> servers. 1 way which would work for not breaking compatibility with<br>
> current viewers would be to have a central domain they connect to that<br>
> is adjusted to different authentication servers based on load. Like a<br>
> round robin setup but controlled by OpenSim. This like I said is best<br>
> for not breaking current viewers but requires some type of interaction<br>
> with a dns server. The second would be to modify the viewers to simply<br>
> query the routing server which would tell the viewer which<br>
> authentication server would be best to use at that moment. This would<br>
> also work pretty well with the asset servers too but I believe this<br>
> topic is about authentication methods.<br>
><br>
> OpenID I don't have an opinion on it because it doesn't really benefit<br>
> the project load and scalability wise because it would still need to<br>
> be matched to an existing account on the grid. If anything it adds<br>
> another step to the authentication process which can create more load.<br>
><br>
> My knowledge in cloud computing is rather new so maybe some of this<br>
> doesn't make sense but hopefully you guys will get what i am saying. A<br>
> lot of scalability can be added by using a database system that scales<br>
> well. MySQL is notoriously not scalable and a load monster. I know<br>
> that there is already some stuff in there for different database<br>
> systems so this might be already on its way.<br>
><br>
><br>
><br>
> On Tue, Nov 24, 2009 at 9:59 AM, Impalah Shenzhou <<a href="mailto:impalah@gmail.com">impalah@gmail.com</a><br>
</div></div><div><div></div><div class="h5">> <mailto:<a href="mailto:impalah@gmail.com">impalah@gmail.com</a>>> wrote:<br>
> > Ok, maybe it's a misunderstood. I will try to explain what I<br>
> wanted to know:<br>
> ><br>
> > Imagine 100000 region servers pretending to be a grid.<br>
> ><br>
> > What I understood from Morgaine comment:<br>
> ><br>
> > Opensim needs decentralized / distributed mechanisms for<br>
> > identity,<br>
> ><br>
> > was<br>
> ><br>
> > "I have entered that grid, my authentication was managed by one<br>
> region<br>
> > server. When I try to jump to another region in the same grid I<br>
> have to<br>
> > authenticate again in the region server and that region server<br>
> must contain<br>
> > my data to authenticate me again".<br>
> ><br>
> > Nowadays is like: Enter in a grid, being authenticated by a<br>
> common user<br>
> > server, when I want to jump to another region in the grid, I<br>
> don't need to<br>
> > authenticate me again.<br>
> ><br>
> > What I understand with "descentralized" is: each opensim servers<br>
> has the<br>
> > mechanisms to authenticate an user even when it is part of a grid.<br>
> ><br>
> > And that is what I don't understand: why? why not to surrogate the<br>
> > authentications to specialized and centralized servers.<br>
> ><br>
> > And that was the reason for my question about OpenID, maybe this<br>
> is a system<br>
> > considered "decentralized".<br>
> ><br>
> ><br>
> > Anyway I can't see anything bad on centralized servers. If anyone<br>
> wants to<br>
> > enter in my server he/she have to follow my rules; if I have 1000<br>
> servers, I<br>
> > provide you with a common auth mechanism for accessing all of them.<br>
> ><br>
> > Or maybe I am completelly wrong.<br>
> ><br>
> ><br>
> > Greetings<br>
> ><br>
> ><br>
> ><br>
> ><br>
> ><br>
> > 2009/11/24 Robert A. Knop Jr. <<a href="mailto:rknop@pobox.com">rknop@pobox.com</a><br>
</div></div>> <mailto:<a href="mailto:rknop@pobox.com">rknop@pobox.com</a>>><br>
<div class="im">> >><br>
> >> I don't know that this really *is* offtopic, unless it's already a<br>
> >> settled issue amongs the OpenSim devs.<br>
> >><br>
> >> On Tue, Nov 24, 2009 at 02:19:20PM +0100, Impalah Shenzhou wrote:<br>
> >> > I could trust in you, but you need to tell me "you are really<br>
> you" with<br>
> >> > a<br>
> >> > local login (i.e. email headers can be altered to impersonate<br>
> as another<br>
> >> > person) or someone I trust should tell it to me (i.e. OpenID).<br>
> >><br>
> >> Do you have any personal web pages anywhere? Do you run any CGI<br>
> or any<br>
> >> PHP there? Do you identify everybody who comes there? That's the<br>
> >> analogy we should think about. Yes, we need a secure<br>
> infrastructure so<br>
> >> that only the small number of people you *really* trust can do scary<br>
> >> things. But at the level of running regions -- well, you may be<br>
> using a<br>
> >> hosting provider, or you may be hosting yourself, but you don't need<br>
> >> full and complete trust that everybody is who they claim to be<br>
> just to<br>
> >> connect to the world.<br>
> >><br>
> >> --<br>
> >> --Rob Knop<br>
</div>> >> E-mail: <a href="mailto:rknop@pobox.com">rknop@pobox.com</a> <mailto:<a href="mailto:rknop@pobox.com">rknop@pobox.com</a>><br>
<div class="im">> >> Home Page: <a href="http://www.pobox.com/%7Erknop/" target="_blank">http://www.pobox.com/~rknop/</a><br>
</div>> <<a href="http://www.pobox.com/%7Erknop/" target="_blank">http://www.pobox.com/%7Erknop/</a>><br>
<div class="im">> >> Blog: <a href="http://www.sonic.net/%7Erknop/blog/" target="_blank">http://www.sonic.net/~rknop/blog/</a><br>
</div>> <<a href="http://www.sonic.net/%7Erknop/blog/" target="_blank">http://www.sonic.net/%7Erknop/blog/</a>><br>
<div class="im">> >><br>
> >> -----BEGIN PGP SIGNATURE-----<br>
> >> Version: GnuPG v1.4.9 (GNU/Linux)<br>
> >><br>
> >> iD8DBQFLC+pcfEn1oMJSrdsRApVqAKCGz8o5gt7vEqvl3HJK07jftpLi5wCg56g+<br>
> >> oq1mcfGvljoH5K0Y6X/WX9M=<br>
> >> =bh/M<br>
> >> -----END PGP SIGNATURE-----<br>
> >><br>
> >> _______________________________________________<br>
> >> Opensim-dev mailing list<br>
</div>> >> <a href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a> <mailto:<a href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a>><br>
<div class="im">> >> <a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br>
> >><br>
> ><br>
> ><br>
> > _______________________________________________<br>
> > Opensim-dev mailing list<br>
</div>> > <a href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a> <mailto:<a href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a>><br>
<div class="im">> > <a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br>
> ><br>
> ><br>
> _______________________________________________<br>
> Opensim-dev mailing list<br>
</div>> <a href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a> <mailto:<a href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a>><br>
<div><div></div><div class="h5">> <a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br>
><br>
><br>
<br>
_______________________________________________<br>
Opensim-dev mailing list<br>
<a href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br>
</div></div></blockquote></div><br>