{"id":2944,"date":"2014-03-11T09:32:44","date_gmt":"2014-03-11T09:32:44","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/03\/11\/mysqlreplicationdatabase-replicationmaster-slaverelated-issues-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:50:21","modified_gmt":"2022-08-30T15:50:21","slug":"mysqlreplicationdatabase-replicationmaster-slaverelated-issues-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2014\/03\/11\/mysqlreplicationdatabase-replicationmaster-slaverelated-issues-collection-of-common-programming-errors\/","title":{"rendered":"mysql,replication,database-replication,master-slaveRelated issues-Collection of common programming errors"},"content":{"rendered":"<ul>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/2bf827618467bb43f88b32731f50856f?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nMsonic<br \/>\nc# asp.net mysql<br \/>\nI&#8217;m building very simple search engine for a job site. It has 3 optional input fields, term, category and employer. Term and employer fields are text input and category is dropdown list. Search logic is very stupid, complicated and not scalable but this search is meant to be used just one time and all i need from it is that it works on a few cases and since i have more important things to do at the time i didn&#8217;t tried to make it any better. This is the method that returns a DataSet with results<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/3189f1e006358ec6c65481b9605cd0e3?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nLightness Races in Orbit<br \/>\nmysql null zero<br \/>\n(I&#8217;m using MySQL 5.1.)Insert looks like this:INSERT INTO foo (bar) VALUES (&#8221;);bar field was created as so: bar INT(11) COLLATION: (NULL) NULL: YES DEFAULT: (NULL)Shouldn&#8217;t an empty string be inserting a NULL? Not sure why I&#8217;m seeing a zero (0) being stored in the table.<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/432adf003d27dda1431e26b1c8ecde79?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nSeven<br \/>\nmysql cakephp-2.1<br \/>\nI created a site with CakePHP responsible for displaying my CV. I would like to add a new feature relying on that if i still work at some company it should display text: &#8220;until now&#8221;, if dont it should display a proper date. The problem is that when I adding a new column to my database named isActive and I set up value 1 to one of the entries (other entries have value 0) page displays value 0 for all entries. This problem occurs on production server. On my development server everything is ok.View<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/3d575ee50a8388454791b5f8e2841ba2?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nJader Dias<br \/>\nmysql geospatial<br \/>\nI want to get the length in meters between 2 points in the surface of the Earth. But the GLength method returns an unexpected valuehttp:\/\/dev.mysql.com\/doc\/refman\/5.0\/en\/geometry-property-functions.html#function_glengthSELECT GLength(GeomFromText(&#8216;LINESTRING(-67.8246 -10.0073,-67.8236 -10.0082)&#8217;, 4326))actual result0.00134536240471071expected value in meters:147<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/20dd8c0e6b00089d1a8f39b54c3d46e3?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nKonstantin V. Salikhov<br \/>\njava mysql hibernate jpa eclipselink<br \/>\nI used NanedQueries (as follows) in my JPA project Eclipselink as persistence provider:@Entity @Table(name = &#8220;login&#8221;) @NamedQueries({@NamedQuery(name = &#8220;Login.random&#8221;, query = &#8220;SELECT l FROM Login l WHERE l.pk = :randomPk&#8221;),@NamedQuery(name = &#8220;Login.max&#8221;, query = &#8220;SELECT MAX(l.pk) FROM Login l&#8221;) })But after I change Hibernate as my persistence provider, I get the following error:java.lang.IllegalArgumentException: org.hibernate.QueryException: unexpected char: &#8216;{&#8216; [SELECT&#8230;I use Hibernate 3.2.5<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/9659b2c900b006ebfc9483d0cfa9c654?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nmcgrailm<br \/>\nphp jquery mysql jquery-ajax jquery-selectbox<br \/>\nToday I realised it&#8217;s pretty usefull when one combobox can control the data of the second combobox. My problem -&gt; I&#8217;ve never worked with Ajax before.Currently working on the following webpage: http:\/\/194.247.30.66\/~keizer\/?ond=woningenTry to use the comboboxes on the left.My general question: I hate submit buttons, I hate a default look, how can I use Ajax to handle the data of the second combobox? For example: The first combobox contains a list of city&#8217;s. When I select a city, it should automat<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/0f0309525b133214d5e87e061b6baead?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nChristian Wibowo<br \/>\nphp mysql insert<br \/>\ni want to insert array to mysql db using php..and now i getting error with this code :$insert_sql = sprintf(&#8220;INSERT INTO detail_paket (id_paket, menu_paket) selectpaket.id,\\&#8217;%s\\&#8217; from paket where paket.nama_paket=&#8217;$nama_paket'&#8221;,%data1[$i]);^| here is the error syntaxdata1 is the array..what is the correct syntax to use \\&#8217;%s\\&#8217; ?when i trying to run the query, the error info show : syntax error, unexpected &#8216;%&#8217; in or syntax error unexpected &#8220;&#8221; in*.i already tried using \\&#8221;%s\\ and \\&#8221;%s&#8221;\\ and %s and<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/c1cb63a2e2e70d0f62b232497c956efb?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nR.S<br \/>\nphp html mysql<br \/>\nPossible Duplicate:Parse error: syntax error, unexpected T_STRING 59 I have a database with names that I would like displayed in the form of a table with checkboxes. Everything works until I try to place the html tag into my php code. When I put the input tag in it gives me the error: Parse error: syntax error, unexpected T_STRING, expecting &#8216;,&#8217; or &#8216;;&#8217;I can&#8217;t see where I would put a comma or semi colon.&lt;form&gt;&lt;?php$name = $_POST[&#8216;name&#8217;];$host = &#8220;mysql16.000webhost.com&#8221;;$user_name = &#8220;<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/47307ec3d32c63b4eb29639523dc435a?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nuser1023768<br \/>\nmysql transactions insert innodb myisam<br \/>\nI have a MySQL table implementing a mail queue, and I use it also to send mails which reports unexpected errors in the system. Sometimes these unexcepted errors ocurrs inside a transaction so when I rollback the transacion also I undo the row inserted (the mail which is reporting the unexpected error) in the mail queue table.My question is how can I force to insert a row in a table in the middle a transaction ignoring the possible transaction rollback?. I mean, If the transactions finally rollsb<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/ad10c3866c19df2469967561dfd6c358?s=32&amp;d=identicon&amp;r=PG&amp;f=1\" \/><br \/>\nBalaji Reddy<br \/>\nmysql hibernate jpa<br \/>\nUsing JPA and mysql,I want to write program for delete and insert into a table in single transaction using @Transaction annotationMy code is like this\/\/Delete entityManager.createNamedQuery( &#8220;DELETE_QUERY&#8221; ).setParameter( &#8220;userId&#8221;, userId ).executeUpdate();entityManager.flush();\/\/InsertUser user = new User(); user.setUserId(122); user.setPassword(&#8220;test&#8221;);entityManager.merge( user ); entityManager.flush();Delete query is displayed. Then the update query is running here&#8230;Then it throw the below<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/6a61a40ee46871d39e99835351e178ef?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nslm<br \/>\ncentos rhel migration duplicate replication<br \/>\nWe currently have our website and website&#8217;s CMS hosted on a dedicated host which runs Red Hat. We want to remove Red Hat and install CentOS instead.My question: is there a straight forward way of replicating all the server settings, PHP, Apache, SQL data, website files, and CMS settings from the Red Hat install, and moving them over to a new CentOS install?To make things easier, I don&#8217;t mind installing the equivalent version of CentOS, based on the Red Hat version we currently have. So if we h<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/7f122d3fa1b3e0e69c1b283497c93905?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nGeesu<br \/>\npostgresql replication<br \/>\nI currently have 1 master server (a) and 3 replication servers (b, c, d) that come directly from the master, the archive_command I use is the following script: https:\/\/gist.github.com\/Geesu\/8640616All servers are Ubuntu 12.04.4 running PostgreSQL 9.2.6And here is the recovery.conf for each of the replication servers: https:\/\/gist.github.com\/Geesu\/8640635What&#8217;s strange is about 6 hours after I started the replication servers, 2 of them immediately fell behind and are now stuck trying to catch up,<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/5f59fc2e5fe801722a06429d61e38a0a?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nZak<br \/>\nmysql vmware-esxi replication cloud<br \/>\nWe currently are in the research phase of building a &#8220;Master&#8221; database for our e-commerce business that will centralize all data, including product information, vendor information, Magento information, Amazon, etc &#8230;. We have looked into both &#8220;physical hardware&#8221; (Two RAID 5 machines, master\/slave, with a HDD backup off the slave &#8212; and a separate application server)&#8230;. Or we could do a &#8220;cloud based&#8221; system.The heart of the question is, is there any benefit with replicating on a cloud? Th<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/82d1ee1e5cd5fa32a7eeee2df0c44c3c?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\njabley<br \/>\nmysql replication disaster-recovery mysql-replication<br \/>\nAfter a power outage at our data centre, the slave MySQL databases are struggling.This is in the logs for one of the slaves:100118 10:05:56 [Note] Slave I\/O thread: connected to master &#8216;repl@db1:3306&#8217;, replication started in log &#8216;bin-log.004712&#8217; at position 724207814 100118 10:05:56 [ERROR] Error reading packet from server: Client requested master to start replication from impossible position ( server_errno=1236) 100118 10:05:56 [ERROR] Got fatal error 1236: &#8216;Client requested master to start re<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/8ae44dc366eacfc7e7eede0ae0ac065c?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nRafal Dowgird<br \/>\nmysql replication mysql-replication<br \/>\nWhen issuing START SLAVE UNTIL on MySQL , I&#8217;m getting the following:Warning: It is recommended to use &#8211;skip-slave-start when doing step-by-step replication with START SLAVE UNTIL; otherwise, you will get problems if you get an unexpected slave&#8217;s mysqld restart.Why exactly is it recommended to use &#8211;skip-slave-start? What happens if the slave indeed restarts &#8211; does it only forget the UNTIL part and replicates till the end of binlog?<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/6566a52971f284b19822a45d97db828f?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nRolandoMySQLDBA<br \/>\nmysql replication mysql-5.5 mysql-5<br \/>\nI have a question about deleting binary logs in the replication environment:We have an environment with 1 master and 2 slaves (running mysql 5.5). Sometimes, we run into a space issues during heavy processing times, whereby bin log directory gets full. Logs are expired every 3 days. I was wondering, is there a reason why logs should be kept for 3 days on all the boxes &#8211; master and both slaves? Would it make sense to, for example, keep logs for 3 days on a master, but for 1 day on slaves? What is<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/f09eaf7b1c438f76d4d27781d837f286?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\ncom<br \/>\nmysql replication<br \/>\nI get a lot of following messagesUnsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it accesses a non-transactional table after accessing a transactional table within the same transaction. Statement:I don&#8217;t really understand why this happens. According to messages, it happens because in the code I try to INSERT and UPDATE Innodb table and MyISAM table. Is it right?Is this dangerous? What&#8217;s the consequences of this error.<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/5c61b4a2bb3858e9fd2de8dcb9ba3e14?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nKajMagnus<br \/>\npostgresql replication<br \/>\nI&#8217;ve configured master slave replication in PostgreSQL, following this tutorial: http:\/\/wiki.postgresql.org\/wiki\/Binary_Replication_Tutorial#Binary_Replication_in_6_StepsIt worked fine. Now I&#8217;ve promoted the slave, and configured the original master to be a slave to the new master, again following the tutorial linked above.However, replication no longer works. The new slave (i.e. the former master) logs errors like:FATAL: terminating walreceiver process due to administrator command LOG: out-o<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/3bac4180a7bd7b0b6fd8a44c1c7452b7?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nNiels Kristian<br \/>\npostgresql replication<br \/>\nI have a streaming replication hot-standby setup, which seems to be running all good. I can login, execute selects and the result seems to be up-to-date with the master. However in the log of the standby, I see a lot of these:cp: cannot stat `\/mnt\/wal_drive\/wals\/0000000100004BA800000070&#8242;: No such file or directory 2014-02-28 16:00:37 CET LOG: record with zero length at 4BA8\/70DD79D0 2014-02-28 16:00:37 CET LOG: started streaming WAL from primary at 4BA8\/70000000 on timeline 1 2014-02-28 16:02:<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/ab716bbb1ccfe0184445186afb5c7cb5?s=128&amp;d=identicon&amp;r=PG\" \/><br \/>\nivica<br \/>\nreplication mongodb permissions<br \/>\nI&#8217;m having some trouble with intentionally removing a secondary from a replica set. I&#8217;m trying to simulate unexpected shutdown.My replica set consists of one primary and 2 secondaries. When I shut down the mongo instance on one of the secondaries and try to restart the service it fails with the message from the log which states:Tue Dec 24 12:20:08.882 [initandlisten] couldn&#8217;t open \/var\/lib\/mongo\/maars.ns errno:13 Permission deniedSimple chown -R mongod \/var\/lib\/mongo solves the problem, but this<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/701922ccaeb5cf2209eff4a233c9c922?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nvaan38<br \/>\nmysql database-replication<br \/>\nI just configure 2 mySQL servers for a MASTER-MASTER replication. I choose the RBR replication for some reason.My congifuration on the server ONE :#replication server-id=1 binlog_do_db = db1 binlog_ignore_db = db2 log-bin=&#8221;C:\/ProgramData\/MySQL\/my56&#8243; auto_increment_increment = 2 auto_increment_offset = 1 binlog_format=ROW replicate_do_db=db1and on the server TWO :#replication server-id=2 binlog_do_db = db1 log-bin=&#8221;C:\/ProgramData\/MySQL\/my56&#8243; auto_increment_increment = 2 auto_increment_offset = 2<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/5bdfd807c52af99d45db34821b8dfedd?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nJulio Garcia<br \/>\ndatabase postgresql database-replication postgresql-9.1<br \/>\nI am trying to set up synchronous replication with Postgres 9.1, but I cannot get it to work. I was able to configure streaming replication, but not synchronous. I hope I have not missed anything obvious. I have read carefully many sections of ch 17, 18, 14, 25, 26 and 29 in the admin guide.I am running ubuntu 12.04 and my master postgresql.conf has these, among all the other standard settings:listen_addresses = &#8216;*&#8217; # what IP address(es) to listen on; wal_level = archive<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/4cd7dd6827a5a8b531cc6242a103f0a1?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nChad Johnson<br \/>\nmysql database-replication<br \/>\nWe started using Multi-Master Replication Manager for MySQL, and I am wondering whether it is possible to to treat this setup like multi-symmetric processing: a process pops off the process queue, and the node (in this case a server) that is most free is selected for the job.It seems that what happens is, the service switches to a slave ONLY when it mysqld crashes or goes away.Is there a way to make database replication for MySQL act in more of a distributed manner? Maybe there is other software<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/3d91a083d47c66019bcda1f3a9b32fde?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nuser805627<br \/>\nc database mongodb database-replication mongodb-c<br \/>\nIn this simple program, I want to reconnect to replica set when the primary node crash. But it doesn&#8217;t work: if the primary node crash, this program will be terminated immediately without any output, and return 141. I don&#8217;t know why. What is the proper way to reconnect to replica set?#include &lt;stdio.h&gt; #include &lt;mongo.h&gt;int insertVal(mongo *conn, int val) {bson op[1];bson_init(op);bson_append_int(op, &#8220;val&#8221;, val);bson_finish(op);int status = mongo_insert(conn, &#8220;test.vals&#8221;, op, NULL);b<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/ccb1570a0611016f6f12d1cfc14c60eb?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nQA Automator<br \/>\nmysql database-replication<br \/>\nWe have a MySQL setup running a single master and two replication slaves. We recently ran into a scenario where SlaveIO had stopped on one of the replication slaves and SlaveSQL had stopped on the other replication slave. This had silently stopped replication on both slave servers. I decided to write a monitoring plugin for Nagios to keep an eye on the status of SlaveIO and SlaveSQL. The problem I am having is emulating the scenarios we ran into above. I can issue a &#8220;STOP SLAVE&#8221; command to stop<\/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\/d06c06f469a6c2d73f8fdc1e9e04f452?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\njuwi<br \/>\nemailserver postgresql replication database-replication<br \/>\nI&#8217;m currently planning a more fault tolerant setup for my organizations Mail setup. We currently have two machines available in different datacenters, that we&#8217;re planning to use for this, one being a physical host, the other being an lxc &#8220;VM&#8221;. The plan is to make the Physical host our primary Mailserver (lets call it server1) and the VM (lets call that server2) the secondary via DNS, so that when server1 goes down, server2 could take over until we&#8217;ve got the other one up and running again.As wit<\/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\/173dabf42177173c8f9cc17b05a1aebb?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\npkyeck<br \/>\nmongodb node.js database-replication mongoose<br \/>\ni have installed mongodb (1.8.3) on two seperate servers and set them up to use &#8220;replica sets&#8221; as found here: http:\/\/www.mongodb.org\/display\/DOCS\/Replica+Set+Tutorialeverything looks good so far: one server is recognized as primary, one as secondary (when i access them via commandline).the problem is that i can&#8217;t connect to the DB using node.js (0.4.10) and mongoose (2.1.0) like this:var mongo = require(&#8216;mongoose&#8217;); mongo.connectSet(&#8216;mongodb:\/\/host\/dbname,mongodb:\/\/host2\/dbname&#8217;);i always get th<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/63cead946e4d83b2330733e5400e7a63?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nRajesh Chamarthi<br \/>\noracle database-replication<br \/>\nI am trying to run an initial load as shown in the tutorial at http:\/\/www.oracle.com\/webfolder\/technetwork\/tutorials\/obe\/fmw\/goldengate\/11g\/GGS_Sect_Config_WinUX_ORA_to_WinUX_ORA.pdf and I am seeing this error in the REPLICAT process.I have tried using the SOURCEDEFS clause as well (Even though the source and Target structures are exactly similar), but I run into the same issue.** Run Time Messages **2011-04-14 12:02:15 GGS ERROR 171 Unknown data type received &lt;0x54 49&gt;.The only other Indi<\/li>\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>Msonic c# asp.net mysql I&#8217;m building very simple search engine for a job site. It has 3 optional input fields, term, category and employer. Term and employer fields are text input and category is dropdown list. Search logic is very stupid, complicated and not scalable but this search is meant to be used just one [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,1],"tags":[],"class_list":["post-2944","post","type-post","status-publish","format-standard","hentry","category-magento","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/2944","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=2944"}],"version-history":[{"count":1,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/2944\/revisions"}],"predecessor-version":[{"id":9050,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/2944\/revisions\/9050"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=2944"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=2944"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=2944"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}