[PHP-DB]-Replication
Hello. I have MySQL 3.23.41 on a RH-7.2 Linux used as local server. I'm trying to replicate the databases from server (192.168.0.1) to another linux PC (192.168.0.3). Following the manual, i grant to the master a user with file privileges, and edit both my.cnf files. The master starts fine but the slave mysql.log shows up an error: Slave thread: error connecting to master: Access denied for user: [EMAIL PROTECTED]' (Using password: YES) (0), retry in 60 sec Can somebody help m out? Thanx - Nikos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] replication questions
Answer to your questions: 1. Yes they can have dbs that each other does not know about. 2. Follow the instructions on setting up replication in mysql docs. They are easy to set up... Regarding the development db's...they are development and they should be on only one server. Why would you want to replicate development server. Replications is mostly used for production data. Also just a heads up that you can do bi-directional replication...you just need to do some work around on the mysql and server ends. It is fairly complex but I have done it with both mysql and postgresql. Ray "BigDog" Hunter -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 7:57 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP-DB] replication questions >From the mySQL Replication docs... snip -- In Version 3.23.15, all of the tables and databases will be replicated. Starting in Version 3.23.16, you can restrict replication to a set of databases with replicate-do-db directives in `my.cnf' or just exclude a set of databases with replicate-ignore-db. -- Two-way replication is not supported yet. http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database _Administration.html#Replication 'Luck -Szii - Original Message - From: "Jeff Field" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 20, 2002 6:03 PM Subject: [PHP-DB] replication questions > I think I understand how to set up replication but have a couple > unanswered questions. I'm hoping the list can help. > > I have two servers with MySQL. Each server currently has completely > different databases, except for the standard mysql permissions > database. Server 1 is in production and server 2 is basically a > development box. I would like to replicate server 1's databases to > server 2 (in effect, creating a hot-swap), but then that would mean > that server 2 not only has the production db's, but also the > development db's. My question are: > > 1) Is that even possible to do? Can a slave to a master also have > additional db's on it that the master doesn't even know about? > > 2) If the answer to question one is yes, then what do you do regarding > the mysql permissions db on the slave? > > BTW, I'm thinking that my setup perhaps has to be more along the > following > lines: > > The master contains all my db's, both production and development. The > production db's (as well as the development db's) would sit there in > production on server 1, replicating all the data to server 2. I would > have to set the permissions for both production and development db's > on server 1. > > Meanwhile, as the production server is sitting there and replicating > all it's important data to the development box, I could still work on > the development db's on the slave box (thereby not fooling around with > the production box). > > The issue, as I see it, would be that the slave box's development db's > would soon go out of synch with the development db's on the master > (because I'd be inserting, updating, etc. records on the development > db's on the slave and the master would never know). I could set up > two-way replication, but since I don't really care about the > development db's being in synch on the master, why bother. Does this > make sense? > > Anyway, I hope I've made this clear enough for someone to jump with > answers and comments. > > Jeff > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] replication questions
>From the mySQL Replication docs... snip -- In Version 3.23.15, all of the tables and databases will be replicated. Starting in Version 3.23.16, you can restrict replication to a set of databases with replicate-do-db directives in `my.cnf' or just exclude a set of databases with replicate-ignore-db. -- Two-way replication is not supported yet. http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Replication 'Luck -Szii - Original Message - From: "Jeff Field" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 20, 2002 6:03 PM Subject: [PHP-DB] replication questions > I think I understand how to set up replication but have a couple unanswered > questions. I'm hoping the list can help. > > I have two servers with MySQL. Each server currently has completely > different databases, except for the standard mysql permissions database. > Server 1 is in production and server 2 is basically a development box. I > would like to replicate server 1's databases to server 2 (in effect, > creating a hot-swap), but then that would mean that server 2 not only has > the production db's, but also the development db's. My question are: > > 1) Is that even possible to do? Can a slave to a master also have > additional db's on it that the master doesn't even know about? > > 2) If the answer to question one is yes, then what do you do regarding the > mysql permissions db on the slave? > > BTW, I'm thinking that my setup perhaps has to be more along the following > lines: > > The master contains all my db's, both production and development. The > production db's (as well as the development db's) would sit there in > production on server 1, replicating all the data to server 2. I would have > to set the permissions for both production and development db's on server 1. > > Meanwhile, as the production server is sitting there and replicating all > it's important data to the development box, I could still work on the > development db's on the slave box (thereby not fooling around with the > production box). > > The issue, as I see it, would be that the slave box's development db's would > soon go out of synch with the development db's on the master (because I'd be > inserting, updating, etc. records on the development db's on the slave and > the master would never know). I could set up two-way replication, but since > I don't really care about the development db's being in synch on the master, > why bother. Does this make sense? > > Anyway, I hope I've made this clear enough for someone to jump with answers > and comments. > > Jeff > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] replication questions
I think I understand how to set up replication but have a couple unanswered questions. I'm hoping the list can help. I have two servers with MySQL. Each server currently has completely different databases, except for the standard mysql permissions database. Server 1 is in production and server 2 is basically a development box. I would like to replicate server 1's databases to server 2 (in effect, creating a hot-swap), but then that would mean that server 2 not only has the production db's, but also the development db's. My question are: 1) Is that even possible to do? Can a slave to a master also have additional db's on it that the master doesn't even know about? 2) If the answer to question one is yes, then what do you do regarding the mysql permissions db on the slave? BTW, I'm thinking that my setup perhaps has to be more along the following lines: The master contains all my db's, both production and development. The production db's (as well as the development db's) would sit there in production on server 1, replicating all the data to server 2. I would have to set the permissions for both production and development db's on server 1. Meanwhile, as the production server is sitting there and replicating all it's important data to the development box, I could still work on the development db's on the slave box (thereby not fooling around with the production box). The issue, as I see it, would be that the slave box's development db's would soon go out of synch with the development db's on the master (because I'd be inserting, updating, etc. records on the development db's on the slave and the master would never know). I could set up two-way replication, but since I don't really care about the development db's being in synch on the master, why bother. Does this make sense? Anyway, I hope I've made this clear enough for someone to jump with answers and comments. Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
