Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 24th October 2011, 11:03
Ripeed Ripeed is offline
Member
 
Join Date: Oct 2011
Posts: 85
Thanks: 11
Thanked 1 Time in 1 Post
Unhappy 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-set...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.
Reply With Quote
Sponsored Links
  #2  
Old 25th October 2011, 11:52
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

Try this: http://serverfault.com/questions/268...-databases-how
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
The Following User Says Thank You to falko For This Useful Post:
Ripeed (27th October 2011)
  #3  
Old 26th October 2011, 15:15
Ripeed Ripeed is offline
Member
 
Join Date: Oct 2011
Posts: 85
Thanks: 11
Thanked 1 Time in 1 Post
Default

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 by Ripeed; 26th October 2011 at 15:21.
Reply With Quote
  #4  
Old 27th October 2011, 16:30
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

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.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
The Following User Says Thank You to falko For This Useful Post:
Ripeed (27th October 2011)
  #5  
Old 27th October 2011, 16:33
Ripeed Ripeed is offline
Member
 
Join Date: Oct 2011
Posts: 85
Thanks: 11
Thanked 1 Time in 1 Post
 
Default

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

Thanks Again!
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Replication on Web, Email And MySQL Database Cluster matiasCU Installation/Configuration 0 24th October 2011 09:21
Problems with SpamSnake ClamAV (Sanesecurity Signatures) tmaleshafske HOWTO-Related Questions 0 21st September 2010 01:59
ISPC 3, powerdns, mysql replication not working. damir General 2 8th July 2010 09:24
Recovering unlinked mysql databases and users... Dave Lane Installation/Configuration 2 10th May 2006 19:45
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 23:44.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.