Re: Replication basics

2004-11-03 Thread Gleb Paharenko
Hi. You should really read the FAQ: http://mysql.ensita.net/doc/mysql/en/Replication_FAQ.html In case you want us to fine-tune replication for you, you may want to order commercial support, go to: https://order.mysql.com/?ref=ensita. ian douglas <[EMAIL PROTECTED]> wrote: > Hi everyo

Re: Replication basics

2004-11-02 Thread ian douglas
1. If a new database is created on db1, this is not replicated on db2 and db3. ... is there a better way to automate duplicating this >>database on the slaves? Yes put in your my.cnf on the master binlog-ignore-db=mysql,test this means the master will replicate any event to any database other then

RE: Replication basics

2004-11-02 Thread Dathan Vance Pattishall
DVP Dathan Vance Pattishall http://www.friendster.com > -Original Message- > From: ian douglas [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 02, 2004 9:30 AM > To: [EMAIL PROTECTED] > Subject: Replication basics > > Hi everyone, > > I&

Replication basics

2004-11-02 Thread ian douglas
Hi everyone, I've been browsing the online archives for a while and haven't found as much data as I'd like to feel really comfortable about replication. I've been a pretty busy developer in terms of using MySQL, but never so much in the way of administration. Also, I've only ever had to deal wit