Share Pastebin
Guest
Public paste!

Untitled

By: a guest | Mar 20th, 2010 | Syntax: None | Size: 0.72 KB | Hits: 120 | Expires: Never
Copy text to clipboard
  1. Here's some sample configurations:
  2.  
  3.    http {
  4.        ...
  5.  
  6.        upstream cluster {
  7.            # simple round-robin
  8.            drizzle_server 127.0.0.1:3306 dbname=test
  9.                 password=some_pass user=monty protocol=mysql;
  10.            drizzle_server 127.0.0.1:1234 dbname=test2
  11.                 password=pass user=bob protocol=drizzle;
  12.        }
  13.  
  14.        upstream backend {
  15.            drizzle_server 127.0.0.1:3306 dbname=test
  16.                 password=some_pass user=monty protocol=mysql;
  17.        }
  18.  
  19.        server {
  20.            location /mysql {
  21.                set $my_sql 'select * from cats';
  22.                drizzle_query $my_sql;
  23.  
  24.                drizzle_pass backend;
  25.            }
  26.            ...
  27.        }
  28.    }