techincally yes you can have. replication is all about the queries that are getting executed on the master will be executed on the slave. So , if the database that exists on the master exists on the slave , then you should have no problems.
Thanks Alex On 5/14/07, richard <[EMAIL PROTECTED]> wrote:
as far as I can see, these commands select which db's to replicate on the slave that currently exist on the master server. What i am asking is, if I set a server up as a slave, can I have other databases on the slave that are not part of the replication system? MySQL 中文网 wrote: > > of course > > setup by the option replication-do-db or replication-ignore-db :) > > richard wrote: >> >> Hi, >> >> I have a server (master version 4.0.1) that has a database that I >> want to replicate on another server (slave version 4.1.20). >> The slave already has another db on it. Is is possible to have a >> mixture of replicated and non replicated dbs running on a slave? >> >> cheers >> Rich >> >> > > -- > > > > > > > > ************************************************************** > MySQL 中文网 > 叶金荣 MySQL独立咨询师、系统架构师、培训师 > > 业务: LAMP架构设计、解决方案、负载均衡,MySQL 技术咨询、培训、支持 > 手机:13466608698 > [EMAIL PROTECTED] (或 [EMAIL PROTECTED]) > 网址:http://imysql.cn > ************************************************************** > http://imysql.cn 为用户提供一个专业的、自由的MySQL中文交流社区,欢迎来访 > > 给你的祝福,要让你招架不住! > > 2007/05/14 17:50:01 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]