Re: Master Master Replication ... do a fail over and a week agos data is revealed.

2010-10-19 Thread short cutter
2010/10/18 Brent Clark brentgclarkl...@gmail.com: Hiya I run MySQL Master - Master Replication. Ive had an interesting situation whereby I failed over using heartbeat but whats is interesting  is that via the application (vbulletin), I see that the forums was showing that a weeks ago data.

innodb_flush_log_at_trx_commit

2010-10-16 Thread short cutter
Hello, Does innodb_flush_log_at_trx_commit = 1 or 2 make a busy mysql server bad performance? We found that setting it to 0 will make disk IO decrease a lot. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

about auto_increment id

2010-10-16 Thread short cutter
Hello, I have a table which has the ID key with auto_increment and which is a primary key. If I insert the table with the id value which is generated by the program, for example, insert table (id, user_name, age) values (1000, 'kenn', 30); the value 1000 is inserted forcely, not generated by

Re: about auto_increment id

2010-10-16 Thread short cutter
Hi, Is it possible to change this directive's value without modifition to my.cnf and restart mysqld? I remember there is a set @@variable syntax, but not sure. Thanks. 2010/10/17 mos mo...@fastmail.fm: At 08:55 PM 10/16/2010, you wrote: After executing the SQL statement, the next Id inserted

innodb backup

2010-10-08 Thread short . cutter
Hello, Is there any good document for backup of InnoDB? includes the increment backup and full backup. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org