What is Digg?Sponsored by Best Buy
Geek Squad employee sings for Best Buy in holiday campaign. view!
youtube.com/bestbuy0 - Valerie DeAngelo explains the moment she got the casting call.
19 Comments
- xptical, on 10/12/2007, -0/+2Much better to use something like DRBD. It's basicly a way to run RAID1 over a network connection. Place all your conf files, the database storage file, and /var/www all on the virtual device then have it sync across the network. If a server goes down, the head-end load-balancing proxy will automagically drop over to the next box in the series.
Check it out at http://www.drbd.org/ - theajaysharma, on 10/12/2007, -0/+1replication is great for backups. You can easily lock the slave database, take a full mysqldump (that may take hours), then unlock it so that it can sync up with the master. Plus, you can throw some select queries at the slave instead of them all hitting the master to speed things up.
--Ajay - cakefart, on 10/12/2007, -0/+1A couple of commenters are confusing checkpoints and clustering with replication.
If anyone would like more information (on the differences) than what you get out of a quickstart/HOWTO, I'd suggest using MySQL's or Zawodny's guide as well. (Those two explain how to parameters work, and why the settings are what they are.) - hans51, on 12/31/2008, -0/+1Not so sure about that - because ...
1.
I have never done it on WIN
but
all the howto replicate commands are mysql commands and NO WIN or Linux based commands
2.
you use IP to connect one mysql server to another in my.conf
all else is mysql to mysql communication
3.
hence as far as I see - I could imagine that mysql replication could work across different OS
as long as BOTH mysql installs are similar in version-age ( better current / updated versions )
hence if you have a need to do above on WIN - give it a try, chances are it works
just have a look at your BOTH ends firewall settings if any to assure open communication from master to slave
else
you still have the option to migrate to Linux - its now easier than ever before
http://digg.com/microsoft/Instant_solution_to_Inte ...
and may make life much easier - pvera, on 10/12/2007, -0/+0Good catch. +digg
- Claymore, on 10/12/2007, -0/+0@pr0t3st
Yes... it is in the human gene to know how to replicate a MySQL database. Nobody should need to learn something like that for the first time. :P - pr0t3st, on 10/12/2007, -1/+1I thought everyone knew how to do this...
- barium, on 10/12/2007, -0/+0I found this guide both interesting and useful, too bad I don't have any need for replication ATM. I didn't think it was this easy to do it though.
- h4cked, on 10/12/2007, -0/+0Too bad it's not that easy to do on a Windoze box.
- invader, on 10/12/2007, -0/+0definitely not news, but it will save me some research a month or two from now.
- pr0t3st, on 10/12/2007, -0/+0@dknighton
Thank god there are people like you who are able to deduce so much from so very little. A screen name for example. Maybe if I posted "White Power!" you would have voted my comment +3 Excellent?
@Claymore
I know, I know....It is an important tutorial. I dugg it. That was just my way of saying that this was old news and known throughout the MySQL community. - soleblazer, on 10/12/2007, -0/+0Great tutorial. I use this extensively to replicate small mysql servers to different parts of the US and UK. If you have applications that can use mysql as its config file location (as we do), it offers very easy and simple way to make changes in one place and have all the nodes instantly pick it up.
- Gargoyle, on 10/12/2007, -0/+0Not really anything new but it is a nice and clean how-to
+digg - soyverde, on 10/12/2007, -0/+0While it's not exactly new, this will definitely save me some time in the near future...digg++
- rivviepop, on 10/12/2007, -0/+0I tried to add a comment to that article but can't see where it shows up; in short, the article is missing some very important safety configurations on the master, and doesn't load the data on the slave in the appropriate manner.
I suggest that anyone really wanting to do this read:
http://dev.mysql.com/doc/refman/4.1/en/replication-howto.html
This digg'd howto looks to have been written by someone who "just did it" and not by someone who runs MySQL databases on a normal basis on a lot of servers. You're gonna get yourself in trouble if you only use this person's howto. YMMV. - andreizilla, on 10/12/2007, -0/+0This _could_ be used for backup, but I think this is better used for asynchronous applications running on different servers but using the same database.
- bvaughn, on 10/12/2007, -0/+0http://digg.com/linux_unix/How_To_Set_Up_Database_Replication_In_MySQL
- dknighton, on 10/12/2007, -1/+1"I thought everyone knew how to do this..."
In addition to the "check spelling" button in the comment box, there should be a "check stupidity level" button. It would prevent st00pid l33t hax0rs like pr0t3st from posting idiot tripe like that comment.
I will repeat the obvious for the benefit of half-wits like you, pr0t3st...not everyone knows what you do, and not everyone finds the same tasks simple and easy. Just because it may be easy for you, doesn't mean that a good tutorial isn't needed.
I really loathe elitist bastards like you. - inactive, on 10/12/2007, -1/+0got it +++ digg
---------------------------
http://ezbuzz.blogspot.com/
© Digg Inc. 2009
— Content created and posted by Digg users is