PowerPoint Presentation

Size: px

Start display at page:

Download "PowerPoint Presentation"

或全
8 years ago
Views:

1 2014/12/18 19:30 开讲, 票价 200 报名后加 QQ 群 Odoo 部署

2 预告 Q: 其他主题, 敬请期待 Odoo 安装与部署 [Linux] Odoo 消息与邮件 Odoo Security Odoo 自动化 CRM 客户关系管理销售管理采购管理库存管理会计与财务生产管理补货 HR 人力资源管理项目管理品质管理售后服务支持知识管理零售终端 POS /12/17 jeffery 2

3 Odoo Architecture Front-end pages Back-end JS client User Interface HTTP Routing C ontrollers (Front-end, Back-end) Business Logic (Apps) M essaging,notifications (mail) C ontrollers M odels ORM PostgreSQL Store Persistence

4 Deployment Architecture Single server, multi-process HTTP worker Requests HTTP worker HTTP worker Cron worker gevent worker PostgreSQL Store Rule of thumb: --workers=$[1+$cores*2]

5 Deployment Architecture M ulti-server, multi-process HTTP worker HTTP worker HTTP worker Requests Load balancer Cron worker gevent worker PostgreSQL Store HTTP worker HTTP worker HTTP worker Cron worker gevent worker

6 PostgreSQL o Is the real workhorse of your Odoo server o Powers large cloud services o Can handle terabytes of data efficiently o Should be fine-tuned to use your hardware o Cannot magically fix algorithmic/complexity issues in [y]our code!

7 PostgreSQL Deployment o Use PostgreSQL 9.2/9.3 for performance o Tune it: o Avoid deploying PostgreSQL on a VM o If you must,optimize the VM for IOPS o Check out vfabric vpostgres 9.2 o Use separate disks for SYSTEM /DATA/WAL o shared_buffers:more than 55%VM RAM o Enable guest memory ballooning driver

8 Hardware Sizing o 2014 recommandation for single user server for up to ~100 active users o IntelXeonE5 2.5Ghz6c/12t (e.g. E5-1650v2) o 32GB RAM o SATA/SAS RAID-1 o On Odoo online, this spec handles 3000 dbs with a load average 3

9 Transaction Sizing o Typical read transaction takes ~100ms o A single process can handle ~6 t/s o 8 worker processes =~50 t/s o 1 interactive user =~50 t/m peak =~1 t/s o Peak use with 100 users =100 t/s o On average, 5-10% of peak =5-10 t/s

10 Linux Vs Windows Linux 支持 multi processing 稳定操作难 Linux 逼格高 Windows 高富帅 Windows 操作容易 python 有时会 crash 不支持 multi processing

11 Package vs Source code Package nightly build[ Deb RPM Windows installer 简单, 难以控制, 适合测试 Source code - github [ git repo zip package 复杂, 灵活性, 方便控制, 适合生产环境

12 Mobaxterm Pgadmin 工具推荐

13 准备环境安装软件 sudo apt-get update sudo apt-get install openssh-server sudo apt-get install python sudo apt-get install postgresql 创建用户 sudo adduser --system --home=/opt/odoo --group odoo sudo su - postgres createuser --createdb --username postgres --nocreaterole --no-superuser --pwprompt odoo

14 PostgreSQL 调整 /etc/postgresql/9.3/main [Ubuntu] Restart Service PostgreSQL\9.3\data [Windows] postgresql.conf # FILE LOCATIONS data_directory = '/var/lib/postgresql/9.3/main hba_file = '/etc/postgresql/9.3/main/pg_hba.conf' ident_file = '/etc/postgresql/9.3/main/pg_ident.conf external_pid_file = '/var/run/postgresql/9.3-main.pid' listen_addresses = '*' port = 5432 max_connections = 100 unix_socket_directories = = '/var/run/postgresql pg_hba.conf # IPv4 local connections: host all all /32 md5 host all all x.x.x.x/x md5

15 取得源码 Zip 源码包 wget Git repository git clone --depth 1 --branch single-branch. Or git clone git pull # update to date

16 Ref. odoo/requirements.txt 安装 python lib [Ubuntu] apt-get update apt-get install python-dateutil python-feedparser pythongdata python-ldap python-libxslt1 python-lxml pythonmako python-openid python-psycopg2 python-pybabel python-pychart python-pydot python-pyparsing pythonreportlab python-simplejson python-tz pythonvatnumber python-vobject python-webdav pythonwerkzeug python-xlwt python-yaml python-zsi pythondocutils python-psutil wget python-unittest2 pythonmock python-jinja2 python-dev libpq-dev poppler-utils python-pdftools python-pypdf python-setuptools pythonpybabel

17 Ref. odoo/requirements.txt 安装 python lib [windows]

18 启动 Odoo Builtin server # init script to startup Gevent # 入口 odoo/openerp-gevent Prefork # 入口 odoo/openerp-server & workers <> 0 Threaded # 入口 odoo/openerp-gevent & workers = 0 Configurations config file options WSGI application # bundle with http server like Nginx, Apache # 入口 odoo/openerp-wsgi.py

19 odoo 配置 # top security admin_passwd # 数据库 db_host db_port db_user db_password # 第三方模块 addons_path # 多进程 workers # 日志相关 log_level logfile logrotate 多租户模式 SaaS dbfilter Behind proxy proxy_mode More ref /reference/cmdline.html

20 Why and how Nginx Why Security Performance How https Static file cache gzip /etc/nginx [Ubuntu] nginx/conf [windows] nginx.conf http { gzip on; } site.conf location / { proxy_pass } location /longpolling { proxy_pass } location ~* /web/static/ { proxy_pass }

21 性能优化工具 1. dstat 2. pgadmin 3. yslow 手段 1. tune configuration 2. standalone DB 3. tune DB 4. tune http performance, eg gzip, cache

22 其他升级 db Python openerp-server c odoo.conf -u modules d db_name stop-after-init 初始化 db Python openerp-server c odoo.conf -i modules d db_name stop-after-init PDF 打印 Wkhtmtltopdf > 12.1 dpkg i 加入到 PATH, 重启服务中文支持 apt-get install ttf-wqy-zenhei ttf-wqy-microhei Bug fix openerp/report/render/rml2pdf/customfonts.py 在 TTFSearchPath[] 中增加文泉译字体路径 '/usr/share/fonts/truetype/wqy', 并在 list_all_sysfonts() 方法中, 将搜索表达式 '*.[Tt][Tt][Ff]' 改为 '*.[Tt][Tt][Ffc]'

23 dbfilter runbot SaaS

24 QA

Azure_s

Azure_s Azure ? Azure Azure Windows Server Database Server Azure Azure Azure Azure Azure Azure Azure Azure OpenSource Azure IaaS Azure VM Windows Server Linux PaaS Azure ASP.NET PHP Node.js Python MS SQL MySQL