[MonetDB-users] Use cases for seperate servers vs single database
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Hi, What is the developer perspective of running a single database with a single mapi interface but different users (and rights) versus multiple databases having each one user. Is there a good reason not to merge databases? I understand that each MonetDB instance thinks it can access all the memory on the system available, that would indicate it might be better to run a single server. Could someone elaborate on the above? Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEAREKAAYFAkrQsBgACgkQYH1+F2Rqwn3olACffKnjqdhef+fXkmKwmdOLvJkK ltgAnAw/MIIBHfXokLAbV3sA9RMUG/Hw =2fGw -----END PGP SIGNATURE-----
On 10 okt 2009, at 18:02, Stefan de Konink
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512
Hi,
What is the developer perspective of running a single database with a single mapi interface but different users (and rights) versus multiple databases having each one user. it all depends on the application,hardware,expertise,politics.
Is there a good reason not to merge databases? yes/no depends understand that each MonetDB instance thinks it can access all the memory on the system available, that would indicate it might be better to run a single server.
Could someone elaborate on the above?
martin
Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEAREKAAYFAkrQsBgACgkQYH1+F2Rqwn3olACffKnjqdhef+fXkmKwmdOLvJkK ltgAnAw/MIIBHfXokLAbV3sA9RMUG/Hw =2fGw -----END PGP SIGNATURE-----
--- --- --- --------------------------------------------------------------------- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Martin Kersten schreef:
What is the developer perspective of running a single database with a single mapi interface but different users (and rights) versus multiple databases having each one user.
it all depends on the application,hardware,expertise,politics.
Lets put it into a limited hardware resource pool. There is one system available for databasing. And the target is to have an as high as possible throughput of queries given this resource constraint.
Is there a good reason not to merge databases?
yes/no depends
What would be reasons not to merge systems? I can only think of stability, if one database goes down, everything goes down. Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEAREKAAYFAkrRI7AACgkQYH1+F2Rqwn3SswCcDHSPLug+a/CWD1gC3RTuM6xU u4MAn1tzegI1TocwKIfDiusNg0Bziu2F =uhdx -----END PGP SIGNATURE-----
participants (2)
-
Martin Kersten -
Stefan de Konink