Results 1 to 7 of 7
Thread: MySQL ðåïëèêàöèÿ
Hybrid View
-
15th January 2007 17:08 #1Registered User
Join Date: Aug:2002
Location: Ñîôèÿ
Posts: 3,765
MySQL ðåïëèêàöèÿ
Èñêàì äà ïóñíà ðåïëèêàöèÿ íà áàçèòå, äà ñòàâà ìåæäó íÿêîëêî êîìïþòúðà ñ èíñòàëèðàí MySQL.
Ðàçáðàõ äî òóê, ÷å èìàìå åäèí master ñúðâúð îò êîéòî ñå ðàçïðîñòðàíÿâà íà îñòàíàëèòå, êîèòî òðÿáâà äà ñå slave. Àêî ìîæå íàêðàòêî êàê ñòàâà, çàùîòî ïðè òúðñåíå ìè èçëèçàò äîñòà íåùà, à îò SQL íå ðàçáèðàì è ùå îòíåìå âðåìå äà ÷åòà íàðåä.
Âñè÷êè ìàøèíè ùå ñà ñ Windows è âåðñèÿ 5.1 íà MySQL.R5 5600G; Asus TUF Gaming B450 PRO II; 2 x 16 GB ADATA XPG@3200 MHz; Kingston NV1 1TB; Seasonic 500W Core Series;
-
15th January 2007 17:53 #2
Åòî òóê å îïèñàíî:
http://dev.mysql.com/doc/refman/5.1/en/replication.htmlignore list:Java,våelio,jaredharet,gochev.george,Nit rogeniumQuis custodiet ipsos custodes?
-
15th January 2007 17:58 #3Registered User
Join Date: Aug:2002
Location: Ñîôèÿ
Posts: 3,765
Å è àç ïúðâî äî òîâà ñòèãíàõ, àìà ìè ñå èñêàøå ïî - êðàòêî îïèñàíèå. Êàêòî è äà å, óòðå ùå ãî ïðîáâàì.
R5 5600G; Asus TUF Gaming B450 PRO II; 2 x 16 GB ADATA XPG@3200 MHz; Kingston NV1 1TB; Seasonic 500W Core Series;
-
15th January 2007 19:21 #4
Ðåïëèêàöèÿòà å ìàëêî ñïåöèôè÷íà è ìå ñúìíÿâà äà ãî èìà íÿêúäå ñäúâêàíî. À êàòî ïðèáàâèø è ÷àñòíèòå ñëó÷àè - íàé-äîáðå å äà ïðåãëåäàø manuala, çà äà íå áúäåø èçíåíàäàí íåïðèÿòíî.
Îáúðíè âíèìàíèå íà ñèíõðîíèçàöèÿòà íà ÷àñîâíèöèòå íà master/slave ìàøèíèòå !ignore list:Java,våelio,jaredharet,gochev.george,Nit rogeniumQuis custodiet ipsos custodes?
-
1st February 2007 18:13 #5Registered User
Join Date: Aug:2002
Location: Ñîôèÿ
Posts: 3,765
Äîáðå, èìàì íàïðåäúê, ñëåä êàòî íàïðàâèõ Master åäíàòà ìàøèíà, íàñòðîèõ äðóãàòà äà å Slave, è êàòî íàïèñàõ LOAD DATA FROM MASTER ñè èçäúðïà áàçàòà.
À àâòîìàòè÷íî ëè ñòàâà òàçè ðåïëèêàöèÿ (òîâà ìè å öåëòà âñúùíîñò), è ïðåç êîëêî âðåìå ñå îáíîâÿâà? Èëè ñàìî ïðè ïðîìåíè â áàçàòà? Êàê äà ñå íàãëàñè òîâà?R5 5600G; Asus TUF Gaming B450 PRO II; 2 x 16 GB ADATA XPG@3200 MHz; Kingston NV1 1TB; Seasonic 500W Core Series;
-
3rd February 2007 18:53 #6
êîíôèãóðàöèÿòà çà master/slave òè å â my.cnf
Èäåÿòà å â ìîìåíòà â êîéòî èìà ïðîìÿíà ïî áàçàòà, òàçè ïðîìÿíà äà áúäå ðåïëèêèðàíà â slave áàçèòå ( ò.å. íå å íà îïðåäåëåíî âðåìå )ignore list:Java,våelio,jaredharet,gochev.george,Nit rogeniumQuis custodiet ipsos custodes?
-
3rd February 2007 20:30 #7Registered User
Join Date: Aug:2002
Location: Ñîôèÿ
Posts: 3,765
Äà ìåðñè, ðàçáðàõ âå÷å ÷å ðàáîòè.
R5 5600G; Asus TUF Gaming B450 PRO II; 2 x 16 GB ADATA XPG@3200 MHz; Kingston NV1 1TB; Seasonic 500W Core Series;




Reply With Quote
Íå âúçìîæíîñò äà èçêëþ÷à êîìïþòúðà
7th May 2023, 16:02 in Îáù ôîðóì çà PC õàðäóåð