[Chugalug] Newbie question

Dan Lyke danlyke at flutterby.com
Mon Aug 19 03:25:08 UTC 2013


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sun, 18 Aug 2013 19:30:22 -0400
Dave Brockman <dave at brockmans.com> wrote:
> If your environment allows it, I'd recommend two users per database.
> One with read-only privs that you make all your non-updating db calls
> with.  But definitely add a user separate from the database "root"
> account.

And if you can get into the habit of the two user style, then when it
comes time to work off of a master database and a replicated slave, you
can point each of those database handles to the appropriate master
(writable) and slave (read-only).

Dan
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)

iQEcBAEBAgAGBQJSEZAVAAoJEAvds6IeGLPDfk4IAMABawToieG/LBO087f+6YCH
LBtjfQnZdF3Y0C41N9fVc0SiXVwEG/VolVO/AcFcyRygwi4UO3YTkcRc0N9nPSjM
qhbR8spAFwQR/7pdPs9URmfiNtERzIEp97V4Rom+K1c5UJRHc9eaQq7d9OIEUYZS
Y8zttKgTHTLcds3GRE/pjUl16I7MG920UJgPxnuKwTSO9dkecIiGtGD+CYM3tfp0
YfAPLCFYqvL68slz4WQDk9monExI3Hn3KrDMJQclLcNtB2MABWbvTShK7005RQvq
nveMoPvIZqCwyHdCG3CfbKewHNcBkROwCVfHK7mTcBxqa68MsTNHkjP99PI/LNQ=
=zH+r
-----END PGP SIGNATURE-----


More information about the Chugalug mailing list