List:General Discussion« Previous MessageNext Message »
From:Eduardo D Piovesam Date:December 15 2003 3:43pm
Subject:Re: Innodb in production
View as plain text  
Hi,

> How are you doing backups???

Since it's replicated, I stop the slave and copy the entire database
directory.

Then, I restart the server and the slave will get all the queries from the
master...

Works very well!

Eduardo


----- Original Message -----
From: "Arnoldus Th.J. Koeleman" <akoeleman@stripped>
To: "'Eduardo D Piovesam'" <eduardo@stripped>
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:eduardo@stripped]
> Sent: Monday, December 15, 2003 10:31 AM
> To: Nicolas Ross; mysql@stripped
> Subject: Re: Innodb in production
>
>
>
> > 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" <rossnick-lists@stripped>
> To: <mysql@stripped>
> Sent: Monday, December 15, 2003 1:13 PM
> Subject: Innodb in production
>
>
> > Hi !
> >
> > Our db server has about 140+ db's for a total of about 1.5 gigs of
> > data.
> >
> > Some while ago, for a specific DB, I did testing using transaction
> > tables with bdb. This was a bad experience. I ran into some problems
> > and I had to convert back to myisam.
> >
> > One thing I don't like about innobd and bdb is that all the data of
> > all
> db's
> > are all stored in one (or many) file in the base directory compared to
>
> > myisam tables where data resides in the db directory.
> >
> > Is innodb stable enough to use un mass production environement ?
> >
> > Nicolas
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
> >
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
>

Thread
Innodb in productionNicolas Ross15 Dec
  • Re: Innodb in productionChris Nolan15 Dec
  • Re: Innodb in productionEduardo D Piovesam15 Dec
  • Re: Innodb in productionJeremy Zawodny16 Dec
Re: Innodb in productionEduardo D Piovesam15 Dec