{"id":2979,"date":"2014-03-13T00:01:16","date_gmt":"2014-03-13T00:01:16","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/03\/13\/problem-about-master-slave-collection-of-common-programming-errors\/"},"modified":"2014-03-13T00:01:16","modified_gmt":"2014-03-13T00:01:16","slug":"problem-about-master-slave-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2014\/03\/13\/problem-about-master-slave-collection-of-common-programming-errors\/","title":{"rendered":"problem about master-slave-Collection of common programming errors"},"content":{"rendered":"<ul>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/aefd60cb37d083e03b0996a2a74726f0?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nsn\u00f8reven<br \/>\nredundancy redis master-slave<br \/>\nI am using redis as a cache server. Can I somehow configure multiple redis servers, that the cache is fully functional (read\/write) even if some of them go offline?I looked into master-&gt;slave, but the problem I see there is, that if the master fails, and I allow writes to the slaves, they get overwritten once the master is up again. Now the master just serves the old data.The only solution I could come up was disabling write-to-disc, but that sucks as I loose everything if I have to restart the<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/a8332af927878c879529d88d50a1eb40?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\ntamirko<br \/>\nmysql replication database-replication master-slave<br \/>\nHere&#8217;s the scenario: I have one MySQL Master and 1 slave. master-slave replication is set and works perfectly. The slave machine crashes. The master machine is still up and running. Nothing changes in the master DB. I start the slave machine again. I start the slave MySQL DB.Do I need to invoke &#8220;start slave&#8221; again on the slave DB ? 10x.<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/638a28b80c83c796086b51908cef1f04?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\naneez<br \/>\npostgresql master-slave pgpool2<br \/>\nI am trying to configure pgpool2 and postgresql 9.1 to handle failover.I currently have streaming replication running, and are using pgpool2 for read-only load balancing. I have 2 servers in my setup, both running postgresql &#8211; 1 master and 1 slave. The master is also running pgpool2.My question is how do I configure this setup to handle failover? Specifically in the case that the master crashes, and the slave has to take over and run pgpool2 as well. Most documentation and examples I have been a<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/369ccd7f96e58b0d892db6c48bded20c?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nEric DANNIELOU<br \/>\nlinux database oracle11g ulimit master-slave<br \/>\nIs there an issue with &#8220;Ulimit -Hn&#8221; being set too low (at 1024) when (Oracle recommend 65536)? This is for Oracle 64-bit 11g on Linux 5.It is one of the settings that appears to be woefully short of its recommendation. But I am also aware that the database server in question is an Oracle Data Guard Local Standby and should only really have a connection or two from its Primary database server (to ship the redo logs across).The Local Standby database server has &#8216;hung&#8217; about 3 times in as many mon<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/1e6ea8017b8a3e3393c1ab4dc3876a30?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nmethanol<br \/>\nmysql database replication database-replication master-slave<br \/>\nI am about to do a MySQL replication for my typo3 Database. There are two servers. You guessed it one is the Master and one is the Slave.Master my.cnf:[mysql] server-id = 1 log-bin expire_logs_days = 21 max_binlog_size = 500M binlog-ignore-db=mysqlSlave my.cnf:[mysql] server-id = 2 binlog-ignore-db = mysql replicate-ignore-db = mysql auto-increment-offset = 1 expire_logs_days = 21 max_binlog_size = 500MUser on Master: repl@slaveip REPLICATION SLAVE, REPLICATION CLIENT User on Slave: repl@maste<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/0372d48ec5bde6e69aebf759d11b4a18?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nSarah Ryan<br \/>\nbind master-slave zone<br \/>\nUPDATE:BIND Version:[root@10.224.45.130] $ named -v BIND 9.3.6-P1-RedHat-9.3.6-16.P1.el5Operating System:CentOS release 5.6 (Final)After running [root@10.224.45.131] $ dig @10.224.45.130 example.com. axfr:Slave:; &lt;&lt;&gt;&gt; DiG 9.3.6-P1-RedHat-9.3.6-16.P1.el5 &lt;&lt;&gt;&gt; @10.224.45.130 example.com. axfr ; (1 server found) ;; global options: printcmd ; Transfer failed.Master:28-Aug-2011 12:29:01.384 client 10.224.45.131#60553: query: example.com IN AXFR &#8211; 28-Aug-2011 12:29:01.384 clie<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/0e8fb2d4f021291bbb162f08b9350cf0?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nparvus<br \/>\nwindows jenkins master-slave<br \/>\nI set up Jenkins on a Windows 7 64 bit PC, and installed a Jenkins slave service on another Win7 64 PC. The master PC gives this error:Connection was broken java.net.SocketException: Connection resetat java.net.SocketInputStream.read(Unknown Source)at java.io.BufferedInputStream.fill(Unknown Source)at java.io.BufferedInputStream.read(Unknown Source)at java.io.ObjectInputStream$PeekInputStream.peek(Unknown Source)at java.io.ObjectInputStream$BlockDataInputStream.peek(Unknown Source)at java.io.Obj<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/ff565d3c43557cf78dfdc34dec04f768?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nAlaa<br \/>\nmysql innodb master-slave<br \/>\nI have mysql DB on server S1 (mysql version 5.1.41-3ubuntu12.7-log), i have created master-slave for this DB on server S2 (mysql version 5.1.54-1ubuntu4-log). the DB on S1 was using one data file (ibdata). after dumping the DB to S2 i set innodb_file_per_table=1. this made every table to have its own ibd file. now everything went fine and smoothly. but after restarting mysql on S2, i faced a problem with getting this error: Error &#8216;Unknown table engine &#8216;InnoDB&#8221; on query. Default database: MyDB a<\/li>\n<\/ul>\n<p>Web site is in building<\/p>\n","protected":false},"excerpt":{"rendered":"<p>sn\u00f8reven redundancy redis master-slave I am using redis as a cache server. Can I somehow configure multiple redis servers, that the cache is fully functional (read\/write) even if some of them go offline?I looked into master-&gt;slave, but the problem I see there is, that if the master fails, and I allow writes to the slaves, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2979","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/2979","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=2979"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/2979\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=2979"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=2979"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=2979"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}