|
Say you have 2 database servers, one database is the 'master' database where all write operations are performed, it is treated as the 'real/original' database. The other server's database is to be a mirror copy of the master database (slave?), which will...
Started by public static on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
It will replicate changes in near real time as ... .
What you want is called Transactional Replication in SQL Server 2005.
Edit: Sorry this as sqlserver.
The answer to this will vary depending on the database server you are using to do this.
|
|
I have been rereading some sections of "Active Directory Bible" by Curt Simmons in preparation for some machine replacement and changes to our windows 2000 active directory infrastructure. It seems that in any relaible active directory network you should...
Started by AudioDan on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
A note re: infrastructure master and global catalog servers: In a single domain environment with the infrastructure master role assigned to a global catalog server: http://support.microsoft.com/kb/248047 not place the infrastructure....
|
|
I have a 2 master and 6 slave MySQL database environment. One master is hot and the other master is considered cold and is just running as a slave. I don't want to do a real master - master where both are replicating from each other. During fail over ...
Answer Snippets (Read the full thread at serverfault):
Routine, you could attempt to connect to the hot master and if that fails, connect to the cold master from the the failed master to the cold master" ?
If so, what you want is to use either Red Hat Cluster Suite hosts can run....
|
Ask your Facebook Friends
|
Why does everyone tell me that master-master always ends in tears and should be avoided?
Started by Alex on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at serverfault):
Because no two people use ....
Both records are equally.
Which one is right? In a Master<->Master environment, there is no right.
Inevitably both will get updated.
Mean that scaling by adding another DB server is a hellish process.
|
|
Have done what is mentioned on the other MW3 thread in this forum but keep getting "No Steam Master Servers found when starting the server software. Server will LAN visible only." - any suggestions?
Started by EvilCensor on
, 2 posts
by 1 people.
Answer Snippets (Read the full thread at nfoservers):
I check the Firewall on the server and noted that although Inbound rules had been created for TDP.
|
|
Because everyone says master-master is not recommended.
But if you think about it...1 write server is hardly enough!
So, how would you set it up (high-level, not tutorial-level) so that it works out well?
Started by Alex on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
HA takes care of availability to do trillions of writes, you'd probably be better off just having a number of unconnected servers to handle:
Go for a master ->....
When I think about it, I realise that one writable server is plenty.
|
|
Hi there,
I have replication setup between two mysql servers, one is a master and the other is the slave.
This works well unless the master is restarted for any reason. When it comes back up the slave doesn't connect. On the slave I do a start slave; ...
Started by Wizzard on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
Incidentally, when you say "I do a start slave;", you are... .
In my case the solution was to use the IP address instead .
I have to the master.
RESET MASTER at some point, or something in the server's startup is clearing out /var/run .
|
|
I have two servers running mysql as dual master (each server is a master, each server is slaved to the other). While troubleshooting a possible issue during peak load, I began to wonder how mysql prevent a "loop" of commands in a relationship like this...
Started by jj33 on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
If a server receives a statement....
As far as your specific question, it's a combination of two things:
By default, if a server), leading to: In replication, it sends the server-id of the origination server along with the statement.
|
|
Hook Post subject: Re: UT MASTER SERVERS Acting Up? (again) Posted: Fri Mar 05, 2010 10:55 am *Captain (Site Administrator)*
Joined: Thu Mar 29, 2007 9:35 am
Posts: 3418
Location: Minnesota USA (Just West of MPLS - by a pond beneath a tree - Dead & Buried...
Answer Snippets (Read the full thread at freeforums):
There's also another master server:
ServerActors=IpServer.UdpServerUplink don't have that line, I just know if I hadn't set it to True my master servers would be deleted, yeah I found ....
Of master servers.
|
|
I have two machines (A and B, A is Master) running VRPP (from keepalived) for a Virtual IP.
How can I prevent A from becoming Master again if it has failed and come back up (for whatever reason)?
I'm doing this so that we have a single fail-over to the...
Started by MrMagu on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
As I understand it, when a new VRRP server comes up, it forces an election, and the current server doesn't get any benefit, so....
masters just because a new server came online, only switch when the current master fails.
|
