Also,
run "SHOW PROCESSLIST", to see what sql's are running on slave.
This will give u any idea if any huge dml was run on master and its getting
sync'd with slave.
regards
anandkl
On Fri, Mar 26, 2010 at 8:25 PM, Jim Lyons wrote:
> A few things to keep in mind:
>
> 1: the master may have seve
A few things to keep in mind:
1: the master may have several threads feeding into the binlog at a time,
but a slave only executes in a single thread. Are you throwing more stuff
at the slave in multiple mysql threads?
2: is there something else going on with the slave box? some big backup or
gz
Hi,
MySQL replicate the databases at SQL level, so if the two servers are
using the same engine (innodb), they will be replicated without
problems.
If the BLOB data is big, don't configure the replication over a WAN or
you will get too much latency (of course, it depends on your
bandwidth).
2009
ore than once.
>-Original Message-
>From: Daevid Vincent [mailto:dae...@daevid.com]
>Sent: Wednesday, May 20, 2009 4:49 PM
>To: mysql@lists.mysql.com
>Cc: 'Gavin Towey'; 'Claudio Nanni'
>Subject: RE: mySQL slave IO Running and SQL Running
>
>Well, in 9
y [mailto:gto...@ffn.com]
> Sent: Wednesday, May 20, 2009 1:20 PM
> To: Claudio Nanni; Daevid Vincent
> Cc: mysql@lists.mysql.com
> Subject: RE: mySQL slave IO Running and SQL Running
>
> Please note that this is *NOT* a way to "get them synched again"
>
> In fact
re just masking
problems.
-Original Message-
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Wednesday, May 20, 2009 12:49 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: mySQL slave IO Running and SQL Running
Yeah Daevid! I know very well the issue!
first set th
Yeah Daevid! I know very well the issue!
first set the slave to READ ONLY
[mysqld]
read-only
then there is a configuration option to tell the server to skip some type of
errors automatically
slave-skip-errors=
http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld
my sql version is
mysql> select version();
+--+
| version()|
+--+
| 5.0.24a-standard-log |
+--+
1 row in set (0.00 sec)
linux kernel 2.6.11.6
Changying Li <[EMAIL PROTECTED]> writes:
> I set a master and a slave, master s
On Fri, Apr 18, 2008 at 7:06 PM, Ben Clewett <[EMAIL PROTECTED]> wrote:
> Check the error.log on both server and client, should show where connected
> and disconnected.
>
> Or write a small program to execute SHOW SLAVE STATUS every minute and log
> the results. Which I belive is done for you in
Check the error.log on both server and client, should show where
connected and disconnected.
Or write a small program to execute SHOW SLAVE STATUS every minute and
log the results. Which I belive is done for you in the MySql dashboard
program suit.
Ben
Kaushal Shriyan wrote:
Hi
Is there
> Hi
> Is there a way to find out when the MySQL Slave has been restarted.
> Thanks and Regards
> Kaushal
You can determine the server actions by looking through the slave log
file.
David
2007 6:53:17 PM (GMT+0530) Asia/Calcutta
Subject: Re: MySQL slave error when creating view
Sounds like a bug to me. It's likely fixed in newer versions; a lot of
view/function/sproc replication bugs have been fixed. But if not, you should
report it.
Tim Lucia wrote:
> Nobody has any idea
Sounds like a bug to me. It's likely fixed in newer versions; a lot of
view/function/sproc replication bugs have been fixed. But if not, you should
report it.
Tim Lucia wrote:
Nobody has any idea(s) on this?
-Original Message-
From: Tim Lucia [mailto:[EMAIL PROTECTED]
Sent: Friday,
Nobody has any idea(s) on this?
> -Original Message-
> From: Tim Lucia [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 06, 2007 7:11 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL slave error when creating view
>
>
> I ran the following DDL on our master today:
>
> CREATE OR REPLACE VIEW R
There is an option starting in 4.0.14 called read-only that will allow
only the slave i/o thread and users with the super priv to execute write
queries.
Jeremiah Gowdy wrote:
Is there a way to make MySQL Slaves read only in regards to all UPDATE, INSERT,
DELETE, DROP, TRUNCATE, etc, except
On Thu, Oct 25, 2001 at 06:53:28PM -0500, William Robbins wrote:
> I am getting this error message on my slave server
>
> 011025 16:46:14 mysqld started
> /usr/local/mysql/libexec/mysqld: ready for connections
> 011025 16:46:14 Slave thread: error connecting to master: Unknown MySQL
> Server Ho
16 matches
Mail list logo
