New answers tagged

1

Yes you can define in pgbouncer your 2 servers (or more) masetr and slave and connect to each of them. There is different kind of topology you can install pgbouncer on each www, as is the connection will be the fastest (www process can use unix socket to connect), on install a pgbouncer on each server (master and slave) or install it on a new host to be ...


1

Setting in the command line are not persisted anywhere. Therefore after a restart it resets to default or picks up the value from the config file. Put the following line into your my.cnf file under the [mysqld] section: max_allowed_packet = 16777216 About how to find what file is used you can find some resources here on stack exchange as well: ...



Top 50 recent answers are included