AW: replication on single server
The thing is that this particular table in database 'A' contains bounceback email addresses, all other databases are customer databases containing pretty large subscriber tables. Now I need to find matches between this bounceback table and all other customer subscriber tables. So I'd like to do a join over these, which is not possible because they reside in different databases (Like SELECT s.name FROM bouncebacks b, subcriber s where s.email = b.email). So if I could replicate this table, I could perform the above join. right now I find matches between the bounceback and the subscriber list by scripting, which is slooow - with ca. 10,000 bouncebacks and say up to 15,000 subscribers/customer. I don't really like this concept, but I can't think of a better one... Thanks again for suggestions! Tom -Ursprüngliche Nachricht- Von: Paul DuBois [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 14. März 2003 19:19 An: Brandl, Thomas; [EMAIL PROTECTED] Betreff: Re: replication on single server At 10:49 +0100 3/14/03, Brandl, Thomas wrote: Hey everybody, I want to replicate several tables from one database to all other databases on the same machine, so to say a table-level-replication Simply said, imagine this scenario: A MySQL server with about 10 databases: A and 1 to 9. Database A contains a 'special' table that is supposed to be replicated to all other databases on the same machine, so it is kinda like the master database. The table has the same name on every database. Is such a thing possible and if yes, how? Thanks very much for your help! Thomas I don't understand why you'd bother. Put it in one database and grant everybody permission to access it. Wouldn't that accomplish the same thing, without all the headache of trying to copy it everywhere? -- Paul DuBois, [EMAIL PROTECTED] http://www.kitebird.com/ sql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: AW: replication on single server
Hi, With MySQL, you can join tables that are in different databases as long as they are on the same server. In your case, you could run: SELECT s.name FROM A.bouncebacks b, subcriber s where s.email = b.email Regards, Joseph Bueno Brandl, Thomas wrote: The thing is that this particular table in database 'A' contains bounceback email addresses, all other databases are customer databases containing pretty large subscriber tables. Now I need to find matches between this bounceback table and all other customer subscriber tables. So I'd like to do a join over these, which is not possible because they reside in different databases (Like SELECT s.name FROM bouncebacks b, subcriber s where s.email = b.email). So if I could replicate this table, I could perform the above join. right now I find matches between the bounceback and the subscriber list by scripting, which is slooow - with ca. 10,000 bouncebacks and say up to 15,000 subscribers/customer. I don't really like this concept, but I can't think of a better one... Thanks again for suggestions! Tom -Ursprüngliche Nachricht- Von: Paul DuBois [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 14. März 2003 19:19 An: Brandl, Thomas; [EMAIL PROTECTED] Betreff: Re: replication on single server At 10:49 +0100 3/14/03, Brandl, Thomas wrote: Hey everybody, I want to replicate several tables from one database to all other databases on the same machine, so to say a table-level-replication Simply said, imagine this scenario: A MySQL server with about 10 databases: A and 1 to 9. Database A contains a 'special' table that is supposed to be replicated to all other databases on the same machine, so it is kinda like the master database. The table has the same name on every database. Is such a thing possible and if yes, how? Thanks very much for your help! Thomas I don't understand why you'd bother. Put it in one database and grant everybody permission to access it. Wouldn't that accomplish the same thing, without all the headache of trying to copy it everywhere? -- Paul DuBois, [EMAIL PROTECTED] http://www.kitebird.com/ sql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
replication on single server
Hey everybody, I want to replicate several tables from one database to all other databases on the same machine, so to say a table-level-replication Simply said, imagine this scenario: A MySQL server with about 10 databases: A and 1 to 9. Database A contains a 'special' table that is supposed to be replicated to all other databases on the same machine, so it is kinda like the master database. The table has the same name on every database. Is such a thing possible and if yes, how? Thanks very much for your help! Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: replication on single server
At 10:49 +0100 3/14/03, Brandl, Thomas wrote: Hey everybody, I want to replicate several tables from one database to all other databases on the same machine, so to say a table-level-replication Simply said, imagine this scenario: A MySQL server with about 10 databases: A and 1 to 9. Database A contains a 'special' table that is supposed to be replicated to all other databases on the same machine, so it is kinda like the master database. The table has the same name on every database. Is such a thing possible and if yes, how? Thanks very much for your help! Thomas I don't understand why you'd bother. Put it in one database and grant everybody permission to access it. Wouldn't that accomplish the same thing, without all the headache of trying to copy it everywhere? -- Paul DuBois, [EMAIL PROTECTED] http://www.kitebird.com/ sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication on single server
Hey guys, Simply said, imagine this scenario: A MySQL server with about 10 databases: A and 1 to 9. Database A contains a 'special' table that is supposed to be replicated to all other databases on the same machine, so it is kinda like the master database. So how do I tell MySQL which databases I consider to be slaves and master?? Thanks very mouch for your help! Thomas Mit freundlichen Grüßen Thomas Brandl ___ Thomas Brandl Barff Infotainment Grimmstr. 1 80336 Muenchen Tel. 089 / 74 71 16-21 Fax. 089 / 74 71 16-18 E-Mail: [EMAIL PROTECTED] Internet:http://www.barff.de/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: replication on single server
Databases are neither slave nor master, servers are. A master may have many slaves, but a slave may have only one master. Brandl, Thomas wrote: Hey guys, Simply said, imagine this scenario: A MySQL server with about 10 databases: A and 1 to 9. Database A contains a 'special' table that is supposed to be replicated to all other databases on the same machine, so it is kinda like the master database. So how do I tell MySQL which databases I consider to be slaves and master?? Thanks very mouch for your help! Thomas Mit freundlichen Grüßen Thomas Brandl ___ Thomas Brandl Barff Infotainment Grimmstr. 1 80336 Muenchen Tel. 089 / 74 71 16-21 Fax. 089 / 74 71 16-18 E-Mail: [EMAIL PROTECTED] Internet:http://www.barff.de/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php