TalkPHP - View Single Post

Wildhoney · 12-04-2007, 04:06 AM

I think what Bluesaga is getting is that when you lock a table, you prevent the opposite to what you're doing from happening. So you cannot INSERT and SELECT. So if you use 2 tables for the 2 different purposes, and then move the data from the slave to the active database periodically, then at least the data is safe for if the power fails on one of the databases servers. Although I'm guessing there are other reasons, too.

12-04-2007, 04:06 AM	#6 (permalink)
Wildhoney La Vida es Sueño Join Date: Sep 2007 Location: Oldham Posts: 2,280 Thanks: 90	I think what Bluesaga is getting is that when you lock a table, you prevent the opposite to what you're doing from happening. So you cannot INSERT and SELECT. So if you use 2 tables for the 2 different purposes, and then move the data from the slave to the active database periodically, then at least the data is safe for if the power fails on one of the databases servers. Although I'm guessing there are other reasons, too. __________________ The man who comes back through the Door in the Wall will never be quite the same as the man who went out.