/ \ / \ 3 <---2 Thank for you answer, Matt... [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => <461559fa$0$27369$ba4acef3@news.orange.fr> [ref] => <4612ab5a$0$5086$ba4acef3@news.orange.fr> [htmlstate] => on_nl2br [postusername] => matt [ip] => matt@mata.com [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 3 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> tion - MySQL

tion - MySQL

Hello, I'm french so sorry for my english. I do a tion in ring like this : 1 / \ / \ 3 ----2 1 is slave of 3 and master of 2 2 is slave of 1 and master of 3 3 is slave of 2 and master of 1 It's ok, no problem. But I want to put 1 serveur like this 1 ------ 4 / \ / \ 3 ----2 4 is slave of 1 but 1 can't be master of 4 because it's master of 2. How i can do that on mysql 5.1 ? Have ...

  1. #1

    Default tion

    Hello,

    I'm french so sorry for my english.

    I do a tion in ring like this :


    1
    / \
    / \
    3 ----2

    1 is slave of 3 and master of 2
    2 is slave of 1 and master of 3
    3 is slave of 2 and master of 1

    It's ok, no problem. But I want to put 1 serveur like this

    1 ------ 4
    / \
    / \
    3 ----2


    4 is slave of 1 but 1 can't be master of 4 because it's master of 2.

    How i can do that on mysql 5.1 ?

    Have you some idea ?

    thanks for you answer,

    Matt...
    matt Guest

  2. #2

    Default Re: tion

    matt schrieb: 

    No, there is no problem. AFAIK, to-be-a-master is only definded at the
    slave's side. A master needs to maintain a bin-log, which is also
    necessary for #2.
    If 4 is a copy of 2 it would work ... but better 4 has its own id!


    Michael
    werner Guest

  3. #3

    Default Re: tion

    werner bauer a écrit : 
    >
    > No, there is no problem. AFAIK, to-be-a-master is only definded at the
    > slave's side. A master needs to maintain a bin-log, which is also
    > necessary for #2.
    > If 4 is a copy of 2 it would work ... but better 4 has its own id!
    >
    >
    > Michael[/ref]

    Hello,

    Ok, I'm french and I don't understand.

    I want to that the data insert in 1 was insert in 4 (and in 2) and the
    data insert in 4 was insert in 1 (and in 2).


    <------
    1 4
    ------>
    / \
    / \
    3 <---2

    Thank for you answer,

    Matt...
    matt Guest

  4. #4

    Default tion

    Hi

    Early phase of looking at database tion, and I'm wondering if
    the following is possible.

    I would like a local copy and a web copy of my database which sync
    with each other - in short making them both master/slave with neither
    the specific one.

    I basically want my PC to have a copy of our live DB and then be able
    to use an Access/ODBC interface to access the local one - which will
    naturally be much quicker than the web hosted version.

    Thats just one reason - but I'm interested to check it can be done.

    Many thanks

    A

    UKuser Guest

  5. #5

    Default Re: tion

    On 8 May, 15:25, UKuser <co.uk> wrote: 

    Ignore me - it can be done. I use SQLyog and there is a wizard to help
    you do it in there!

    UKuser Guest

  6. #6

    Default tion

    Hello,

    I don't seem to get a definite answer: is there a community version of
    MySQL that supports tion? Or is it only for MySQL:AB users?

    Thanks for your reply.
    Alex

    parahumanoid Guest

  7. #7

    Default I meant enterprise editions

    What I meant was whether this feature is accessible only on paid
    versions of mysql server.

    parahumanoid Guest

  8. #8

    Default Re: I meant enterprise editions

    parahumanoid wrote: 
    tion is available to all users. you can download the community
    version and start using it.

    --
    lark -- net
    To reply to me directly, delete "despam".
    lark Guest

Similar Threads

  1. Forced tion in File tion Services
    By James in forum Windows Server
    Replies: 0
    Last Post: July 16th, 03:45 PM
  2. tion
    By Kalle in forum Oracle Server
    Replies: 3
    Last Post: October 30th, 02:08 PM
  3. One way tion
    By Tony Do in forum IBM DB2
    Replies: 1
    Last Post: August 21st, 03:10 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139