If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Master-slave Replication question

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Dec 2012
Posts: 23
Master-slave Replication question

Dear All,

My running production server :: RedHat Linux 32bit
My new server :: CentOS 64bit

Now can i configure master - slave replication between those servers.

Any suggestions/useful link is appreciated.

regards,

--rush
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Feb 2006
Posts: 169
Just Google this phrase: replicate mysql database another server
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Dec 2012
Posts: 23
In one of my test system..i have configured master-slave replication..so far it is working nice..insert/delete/update is working fine..

Master = Fedora 32 bit
Slave = CentOS 64 bit
Mysql = 5.0.95

So I think it is possible to configure replication between RedHat 32 bit to CentOS 64 bit..!!

suggestion pls....

regards,

--rush
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Sep 2009
Location: San Sebastian, Spain
Posts: 860
It is indeed possible. Replication in MySQL is based on the binary log contents. A slave process passes the contents on to another MySQL agent which then applies it into the database. The package format used is independent of hardware and should work against any different version of MySQL on different platforms. So you could also have replication between Linux and Windows too.
__________________
Ronan Cashell
Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
http://www.it-iss.com
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Dec 2012
Posts: 23
Thank you very much for your suggestion Mr. Ronan.....now my confusion is clear..i will start implement replication into my production server and will give a try in my test system between linux and windows..thanks again..!!

regards,

--rush
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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 Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On