You can see connecting to master means it is not able to establish the
connection from slave to master, give the grants as (replication client
etc..)
and then try again.
Thanks,
Dilipkumar
Database Engineering
Pager mail:9884430...@nma.vodafone.in
-Original Message-
From: Jeetendra Ranjan
Hi,
I am getting this information from slave
mysql> show slave status \G;
*** 1. row ***
Slave_IO_State: Connecting to master
Master_Host: 201.107.236.77
Master_User: root
Master_Port: 33
Yep, It might not be needed to sync, but its better to double check ;).
Carlos
On 12/23/2009 2:44 PM, Claudio Nanni wrote:
In this case it should not be needed to sync the slave,
Resetting the master basically broke the 'pipe' but events are still
on the new binary logs, it might have lost s
Thank you guys for the tips.
I've also updated the documentation so others don't run into this:
http://dev.mysql.com/doc/refman/5.0/en/reset.html
> -Original Message-
> From: prabhat kumar [mailto:aim.prab...@gmail.com]
> Sent: Wednesday, December 23, 2009 12:46 PM
> To: Carlos Proal
>
*Next time look for 'purge binary logs'!*
Purge may also cause problem , before doing purge make sure slave is in sync
with master or at least cross check slave currently which bin file getting
sync.
On Thu, Dec 24, 2009 at 2:05 AM, Carlos Proal wrote:
>
> The issue is that replication relies on
In this case it should not be needed to sync the slave,
Resetting the master basically broke the 'pipe' but events are still on the
new binary logs, it might have lost some event in some unfortunate case, but
anyway it is probably for now to put slave back on track, check and
eventually resync.
Cia
The issue is that replication relies on this logs !!!, so when you
deleted them .
Generally speaking you have to:
> stop the slave
> sync the master with the slave (there are several ways to do this and
depending how busy is your master)
>grab the master status (position)
>change the sla
That was a wrong operation to do.
Anyway, issue a show master status, and set the replucation again on the
slave with the new values. Next time look for 'purge binary logs'!
Ciao
Claudio
On 23 dec 2009 21:21, "Daevid Vincent" wrote:
I got an alert that one of the drives was filling up (3% free).
I got an alert that one of the drives was filling up (3% free). So I
figured out that a large chunk was from /var/log/mysql
r...@pse10:~# find / -type d -print0 | xargs -0 -n1 du -sk | sort -rn |
head -n20 > ~/dir-sizes.txt
r...@pse10:~# cat ~/dir-sizes.txt
159121012 /
70442396 /var
70127764 /v
Hey.
Back to few years ago, InnoDB require table level locking when
inserting auto-increment PK to the table, and Heikki said there will
be a fix.
Is this problem still exist now?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
>-Original Message-
>From: Mikhail Berman [mailto:mikhail...@gmail.com]
>Sent: Wednesday, December 23, 2009 9:16 AM
>To: Eva
>Cc: mysql@lists.mysql.com
>Subject: Re: help design the table
>
>Hi Eva,
>
>It seems to me that you might want to have two tables that will describe
>data in your da
Hi Eva,
It seems to me that you might want to have two tables that will describe
data in your database
* - DOMAINS
* - IPS
DOMAINS table should contain two fields:
* `domain_key` - auto-increment
* `domain_name` - varchar(20)
IPS table should contain three fields
domain_key - int(10) - being
Hello,
I have a table, which has a column named as "domain", each domain has
some IPs, each IP has two attributes: "disabled","noticed".
For example, the table:
domainIP
www.aol.com 64.12.245.203 64.12.244.203 64.12.190.33 64.12.190.1
But I don't know how to control the IP's att
Hi
I am running collectd
(http://www.collectd.org/wiki/index.php/Plugin:MySQL) version 4.9.0 on
Ubuntu Linux 8.04 (Hardy) Server.
Host "localhost"
User "nagios"
14 matches
Mail list logo
