Hi Stephen,
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote:
>
> I believe I already know the answer to this, consider it a
> feature request :)
>
Not sure ;-)
> I would like to see if there is a way to make loadercli or
> backup work so that data is streamed directly from one MaxDB
> server into another :)
> Even if the data is Endian reversed (sparc vs. i386)? In
> other words, no use of intermediate disk space. A pipe,
> special driver, etc.
>
That is already in loadercli. You can specify PIPE instead of FILE
in the INSTREAM specification. You have to create the pipe(s) with
OS means and then your command could look like this (using your
example from a previous mail):
DBEXTRACT CATALOG OUTSTREAM PIPE '<catalog pipe name>'
DATA OUTSTREAM PIPE '<data pipe name>' RECORDS
and the corresponding loading process should use this command:
DBLOAD CATALOG INSTREAM PIPE '<catalog pipe name>'
DATA INSTREAM PIPE '<data pipe name>' RECORDS
No need to mention that you need 2 Loader to serve this.
BUT (and now it comes) it works as expected under Windows only at the
moment :-( We're working on it!
> When you get into 50GB+ databases... the extra step to write
> out to disk can be a big logistical issue. A cross over
> cable and two 1Gbps
> network adapters come in handy here...
>
> Is there effort underway to provide such a method? I don't
> assume the new 'hot standby' will support cross-platform
> (mixed Endian) partners?
>
And we're thinking about integrating the whole transportation into
a single Loader command without the need to define any external medium
at all and having the Loader serving more than one DB at the same time.
Concerning the cross-platform transport (mixed endians), would you mind
sharing the exact problems/messages
you encountered when extracting/loading pages? Are there any messages in
the Loader log file that could be of any help?
To be honest: it should work to transport tables cross-platform using
the Loader.
Regards,
Steffen
--
Steffen Schildberg
SAP DB Team
SAP Labs Berlin
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
