My system is configured as follows: database server on a linux server web application on another linux server For sanitation purposes I would like to restart these servers during night at least once a week. The constraints are : when the web application is loaded the database must be already online the downtime should be … Read more
I have a server in internet that must have all data synced (dont need to be in realtime) from a server from a intranet (obviously has internet connection). Is it possible? How about sync both sides, master-master? I havent tried yet because my internal server is behind a NAT and I dont have access to … Read more
I am a beginner to server administration and network design. Following is the requirement: I have three dedicated servers. These three servers need to accomplish following: There is a master DB There is a slave DB There is a production web server There is a way to include development ladder: Development=>Testing=>Production Version control is through … Read more
I am having trouble setting up the following with pacemaker: a 2-node cluster where the master server always has IP address A, and the slave server always has IP address B. This is a failover cluster, so when the servers switch roles, the IP addresses need to change correspondingly. Sounds like it should be a … Read more
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 8 years ago. Improve this question edit: (for clarification) I have two servers. Server 1 has a static IP, and server2 has a dynamic hostname using … Read more
Hi I have a master MySQL server with 950 gb of data and slave has stopped for some reason and there is a difference of 80gb of data. so I started to setup new slave . Since the data is changing and multiple databases dumping, copying and restoring will take lot of time . So … Read more
It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 10 years ago. I want to install a secondary (slave) DNS … Read more
Could anyone explain the behavior of DNS slave? I am testing DNS server, for internal purpose, and after configuring master slave everything works fine, but I am willing to understand the mechanism behind, Lets say, dnsmaster.net and dnsslave.net [my 2 DNS] However, I wanted to make dnsslave to be available to serve query if dnsmaster.net … Read more
Is it possible to setup replication for database_A from master_A and database_B from master_B server? It looks like I can only set one master-host in MySQL configuration file. Thanks in advance. Answer Read this tread and this article. A possible trick is federated storage engine, but is not good as replication. AttributionSource : Link , … Read more
I’ll be doing a upgrade of a large MySQL 5.0 database to Percona 5.1 and I’m attempting to keep the actual downtime as short as possible during the upgrade, so the regular mysqldump + mysql import procedure doesn’t work as well for me as the downtime would be several hours. Currently I’m running a Master->Slave … Read more
