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

[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.


Why using M-M replication?
The book of High performance Mysql says it is not a reliable mechanism.

Regards.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

innodb_flush_log_at_trx_commit

[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:http://lists.mysql.com/mysql?unsub=arch...@jab.org

about auto_increment id

[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 database automatically.

Will this cause problem?

Thanks.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: about auto_increment id

[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 will be 1000.

 Oops. I meant :

 After executing the SQL statement, the next Id inserted will be 1001.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

innodb backup

[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