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