205 reputation
28
bio website isubapp.com
location San Francisco, CA
age 28
visits member for 3 years, 8 months
seen Aug 6 at 18:29

I'm an independent developer with a systems and database administration background. Especially interested in touch interfaces and networked applications.

I develop iOS apps using Objective-C and CocoaTouch, Android apps using Java and the Android SDK, some server side code in PHP and Java, some client side web code in JavaScript (primarily using JQuery), HTML, and CSS, and just recently I've been working with C# and the Mono framework for platform agnostic development that doesn't require a JRE install.

My media streaming app for iOS: http://isubapp.com

My GitHub page: https://github.com/einsteinx2


Mar
25
comment How, and when, do I add servers for my website?
Then, any time you need to add more slaves (or do backups) you don't have to turn off your master server. You just turn off the slave server, clone the data to another server (becomes second slave) and turn them both back on. You can create many slave servers this way. So then you can have different slave servers handle the read loads for different processes/parts of the site and for backups.
Mar
25
comment How, and when, do I add servers for my website?
So you mean if you already have a web server and a database server, how to you expand to more database servers? Now my experience is specifically with MySQL, but I'm sure it's similar with other DBMS's. It's actually pretty simple, but it requires a little site downtime (can do at 4am or something). 1. Turn off db server. 2. Copy the data files for the database to new slave server. 3. Configure new slave server to replicate from original master server. 4. Turn on master. 5. Turn on slave. Now they will be in sync and the slave will get all changes from the master.
Mar
24
awarded  Editor
Mar
24
revised How, and when, do I add servers for my website?
added ascii art; added 7 characters in body; deleted 1 characters in body
Mar
24
answered How, and when, do I add servers for my website?