How To Set Up MySQL Database Replication With SSL Encryption for ALL DATABASES!

Hi masters of linux.

I want to use this tutor: http://www.howtoforge.com/how-to-se...ication-with-ssl-encryption-on-debian-squeeze

But I will like to use this for mirroring ALL DATABASES and any future databases on server. Please help me, how can i do this.

I have 1 Master server and 1 Slave. I all ready have sync WWW between it. Now I need sync the databases.

Thanks for reply and help.

 

Try this: http://serverfault.com/questions/268627/mysql-master-master-replication-of-all-databases-how

 

Thanks, I read that but this still don´t help me I am not that god in linux. I only need if somebody will help me with change in my.cnf in tutorial How To Set Up MySQL Database Replication With SSL Encryption...

I think its must be possible to type there replicate all databases but i dont know how.

Code:

server-id               = 1
log_bin                 = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size         = 100M
binlog_do_db            = exampledb <---- i need some like change this:) to something like "replicate all databases":)

Help pls... linux guru?

 

Leave out the binlog_do_db line and use

Code:

binlog-ignore-db=test
binlog-ignore-db=information_schema
binlog-ignore-db=mysql

instead, just as in the link I posted.

 

Yes, Thanks I got it. I figured out in another way... and than I understood your link.

Thanks Again!