Results 1 to 7 of 7

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered 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;

  2. #2
    Registered User singularity's Avatar
    Join Date: Apr:2003
    Location: Ñîôèÿ
    Posts: 3,382
    ignore list:Java,våelio,jaredharet,gochev.george,Nit rogenium
    Quis custodiet ipsos custodes?

  3. #3
    Registered 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;

  4. #4
    Registered User singularity's Avatar
    Join Date: Apr:2003
    Location: Ñîôèÿ
    Posts: 3,382
    Ðåïëèêàöèÿòà å ìàëêî ñïåöèôè÷íà è ìå ñúìíÿâà äà ãî èìà íÿêúäå ñäúâêàíî. À êàòî ïðèáàâèø è ÷àñòíèòå ñëó÷àè - íàé-äîáðå å äà ïðåãëåäàø manuala, çà äà íå áúäåø èçíåíàäàí íåïðèÿòíî.
    Îáúðíè âíèìàíèå íà ñèíõðîíèçàöèÿòà íà ÷àñîâíèöèòå íà master/slave ìàøèíèòå !
    ignore list:Java,våelio,jaredharet,gochev.george,Nit rogenium
    Quis custodiet ipsos custodes?

  5. #5
    Registered 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;

  6. #6
    Registered User singularity's Avatar
    Join Date: Apr:2003
    Location: Ñîôèÿ
    Posts: 3,382
    êîíôèãóðàöèÿòà çà master/slave òè å â my.cnf
    Èäåÿòà å â ìîìåíòà â êîéòî èìà ïðîìÿíà ïî áàçàòà, òàçè ïðîìÿíà äà áúäå ðåïëèêèðàíà â slave áàçèòå ( ò.å. íå å íà îïðåäåëåíî âðåìå )
    ignore list:Java,våelio,jaredharet,gochev.george,Nit rogenium
    Quis custodiet ipsos custodes?

  7. #7
    Registered 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;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 Õàðäóåð ÁÃ. Âúçìîæíî å ñúäúðæàíèåòî íà òàçè ñòðàíèöà äà å îáåêò íà àâòîðñêè ïðàâà.
iskamPC.com | mobility.BG | Bloody's Techblog | Êðèïòîâàëóòè è ìàéíèíã | 3D Vision Blog | Ìàãàçèí çà åëåêòðîííè öèãàðè