Re: MySQL on NetWare?

2003-12-18 Thread Eduardo D Piovesam
Hi Chris We're running MySQL on NetWare6.5 with good performance & stability. About 20GB with InnoDB and a "simple replication" enabled (M -> S). This database will grow up to 200GB in a year (with 400 active connections). We did tests and we liked. We'll set up another 2 servers to run a 100GB

Re: Innodb in production

2003-12-15 Thread Eduardo D Piovesam
h.J. Koeleman" <[EMAIL PROTECTED]> To: "'Eduardo D Piovesam'" <[EMAIL PROTECTED]> Sent: Monday, December 15, 2003 1:38 PM Subject: RE: Innodb in production > How are you doing backups??? > > > -Original Message- > From: Eduardo D Piovesam [ma

Re: Innodb in production

2003-12-15 Thread Eduardo D Piovesam
> Is innodb stable enough to use un mass production environement ? Yes, it's. We use it on a 24x7 system (replicated), with 20GB w/no issues. We're using 4.0.16 on NetWare6.5. Eduardo - Original Message - From: "Nicolas Ross" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, De

Replication error (1236 - impossible position on slave)

2003-12-11 Thread Eduardo D Piovesam
Hi, We have 2 MySQL 4.0.16 with replication enabled (M -> S), only InnoDB tables. We're getting "Error reading packet from server: Client requested master to start replication from impossible position (server_errno=1236)" in the slave. The master server had a problem... when it came back (with s

Re: Replication : blocking updates to slave

2003-12-03 Thread Eduardo D Piovesam
with the master... Thanks, Eduardo - Original Message - From: "Fred van Engen" <[EMAIL PROTECTED]> To: "Eduardo D Piovesam" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, December 03, 2003 11:21 AM Subject: Re: Replication : blocking u

Re: Replication : blocking updates to slave

2003-12-03 Thread Eduardo D Piovesam
e'll need to rebuild all the priveleges on the slave. Thanks, Eduardo - Original Message - From: "Duncan Hill" <[EMAIL PROTECTED]> To: "Eduardo D Piovesam" <[EMAIL PROTECTED]> Sent: Wednesday, December 03, 2003 11:00 AM Subject: Re: Replication : blocking

Re: Replication : blocking updates to slave

2003-12-03 Thread Eduardo D Piovesam
Hi Fred, thanks for reply. But we want to replicate the mysql database... we want a exact copy of the master. Is there another way? Thanks, Eduardo - Original Message - From: "Fred van Engen" <[EMAIL PROTECTED]> To: "Eduardo D Piovesam" <[EMAIL PROTECTED]&

Replication : blocking updates to slave

2003-12-03 Thread Eduardo D Piovesam
Hi, We're using replication (1 master + 1 slave), and we want to block updates / deletes, issued by the users, to the slave. Because sometimes they get confused and use the slave as the master... got it? Any clue? Thanks, Eduardo -- MySQL General Mailing List For list archives: http://lists.

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-24 Thread Eduardo D Piovesam
. Currently we have only 2 problems : view + stored procedures, but we can do some "workaround" because we have only a few of them. Regards, Eduardo - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: "Eduardo D Piovesam" <[EMAIL PROTE

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-24 Thread Eduardo D Piovesam
s. > > Best regards, > > Heikki > Innobase Oy > http://www.innodb.com > InnoDB - transactions, row level locking, and foreign keys for MySQL > InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM > tables > > .. > From:

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-23 Thread Eduardo D Piovesam
(Sorry for the last email, it's not complete). Hello Heikki, Sorry, but I didn't understand the concept of tablespace applied. It's different from Oracle, right? AFAIK, tablespace is utilized to logically group "tables" into one (or more) files. And to group "indexes" into another files... But

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-23 Thread Eduardo D Piovesam
Hello Heikki, I didn't understand the concept of tablespaces utilized, - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, October 22, 2003 12:00 PM Subject: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1 >

Re: Multiple tablespace + subqueries

2003-09-26 Thread Eduardo D Piovesam
Heikki, Great! Thank you! Regards, Eduardo - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 26, 2003 4:31 PM Subject: Re: Multiple tablespace + subqueries > Eduardo, > > - Original Me

Multiple tablespace + subqueries

2003-09-25 Thread Eduardo D Piovesam
Hello all, We want to use MySQL (InnoDB) for a corporate/non-stop environment, but we really want/need multiple tablespace support + subqueries. When will both be available for a production environment? Only in 4.1.x? Any date? Thank you! Eduardo -- MySQL General Mailing List For list archiv