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
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, December

Re: Innodb in production

2003-12-15 Thread Eduardo D Piovesam
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 [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 10:31 AM To: Nicolas Ross

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

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:

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] Cc: [EMAIL PROTECTED] Sent

Re: Replication : blocking updates to slave

2003-12-03 Thread Eduardo D Piovesam
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 updates to slave On Wednesday 03 December 2003 12:56, Eduardo D

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 updates to slave Eduardo, On Wed, Dec 03, 2003 at 10:56

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

2003-10-24 Thread Eduardo D Piovesam
keys for MySQL InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM tables .. From: Eduardo D Piovesam ([EMAIL PROTECTED]) Subject: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1 View this article only Newsgroups: mailing.database.myodbc

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

2003-10-24 Thread Eduardo D Piovesam
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 PROTECTED]; [EMAIL PROTECTED] Sent: Friday, October 24, 2003 11:23 AM Subject

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 Hi!

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: 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 Message - From: Eduardo D Piovesam [EMAIL

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