API tools faq
paste
Guest User

Untitled

a guest
Sep 20th, 2018
119
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 35.16 KB | None | 0 0
raw download clone embed print report
  1. # ----------------------------
  2. # pgPool-II configuration file
  3. # ----------------------------
  4. #
  5. # This file consists of lines of the form:
  6. #
  7. # name = value
  8. #
  9. # Whitespace may be used. Comments are introduced with "#" anywhere on a line.
  10. # The complete list of parameter names and allowed values can be found in the
  11. # pgPool-II documentation.
  12. #
  13. # This file is read on server startup and when the server receives a SIGHUP
  14. # signal. If you edit the file on a running system, you have to SIGHUP the
  15. # server for the changes to take effect, or use "pgpool reload". Some
  16. # parameters, which are marked below, require a server shutdown and restart to
  17. # take effect.
  18. #
  19.  
  20.  
  21. #------------------------------------------------------------------------------
  22. # CONNECTIONS
  23. #------------------------------------------------------------------------------
  24.  
  25. # - pgpool Connection Settings -
  26.  
  27. listen_addresses = '*'
  28. # Host name or IP address to listen on:
  29. # '*' for all, '' for no TCP/IP connections
  30. # (change requires restart)
  31. port = 5432
  32. # Port number
  33. # (change requires restart)
  34. socket_dir = '/var/run/postgresql'
  35. # Unix domain socket path
  36. # The Debian package defaults to
  37. # /var/run/postgresql
  38. # (change requires restart)
  39. listen_backlog_multiplier = 4
  40. # Set the backlog parameter of listen(2) to
  41. # num_init_children * listen_backlog_multiplier.
  42. # (change requires restart)
  43. serialize_accept = off
  44. # whether to serialize accept() call to avoid thundering herd problem
  45. # (change requires restart)
  46.  
  47. # - pgpool Communication Manager Connection Settings -
  48.  
  49. pcp_listen_addresses = '*'
  50. # Host name or IP address for pcp process to listen on:
  51. # '*' for all, '' for no TCP/IP connections
  52. # (change requires restart)
  53. pcp_port = 9898
  54. # Port number for pcp
  55. # (change requires restart)
  56. pcp_socket_dir = '/var/run/postgresql'
  57. # Unix domain socket path for pcp
  58. # The Debian package defaults to
  59. # /var/run/postgresql
  60. # (change requires restart)
  61.  
  62. # - Backend Connection Settings -
  63.  
  64. backend_hostname0 = '192.168.40.35'
  65. # Host name or IP address to connect to for backend 0
  66. backend_port0 = 5432
  67. # Port number for backend 0
  68. backend_weight0 = 1
  69. # Weight for backend 0 (only in load balancing mode)
  70. backend_data_directory0 = '/var/lib/postgresql/10/main/'
  71. # Data directory for backend 0
  72. backend_flag0 = 'ALLOW_TO_FAILOVER'
  73. # Controls various backend behavior
  74. # ALLOW_TO_FAILOVER, DISALLOW_TO_FAILOVER
  75. # or ALWAYS_MASTER
  76. backend_hostname1 = '192.168.40.36'
  77. backend_port1 = 5432
  78. backend_weight1 = 1
  79. backend_data_directory1 = '/var/lib/postgresql/10/main/'
  80. backend_flag1 = 'ALLOW_TO_FAILOVER'
  81.  
  82. # - Authentication -
  83.  
  84. enable_pool_hba = on
  85. # Use pool_hba.conf for client authentication
  86. pool_passwd = 'pool_passwd'
  87. # File name of pool_passwd for md5 authentication.
  88. # "" disables pool_passwd.
  89. # (change requires restart)
  90. authentication_timeout = 60
  91. # Delay in seconds to complete client authentication
  92. # 0 means no timeout.
  93.  
  94. # - SSL Connections -
  95.  
  96. ssl = off
  97. # Enable SSL support
  98. # (change requires restart)
  99. #ssl_key = './server.key'
  100. # Path to the SSL private key file
  101. # (change requires restart)
  102. #ssl_cert = './server.cert'
  103. # Path to the SSL public certificate file
  104. # (change requires restart)
  105. #ssl_ca_cert = ''
  106. # Path to a single PEM format file
  107. # containing CA root certificate(s)
  108. # (change requires restart)
  109. #ssl_ca_cert_dir = ''
  110. # Directory containing CA root certificate(s)
  111. # (change requires restart)
  112.  
  113.  
  114. #------------------------------------------------------------------------------
  115. # POOLS
  116. #------------------------------------------------------------------------------
  117.  
  118. # - Concurrent session and pool size -
  119.  
  120. num_init_children = 175
  121. # Number of concurrent sessions allowed
  122. # (change requires restart)
  123. max_pool = 10
  124. # Number of connection pool caches per connection
  125. # (change requires restart)
  126.  
  127. # - Life time -
  128.  
  129. child_life_time = 300
  130. # Pool exits after being idle for this many seconds
  131. child_max_connections = 0
  132. # Pool exits after receiving that many connections
  133. # 0 means no exit
  134. connection_life_time = 0
  135. # Connection to backend closes after being idle for this many seconds
  136. # 0 means no close
  137. client_idle_limit = 0
  138. # Client is disconnected after being idle for that many seconds
  139. # (even inside an explicit transactions!)
  140. # 0 means no disconnection
  141.  
  142.  
  143. #------------------------------------------------------------------------------
  144. # LOGS
  145. #------------------------------------------------------------------------------
  146.  
  147. # - Where to log -
  148.  
  149. log_destination = 'syslog'
  150. # Where to log
  151. # Valid values are combinations of stderr,
  152. # and syslog. Default to stderr.
  153.  
  154. # - What to log -
  155.  
  156. log_line_prefix = '%t: pid %p: ' # printf-style string to output at beginning of each log line.
  157.  
  158. log_connections = off
  159. # Log connections
  160. log_hostname = off
  161. # Hostname will be shown in ps status
  162. # and in logs if connections are logged
  163. log_statement = off
  164. # Log all statements
  165. log_per_node_statement = off
  166. # Log all statements
  167. # with node and backend informations
  168. log_standby_delay = 'none'
  169. # Log standby delay
  170. # Valid values are combinations of always,
  171. # if_over_threshold, none
  172.  
  173. # - Syslog specific -
  174.  
  175. syslog_facility = 'LOCAL0'
  176. # Syslog local facility. Default to LOCAL0
  177. syslog_ident = 'pgpool'
  178. # Syslog program identification string
  179. # Default to 'pgpool'
  180.  
  181. # - Debug -
  182.  
  183. #log_error_verbosity = default # terse, default, or verbose messages
  184.  
  185. #client_min_messages = notice # values in order of decreasing detail:
  186. # debug5
  187. # debug4
  188. # debug3
  189. # debug2
  190. # debug1
  191. # log
  192. # notice
  193. # warning
  194. # error
  195.  
  196. #log_min_messages = warning # values in order of decreasing detail:
  197. # debug5
  198. # debug4
  199. # debug3
  200. # debug2
  201. # debug1
  202. # info
  203. # notice
  204. # warning
  205. # error
  206. # log
  207. # fatal
  208. # panic
  209.  
  210. #------------------------------------------------------------------------------
  211. # FILE LOCATIONS
  212. #------------------------------------------------------------------------------
  213.  
  214. pid_file_name = '/var/run/postgresql/pgpool.pid'
  215. # PID file name
  216. # Can be specified as relative to the"
  217. # location of pgpool.conf file or
  218. # as an absolute path
  219. # (change requires restart)
  220. logdir = '/var/log/postgresql'
  221. # Directory of pgPool status file
  222. # (change requires restart)
  223.  
  224.  
  225. #------------------------------------------------------------------------------
  226. # CONNECTION POOLING
  227. #------------------------------------------------------------------------------
  228.  
  229. connection_cache = on
  230. # Activate connection pools
  231. # (change requires restart)
  232.  
  233. # Semicolon separated list of queries
  234. # to be issued at the end of a session
  235. # The default is for 8.3 and later
  236. reset_query_list = 'ABORT; DISCARD ALL'
  237. # The following one is for 8.2 and before
  238. #reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
  239.  
  240.  
  241. #------------------------------------------------------------------------------
  242. # REPLICATION MODE
  243. #------------------------------------------------------------------------------
  244.  
  245. replication_mode = off
  246. # Activate replication mode
  247. # (change requires restart)
  248. replicate_select = off
  249. # Replicate SELECT statements
  250. # when in replication mode
  251. # replicate_select is higher priority than
  252. # load_balance_mode.
  253.  
  254. insert_lock = on
  255. # Automatically locks a dummy row or a table
  256. # with INSERT statements to keep SERIAL data
  257. # consistency
  258. # Without SERIAL, no lock will be issued
  259. lobj_lock_table = ''
  260. # When rewriting lo_creat command in
  261. # replication mode, specify table name to
  262. # lock
  263.  
  264. # - Degenerate handling -
  265.  
  266. replication_stop_on_mismatch = off
  267. # On disagreement with the packet kind
  268. # sent from backend, degenerate the node
  269. # which is most likely "minority"
  270. # If off, just force to exit this session
  271.  
  272. failover_if_affected_tuples_mismatch = off
  273. # On disagreement with the number of affected
  274. # tuples in UPDATE/DELETE queries, then
  275. # degenerate the node which is most likely
  276. # "minority".
  277. # If off, just abort the transaction to
  278. # keep the consistency
  279.  
  280.  
  281. #------------------------------------------------------------------------------
  282. # LOAD BALANCING MODE
  283. #------------------------------------------------------------------------------
  284.  
  285. load_balance_mode = on
  286. # Activate load balancing mode
  287. # (change requires restart)
  288. ignore_leading_white_space = on
  289. # Ignore leading white spaces of each query
  290. white_function_list = ''
  291. # Comma separated list of function names
  292. # that don't write to database
  293. # Regexp are accepted
  294. black_function_list = 'nextval,setval,nextval,setval'
  295. # Comma separated list of function names
  296. # that write to database
  297. # Regexp are accepted
  298.  
  299. database_redirect_preference_list = ''
  300. # comma separated list of pairs of database and node id.
  301. # example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'
  302. # valid for streaming replicaton mode only.
  303.  
  304. app_name_redirect_preference_list = ''
  305. # comma separated list of pairs of app name and node id.
  306. # example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'
  307. # valid for streaming replicaton mode only.
  308. allow_sql_comments = off
  309. # if on, ignore SQL comments when judging if load balance or
  310. # query cache is possible.
  311. # If off, SQL comments effectively prevent the judgment
  312. # (pre 3.4 behavior).
  313.  
  314. #------------------------------------------------------------------------------
  315. # MASTER/SLAVE MODE
  316. #------------------------------------------------------------------------------
  317.  
  318. master_slave_mode = on
  319. # Activate master/slave mode
  320. # (change requires restart)
  321. master_slave_sub_mode = 'stream'
  322. # Master/slave sub mode
  323. # Valid values are combinations stream, slony
  324. # or logical. Default is stream.
  325. # (change requires restart)
  326.  
  327. # - Streaming -
  328.  
  329. sr_check_period = 0
  330. # Streaming replication check period
  331. # Disabled (0) by default
  332. sr_check_user = 'replicate'
  333. # Streaming replication check user
  334. # This is necessary even if you disable
  335. # streaming replication delay check with
  336. # sr_check_period = 0
  337. sr_check_password = 'r9ZCmanRq4FO'
  338. # Password for streaming replication check user
  339. sr_check_database = 'postgres'
  340. # Database name for streaming replication check
  341. delay_threshold = 0
  342. # Threshold before not dispatching query to standby node
  343. # Unit is in bytes
  344. # Disabled (0) by default
  345.  
  346. # - Special commands -
  347.  
  348. follow_master_command = ''
  349. # Executes this command after master failover
  350. # Special values:
  351. # %d = node id
  352. # %h = host name
  353. # %p = port number
  354. # %D = database cluster path
  355. # %m = new master node id
  356. # %H = hostname of the new master node
  357. # %M = old master node id
  358. # %P = old primary node id
  359. # %r = new master port number
  360. # %R = new master database cluster path
  361. # %% = '%' character
  362.  
  363. #------------------------------------------------------------------------------
  364. # HEALTH CHECK GLOBAL PARAMETERS
  365. #------------------------------------------------------------------------------
  366.  
  367. health_check_period = 5
  368. # Health check period
  369. # Disabled (0) by default
  370. health_check_timeout = 20
  371. # Health check timeout
  372. # 0 means no timeout
  373. health_check_user = 'replicate'
  374. # Health check user
  375. health_check_password = 'r9ZCmanRq4FO'
  376. # Password for health check user
  377. health_check_database = 'postgres'
  378. # Database name for health check. If '', tries 'postgres' frist, then 'template1'
  379.  
  380. health_check_max_retries = 1
  381. # Maximum number of times to retry a failed health check before giving up.
  382. health_check_retry_delay = 1
  383. # Amount of time to wait (in seconds) between retries.
  384. connect_timeout = 10000
  385. # Timeout value in milliseconds before giving up to connect to backend.
  386. # Default is 10000 ms (10 second). Flaky network user may want to increase
  387. # the value. 0 means no timeout.
  388. # Note that this value is not only used for health check,
  389. # but also for ordinary conection to backend.
  390.  
  391. #------------------------------------------------------------------------------
  392. # HEALTH CHECK PER NODE PARAMETERS (OPTIONAL)
  393. #------------------------------------------------------------------------------
  394. #health_check_period0 = 0
  395. #health_check_timeout0 = 20
  396. #health_check_user0 = 'nobody'
  397. #health_check_password0 = ''
  398. #health_check_database0 = ''
  399. #health_check_max_retries0 = 0
  400. #health_check_retry_delay0 = 1
  401. #connect_timeout0 = 10000
  402.  
  403. #------------------------------------------------------------------------------
  404. # FAILOVER AND FAILBACK
  405. #------------------------------------------------------------------------------
  406.  
  407. failover_command = '/usr/local/bin/failover.sh %H'
  408. # Executes this command at failover
  409. # Special values:
  410. # %d = node id
  411. # %h = host name
  412. # %p = port number
  413. # %D = database cluster path
  414. # %m = new master node id
  415. # %H = hostname of the new master node
  416. # %M = old master node id
  417. # %P = old primary node id
  418. # %r = new master port number
  419. # %R = new master database cluster path
  420. # %% = '%' character
  421. failback_command = ''
  422. # Executes this command at failback.
  423. # Special values:
  424. # %d = node id
  425. # %h = host name
  426. # %p = port number
  427. # %D = database cluster path
  428. # %m = new master node id
  429. # %H = hostname of the new master node
  430. # %M = old master node id
  431. # %P = old primary node id
  432. # %r = new master port number
  433. # %R = new master database cluster path
  434. # %% = '%' character
  435.  
  436. fail_over_on_backend_error = on
  437. # Initiates failover when reading/writing to the
  438. # backend communication socket fails
  439. # If set to off, pgpool will report an
  440. # error and disconnect the session.
  441.  
  442. search_primary_node_timeout = 300
  443. # Timeout in seconds to search for the
  444. # primary node when a failover occurs.
  445. # 0 means no timeout, keep searching
  446. # for a primary node forever.
  447.  
  448. #------------------------------------------------------------------------------
  449. # ONLINE RECOVERY
  450. #------------------------------------------------------------------------------
  451.  
  452. recovery_user = 'nobody'
  453. # Online recovery user
  454. recovery_password = ''
  455. # Online recovery password
  456. recovery_1st_stage_command = ''
  457. # Executes a command in first stage
  458. recovery_2nd_stage_command = ''
  459. # Executes a command in second stage
  460. recovery_timeout = 90
  461. # Timeout in seconds to wait for the
  462. # recovering node's postmaster to start up
  463. # 0 means no wait
  464. client_idle_limit_in_recovery = 0
  465. # Client is disconnected after being idle
  466. # for that many seconds in the second stage
  467. # of online recovery
  468. # 0 means no disconnection
  469. # -1 means immediate disconnection
  470.  
  471.  
  472. #------------------------------------------------------------------------------
  473. # WATCHDOG
  474. #------------------------------------------------------------------------------
  475.  
  476. # - Enabling -
  477.  
  478. use_watchdog = on
  479. # Activates watchdog
  480. # (change requires restart)
  481.  
  482. # -Connection to up stream servers -
  483.  
  484. trusted_servers = ''
  485. # trusted server list which are used
  486. # to confirm network connection
  487. # (hostA,hostB,hostC,...)
  488. # (change requires restart)
  489. ping_path = '/bin'
  490. # ping command path
  491. # (change requires restart)
  492.  
  493. # - Watchdog communication Settings -
  494.  
  495. wd_hostname = '192.168.40.30'
  496. # Host name or IP address of this watchdog
  497. # (change requires restart)
  498. wd_port = 9000
  499. # port number for watchdog service
  500. # (change requires restart)
  501. wd_priority = 1
  502. # priority of this watchdog in leader election
  503. # (change requires restart)
  504.  
  505. wd_authkey = ''
  506. # Authentication key for watchdog communication
  507. # (change requires restart)
  508.  
  509. wd_ipc_socket_dir = '/tmp'
  510. # Unix domain socket path for watchdog IPC socket
  511. # The Debian package defaults to
  512. # /var/run/postgresql
  513. # (change requires restart)
  514.  
  515.  
  516. # - Virtual IP control Setting -
  517.  
  518. delegate_IP = '192.168.40.32'
  519. # delegate IP address
  520. # If this is empty, virtual IP never bring up.
  521. # (change requires restart)
  522. if_cmd_path = '/sbin'
  523. # path to the directory where if_up/down_cmd exists
  524. # (change requires restart)
  525. if_up_cmd = 'ip addr add $_IP_$/32 dev eth0 label eth0:0'
  526. # startup delegate IP command
  527. # (change requires restart)
  528. if_down_cmd = 'ip addr del $_IP_$/32 dev eth0'
  529. # shutdown delegate IP command
  530. # (change requires restart)
  531. arping_path = '/usr/sbin'
  532. # arping command path
  533. # (change requires restart)
  534. arping_cmd = 'arping -U $_IP_$ -w 1'
  535. # arping command
  536. # (change requires restart)
  537.  
  538. # - Behaivor on escalation Setting -
  539.  
  540. clear_memqcache_on_escalation = on
  541. # Clear all the query cache on shared memory
  542. # when standby pgpool escalate to active pgpool
  543. # (= virtual IP holder).
  544. # This should be off if client connects to pgpool
  545. # not using virtual IP.
  546. # (change requires restart)
  547. wd_escalation_command = ''
  548. # Executes this command at escalation on new active pgpool.
  549. # (change requires restart)
  550. wd_de_escalation_command = ''
  551. # Executes this command when master pgpool resigns from being master.
  552. # (change requires restart)
  553.  
  554. # - Watchdog consensus settings for failover -
  555.  
  556. failover_when_quorum_exists = on
  557. # Only perform backend node failover
  558. # when the watchdog cluster holds the quorum
  559. # (change requires restart)
  560.  
  561. failover_require_consensus = on
  562. # Perform failover when majority of Pgpool-II nodes
  563. # aggrees on the backend node status change
  564. # (change requires restart)
  565.  
  566. allow_multiple_failover_requests_from_node = off
  567. # A Pgpool-II node can cast multiple votes
  568. # for building the consensus on failover
  569. # (change requires restart)
  570.  
  571. # - Lifecheck Setting -
  572.  
  573. # -- common --
  574.  
  575. wd_monitoring_interfaces_list = '' # Comma separated list of interfaces names to monitor.
  576. # if any interface from the list is active the watchdog will
  577. # consider the network is fine
  578. # 'any' to enable monitoring on all interfaces except loopback
  579. # '' to disable monitoring
  580. # (change requires restart)
  581.  
  582.  
  583. wd_lifecheck_method = 'heartbeat'
  584. # Method of watchdog lifecheck ('heartbeat' or 'query' or 'external')
  585. # (change requires restart)
  586. wd_interval = 3
  587. # lifecheck interval (sec) > 0
  588. # (change requires restart)
  589.  
  590. # -- heartbeat mode --
  591.  
  592. wd_heartbeat_port = 9694
  593. # Port number for receiving heartbeat signal
  594. # (change requires restart)
  595. wd_heartbeat_keepalive = 2
  596. # Interval time of sending heartbeat signal (sec)
  597. # (change requires restart)
  598. wd_heartbeat_deadtime = 30
  599. # Deadtime interval for heartbeat signal (sec)
  600. # (change requires restart)
  601. heartbeat_destination0 = '192.168.40.31'
  602. # Host name or IP address of destination 0
  603. # for sending heartbeat signal.
  604. # (change requires restart)
  605. heartbeat_destination_port0 = 9694
  606. # Port number of destination 0 for sending
  607. # heartbeat signal. Usually this is the
  608. # same as wd_heartbeat_port.
  609. # (change requires restart)
  610. heartbeat_device0 = ''
  611. # Name of NIC device (such like 'eth0')
  612. # used for sending/receiving heartbeat
  613. # signal to/from destination 0.
  614. # This works only when this is not empty
  615. # and pgpool has root privilege.
  616. # (change requires restart)
  617.  
  618. #heartbeat_destination1 = 'host0_ip2'
  619. #heartbeat_destination_port1 = 9694
  620. #heartbeat_device1 = ''
  621.  
  622. # -- query mode --
  623.  
  624. wd_life_point = 3
  625. # lifecheck retry times
  626. # (change requires restart)
  627. wd_lifecheck_query = 'SELECT 1'
  628. # lifecheck query to pgpool from watchdog
  629. # (change requires restart)
  630. wd_lifecheck_dbname = 'template1'
  631. # Database name connected for lifecheck
  632. # (change requires restart)
  633. wd_lifecheck_user = 'nobody'
  634. # watchdog user monitoring pgpools in lifecheck
  635. # (change requires restart)
  636. wd_lifecheck_password = ''
  637. # Password for watchdog user in lifecheck
  638. # (change requires restart)
  639.  
  640. # - Other pgpool Connection Settings -
  641.  
  642. other_pgpool_hostname0 = '192.168.40.31'
  643. # Host name or IP address to connect to for other pgpool 0
  644. # (change requires restart)
  645. other_pgpool_port0 = 5432
  646. # Port number for other pgpool 0
  647. # (change requires restart)
  648. other_wd_port0 = 9000
  649. # Port number for other watchdog 0
  650. # (change requires restart)
  651. #other_pgpool_hostname1 = 'host1'
  652. #other_pgpool_port1 = 5432
  653. #other_wd_port1 = 9000
  654.  
  655.  
  656. #------------------------------------------------------------------------------
  657. # OTHERS
  658. #------------------------------------------------------------------------------
  659. relcache_expire = 0
  660. # Life time of relation cache in seconds.
  661. # 0 means no cache expiration(the default).
  662. # The relation cache is used for cache the
  663. # query result against PostgreSQL system
  664. # catalog to obtain various information
  665. # including table structures or if it's a
  666. # temporary table or not. The cache is
  667. # maintained in a pgpool child local memory
  668. # and being kept as long as it survives.
  669. # If someone modify the table by using
  670. # ALTER TABLE or some such, the relcache is
  671. # not consistent anymore.
  672. # For this purpose, cache_expiration
  673. # controls the life time of the cache.
  674.  
  675. relcache_size = 256
  676. # Number of relation cache
  677. # entry. If you see frequently:
  678. # "pool_search_relcache: cache replacement happend"
  679. # in the pgpool log, you might want to increate this number.
  680.  
  681. check_temp_table = on
  682. # If on, enable temporary table check in SELECT statements.
  683. # This initiates queries against system catalog of primary/master
  684. # thus increases load of master.
  685. # If you are absolutely sure that your system never uses temporary tables
  686. # and you want to save access to primary/master, you could turn this off.
  687. # Default is on.
  688.  
  689. check_unlogged_table = on
  690. # If on, enable unlogged table check in SELECT statements.
  691. # This initiates queries against system catalog of primary/master
  692. # thus increases load of master.
  693. # If you are absolutely sure that your system never uses unlogged tables
  694. # and you want to save access to primary/master, you could turn this off.
  695. # Default is on.
  696.  
  697. #------------------------------------------------------------------------------
  698. # IN MEMORY QUERY MEMORY CACHE
  699. #------------------------------------------------------------------------------
  700. memory_cache_enabled = off
  701. # If on, use the memory cache functionality, off by default
  702. memqcache_method = 'shmem'
  703. # Cache storage method. either 'shmem'(shared memory) or
  704. # 'memcached'. 'shmem' by default
  705. # (change requires restart)
  706. memqcache_memcached_host = 'localhost'
  707. # Memcached host name or IP address. Mandatory if
  708. # memqcache_method = 'memcached'.
  709. # Defaults to localhost.
  710. # (change requires restart)
  711. memqcache_memcached_port = 11211
  712. # Memcached port number. Mondatory if memqcache_method = 'memcached'.
  713. # Defaults to 11211.
  714. # (change requires restart)
  715. memqcache_total_size = 67108864
  716. # Total memory size in bytes for storing memory cache.
  717. # Mandatory if memqcache_method = 'shmem'.
  718. # Defaults to 64MB.
  719. # (change requires restart)
  720. memqcache_max_num_cache = 1000000
  721. # Total number of cache entries. Mandatory
  722. # if memqcache_method = 'shmem'.
  723. # Each cache entry consumes 48 bytes on shared memory.
  724. # Defaults to 1,000,000(45.8MB).
  725. # (change requires restart)
  726. memqcache_expire = 0
  727. # Memory cache entry life time specified in seconds.
  728. # 0 means infinite life time. 0 by default.
  729. # (change requires restart)
  730. memqcache_auto_cache_invalidation = on
  731. # If on, invalidation of query cache is triggered by corresponding
  732. # DDL/DML/DCL(and memqcache_expire). If off, it is only triggered
  733. # by memqcache_expire. on by default.
  734. # (change requires restart)
  735. memqcache_maxcache = 409600
  736. # Maximum SELECT result size in bytes.
  737. # Must be smaller than memqcache_cache_block_size. Defaults to 400KB.
  738. # (change requires restart)
  739. memqcache_cache_block_size = 1048576
  740. # Cache block size in bytes. Mandatory if memqcache_method = 'shmem'.
  741. # Defaults to 1MB.
  742. # (change requires restart)
  743. memqcache_oiddir = '/var/log/pgpool/oiddir'
  744. # Temporary work directory to record table oids
  745. # (change requires restart)
  746. white_memqcache_table_list = ''
  747. # Comma separated list of table names to memcache
  748. # that don't write to database
  749. # Regexp are accepted
  750. black_memqcache_table_list = ''
  751. # Comma separated list of table names not to memcache
  752. # that don't write to database
  753. # Regexp are accepted
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!