LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 04-05-2010, 03:27 AM   #1
packets
Member
 
Registered: Oct 2005
Posts: 339

Rep: Reputation: 32
2 mysql replication to 1 machine


If I have 2 MySQL server and I want to replicate their database to only 1 server, is it possible? I cannot afford to have master-to-master only because I still need to replicate one more machine but I do not have anymore more machine for replication so I'm thinking if these 2 MySQL server can be replicate to only 1 machine.

If this is not possible, I guess I've no choice but to have two mysql daemon on that machine
 
Old 04-05-2010, 03:54 AM   #2
ganiutomo
LQ Newbie
 
Registered: Jun 2009
Posts: 14

Rep: Reputation: 2
yes it's possible.
if your server is strong enough, you can use virtual environment.
 
Old 04-05-2010, 04:16 AM   #3
packets
Member
 
Registered: Oct 2005
Posts: 339

Original Poster
Rep: Reputation: 32
Quote:
if your server is strong enough, you can use virtual environment
I haven't experience installing virtual apps like VMware,Xen or Virtualbox to a machine with no GUI. Is it possible I can install those virtualization software even the master has no GUI? Also, Can I do this via SSH only?

If virtualization is not possible, any other suggestions?
 
Old 04-05-2010, 05:15 AM   #4
ganiutomo
LQ Newbie
 
Registered: Jun 2009
Posts: 14

Rep: Reputation: 2
First:
You can install VirtualBox using SSH, and every administrative purpose in VirtualBox can be done via terminal.

The tricky part is when installing guest OS on it. But, you can make guest os on machine with GUI. Made every necessary adjustment, like setting vnc server on it, etc. Then copy the guest vdi file to the server.

Using VirtualBox tunneling, you can access guest VNCServer from your workstation.

Second:
You can install VNCServer in the master.
Access VNCServer trough SSH tunnel.
Install virtualization using gui environment.

Three:
If virtualization is not possible, may be using two sql daemon is the solution.
As far as i know mysql is one master with many slave, not many master one slave.
 
Old 04-05-2010, 09:31 PM   #5
packets
Member
 
Registered: Oct 2005
Posts: 339

Original Poster
Rep: Reputation: 32
would you recommend having two mysql daemon listening on different ports and bind to different ip's?
 
Old 04-09-2010, 12:57 AM   #6
ganiutomo
LQ Newbie
 
Registered: Jun 2009
Posts: 14

Rep: Reputation: 2
yes i would recommend that solution.
in fact i'm going to try it myself.
i'll let you know the result of my experiment.
 
  


Reply



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



Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL replication Ammad Linux - General 1 09-16-2009 08:46 PM
mysql replication lord-fu *BSD 1 04-03-2007 09:23 PM
mysql replication lord-fu Linux - Server 0 04-02-2007 08:38 AM
MySQL Replication ACDII Linux - Server 5 12-18-2006 08:08 AM
mysql replication cheng Linux - Software 1 08-22-2002 02:11 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 07:23 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration