Is there kind of tablespace concepts?
Hi All, Is there any possibility of retrieving the same table from 2 different sources (as similar to 2 tablespaces)? Regards, Sreejith
On 17 October 2017 at 14:35:55, Sharma, Sreejith (sreejith.sharma@harman.com) wrote: Hi All, Is there any possibility of retrieving the same table from 2 different sources (as similar to 2 tablespaces)? Regards, Sreejith _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list Hi Sharma! I’m not entirely sure what you mean with same table from 2 sources, could you give a more detailed example? Joeri
Hi Joeri, If we need to load balance, we can have the same tables sitting over 2 tablesspaces or 2 servers. This can help balance the load coming into same server and can share the load within servers. Sreejith From: users-list [mailto:users-list-bounces+sreejith.sharma=harman.com@monetdb.org] On Behalf Of Joeri van Ruth Sent: Tuesday, October 17, 2017 8:22 PM To: Communication channel for MonetDB users Subject: [EXTERNAL] Re: Is there kind of tablespace concepts? On 17 October 2017 at 14:35:55, Sharma, Sreejith (sreejith.sharma@harman.commailto:sreejith.sharma@harman.com) wrote: Hi All, Is there any possibility of retrieving the same table from 2 different sources (as similar to 2 tablespaces)? Regards, Sreejith _______________________________________________ users-list mailing list users-list@monetdb.orgmailto:users-list@monetdb.org https://clicktime.symantec.com/a/1/pu_KcYJjKrAPr1ZJTrJX4mkXH5s5kNf2dMmjHkWvMTc=?d=KbDls4KNqlWYTMpZa_vsXJVosCwx3_ZQAudONf22lbjWZt1DSDn6apwp2Fqv2JnUgjVqAWy77gk8LAraRcuDR_I6Ke87N4ha21c68C13nsfV1TXpi2aTBUL_YMqySQL_vd53WMk9QTn9go1kmTEeVc21uSmjrZT0kA4Tx9E1ygHevsYK6nxzPR-ScW3Ueh1tBzi1L33G5WqLMPtlRHFxpsT7mbwRqvBN9rAnK5BJ3m0vddOXbl-DNLQW-ZKSmpsLkwK0bFE9jx8HTw4OrUFjMuxBsktljqRMpG9wS2Nak1_qRYyg1-6--GHKKMAOpD99yn1XeG3e1Zm4uKf_-w3zUllOyxhx3TbExXZN_LkaR4ynPsJFNJLEj_36S1Gb3ZSg1rAj-6UnA04cCJ7uavDYddGLQMPxnXzS8BR4kQblv2xLO_QS8uDw9uus&u=https%3A%2F%2Fwww.monetdb.org%2Fmailman%2Flistinfo%2Fusers-list Hi Sharma! I’m not entirely sure what you mean with same table from 2 sources, could you give a more detailed example? Joeri
Ah, you want MERGE TABLEs, in combination with REMOTE TABLEs. See https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/DataPartitioning and https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/DistributedQueryP... You can build a merge table out of remote tables :) There have been some bugs recently so be sure to use the most recent version of MonetDB. Joeri On Tue, Oct 17, 2017 at 03:02:34PM +0000, Sharma, Sreejith wrote:
Hi Joeri,
If we need to load balance, we can have the same tables sitting over 2 tablesspaces or 2 servers. This can help balance the load coming into same server and can share the load within servers.
Sreejith
From: users-list [mailto:users-list-bounces+sreejith.sharma=harman.com@monetdb.org] On Behalf Of Joeri van Ruth Sent: Tuesday, October 17, 2017 8:22 PM To: Communication channel for MonetDB users Subject: [EXTERNAL] Re: Is there kind of tablespace concepts?
On 17 October 2017 at 14:35:55, Sharma, Sreejith (sreejith.sharma@harman.commailto:sreejith.sharma@harman.com) wrote: Hi All, Is there any possibility of retrieving the same table from 2 different sources (as similar to 2 tablespaces)? Regards, Sreejith _______________________________________________ users-list mailing list users-list@monetdb.orgmailto:users-list@monetdb.org https://clicktime.symantec.com/a/1/pu_KcYJjKrAPr1ZJTrJX4mkXH5s5kNf2dMmjHkWvMTc=?d=KbDls4KNqlWYTMpZa_vsXJVosCwx3_ZQAudONf22lbjWZt1DSDn6apwp2Fqv2JnUgjVqAWy77gk8LAraRcuDR_I6Ke87N4ha21c68C13nsfV1TXpi2aTBUL_YMqySQL_vd53WMk9QTn9go1kmTEeVc21uSmjrZT0kA4Tx9E1ygHevsYK6nxzPR-ScW3Ueh1tBzi1L33G5WqLMPtlRHFxpsT7mbwRqvBN9rAnK5BJ3m0vddOXbl-DNLQW-ZKSmpsLkwK0bFE9jx8HTw4OrUFjMuxBsktljqRMpG9wS2Nak1_qRYyg1-6--GHKKMAOpD99yn1XeG3e1Zm4uKf_-w3zUllOyxhx3TbExXZN_LkaR4ynPsJFNJLEj_36S1Gb3ZSg1rAj-6UnA04cCJ7uavDYddGLQMPxnXzS8BR4kQblv2xLO_QS8uDw9uus&u=https%3A%2F%2Fwww.monetdb.org%2Fmailman%2Flistinfo%2Fusers-list
Hi Sharma!
I’m not entirely sure what you mean with same table from 2 sources, could you give a more detailed example?
Joeri
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Thanks a ton, Joeri. One last question - Can we run two instance of MonetDB in the same server? It's not about different database, but 2 instance of mserver. -----Original Message----- From: users-list [mailto:users-list-bounces+sreejith.sharma=harman.com@monetdb.org] On Behalf Of Joeri van Ruth Sent: Tuesday, October 17, 2017 8:39 PM To: Communication channel for MonetDB users Subject: Re: [EXTERNAL] Re: Is there kind of tablespace concepts? Ah, you want MERGE TABLEs, in combination with REMOTE TABLEs. See https://clicktime.symantec.com/a/1/blIoEdRZrwbaenJ41G8vKfBIwrJ5fOC9V12modSCD1E=?d=FdK9PjFd5xvc27E4CH7LO2IrdHa80eddzDbblrbsUtmEBNGHJ9TJqk4TDd_4_prB92C73VdYd2BphYGgbTeoDnhE9HNO7eLnzBDPBLjF3bOLZemU8FU_0rKs8tqvy-zin7T5zJ-ccSoDi1IEgWCiV6GebtRdMNXJ7Vo4LlLurejaoBghqmD2_jxfRV6X2n9Oy3cZ-VAeGNc492QqZLm0oXLNg-ImyEN4-vNfnyWY2MKBfEN77WtVjPNAktjvCAHI4mwIGZgBlYfyEAHcF4MUGRdJD6Q0jk0FVdGJ33ooPdWJaddBS-BUa_4NKXb6Pg1iu3yhQmIOm9M7rSGkzz3HbC0zkMIyowMRHPy9S-uGzvfY_-aHPA4pmlWol4Kx5I4-DrKjC5aoDoLqN_tGf3f0L6j4AYliEci8QTkWymde2gUjQZ7-z3f6Iut1fK1bn3CQkMLWqDMe&u=https%3A%2F%2Fwww.monetdb.org%2FDocumentation%2FCookbooks%2FSQLrecipes%2FDataPartitioning and https://clicktime.symantec.com/a/1/-WMKy0cJcpNHPO6Vx75bpKOHeLOg3dfG8GNSCI8jtk0=?d=FdK9PjFd5xvc27E4CH7LO2IrdHa80eddzDbblrbsUtmEBNGHJ9TJqk4TDd_4_prB92C73VdYd2BphYGgbTeoDnhE9HNO7eLnzBDPBLjF3bOLZemU8FU_0rKs8tqvy-zin7T5zJ-ccSoDi1IEgWCiV6GebtRdMNXJ7Vo4LlLurejaoBghqmD2_jxfRV6X2n9Oy3cZ-VAeGNc492QqZLm0oXLNg-ImyEN4-vNfnyWY2MKBfEN77WtVjPNAktjvCAHI4mwIGZgBlYfyEAHcF4MUGRdJD6Q0jk0FVdGJ33ooPdWJaddBS-BUa_4NKXb6Pg1iu3yhQmIOm9M7rSGkzz3HbC0zkMIyowMRHPy9S-uGzvfY_-aHPA4pmlWol4Kx5I4-DrKjC5aoDoLqN_tGf3f0L6j4AYliEci8QTkWymde2gUjQZ7-z3f6Iut1fK1bn3CQkMLWqDMe&u=https%3A%2F%2Fwww.monetdb.org%2FDocumentation%2FCookbooks%2FSQLrecipes%2FDistributedQueryProcessing You can build a merge table out of remote tables :) There have been some bugs recently so be sure to use the most recent version of MonetDB. Joeri On Tue, Oct 17, 2017 at 03:02:34PM +0000, Sharma, Sreejith wrote:
Hi Joeri,
If we need to load balance, we can have the same tables sitting over 2 tablesspaces or 2 servers. This can help balance the load coming into same server and can share the load within servers.
Sreejith
From: users-list [mailto:users-list-bounces+sreejith.sharma=harman.com@monetdb.org] On Behalf Of Joeri van Ruth Sent: Tuesday, October 17, 2017 8:22 PM To: Communication channel for MonetDB users Subject: [EXTERNAL] Re: Is there kind of tablespace concepts?
On 17 October 2017 at 14:35:55, Sharma, Sreejith (sreejith.sharma@harman.commailto:sreejith.sharma@harman.com) wrote: Hi All, Is there any possibility of retrieving the same table from 2 different sources (as similar to 2 tablespaces)? Regards, Sreejith _______________________________________________ users-list mailing list users-list@monetdb.orgmailto:users-list@monetdb.org https://clicktime.symantec.com/a/1/pu_KcYJjKrAPr1ZJTrJX4mkXH5s5kNf2dMm jHkWvMTc=?d=KbDls4KNqlWYTMpZa_vsXJVosCwx3_ZQAudONf22lbjWZt1DSDn6apwp2F qv2JnUgjVqAWy77gk8LAraRcuDR_I6Ke87N4ha21c68C13nsfV1TXpi2aTBUL_YMqySQL_ vd53WMk9QTn9go1kmTEeVc21uSmjrZT0kA4Tx9E1ygHevsYK6nxzPR-ScW3Ueh1tBzi1L3 3G5WqLMPtlRHFxpsT7mbwRqvBN9rAnK5BJ3m0vddOXbl-DNLQW-ZKSmpsLkwK0bFE9jx8H Tw4OrUFjMuxBsktljqRMpG9wS2Nak1_qRYyg1-6--GHKKMAOpD99yn1XeG3e1Zm4uKf_-w 3zUllOyxhx3TbExXZN_LkaR4ynPsJFNJLEj_36S1Gb3ZSg1rAj-6UnA04cCJ7uavDYddGL QMPxnXzS8BR4kQblv2xLO_QS8uDw9uus&u=https%3A%2F%2Fwww.monetdb.org%2Fmai lman%2Flistinfo%2Fusers-list
Hi Sharma!
I’m not entirely sure what you mean with same table from 2 sources, could you give a more detailed example?
Joeri
_______________________________________________ users-list mailing list users-list@monetdb.org https://clicktime.symantec.com/a/1/66ThFjWTG376gpf6EtF8hgd9qUgLJz6tyIx 7xjjA7CY=?d=FdK9PjFd5xvc27E4CH7LO2IrdHa80eddzDbblrbsUtmEBNGHJ9TJqk4TDd _4_prB92C73VdYd2BphYGgbTeoDnhE9HNO7eLnzBDPBLjF3bOLZemU8FU_0rKs8tqvy-zi n7T5zJ-ccSoDi1IEgWCiV6GebtRdMNXJ7Vo4LlLurejaoBghqmD2_jxfRV6X2n9Oy3cZ-V AeGNc492QqZLm0oXLNg-ImyEN4-vNfnyWY2MKBfEN77WtVjPNAktjvCAHI4mwIGZgBlYfy EAHcF4MUGRdJD6Q0jk0FVdGJ33ooPdWJaddBS-BUa_4NKXb6Pg1iu3yhQmIOm9M7rSGkzz 3HbC0zkMIyowMRHPy9S-uGzvfY_-aHPA4pmlWol4Kx5I4-DrKjC5aoDoLqN_tGf3f0L6j4 AYliEci8QTkWymde2gUjQZ7-z3f6Iut1fK1bn3CQkMLWqDMe&u=https%3A%2F%2Fwww.m onetdb.org%2Fmailman%2Flistinfo%2Fusers-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://clicktime.symantec.com/a/1/66ThFjWTG376gpf6EtF8hgd9qUgLJz6tyIx7xjjA7CY=?d=FdK9PjFd5xvc27E4CH7LO2IrdHa80eddzDbblrbsUtmEBNGHJ9TJqk4TDd_4_prB92C73VdYd2BphYGgbTeoDnhE9HNO7eLnzBDPBLjF3bOLZemU8FU_0rKs8tqvy-zin7T5zJ-ccSoDi1IEgWCiV6GebtRdMNXJ7Vo4LlLurejaoBghqmD2_jxfRV6X2n9Oy3cZ-VAeGNc492QqZLm0oXLNg-ImyEN4-vNfnyWY2MKBfEN77WtVjPNAktjvCAHI4mwIGZgBlYfyEAHcF4MUGRdJD6Q0jk0FVdGJ33ooPdWJaddBS-BUa_4NKXb6Pg1iu3yhQmIOm9M7rSGkzz3HbC0zkMIyowMRHPy9S-uGzvfY_-aHPA4pmlWol4Kx5I4-DrKjC5aoDoLqN_tGf3f0L6j4AYliEci8QTkWymde2gUjQZ7-z3f6Iut1fK1bn3CQkMLWqDMe&u=https%3A%2F%2Fwww.monetdb.org%2Fmailman%2Flistinfo%2Fusers-list
Mserver5 requires exclusive access to the database. There is no way around that. So you can have multiple mservers on a server, each serving another database, but you cannot have multiple mservers serving a single database, even with read only access. There would not be any benefit to that anyway as a single mserver5 will already use all available memory and all available cores to do its work. Two will only get in each others way. Hope this makes sense. Joeri On Wed, Oct 18, 2017 at 04:13:51AM +0000, Sharma, Sreejith wrote:
Thanks a ton, Joeri.
One last question - Can we run two instance of MonetDB in the same server? It's not about different database, but 2 instance of mserver.
-----Original Message----- From: users-list [mailto:users-list-bounces+sreejith.sharma=harman.com@monetdb.org] On Behalf Of Joeri van Ruth Sent: Tuesday, October 17, 2017 8:39 PM To: Communication channel for MonetDB users Subject: Re: [EXTERNAL] Re: Is there kind of tablespace concepts?
Ah, you want MERGE TABLEs, in combination with REMOTE TABLEs.
You can build a merge table out of remote tables :)
There have been some bugs recently so be sure to use the most recent version of MonetDB.
Joeri
On Tue, Oct 17, 2017 at 03:02:34PM +0000, Sharma, Sreejith wrote:
Hi Joeri,
If we need to load balance, we can have the same tables sitting over 2 tablesspaces or 2 servers. This can help balance the load coming into same server and can share the load within servers.
Sreejith
From: users-list [mailto:users-list-bounces+sreejith.sharma=harman.com@monetdb.org] On Behalf Of Joeri van Ruth Sent: Tuesday, October 17, 2017 8:22 PM To: Communication channel for MonetDB users Subject: [EXTERNAL] Re: Is there kind of tablespace concepts?
On 17 October 2017 at 14:35:55, Sharma, Sreejith (sreejith.sharma@harman.commailto:sreejith.sharma@harman.com) wrote: Hi All, Is there any possibility of retrieving the same table from 2 different sources (as similar to 2 tablespaces)? Regards, Sreejith _______________________________________________ users-list mailing list users-list@monetdb.orgmailto:users-list@monetdb.org https://clicktime.symantec.com/a/1/pu_KcYJjKrAPr1ZJTrJX4mkXH5s5kNf2dMm jHkWvMTc=?d=KbDls4KNqlWYTMpZa_vsXJVosCwx3_ZQAudONf22lbjWZt1DSDn6apwp2F qv2JnUgjVqAWy77gk8LAraRcuDR_I6Ke87N4ha21c68C13nsfV1TXpi2aTBUL_YMqySQL_ vd53WMk9QTn9go1kmTEeVc21uSmjrZT0kA4Tx9E1ygHevsYK6nxzPR-ScW3Ueh1tBzi1L3 3G5WqLMPtlRHFxpsT7mbwRqvBN9rAnK5BJ3m0vddOXbl-DNLQW-ZKSmpsLkwK0bFE9jx8H Tw4OrUFjMuxBsktljqRMpG9wS2Nak1_qRYyg1-6--GHKKMAOpD99yn1XeG3e1Zm4uKf_-w 3zUllOyxhx3TbExXZN_LkaR4ynPsJFNJLEj_36S1Gb3ZSg1rAj-6UnA04cCJ7uavDYddGL QMPxnXzS8BR4kQblv2xLO_QS8uDw9uus&u=https%3A%2F%2Fwww.monetdb.org%2Fmai lman%2Flistinfo%2Fusers-list
Hi Sharma!
I’m not entirely sure what you mean with same table from 2 sources, could you give a more detailed example?
Joeri
_______________________________________________ users-list mailing list users-list@monetdb.org https://clicktime.symantec.com/a/1/66ThFjWTG376gpf6EtF8hgd9qUgLJz6tyIx 7xjjA7CY=?d=FdK9PjFd5xvc27E4CH7LO2IrdHa80eddzDbblrbsUtmEBNGHJ9TJqk4TDd _4_prB92C73VdYd2BphYGgbTeoDnhE9HNO7eLnzBDPBLjF3bOLZemU8FU_0rKs8tqvy-zi n7T5zJ-ccSoDi1IEgWCiV6GebtRdMNXJ7Vo4LlLurejaoBghqmD2_jxfRV6X2n9Oy3cZ-V AeGNc492QqZLm0oXLNg-ImyEN4-vNfnyWY2MKBfEN77WtVjPNAktjvCAHI4mwIGZgBlYfy EAHcF4MUGRdJD6Q0jk0FVdGJ33ooPdWJaddBS-BUa_4NKXb6Pg1iu3yhQmIOm9M7rSGkzz 3HbC0zkMIyowMRHPy9S-uGzvfY_-aHPA4pmlWol4Kx5I4-DrKjC5aoDoLqN_tGf3f0L6j4 AYliEci8QTkWymde2gUjQZ7-z3f6Iut1fK1bn3CQkMLWqDMe&u=https%3A%2F%2Fwww.m onetdb.org%2Fmailman%2Flistinfo%2Fusers-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://clicktime.symantec.com/a/1/66ThFjWTG376gpf6EtF8hgd9qUgLJz6tyIx7xjjA7CY=?d=FdK9PjFd5xvc27E4CH7LO2IrdHa80eddzDbblrbsUtmEBNGHJ9TJqk4TDd_4_prB92C73VdYd2BphYGgbTeoDnhE9HNO7eLnzBDPBLjF3bOLZemU8FU_0rKs8tqvy-zin7T5zJ-ccSoDi1IEgWCiV6GebtRdMNXJ7Vo4LlLurejaoBghqmD2_jxfRV6X2n9Oy3cZ-VAeGNc492QqZLm0oXLNg-ImyEN4-vNfnyWY2MKBfEN77WtVjPNAktjvCAHI4mwIGZgBlYfyEAHcF4MUGRdJD6Q0jk0FVdGJ33ooPdWJaddBS-BUa_4NKXb6Pg1iu3yhQmIOm9M7rSGkzz3HbC0zkMIyowMRHPy9S-uGzvfY_-aHPA4pmlWol4Kx5I4-DrKjC5aoDoLqN_tGf3f0L6j4AYliEci8QTkWymde2gUjQZ7-z3f6Iut1fK1bn3CQkMLWqDMe&u=https%3A%2F%2Fwww.monetdb.org%2Fmailman%2Flistinfo%2Fusers-list _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Joeri van Ruth -
Sharma, Sreejith