Hello List,
On 8/26/2010 3:00 PM, Daevid Vincent wrote:
ssh to the slave
mysql -uroot -pPASSWORD -P3306 -hlocalhost
show slave status\G
If the Slave IO is NOT Running, but SQL is, then simply try to restart the
slave...
*** 1. row ***
ssh to the slave
mysql -uroot -pPASSWORD -P3306 -hlocalhost
show slave status\G
If the Slave IO is NOT Running, but SQL is, then simply try to restart the
slave...
*** 1. row ***
Slave_IO_State:
Master_Host: 10.10.10.45
I don't think there's anything inherently wrong with the way you've designed
your table to store your match data. I don't have experience designing
these kinds of applications, so maybe some others might have better advice
for you. If you find your reporting is too slow or it is too awkward to
qu
Just convert your binary log file into sql file using mysqlbinlog tools and
search the deleted record between 12 AM to 2 AM and reinsert it.
Jeetendra Ranjan
MySQL DBA
--- On Thu, 26/8/10, Kranthi wrote:
From: Kranthi
Subject: RE: Recover Records
To: "'Jangita'"
Cc: mysql@lists.mysql.com
D
Nunzio,
Nunzio Daveri wrote:
> Hello gurus, I am trying to install the perl-DBD-MySQL and each time I get
> this
> error message. Any ideas? I have tried it on a Sun X4150 (Dual Quad Cored
> Intel) and a Sun X4200 (Dual Dual Core Opteron) both on CentOS 4.8. I have
> tried to install and b
Quoting jitendra ranjan :
Hi,
The best way to use sync the master and slave is using mk-checksum
tools. just google it and use the the tools for online sync of
master and slave.
Jeetendra Ranjan
MySQL DBA
Yes, data integrity isnt guaranteed with MySQL replication. So if you
want to b
Quoting Ananda Kumar :
Smith,
I never said, this wont work.Some times, there are chances of lossing data.
regards
anandkl
If you have experience of this fair enough. Theres no reason it should
make any difference, as everything is based upon the binlog file and
position...
--
MySQL
Just convert your binary log file into sql file using mysqlbinlog tools and
search the deleted record between 12 AM to 2 AM and reinsert it.
Jeetendra Ranjan
MySQL DBA
--- On Thu, 26/8/10, Kranthi wrote:
From: Kranthi
Subject: RE: Recover Records
To: "'Jangita'"
Cc: mysql@lists.mysql.com
Hi,
The best way to use sync the master and slave is using mk-checksum tools. just
google it and use the the tools for online sync of master and slave.
Jeetendra Ranjan
MySQL DBA
--- On Thu, 26/8/10, Norman Khine wrote:
From: Norman Khine
Subject: master-slave replication sync problems.
T
Smith,
I never said, this wont work.Some times, there are chances of lossing data.
regards
anandkl
On Thu, Aug 26, 2010 at 8:48 PM, wrote:
> Quoting Norman Khine :
>
> i see, so the best is to just stop slave and then check the master
>> status, and when the master status syncs then i start t
Quoting Norman Khine :
i see, so the best is to just stop slave and then check the master
status, and when the master status syncs then i start the slave?
Well Im willing to hear from others experiences, but if you really
shouldnt have to do anything. If you want you can issue a stop slav
Hello gurus, I am trying to install the perl-DBD-MySQL and each time I get this
error message. Any ideas? I have tried it on a Sun X4150 (Dual Quad Cored
Intel) and a Sun X4200 (Dual Dual Core Opteron) both on CentOS 4.8. I have
tried to install and build with MySQL 4.x on the box and then re
Quoting Jerry Schwartz :
-Original Message-
From: Jacob Steinberger [mailto:trefal...@realitybytes.net]
I have a requirement to keep track of a set of data, and all changes
that might occur. In order to do this, for each field of the data set,
I've created a table that keeps track of the
Yes,
You need to note down the master bin-log file name and position on the
slave, this is a must.
regards
anandkl
On Thu, Aug 26, 2010 at 7:34 PM, Norman Khine wrote:
> i see, so the best is to just stop slave and then check the master
> status, and when the master status syncs then i start
i see, so the best is to just stop slave and then check the master
status, and when the master status syncs then i start the slave?
On Thu, Aug 26, 2010 at 3:09 PM, wrote:
> That is really bad, you will loose changes.
>
> You shouldnt have to do anything when rebooting either the master or sla
>-Original Message-
>From: Jacob Steinberger [mailto:trefal...@realitybytes.net]
>Sent: Wednesday, August 25, 2010 8:36 PM
>To: mysql@lists.mysql.com
>Subject: Complicated SQL Query
>
>I have a requirement to keep track of a set of data, and all changes
>that might occur. In order to do thi
True,
But some times, this does not work and u need to know the master bin-log
file and position to start, so that there is no loss of data.
regards
anandkl
On Thu, Aug 26, 2010 at 6:39 PM, wrote:
> That is really bad, you will loose changes.
>
> You shouldnt have to do anything when rebooting
That is really bad, you will loose changes.
You shouldnt have to do anything when rebooting either the master or
slave. If the master is down, then the slave recieves no updates. If
the slave is down, when it comes back up it checks the master log pos
and plays thro any changes that are nec
since u r starting slave by postion beyond master, and if some of the
changes are already present on slave, it would error out with duplicate.
You need
show slave status\G;
slave stop;
show slave status\G;..wait for few min..than again
show slave status\G;just to make sure...slave is in comple
hello,
i have a working master-slave replication, the problem i find is that
if i restart the MASTER there is a difference in the MASTER_LOG_FILE
and MASTER_LOG_POS on the SLAVE.
what is the correct way to keep the two slaves in sync even after i
restart the server. the way i do it now is to:
[MA
Hi!
SQL Maestro Group announces the release of PHP Generator for MySQL
10.8, a GUI frontend that allows you to generate high-quality PHP
scripts for the selected MySQL tables, views and queries for the
further working with these objects through the web.
http://www.sqlmaestro.com/products/mysql/php
Thank u Janqita, I can get
Regards ,
Kranthi
-Original Message-
From: Jangita [mailto:jang...@jangita.com]
Sent: Thursday, August 26, 2010 3:33 PM
To: mysql@lists.mysql.com
Subject: Re: Recover Records
On 26/08/2010 11:35 a, Kranthi wrote:
> Hi all,
>
> My database size
On 26/08/2010 11:35 a, Kranthi wrote:
Hi all,
My database size is 1gb.I take backup at 12 am and unfortunately
I deleted 8 records at 2 am . I checked 8 records in 12 am backup , that 8
records are not there, I think that 8 records inserted between 12 am to 2
am. I am maintaining lo
Hi all,
My database size is 1gb.I take backup at 12 am and unfortunately
I deleted 8 records at 2 am . I checked 8 records in 12 am backup , that 8
records are not there, I think that 8 records inserted between 12 am to 2
am. I am maintaining log file how can I recover particular recor
Inventions come from need.
Congratulations and thank you for sharing your science,
Its very interesting.
May be useful for other uses.
Claudio
On Aug 26, 2010 9:11 AM, "Jangita" wrote:
> On 26/08/2010 4:31 a, Jacob Steinberger wrote:
>> I found an answer without having to worry about complicated
On 26/08/2010 4:31 a, Jacob Steinberger wrote:
I found an answer without having to worry about complicated SQL
statements - it's more about managing the tables than the SQL.
Jacob
I usually just turn on binary logging, that way I have a record of
anything that changes in the entire database an
26 matches
Mail list logo
