How to set up MySQL replication
How to set up MySQL replication. And for debugging purpose, it will be great if I can run multiple MySQL instances on a single host.
To set up MySQL replication, check these tutorials:
Similar Posts
Port forwarding on local host
ByQ AI am trying to forward UDP port 500 to 2500 on local host, but can’t get this to work – I have run: iptables -t nat -A PREROUTING -p udp -d 192.168.1.10 –dport 500 -j DNAT –to-destination 192.168.1.10:2500 iptables -A FORWARD -p udp -d 192.168.1.10 –dport 2500 -j ACCEPT where 192.168.1.10 is the IP of…
MySQL at Facebook
ByQ AFacebook uses lots MySQL databases. Any information about how Facebook scales MySQL? Some information on the Web: MySQL at Facebook’s page https://www.facebook.com/MySQLatFacebook?filter=1 A post by Ryan Thiessen, Database Operations at Facebook on Quora: http://www.quora.com/Facebook-Engineering/How-does-Facebook-structure-MySQL-so-that-it-is-robust-and-scalable And more: http://mashable.com/2011/12/15/facebook-timeline-mysql/ http://gigaom.com/2011/12/06/facebook-shares-some-secrets-on-making-mysql-scale/ http://www.wired.com/wiredenterprise/2011/12/facebook-timeline-anatomy “A lot of people are surprised that for this shiny new thing for Facebook, we’re using…
How to Debug a Bash script?
ByEric MaHow to debug a Bash script if it has some bugs? Common techniques like printing varibles out for checking apply for bash too. For bash, I also use 2 bash-specific techniques. Use errexit option Run the script with -e option like bash -e your-script.sh or add set -o errexit to the beginning of the script….
How to save PuTTY profiles/sessions?
ByQ APuTTY is a great SSH client on Windows. However, how to save it’s profiles/sessions that I saved so that I can migrate my settings from one machine to another? PuTTY saves its settings in the registry of Windows. You can find it in the registry editor by run regedit under: HKEY_CURRENT_USERSoftwareSimonTatham You can save your…
How to debug media print view of Web page in Firefox?
ByEric MaHow to debug the media print view set by @media print {} in CSS of Web pages in Firefox? In firefox, after opening the Web page, First, hit “Shift + F2” to open the “Developer Toolbar” at the bottom. Second, in the “Developer Toobar”, input media emulate print and Firefox will show the print view…
Squeezing Space in LaTeX – SysTutorials QA
ByQ AHow to squeeze space in Latex? A good tutorial about “squeezing space in LaTex” in here from the Cambridge University’s website: http://www.eng.cam.ac.uk/help/tpl/textprocessing/squeeze.html These settings work great for me: setlength{textfloatsep}{1pt} setlength{abovecaptionskip}{1pt} setlength{belowcaptionskip}{1pt} A more aggressive configuration to squeeze space in a LaTex doc: % save space usepackage{enumitem} setlist{nolistsep} % no space between refs usepackage{bibspacing} setlength{bibspacing}{baselineskip} usepackage[small,compact]{titlesec}…