All,
Thanks for your replies and as per the advise I switched to row-based
replication but replication ended with below error.
*Last_Error: Error 'Table 'b.sdefrent' doesn't exist' on query. Default
database: 'b. Query: 'drop table sdefrent'*
above error is due to non existence of database an
> **On master server I have two databases *A and B*. App team use database B
> temporarily for there application to compute calculation and insert the
> values on A database.
For certain statements you could start with "SET SQL_BIN_LOG=0" so it
doesn't log that statement, and it won't be replicat
On Thu, Jan 27, 2011 at 10:40 AM, Nagaraj S wrote:
> **On Slave Server I replicate database *A alone* and my replication not
> working due to data fetching happen on B database.
>
Well, yes. Statement-based replication does what it says on the box: it
executes the exact same statement on the sla
I have setup mysql replication with below scenario
**On master server I have two databases *A and B*. App team use database B
temporarily for there application to compute calculation and insert the
values on A database.
**On Slave Server I replicate database *A alone* and my replication not
Hi All,
I set this parameters on master & slave
SET GLOBAL log_bin_trust_function_creators = 1;
Then i applied a script that creates procedure and function. It got created
on master, but on slave i am getting below error and procedure and function
are not getting created on slave.
select ROUTINE_
Thanks for the response.
We can't afford to lose information, and I don't like doing dangerous
things.
I guess it's time to rebuild the slave.
David
Gleb Paharenko wrote:
Hello.
Other than rebuilding the slave from a backup of the master, is there
any way to get the replication backup
Hello.
> Other than rebuilding the slave from a backup of the master, is there
> any way to get the replication backup up?
Have you tried to stop a slave and then start with SQL_SLAVE_SKIP_COUNTER = n,
as suggested at:
http://dev.mysql.com/doc/mysql/en/replication-problems.html
But if
We have a master-slave setup in production.
The master is running on a dual-Opteron with SuSE 8 SLES.
The slave is running on a dual Xeon with SuSE 9.
Both run MySQL 4.0.20
We recently moved our traffic database to the machine and started
writing additional traffic (perhaps as much as 600,000 inse
What causes this error when trying to replicate mysql server:
020711 10:50:50 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'jupiter-bin.001' at
position 1262
020711 10:50:50 Error reading packet from server: log event entry
exceeded max_allowed_packet - increa
