`

Some tips from the architeture of StackOverflow

阅读更多

Definition(from Scaling up vs. Scaling out ):
scaling up -- a seriously big iron single server.
scaled out -- Hadoop or MapReduce style, across lots and lots of inexpensive servers.
Other factors(per year):
software licensing: if using all open source software, close to zero.
power cost.

Scaling up and scaling out are both viable solutions, depending on what problem you're trying to solve, and what resources (financial, software, and otherwise) you have at hand.

Some tips:
1. Chose proper database architeture. The Wikipedia database design need to be refactoring to avoid excessive joins in a lot of key queries. This is the key lesson from giant multi-terabyte table chemas (like Google’s BigTable) which are completely join-free.
2. CPU speed is surprisingly important to the database server. Going from 1.86 GHz, to 2.5 GHz, to 3.5 GHz CPUs causes an almost linear improvement in typical query times.
3. Key cost when scaling out. At low server volume, the key cost driver is not rackspace, power, bandwidth, servers, or software; it is NETWORKING EQUIPMENT. You need a gigabit network between your DB and Web tiers. Between the cloud and your web server, you need firewall, routing, and VPN devices. The moment you add a second web server, you also need a load balancing appliance. The upfront cost of these devices can easily be 2x the cost of a handful of servers.
4. Applications should keep state in the database so they scale horizontally by adding more servers.


分享到:
评论

相关推荐

    Principles of Computer Architeture

    ### 计算机架构原理概览 #### 一、引言与概述 计算机架构是现代数字计算机设计的核心,它定义了计算机系统的工作原理及其组成部分之间的交互方式。《计算机架构原理》这本书旨在为读者揭示现代数字计算机内部工作的...

    arm.zip_VxWorks ARM_arm intArchLib_vxworks 2410_vxworks bsp_vxw

    This the architeture source of the arm of VxWorks 5.5. This Zip file contain ARM archetitectire specfic code for VxWorks. it is useful in making VxWorks ARM BSP.

    RF Architectures of Transceivers

    ### 射频收发器架构与数字信号处理 #### 一、引言 在现代通信系统中,射频(RF)收发器是至关重要的组件之一。这些设备负责无线信号的接收与发射,并且通常涉及复杂的射频架构与数字信号处理技术。...

    MPC56xx-Power Architeture MCU for Automotive.pdf

    ### MPC56xx系列:汽车应用的Power Architecture MCU MPC56xx系列微控制器(MCU)由Freescale Semiconductor公司设计与制造,专为汽车电子系统提供高性能、高集成度的解决方案。该系列MCU基于Power Architecture...

    react-clean-architeture

    6. **Inversion of Control (IoC) 容器**:在Clean Architecture中,依赖关系的注入是关键。TypeScript支持依赖注入,使得对象的创建和依赖关系的管理更加容易,同时也便于单元测试。 7. **测试**:由于Clean ...

    api-nodejs-clean-architeture-tdd

    标题中的"api-nodejs-clean-architeture-tdd"表明这是一个关于使用Node.js构建API的项目,其中融入了清洁架构原则,并采用了测试驱动开发(TDD)方法。在这个项目中,我们将深入探讨如何利用JavaScript(标签)来...

    Intel64 and IA-32 Architectures Volume 1 Basic Architecture.pdf

    Intel64和IA-32架构是英特尔公司开发的两种微处理器架构。IA-32架构,也就是常说的x86架构,是在1978年推出的32位微处理器架构,是英特尔早期的成功产品。而Intel 64架构,也称为x86-64或AMD64(因为AMD也参与开发)...

    clean-node-api:API em Node.js utilizando Typescript,Clean Architeture,TDD eprincípiosSOLID

    **标题与描述解析** 标题和描述提到了"clean-node-api",这是一个基于Node.js构建的API,使用了TypeScript作为编程语言,同时采用了Clean Architecture设计原则、Test-Driven Development(TDD)测试驱动开发方法...

    车联网综述

    此外,还包括SAE(Society of Automotive Engineers)、ISOCALM、ARIB等不同国家和地区组织制定的标准和协议。在实际的智能交通系统(ITS)项目中,美国、日本和欧洲都展开了大量与车联网相关的研究项目和试点工程。...

    BackEnd-Store-TS-TDD-SOLID-estudo

    #BackEnd-Store-TS-TDD-SOLID-estudo #Tecnologias: 节点JS 打字稿笑话亚马逊S3 穆特尔表示Este projetoéum cadastro de produtos,TDE概念的准入门级打字稿,Clean Architeture和SOLID 例子文件.env例子文件.env...

    xilinx-01-7-Series Architecture Overview

    xilinx7系列FPGA主要包括:Spartan®-7/Artix®-7/Kintex®-7/Virtex®-7。其性能/密度/价格也随着系列的不同而提升。其中以Virtex-7有着极高的系统性能和资源

Global site tag (gtag.js) - Google Analytics