Re: Problem after replication switchover

Поиск
Список
Период
Сортировка
От Lars Arvidson
Тема Re: Problem after replication switchover
Дата
Msg-id AM3PR06MB497590A3A40143C8EBDDC07E3900@AM3PR06MB497.eurprd06.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Problem after replication switchover  (Alan Hodgson <ahodgson@lists.simkin.ca>)
Список pgsql-general
> If it's just storing the logs, I doubt it's the cause of the problem. You can ignore my message. I had too much fun
fightingwith Gluster recently. 
Hehe, hope you came through on top ;).  Anyways, I added an md5sum calculation in the archiving script just to be able
toverify that the files don't get corrupted. From what I can tell this far they have not been corrupted but I'll keep
aneye on it. 

> I reread your original full post, and the one thing that stuck out for me was "the clusters are now replicating from
eachother". I feel like that could be a problem. But someone more intimate with the replication might want to input on
that.
Would be nice with some input on that. I do think it is the way to go for ensuring that two cluster are in synch when
switchingmaster (although I cannot remember the source of that information). Josh Berkus writes a bit about cycles in
replication(http://www.databasesoup.com/2013/01/cascading-replication-and-cycles.html) and writes "temporary cycle is a
legitimatepart of a transition between two different replication setups". 

> Other than that, I wonder if you just have a hardware problem with your storage.
We use fusionio ssd cards for storage. If there is something wrong with them I would expect more problems than I am
currentlyexperiencing, and more random problems... 

/Lars


В списке pgsql-general по дате отправления:

Предыдущее
От: Rakesh Kumar
Дата:
Сообщение: Re: Trying to understand page structures in PG
Следующее
От: Christoph Moench-Tegeder
Дата:
Сообщение: Re: Non-default postgresql.conf values to log