LinuxQuestions.org
Review your favorite Linux distribution.
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 10-26-2006, 12:16 PM   #1
ACDII
Member
 
Registered: Aug 2006
Posts: 87

Rep: Reputation: 16
MySQL Replication


Has anyone done this? I am looking to have the same database on two servers that run Tacacs. The master would be the server that has teh webfront for the Tacacs, but both servers run their own version of Tacacs using the same information in the database. I found documentation regarding setting up replication, but it also pushes ALL the databases, not just a select few. One server is just running Tacacs, the other is also running a few other programs that use MySQL, and I dont want those databases to be replicated.

What I am wondering is if I have the one server that has just the one Database as the master, can I have multiple databases on the Slave server?
 
Old 10-26-2006, 01:58 PM   #2
J_K9
Member
 
Registered: Nov 2004
Distribution: Slackware 11, Ubuntu 6.06 LTS
Posts: 700

Rep: Reputation: 30
Hmm... Well, instead of replicating, you could always allow remote (authenticated) access to mysqld and set Tacacs on the secondary server to use the master server's database directly (and remotely)? This seems far simpler than constant replication - using your method, if your database were altered often, you'd waste one heck of a lot of bandwidth sending that data to your secondary server. But that's just MHO
 
Old 10-26-2006, 03:24 PM   #3
ACDII
Member
 
Registered: Aug 2006
Posts: 87

Original Poster
Rep: Reputation: 16
Quote:
Originally Posted by J_K9
Hmm... Well, instead of replicating, you could always allow remote (authenticated) access to mysqld and set Tacacs on the secondary server to use the master server's database directly (and remotely)? This seems far simpler than constant replication - using your method, if your database were altered often, you'd waste one heck of a lot of bandwidth sending that data to your secondary server. But that's just MHO
If I can get the Webui to do it, that is my preferred method instead of trying to maintain two databases. I will see if I can point the tacacs program itself to a different database via IP, but not quite sure how to do it. Linux is still fairly new to me, as I am too used to widoze, but heavy into Cisco CLI, its the placement of files that is taking me those most time learning, then learning how each program works after I locate them is the next thing. At least I get paid to play with them!
 
Old 10-27-2006, 11:18 AM   #4
ACDII
Member
 
Registered: Aug 2006
Posts: 87

Original Poster
Rep: Reputation: 16
Quote:
Originally Posted by J_K9
Hmm... Well, instead of replicating, you could always allow remote (authenticated) access to mysqld and set Tacacs on the secondary server to use the master server's database directly (and remotely)? This seems far simpler than constant replication - using your method, if your database were altered often, you'd waste one heck of a lot of bandwidth sending that data to your secondary server. But that's just MHO
On further thought this would NOT work. If the Tacacs server that has the DB on it goes down, the secondary server has no DB to use, and would be worthless. I tried it out and tested it, actually got it working too, but when I broke the link, tacacs failed to work. Looks like I will need two DB afterall, so the question remains, can I have more DB's on the Client, than there are on the Master? I want to set the master on the primary Tacacs server, which is running a lower rev of MySQL and cannot be upgraded at this time, but only has one DB on it, the CLient will have Two additional DB's that are currently on it, and will be the secondary Tac server.
 
Old 10-28-2006, 11:28 AM   #5
leandean
Member
 
Registered: Oct 2005
Location: Burley, WA
Distribution: Sabayon, Debian
Posts: 278

Rep: Reputation: Disabled
In replication the slave can have any number of databases from any number of masters using multiadmin. Also, the slave will replicate only the databases it knows about. i.e: Standard procedure is to not replicate the mysql db. That prevents breaking replication when you add or delete a user to the master.

However, you will not be able to modify the slave. Only use it for reports, backup, etc.

Last edited by leandean; 10-28-2006 at 11:30 AM.
 
Old 12-18-2006, 08:08 AM   #6
ACDII
Member
 
Registered: Aug 2006
Posts: 87

Original Poster
Rep: Reputation: 16
Has anyone that does replication have the slave database get wiped out? It was working perfectly for weeks and then all of a sudden the one tacacs stopped taking requests and I found that its database was basically wiped out, only one table remained, the rest disappeared. How can a database get wiped without a drop being issued? The master database OTOH was fine, I was able to restore the busted one off of it.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 twistedpair Linux - General 7 06-23-2006 10:10 AM
MySQL Replication not working correctly? Ratclaws Linux - Software 0 06-20-2005 03:34 PM
Looking for suggestions on MySQL one-way replication Pcghost Linux - Software 1 01-25-2005 10:22 AM
Mysql replication pk21 Linux - Software 0 08-28-2003 05:00 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 08:35 PM.

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