Re: MySQL Replication Error
I was about to reply with a long message of all the steps I followed to create replication but I did my steps about an hour ago and I have not seen the replication fail so far. BTW, I created my replication following the info on this web page: http://crazytoon.com/2008/01/29/mysql-how-do-you-set-up-masterslave-replication-in-mysql-centos-rhel-fedora/ THANKS!!! Nestor On Wed, Dec 5, 2012 at 3:35 AM, Johan De Meersman wrote: > - Original Message - > > From: "divesh kamra" > > > > slave-skip-errors=1062 ---> in my.cnf and restart mysql > > Really? Just like that? Without even knowing what it does or what the > problem is? > > If you have replication errors, this kind of stuff is only going to break > it further. "It exists" is not an indication of fitness for any specific > use, and that kind of option is really only for use in very very specific > cases where you KNOW what's wrong and KNOW that it's not harmful in your > highly specific situation. > > > -- > Linux Bier Wanderung 2012, now also available in Belgium! > August, 12 to 19, Diksmuide, Belgium - http://lbw2012.tuxera.be > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql > >
Re: MUltiple value in single insert is not working in mysql procedure
2012/12/03 19:10 +0530, amit Problem mysql> call mobile_series1('(99889988),(12334565)'); You are expecting MySQL to turn one string operand into twain number operands. That does not happen, unless you use PREPARE, which, I suspect, is not part of your homework. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: MySQL Replication Error
2012/11/30 Néstor > I am trying to set up mysql replication on 2 systems but Once I get it > going, I get the following an error 1062, > > > I have re-installed the database on the slave also to see if this fixes the > problem > but after a few minutes I get the same error. I have repeated the > replication from the > beginning but I get the same problem after a while. > > Does anyone know a way to fix this? > > Hello, How did you build the slave from the master? How did you decide in which position the slave should start replicating from? You might want to try pt-table-checksum ( http://www.percona.com/doc/percona-toolkit/2.1/pt-table-checksum.html) to see what else do you have broken. Manuel. -- Manuel Aróstegui Systems Team tuenti.com
Re: MySQL dying?
- Original Message - > From: "Anthony Pace" > > I have heard that due to Oracle taking over, the OS community is > shifting to other type of DB's . I think the question has long been answered. However, out of curiosity (and because they are the questions you should ask yourself anyway), *who* have you heard that from, and what might they not have told you? :-) I can imagine there's zealots from pretty much every database that will be claiming similar things about every project they see as a competitor to be stamped out. Hell, Monty himself has been scaremongering plenty around the time Oracle announced the takeover. -- Linux Bier Wanderung 2012, now also available in Belgium! August, 12 to 19, Diksmuide, Belgium - http://lbw2012.tuxera.be -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: replication problem
On 12/3/2012 7:24 AM, Trimurthy wrote: hi list, i am trying to set up replication but i couldn't complete because of the following error Could not find first log file name in binary log index file can any one please help me. ... snipped ... This one should have been easy for the list to advise you about. Let me step in to keep things on track. For each instance of MySQL that creates binary logs there will be an 'index' file that keeps track of which files this instance is managing. For example, if the binary logs are called "mysql-bin.00", then the index file will be called "mysql-bin.index" What has happened is that the contents of the index file no longer matches the inventory of actual binary logs present on disk. They have either been moved, erased, or had their permissions changed so that the system user that the mysqld daemon executes as can no longer see them. The solution is to manually update the .index file with the current listing of binary log files. The longer term solution is to stop manually removing binary log files and allow the system to perform that for you with a PURGE BINARY LOGS command. When you have MySQL do the purging, the .index file will be automatically updated. For more details about the binary log, please read: http://dev.mysql.com/doc/refman/5.5/en/binary-log.html -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: MySQL Replication Error
- Original Message - > From: "divesh kamra" > > slave-skip-errors=1062 ---> in my.cnf and restart mysql Really? Just like that? Without even knowing what it does or what the problem is? If you have replication errors, this kind of stuff is only going to break it further. "It exists" is not an indication of fitness for any specific use, and that kind of option is really only for use in very very specific cases where you KNOW what's wrong and KNOW that it's not harmful in your highly specific situation. -- Linux Bier Wanderung 2012, now also available in Belgium! August, 12 to 19, Diksmuide, Belgium - http://lbw2012.tuxera.be -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: MySQL dying?
MySQL runs the internet. Go ahead kill it. I dare you. On Tue, Dec 4, 2012 at 11:18 PM, Karen Abgarian wrote: > MySQL, like all other products, can be peachy or bitchy. Good ones, they > also die.Wish I was kidding :-) > > > On Dec 4, 2012, at 2:37 PM, Andrés Tello wrote: > > > Are u kidding? > > > > Mysql is dead easy and damn good... obviously it has its perks, but any > database engine has them... (I'm looking at you DB2)... > > > > There has been a lot of improvements lately, I "feel" that mysql is > moving much more faster under oracle umbrella than when it was alone... > > > > Replication... omg, replicacion is DEAD easy! so easy, that usually you > doublecheck things just because you are unsure that is SO easy... > > > > Partitioning, views, storeprocedures, explain and analise are good > enough... it simply work... I never, ever had a database corruption (I'm > looking at to you Mssql!) ... > > > > I have tables with more the 5millon rows, noproblem, I have a table with > more than 40 millon rows... and of course I have troubles, but always, > always been resolved... > > > > Mysql is... wonderful, it just works... You want it to "work as a > storage with out integrity?", done.. with integrity? done, replicaion, > encryption, secure connections, partition... name your feature! > > > > > > > > > > > > > > > > > > > > On Tue, Dec 4, 2012 at 12:50 PM, Singer Wang > wrote: > > Lol! Good point Karen! > > > > > > On Tue, Dec 4, 2012 at 1:02 PM, Karen Abgarian wrote: > > > > > A touch of realism: we are all dying. For some, it may take a while, > > > hopefully. > > > > > > On 04.12.2012, at 9:53, Tim Pownall wrote: > > > > > > > Mysql is used by just about every web host and is one of the most > common > > > > database servers around the world. I do not have any intent to stop > using > > > > mysql unless they start charging for it which I do not think will > happen. > > > > > > > > Thanks, > > > > > > > > Tim Pownall > > > > Sr. Linux Systems Monitoring > > > > Hostgator.com LLC > > > > > > > > On Tue, Dec 4, 2012 at 11:45 AM, Anthony Pace < > anthony.p...@utoronto.ca > > > >wrote: > > > > > > > >> I have heard that due to Oracle taking over, the OS community is > > > shifting > > > >> to other type of DB's . > > > >> > > > >> Any thoughts? > > > >> > > > >> -- > > > >> MySQL General Mailing List > > > >> For list archives: http://lists.mysql.com/mysql > > > >> To unsubscribe:http://lists.mysql.com/mysql > > > >> > > > >> > > > > > > > > > > > > -- > > > > > > > > Thanks, > > > > > > > > Tim Pownall > > > > GNU/Linux Systems Monitoring > > > > 610-621-9712 > > > > pownall...@gmail.com > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe:http://lists.mysql.com/mysql > > > > > > > > > >