MySQL Replication

[Gayatri Swaminathan]

Hi,

I am trying to setup a simple MySQL replication module using puppet. I am sure there are recipe's to learn from. Since I am in the learning phase I find PuppetLabs/MySQL difficult to comprehend. It would be great if any of you could share a basic recipe for the same that will help me reproduce it. Thanks.

g3kr

[Gayatri Swaminathan]

I have doubts in setting up the slave.



In the slave mysql

I need to do the following

CHANGE MASTER TO

> MASTER_HOST='masteripaddress',
> MASTER_USER='repl',
> MASTER_PASSWORD='password',
> MASTER_LOG_FILE='mysql-bin.000001',
> MASTER_LOG_POS=98;

start slave

how will i get these values from the master in runtime and pass them to slave machine.

Thanks in advance