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

Discussion in 'HOWTO-Related Questions' started by Ripeed, Oct 24, 2011.

  1. Ripeed

    Ripeed Member

  2. falko

    falko Super Moderator ISPConfig Developer

  3. Ripeed

    Ripeed Member

    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?
     
    Last edited: Oct 26, 2011
  4. falko

    falko Super Moderator ISPConfig Developer

    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.
     
  5. Ripeed

    Ripeed Member

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

    Thanks Again!
     

Share This Page