Database Import from Oracle

2009-03-24 Thread frank fischer
Hello @all. I`ve got the question how mysql will have to be set up, that it can handle round about 7.000.000 records most efficiently. What do you think about the the hard and software requirements in order to match the best combination? The data will come from oracle, so it would be interes

RE: Replication A->B->C - changes on B are not replicated to C

2006-01-03 Thread Frank Fischer
search binary logs on B and check if the statement which is not replicated is stored. In case it is stored , research relay logs on C. Remove filters if they're present on C to find out if the problem in them. _ From: Frank Fischer [mailto:[EMAIL PROTECTED] Sent: Wednesday,

Replication A->B->C - changes on B are not replicated to C

2005-12-28 Thread Frank Fischer
Hi all i have a question related to replication on 4.0.x. I have the following setup: A -> B -> C A is a Master and writes all changes to its binlog (meaning there is no filter set). B acts as Slave from A and as Master for C. As a Slave B has filters set, so not every change of every databas

RE: Multiple MySQL services running on the same machine

2005-11-09 Thread Frank Fischer
Original Message- > From: Sujay Koduri [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 09, 2005 9:49 AM > To: Frank Fischer; mysql@lists.mysql.com > Subject: RE: Multiple MySQL services running on the same machine > > > I guess you should be able to run multiple instances

Multiple MySQL services running on the same machine

2005-11-09 Thread Frank Fischer
Hi all i just read some postings related whether it is possible to run multiple services of mysql on windows. One posting states, that is's not possible, another states that is can be done using mysqld-nt for the first instance and mysql-nt-max for the second instance and a third posting states t

Current Timestamp upon creating of a record

2004-12-18 Thread Frank Fischer
Hi all i would like to create a Timestamp upon initial creation of a record. I expected this could be done using now() in my INSERT statement but obv. the related field gets actualised each time a record is updated. Unfortunately that's not what i like - i would like to have the timestamp set jus

Some basic and advanced replication questions

2004-10-13 Thread Frank Fischer
Hi i'm using MySQL version 4.0.20d. I was able to set up a simple replication between a master and a slave. To fully understand the replication mechanism of MySQL i would like to ask some questions (the manual does not answer all my questions): (a) in 4.0.20d there is no way for a kind of Mas