{"id":261992,"date":"2015-07-21T19:17:02","date_gmt":"2015-07-21T15:17:02","guid":{"rendered":"http:\/\/savepearlharbor.com\/?p=261992"},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T21:00:00","slug":"","status":"publish","type":"post","link":"https:\/\/savepearlharbor.com\/?p=261992","title":{"rendered":"PostgreSQL 9.3 + Pgpool-II"},"content":{"rendered":"<p>             \u0420\u0435\u0448\u0438\u043b \u043f\u043e\u0434\u0435\u043b\u0438\u0442\u044c\u0441\u044f \u0441 \u0432\u0430\u043c\u0438 \u043e\u043f\u044b\u0442\u043e\u043c \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u043a\u043b\u0430\u0441\u0442\u0435\u0440\u0430 PostgreSQL 9.3, \u0441\u043e\u0441\u0442\u043e\u044f\u0449\u0435\u0433\u043e \u0438\u0437 \u0434\u0432\u0443\u0445 \u043d\u043e\u0434, \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435\u043c \u043a\u043e\u0442\u043e\u0440\u043e\u0433\u043e \u0437\u0430\u043d\u0438\u043c\u0430\u0435\u0442\u0441\u044f pgpool-II, \u0431\u0435\u0437 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f Stream Replication (WAL). \u041d\u0430\u0434\u0435\u044e\u0441\u044c, \u043a\u043e\u043c\u0443-\u043d\u0438\u0431\u0443\u0434\u044c \u0431\u0443\u0434\u0435\u0442 \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u043e.<\/p>\n<p>  \u0421\u0445\u0435\u043c\u0430:<\/p>\n<p>  <img decoding=\"async\" src=\"http:\/\/s019.radikal.ru\/i601\/1507\/72\/9a31703173ce.png\" alt=\"image\"\/><\/p>\n<p>  \u041a\u0430\u043a \u0412\u044b \u043f\u043e\u043d\u0438\u043c\u0430\u0435\u0442\u0435, \u044d\u0442\u043e \u0431\u0443\u0434\u0443\u0442 \u0434\u0432\u0430 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e \u0441\u0442\u043e\u044f\u0449\u0438\u0445 \u0441\u0435\u0440\u0432\u0435\u0440\u0430, \u043a\u043e\u0442\u043e\u0440\u044b\u043c\u0438 \u0431\u0443\u0434\u0435\u0442 \u0443\u043f\u0440\u0430\u0432\u043b\u044f\u0442\u044c pgpool-II.<\/p>\n<p>  \u041a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u044f \u043d\u043e\u0434 \u0441 PostgreSQL:<br \/>  \u041e\u0431\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u0438\u0434\u0435\u043d\u0442\u0438\u0447\u043d\u044b \u043f\u043e \u0441\u0432\u043e\u0438\u043c \u0430\u043f\u043f\u0430\u0440\u0430\u0442\u043d\u044b\u043c \u0441\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0449\u0438\u043c.  <\/p>\n<ul>\n<li>4vCPU;<\/li>\n<li>16 \u0413\u0431 \u043f\u0430\u043c\u044f\u0442\u0438;<\/li>\n<li>CentOS 6.5;<\/li>\n<\/ul>\n<p>  \u0414\u0438\u0441\u043a\u0438:  <\/p>\n<ul>\n<li>50 \u0413\u0431 \u2014 \u0441\u0438\u0441\u0442\u0435\u043c\u0430;<\/li>\n<li>100 \u0413\u0431 \u2014 pg_xlog<\/li>\n<li>500 \u0413\u0431 \u2014 \u043a\u0430\u0442\u0430\u043b\u043e\u0433 \u0441 \u0434\u0430\u043d\u043d\u044b\u043c\u0438<\/li>\n<\/ul>\n<p>  \u041f\u0440\u0438\u043c\u0435\u0440,  <\/p>\n<pre> Filesystem      Size  Used Avail Use% Mounted on \/dev\/sda3        48G  7.4G   38G  17% \/ tmpfs           7.8G     0  7.8G   0% \/dev\/shm \/dev\/sda1       194M   28M  157M  15% \/boot \/dev\/sdb1        99G  4.9G   89G   6% \/var\/lib\/pgsql\/9.3\/data\/pg_xlog \/dev\/sdc1       493G  234G  234G  50% \/var\/lib\/pgsql\/9.3\/my_data <\/pre>\n<p>  \u041a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u044f \u043d\u043e\u0434 \u0441 pgpool-II:  <\/p>\n<ul>\n<li>4vCPU;<\/li>\n<li>8 \u0413\u0431 \u043f\u0430\u043c\u044f\u0442\u0438;<\/li>\n<li>CentOS 6.5;<\/li>\n<\/ul>\n<p>  \u0414\u0438\u0441\u043a\u0438:  <\/p>\n<ul>\n<li>50 \u0413\u0431 \u2014 \u0441\u0438\u0441\u0442\u0435\u043c\u0430;<\/li>\n<\/ul>\n<p>  \u041f\u0440\u043e \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0443 PostgreSQL \u0432 \u0434\u0435\u0442\u0430\u043b\u0438 \u0432\u0434\u0430\u0432\u0430\u0442\u044c\u0441\u044f \u043d\u0435 \u0431\u0443\u0434\u0443, \u0442\u0430\u043a \u043a\u0430\u043a \u043e\u043d\u0430 \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u0430\u044f.<\/p>\n<p>  \u041d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430 pgpool-II.<br \/>  \u0417\u0430 \u043e\u0441\u043d\u043e\u0432\u0443 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 pgpool-II, \u0432\u0437\u044f\u043b \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u044e \u0441 \u043e\u0444\u0438\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u0433\u043e \u0441\u0430\u0439\u0442\u0430: <a href=\"http:\/\/www.pgpool.net\/pgpool-web\/contrib_docs\/simple_sr_setting2_3.3\/index.html\">www.pgpool.net\/pgpool-web\/contrib_docs\/simple_sr_setting2_3.3\/index.html<\/a><\/p>\n<p>  \u0425\u043e\u0442\u0435\u043b \u0431\u044b \u043e\u0431\u0440\u0430\u0442\u0438\u0442\u044c \u0432\u043d\u0438\u043c\u0430\u043d\u0438\u0435 \u0442\u043e\u043b\u044c\u043a\u043e \u0441\u0430\u043c\u044b\u0435 \u0432\u0430\u0436\u043d\u044b\u0435 \u043c\u043e\u043c\u0435\u043d\u0442\u044b:<br \/>  <a name=\"habracut\"><\/a>  <\/p>\n<pre><code class=\"bash\">#------------------------------------------------------------------------------ # CONNECTIONS #------------------------------------------------------------------------------  # - pgpool Connection Settings -  listen_addresses = '*' port = 9999 socket_dir = '\/tmp' pcp_port = 9898 pcp_socket_dir = '\/tmp' # - Authentication - enable_pool_hba = off pool_passwd = '' log_destination = 'syslog' #------------------------------------------------------------------------------ # REPLICATION MODE (\u0413\u043e\u0432\u043e\u0440\u0438\u043c pgpool, \u0447\u0442\u043e \u0432\u0441\u0435 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u044b\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u043d\u0430\u0434\u043e \u0442\u0440\u0430\u043d\u0441\u043b\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u043d\u0430 \u0432\u0441\u0435 \u043d\u043e\u0434\u044b \u043a\u043b\u0430\u0441\u0442\u0435\u0440\u0430) #------------------------------------------------------------------------------ replication_mode = on replicate_select = on insert_lock = on lobj_lock_table = '' replication_stop_on_mismatch = off failover_if_affected_tuples_mismatch = off #------------------------------------------------------------------------------ # LOAD BALANCING MODE (\u0413\u043e\u0432\u043e\u0440\u0438\u043c pgpool, \u0447\u0442\u043e \u0432\u0441\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u044b SELECT \u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0442\u044c \u043d\u0430 \u0432\u0441\u0435 \u0443\u0437\u043b\u044b \u043a\u043b\u0430\u0441\u0442\u0435\u0440\u0430) #------------------------------------------------------------------------------ load_balance_mode = on ignore_leading_white_space = on white_function_list = '' black_function_list = 'nextval,setval' follow_master_command = '\/etc\/pgpool-II\/failover.sh %d &quot;%h&quot; %p %D %m %M &quot;%H&quot; %P' #------------------------------------------------------------------------------ # FAILOVER AND FAILBACK #------------------------------------------------------------------------------ failover_command = '\/etc\/pgpool-II\/failover.sh %d %P %H %R' failback_command = '' fail_over_on_backend_error = on search_primary_node_timeout = 10 #------------------------------------------------------------------------------ # ONLINE RECOVERY (\u0412 \u0434\u0430\u043d\u043d\u043e\u043c \u0441\u043b\u0443\u0447\u0430\u0435, \u043e\u043d\u043b\u0430\u0439\u043d \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435, \u0432 \u0442\u0435\u0440\u043c\u0438\u043d\u0430\u0445 pgpool, \u043e\u0437\u043d\u0430\u0447\u0430\u0435\u0442 \u0432\u0435\u0440\u043d\u0443\u0442\u044c \u0443\u0437\u0435\u043b \u0432 \u043a\u043b\u0430\u0441\u0442\u0435\u0440 pgpool. \u0415\u0441\u043b\u0438 \u043e\u0434\u043d\u0430 \u0438\u0437 \u043d\u043e\u0434 \u0443\u043f\u0430\u0434\u0435\u0442 \u0438 \u043f\u0440\u043e\u043b\u0435\u0436\u0438\u0442 \u0434\u043e\u043b\u0433\u043e\u0435 \u0432\u0440\u0435\u043c\u044f, \u0442\u043e \u0434\u043e\u0433\u043e\u043d\u0430\u0442\u044c \u044d\u0442\u0443 \u043d\u043e\u0434\u0443 \u0434\u043e \u0430\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0445 \u0434\u0430\u043d\u043d\u044b\u0445 \u043f\u0440\u0438\u0434\u0435\u0442\u0441\u044f \u0432 \u0440\u0443\u0447\u043d\u0443\u044e) #------------------------------------------------------------------------------ recovery_user = 'postgres' recovery_password = '' recovery_1st_stage_command = 'basebackup.sh' recovery_2nd_stage_command = '' recovery_timeout = 90 client_idle_limit_in_recovery = 0 #------------------------------------------------------------------------------ # WATCHDOG #------------------------------------------------------------------------------ # - Enabling - use_watchdog = off trusted_servers = '10.1.16.12' ping_path = '\/bin' wd_hostname = '10.1.16.12' wd_port = 9000 wd_authkey = '' delegate_IP = '10.1.16.16' ifconfig_path = '\/home\/apache\/sbin' if_up_cmd = 'ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0' if_down_cmd = 'ifconfig eth0:0 down' arping_path = '\/home\/apache\/sbin' arping_cmd = 'arping -U $_IP_$ -w 1' clear_memqcache_on_escalation = on wd_escalation_command = '' wd_lifecheck_method = 'heartbeat' wd_interval = 10 wd_heartbeat_port = 9694 wd_heartbeat_keepalive = 2 wd_heartbeat_deadtime = 30 wd_life_point = 3 wd_lifecheck_query = 'SELECT 1' wd_lifecheck_dbname = 'template1' wd_lifecheck_user = 'nobody' wd_lifecheck_password = '' ssl_key = '' ssl_cert = '' ssl_ca_cert = '' ssl_ca_cert_dir = '' listen_backlog_multiplier = 2 log_line_prefix = '' log_error_verbosity = 'DEFAULT' client_min_messages = 'notice' log_min_messages = 'warning' database_redirect_preference_list = '' app_name_redirect_preference_list = '' allow_sql_comments = off connect_timeout = 10000 check_unlogged_table = off backend_hostname0 = 'as-msk-at082.maxus.lan' backend_port0 = 5432 backend_weight0 = 1 backend_data_directory0 = '\/var\/lib\/pgsql\/9.3\/data' backend_flag0= 'ALLOW_TO_FAILOVER' backend_hostname1 = 'as-msk-at083.maxus.lan' backend_port1 = 5432 backend_weight1 = 1 backend_data_directory1 = '\/var\/lib\/pgsql\/9.3\/data' backend_flag1= 'ALLOW_TO_FAILOVER' other_pgpool_hostname0 = '' other_pgpool_port0 = other_wd_port0 = heartbeat_destination0 = '' heartbeat_destination_port0 = heartbeat_device0 = '' <\/code><\/pre>\n<p>  \u041f\u043e\u0441\u043b\u0435 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u043e\u043d\u043d\u043e\u0433\u043e \u0444\u0430\u0439\u043b\u0430, \u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c \u0441\u043b\u0443\u0436\u0431\u0443 pgpool. \u041c\u043e\u0436\u043d\u043e \u0442\u0430\u043a\u0436\u0435 \u043d\u0430\u0441\u0442\u0440\u043e\u0438\u0442\u044c pgpooladmin \u0434\u043b\u044f \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u044f \u043d\u043e\u0434.<\/p>\n<p>  \u042f \u044d\u0442\u043e \u0434\u0435\u043b\u0430\u043b \u043f\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438 \u043e\u0442\u0441\u044e\u0434\u0430:<br \/>  <a href=\"http:\/\/www.pgpool.net\/docs\/pgpoolAdmin\/en\/install.html\">www.pgpool.net\/docs\/pgpoolAdmin\/en\/install.html<\/a><\/p>\n<p>  \u0422\u0430\u043a\u0436\u0435 \u0441\u0442\u0430\u0442\u0443\u0441 \u043d\u043e\u0434 \u0441 PostgreSQL \u043c\u043e\u0436\u043d\u043e \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c, \u0432\u044b\u043f\u043e\u043b\u043d\u0438\u0432 \u043a\u043e\u043c\u0430\u043d\u0434\u0443 \u043d\u0430 pgpool:  <\/p>\n<pre><code class=\"bash\">pcp_node_info 10 &quot;\u0438\u043c\u044f pgpool-\u043d\u043e\u0434\u044b&quot; 9898 postgres postgres 0 pcp_node_info 10 &quot;\u0438\u043c\u044f pgpool-\u043d\u043e\u0434\u044b&quot; 9898 postgres postgres 1 <\/code><\/pre>\n<p>  \u0414\u0430\u043b\u0435\u0435, \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c \u0440\u0430\u0431\u043e\u0442\u0443 \u043d\u0430\u0448\u0435\u0439 \u0441\u0445\u0435\u043c\u044b \u2014 \u0441\u043e\u0437\u0434\u0430\u0435\u043c \u043f\u0443\u0441\u0442\u0443\u044e \u0411\u0414 \u0447\u0435\u0440\u0435\u0437 pgpool. \u0421\u0434\u0435\u043b\u0430\u0442\u044c \u044d\u0442\u043e \u043c\u043e\u0436\u043d\u043e \u0434\u0432\u0443\u043c\u044f \u0441\u043f\u043e\u0441\u043e\u0431\u0430\u043c\u0438:<br \/>  1) \u0447\u0435\u0440\u0435\u0437 pgadmin, \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0438\u0432\u0448\u0438\u0441\u044c \u043a IP-\u0430\u0434\u0440\u0435\u0441\u0443 pgpool-II;<br \/>  2) \u0432\u044b\u043f\u043e\u043b\u043d\u0438\u0432 \u043a\u043e\u043c\u0430\u043d\u0434\u0443 \u043d\u0430 \u043d\u043e\u0434\u0435 \u0441 pgpool: createdb -p 9999 bench_replication<\/p>\n<p>  <b>\u041c\u0438\u043d\u0443\u0441\u044b:<\/b>  <\/p>\n<ul>\n<li>\u0421\u0438\u043d\u0445\u0440\u043e\u043d\u043d\u0430\u044f \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u044f<\/li>\n<li>\u0412 \u0441\u043b\u0443\u0447\u0430\u0435 \u0432\u044b\u0445\u043e\u0434\u0430 \u0438\u0437 \u0441\u0442\u0440\u043e\u044f \u043e\u0434\u043d\u043e\u0439 \u0438\u0437 \u043d\u043e\u0434, \u043d\u0430\u0434 \u0435\u0435 \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0435\u043d\u0438\u0435\u043c \u043f\u0440\u0438\u0434\u0435\u0442\u0441\u044f \u043f\u043e\u043f\u043e\u0442\u0435\u0442\u044c<\/li>\n<li>\u0414\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u043c\u0430\u043b\u043e, \u0433\u0434\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0442\u0430\u043a\u0430\u044f \u0430\u0440\u0445\u0438\u0442\u0435\u043a\u0442\u0443\u0440\u0430<\/li>\n<li>\u0411\u043b\u043e\u043a\u0438\u0440\u043e\u0432\u043a\u0430 \u0442\u0430\u0431\u043b\u0438\u0446\u0430<\/li>\n<\/ul>\n<p>  <b>\u041f\u043b\u044e\u0441\u044b:<\/b>  <\/p>\n<ul>\n<li>\u041b\u043e\u0433\u0438\u0447\u0435\u0441\u043a\u0430\u044f \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u044f, \u043d\u0435 \u0443\u0445\u043e\u0434\u0438\u0442 \u043d\u0430 \u0443\u0440\u043e\u0432\u0435\u043d\u044c \u0421\u0423\u0411\u0414, \u0441\u043d\u0438\u0436\u0430\u044f \u043d\u0430 \u043d\u0435\u0435 \u043d\u0430\u0433\u0440\u0443\u0437\u043a\u0443<\/li>\n<li>\u0411\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u043a\u0430 \u043d\u0430\u0433\u0440\u0443\u0437\u043a\u0438<\/li>\n<li>\u041a\u0435\u0448\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432<\/li>\n<li>\u041e\u0431\u044a\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435 \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0439<\/li>\n<\/ul>\n<p>  \u0417\u0430 \u043e\u0441\u043d\u043e\u0432\u0443 \u0432\u0437\u044f\u0442\u0430 \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u044f \u043f\u043e \u0441\u0441\u044b\u043b\u043a\u0435: <a href=\"http:\/\/www.pgpool.net\/pgpool-web\/contrib_docs\/simple_sr_setting2_3.3\/index.html\">www.pgpool.net\/pgpool-web\/contrib_docs\/simple_sr_setting2_3.3\/index.html<\/a>             <\/p>\n<div class=\"clear\"><\/div>\n<p> \u0441\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b \u0441\u0442\u0430\u0442\u044c\u0438 <a href=\"http:\/\/habrahabr.ru\/post\/263225\/\"> http:\/\/habrahabr.ru\/post\/263225\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>             \u0420\u0435\u0448\u0438\u043b \u043f\u043e\u0434\u0435\u043b\u0438\u0442\u044c\u0441\u044f \u0441 \u0432\u0430\u043c\u0438 \u043e\u043f\u044b\u0442\u043e\u043c \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u043a\u043b\u0430\u0441\u0442\u0435\u0440\u0430 PostgreSQL 9.3, \u0441\u043e\u0441\u0442\u043e\u044f\u0449\u0435\u0433\u043e \u0438\u0437 \u0434\u0432\u0443\u0445 \u043d\u043e\u0434, \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435\u043c \u043a\u043e\u0442\u043e\u0440\u043e\u0433\u043e \u0437\u0430\u043d\u0438\u043c\u0430\u0435\u0442\u0441\u044f pgpool-II, \u0431\u0435\u0437 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f Stream Replication (WAL). \u041d\u0430\u0434\u0435\u044e\u0441\u044c, \u043a\u043e\u043c\u0443-\u043d\u0438\u0431\u0443\u0434\u044c \u0431\u0443\u0434\u0435\u0442 \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u043e.<\/p>\n<p>  \u0421\u0445\u0435\u043c\u0430:<\/p>\n<p>  <img decoding=\"async\" src=\"http:\/\/s019.radikal.ru\/i601\/1507\/72\/9a31703173ce.png\" alt=\"image\"\/><\/p>\n<p>  \u041a\u0430\u043a \u0412\u044b \u043f\u043e\u043d\u0438\u043c\u0430\u0435\u0442\u0435, \u044d\u0442\u043e \u0431\u0443\u0434\u0443\u0442 \u0434\u0432\u0430 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e \u0441\u0442\u043e\u044f\u0449\u0438\u0445 \u0441\u0435\u0440\u0432\u0435\u0440\u0430, \u043a\u043e\u0442\u043e\u0440\u044b\u043c\u0438 \u0431\u0443\u0434\u0435\u0442 \u0443\u043f\u0440\u0430\u0432\u043b\u044f\u0442\u044c pgpool-II.<\/p>\n<p>  \u041a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u044f \u043d\u043e\u0434 \u0441 PostgreSQL:<br \/>  \u041e\u0431\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u0438\u0434\u0435\u043d\u0442\u0438\u0447\u043d\u044b \u043f\u043e \u0441\u0432\u043e\u0438\u043c \u0430\u043f\u043f\u0430\u0440\u0430\u0442\u043d\u044b\u043c \u0441\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0449\u0438\u043c.  <\/p>\n<ul>\n<li>4vCPU;<\/li>\n<li>16 \u0413\u0431 \u043f\u0430\u043c\u044f\u0442\u0438;<\/li>\n<li>CentOS 6.5;<\/li>\n<\/ul>\n<p>  \u0414\u0438\u0441\u043a\u0438:  <\/p>\n<ul>\n<li>50 \u0413\u0431 \u2014 \u0441\u0438\u0441\u0442\u0435\u043c\u0430;<\/li>\n<li>100 \u0413\u0431 \u2014 pg_xlog<\/li>\n<li>500 \u0413\u0431 \u2014 \u043a\u0430\u0442\u0430\u043b\u043e\u0433 \u0441 \u0434\u0430\u043d\u043d\u044b\u043c\u0438<\/li>\n<\/ul>\n<p>  \u041f\u0440\u0438\u043c\u0435\u0440,  <\/p>\n<pre> Filesystem      Size  Used Avail Use% Mounted on \/dev\/sda3        48G  7.4G   38G  17% \/ tmpfs           7.8G     0  7.8G   0% \/dev\/shm \/dev\/sda1       194M   28M  157M  15% \/boot \/dev\/sdb1        99G  4.9G   89G   6% \/var\/lib\/pgsql\/9.3\/data\/pg_xlog \/dev\/sdc1       493G  234G  234G  50% \/var\/lib\/pgsql\/9.3\/my_data <\/pre>\n<p>  \u041a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u044f \u043d\u043e\u0434 \u0441 pgpool-II:  <\/p>\n<ul>\n<li>4vCPU;<\/li>\n<li>8 \u0413\u0431 \u043f\u0430\u043c\u044f\u0442\u0438;<\/li>\n<li>CentOS 6.5;<\/li>\n<\/ul>\n<p>  \u0414\u0438\u0441\u043a\u0438:  <\/p>\n<ul>\n<li>50 \u0413\u0431 \u2014 \u0441\u0438\u0441\u0442\u0435\u043c\u0430;<\/li>\n<\/ul>\n<p>  \u041f\u0440\u043e \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0443 PostgreSQL \u0432 \u0434\u0435\u0442\u0430\u043b\u0438 \u0432\u0434\u0430\u0432\u0430\u0442\u044c\u0441\u044f \u043d\u0435 \u0431\u0443\u0434\u0443, \u0442\u0430\u043a \u043a\u0430\u043a \u043e\u043d\u0430 \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u0430\u044f.<\/p>\n<p>  \u041d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430 pgpool-II.<br \/>  \u0417\u0430 \u043e\u0441\u043d\u043e\u0432\u0443 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 pgpool-II, \u0432\u0437\u044f\u043b \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u044e \u0441 \u043e\u0444\u0438\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u0433\u043e \u0441\u0430\u0439\u0442\u0430: <a href=\"http:\/\/www.pgpool.net\/pgpool-web\/contrib_docs\/simple_sr_setting2_3.3\/index.html\">www.pgpool.net\/pgpool-web\/contrib_docs\/simple_sr_setting2_3.3\/index.html<\/a><\/p>\n<p>  \u0425\u043e\u0442\u0435\u043b \u0431\u044b \u043e\u0431\u0440\u0430\u0442\u0438\u0442\u044c \u0432\u043d\u0438\u043c\u0430\u043d\u0438\u0435 \u0442\u043e\u043b\u044c\u043a\u043e \u0441\u0430\u043c\u044b\u0435 \u0432\u0430\u0436\u043d\u044b\u0435 \u043c\u043e\u043c\u0435\u043d\u0442\u044b:  <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-261992","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/261992","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=261992"}],"version-history":[{"count":0,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/261992\/revisions"}],"wp:attachment":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=261992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=261992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=261992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}