145 reputation
110
bio website
location
age
visits member for 1 year, 10 months
seen Jul 20 '13 at 5:25

Dec
29
comment MySQL Replication and High Availability
I looked into DRBD today, and correct me if I'm wrong, bit it seems it is a very complex approach, and recovering data after failover with DRBD is scary... I was wondering aren't any simpler way of doing this? Like configuring pacemaker and corosync to take care of fail-over, and have mysql to take of replication? (I'm just trying to show a demo to some customers and see what is their reaction, in case I get positive feed back I can assign more resource on it, and do the best approach. I'm just looking for some easy-to-setup approach, rather busy with other stuff than lazy to set DRDB up)
Dec
29
comment MySQL Replication and High Availability
I wish I could have up voted your answer twice :) thank you again once again.
Dec
29
comment MySQL Replication and High Availability
Do I need to use any other 3rd party application to do the fail-over for me (switch to other server in case of failure) or does XtraDB would do it for me?
Dec
29
comment MySQL Replication and High Availability
Thank you for your complete answer, I'm using InnoDB, so I guess I would go for DRBD... they have lots of documentation on their website as well. But about the Replication lag in Master-Master mode which you've mentioned... would it be very obvious if you have both your nodes in the same geographic place, and have them connected through cable?
Dec
25
comment Mysql replication - Error No. 1146&1062
what if I store data with diff ID (even on one server, and odd on the other one)? plus I'm not going to use it like that, I'm gonna use some sort of load balancing strategy: either write with one and read with the other, or have one of them like hot standby, or... any how, as I wrote in my question, I'm just playing around to learn...
Dec
25
comment Mysql replication - Error No. 1146&1062
This is wrong man! I have SRV_A and SRV_B, and I have only one DB on both with only one table in it! No difference which server I commit my changes to, it would be replicate on the other server as well.
Dec
25
comment Mysql replication - Error No. 1146&1062
I think what you don't get is, naturally while one node is committing changes, obviously it's master and the other node is its slave. But the other one can be master if you just connect to it! What I'm trying to say is, master-master replication is a two-way master-slave replication. Each node is master and slave to the other node, no fixed "role".
Dec
25
comment Mysql replication - Error No. 1146&1062
mfouilleul, I'm trying to learn here dude, and there are many stuff I don't know about... but correct me if I'm wrong! Isn't a database a collection of data sets? so same databses is different with same data sets? Beside, what I setup yesterday (I call it master-master replication cause thats what it calls, you can call it wtv though) which gives me the ability to write on ONE table of ONE database from TWO different nodes(masters) and changes are done to the SAME database on both NODES!
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
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.