150 reputation
110
bio website
location
age
visits member for 2 years
seen Jul 20 '13 at 5:25

Dec
24
comment Mysql replication - Error No. 1146&1062
From WIKIPEDIA: Multi-master replication can be contrasted with master-slave replication, in which a single member of the group is designated as the "master" for a given piece of data and is the only node allowed to modify that data item. Other members wishing to modify the data item must first contact the master node. Allowing only a single master makes it easier to achieve consistency among the members of the group, but is less flexible than multi-master replication.
Dec
24
comment Mysql replication - Error No. 1146&1062
read this article buddy. The difference b/w MasterMaster and MasterSlave is described there. In MasterMaster Both of you're servers are master, no diff which one you commit to, but in MasterSlave story is different.
Dec
24
comment Mysql replication - Error No. 1146&1062
and what exactly do you mean by :" You can't make a master-master replication on same databases?". Isn't the whole concept of replication to replicate data of ONE database?
Dec
24
comment Mysql replication - Error No. 1146&1062
Master master replication is pretty simple IMHO, and yes I know how to setup a simple replication. It's just the Primary key which I wanted to be ODD numbers on one master and EVEN on the other one, which I figured how to do so. Unfortunately I cannot post an answer on my own post... it has not been 8 hours since I post my question. Thanks for nothing though :)
Dec
24
comment Mysql replication - Error No. 1146&1062
I didn't put the logbin pos, and I didn't get error, (I got query ok for all of them). And getting master status showed me the pos....How can I tell if it was the good pos?
Dec
24
comment Mysql replication - Error No. 1146&1062
After setting up the replication, I create a database on "Master-1" and added a table and some row, I could see the new database on "Master-2", but doing the same from "Master-2" would not update "Master-1" i.e I can't see the changes I have done in "Master-2" from "Master-1".
Dec
24
asked Mysql replication - Error No. 1146&1062
Dec
22
comment MySQL my.cnf vs my-huge.cnf
Thank you for the detailed answer. For the replication I'm setting up a master-master though. The process should share lots of steps with master-salve I think... Thanks anyway.
Dec
22
awarded  Scholar
Dec
22
accepted MySQL my.cnf vs my-huge.cnf
Dec
19
awarded  Student
Dec
19
awarded  Editor
Dec
19
revised MySQL my.cnf vs my-huge.cnf
fixed gramaticall problem
Dec
19
asked MySQL my.cnf vs my-huge.cnf