Bookmark and Share
Last Updates
Display: 1 - 7 of 7, Total Pages: 1
1
[Blog] MySQL replication got problems on now() [Original] 2010-2-27 4:20pm

The values of the column 'lastModified' are different on the master and the slave.

Read Full Article...

Section:MySQL DBA | Read:561 | Comment:0 | Rating:0%

[Work Notes] Implementing MySQL Database Replication (step by step) [Original] 2009-10-16 3:15pm
Master:IP1, Slave: IP2Master site (IP1)1, Reconfigure a new my.cnf.bak file under /etc    Using my-large.cnf as a model file, change the following item 1)    key_buffer..

Read Full Article...

Section:MySQL DBA | Read:2711 | Comment:0 | Rating:0%

[Work Notes] MySQL dual-master replication [Original] 2009-8-19 12:59pm
By using auto_increment_increment and auto_increment_offset, we can configure a master-to-master replication. -- auto_increment_increment  controls the interval between successive column va..

Read Full Article...

Section:MySQL DBA | Read:2176 | Comment:0 | Rating:0%

[Work Notes] [ERROR] Got error 127 when reading table [Original] 2009-8-18 11:18am
I optimized a base table of a merge table. Later on I got the error 127 on the merge table. And in mysqld.log, it says that merge table is corrupt and needs to be repaired. I tried to optimize table,..

Read Full Article...

Section:MySQL DBA | Read:2605 | Comment:0 | Rating:0%

[Work Notes] ERROR 1033 (HY000): Incorrect information in file [Original] 2009-8-18 11:03am
This error is related to innoDb. You could get this error if you change the size of the innodb logs, change the home directory of innodb_data_file_path, change the size of innodb_data_file_path, etc...

Read Full Article...

Section:MySQL DBA | Read:4022 | Comment:0 | Rating:0%

[Blog] Replication problems caused by [Original] 2009-6-3 10:47am

Slave keeps getting error on the following statements.

INSERT INTO users_logins_first_tmp (logon_date, user_id)   SELECT MIN(logon_date) as logon_date, user_id     FROM users_logins2     WHERE user_id IN (-1, 717, 721, 723, 751, 753, 755, 757, 772,

INSERT INTO users_logins_first_tmp (logon_date, user_id)    SELECT MIN(logon_date) as logon_date, user_id     FROM users_logins2     GROUP BY user_id

INSERT INTO derived_unanswered_questions (question_id)   SELECT  question_id     FROM questions     where not exists (select question_id from mails3 where mails3.question_id = questions.question_id)

Read Full Article...

Section:MySQL DBA | Read:1767 | Comment:0 | Rating:0%

[Blog] 快速修复mysql replication [Original] 2005-8-20 9:47pm

有时来自master的一些bad queries会破坏了mysql replication,下面这个小技巧能在不重新restart mysql slave的情况下修复replication.

Read Full Article...

Section:MySQL DBA | Read:867 | Comment:0 | Rating:0%

1
Latest Comments
eozzrixrlo

on line..
- By admin, 2008-4-24 2:34am
rvaqlckrdu

free nud..
- By admin, 2008-4-24 2:33am
xndfjmwcpj

- By admin, 2008-4-5 1:02pm
vsjblsgatm

somali p..
- By admin, 2008-4-5 1:01pm
jknsdsmvyi

- By admin, 2008-3-12 1:48am
fkgyuchizk

tramadol..
- By admin, 2008-3-12 1:48am
wnniqpohsg

- By admin, 2008-4-24 2:32am
unxnmahoya

in phent..
- By admin, 2008-4-24 2:29am
bkgulrjbtt

- By admin, 2008-3-12 1:47am