Best way for maintaining a "master table" for use in several databases

2005-09-27 Thread Neven Luetic
Hello, I have a database scheme, containing a table, whichs content should be unique across all databases with this scheme (on several servers as well). It would be possible to define one database, in which all changes would be made. But what's the easiest way to keep the table consistent in the

Re: Replication seems ok, but doesn't work

2005-08-22 Thread Neven Luetic
> > So it seems everything is ok. But changes in the original database > > "rtest" on the masterserver aren't replicated to "_rtest" on the slave. > > You have _rtest in the Replicate_do_db column of SHOW SLAVE STATUS, that > tells the slave to restrict replication to statements where the default

Replication seems ok, but doesn't work

2005-08-21 Thread Neven Luetic
Hello, I have set up replication between several servers, all using the same version of mysql (4.0.25, however on different Versions of SuSE-Linux). Production databases of the master server are replicated on the slave server using the same database name with an underscore. This works in all but