On Thu, Oct 7, 2010 at 4:12 PM, Matthew Barr <mb...@mbarr.net> wrote: > Ok, a few basic questions.
Basic Answers... > What's the workload? What portion of the db access is read vs write? What > portions of write traffic is US west vs other locations? Currently 90% US but we expect it to become 50% US, 30% SG, 20% Spain. The majority of it is read, but we also have collaboration projects that have a lot of writes. > You also mentioned file access time - could you describe that problem a bit > more? Files are primarily served though either CIFS (samba) or HTTP (Web CMS) and files can be very large, up to 1GB. Rough estimates show that a 200ms latency increases the download time by up to 20%, proportionally larger for smaller files. > Basically, if you've got a reasonably normal CMS, much of the traffic is > read. You've already got asiapac datacenter space, so some replication > techniques may be able to get big wins. Mysql slaves, prepositioning files > via sync or CDN, some global load balancing tricks... This is the direction that we have been trying to move in. But lately funding and manpower have been an issue. I believe my real challenge is educating the COs about risk and cost, but I also need to know if what they are asking for is even remotely possible. > Cloud won't help- you've already got 2 sites, and aren't utilizing them. And two more sites without datacenters. I can put slaves and caching server is Singapore, which will help Korea, but I can't do anything about Spain. -- Perfection is just a word I use occasionally with mustard. --Atom Powers-- _______________________________________________ Tech mailing list Tech@lopsa.org http://lopsa.org/cgi-bin/mailman/listinfo/tech This list provided by the League of Professional System Administrators http://lopsa.org/
