blob and replication questions

2001-02-05 Thread Lukas Gruber


hi list,
i am new to mysql. i have read through the reference-manual but still
there are some things i could not answer myself. please help, many 
thanks in advance.

---
mysql-reference-manual describes longblob as a blob column with a
maximum length of 4294967295 characters but also says that one cant
use this whole range yet. what exactly does this mean? how much can
i use?

---
chapter 11: "replication" doesnt mention any way of scheduling 
replication. it says after one configured and restarted the slave
server it will connect to the master and then start replication.
is there a way to schedule replication? can i start replication at
specific times only?

---
in chapter 11: "replication" i cannot find any information about
replicating blob data (ok: is doesnt say it is NOT possible). can
this be done? does anybody have experience in replicatin blob-data
(largeblobs)?

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: blob and replication questions

2001-02-05 Thread Jeremy D. Zawodny

On Mon, Feb 05, 2001 at 03:58:37PM +0100, Lukas Gruber wrote:
 
 
 chapter 11: "replication" doesnt mention any way of scheduling
 replication. it says after one configured and restarted the slave
 server it will connect to the master and then start replication.  is
 there a way to schedule replication? can i start replication at
 specific times only?

You can't schedule it, but you could schedule a process to issue
"SLAVE STOP" and "SLAVE START" commands on your slave(s).

 in chapter 11: "replication" i cannot find any information about
 replicating blob data (ok: is doesnt say it is NOT possible). can
 this be done? does anybody have experience in replicatin blob-data
 (largeblobs)?

BLOB fields replicate just fine in my experience.

Jeremy
-- 
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878Fax: (408) 530-5454
Cell: (408) 439-9951

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php