Re: distributed database architecture for a large database

ur setup: - Queries per second avg: 117.236 - Generating over a 1GB of binlog entries per day. - Running with ~120 GB of live data now (used to be 200+ but we have an archival scheme now) Not sure how this compares to your situation. -- Guy Davis http://www.guyda

Mod_Auth_MySQL for Apache 2 and Windows?

-2.0/win32/modules/ but it only crashes the Apache server. (Other people have had the same problem with this version as well.) -- Guy Davis http://www.guydavis.caCalgary, Alberta, Canada Digitally signed by GnuPG (DSA ID 30D52F0B at www.keyserver.net) PGP Fingerprint: 8DC8 4A6F C1AD

Mod_Auth_MySQL for Apache 2 and Windows?

-2.0/win32/modules/ but it only crashes the Apache server. (Other people have had the same problem with this version as well.) -- Guy Davis Phone: (403) 301-3426 Fax: (403) 301-3499 Pason Systems Calgary, AlbertaCanada Digitally signed by GnuPG (DSA ID 759A998E

Re: secure replication

s > there any way to encrypt replication communcations between these mysql > servers internally so i don't need to set up a vpn or ssl tunnel? thanks > all. Setting this up with SSH is quite easy. I have a How-To on it at: http://www.guydavis.ca/projects/oss/docs/ssh_mysql.jsp

Re: Help: SIGSEGV inside mysql_connect to remote server

On Thu, 2002-05-02 at 00:38, Jeremy Zawodny wrote: > On Wed, May 01, 2002 at 04:24:05PM -0600, Guy Davis wrote: > > > I am having a really strange problem with a in-house C application > > that calls mysql_connect() and generates a segfault deep within > > uname() when I

Help: SIGSEGV inside mysql_connect to remote server

n? My feeling is that this is most likely something wrong with our C application. However, it calls ssConnectDB right near the beginning of main(), so there isn't much opportunity for memory errors. Thanks. -- Guy Davis Phone: (403) 301-3426 Pas

Help: SIGSEGV inside mysql_connect to remote server

n? My feeling is that this is most likely something wrong with our C application. However, it calls ssConnectDB right near the beginning of main(), so there isn't much opportunity for memory errors. Thanks. -- Guy Davishttp://www.guydavis.ca PGP: D2E2 76D4 0C9C 5D99 42AA EB

Re: Rotation of binary logs on replication master?

2k/var/lib/mysql/nachos-slow.log 4.0k/var/lib/mysql/nachos.us.pason.com.pid -- Guy Davis Phone: (403) 301-3426 Pason Systems Fax: (403) 301-3499 PGP: 65BA 484B 0B96 5F3B 4D40 DCA2 B2AE 6B5A F52B 1445 ---

Rotation of binary logs on replication master?

Any tips? Thanks. -- Guy Davis Phone: (403) 301-3426 Pason Systems Fax: (403) 301-3499 PGP: 65BA 484B 0B96 5F3B 4D40 DCA2 B2AE 6B5A F52B 1445 - Before posting, please check:

Re-baselining replication slaves?

that have been replicating for a year plus with no troubles? Thanks. -- Guy Davis Phone: (403) 301-3426 Pason Systems Fax: (403) 301-3499 PGP: 65BA 484B 0B96 5F3B 4D40 DCA2 B2AE 6B5A F52B 1445

Re: Running Without TCP Port

On Fri, 2002-02-22 at 11:09, havoc wrote: > Is it possible to run mysqld without binding to a TCP port? > As in run using only unix sockets? Start with --skip-networking: http://www.mysql.com/doc/C/o/Command-line_options.html or put skip-networking into your my.cnf file. -- Guy

Re: insert picture file in MySQL (+php)

(5) unsigned default NULL, `width` smallint(5) unsigned default NULL, `thumb_height` smallint(5) unsigned default NULL, `thumb_width` smallint(5) unsigned default NULL, `img_data` longblob, `category` smallint(5) unsigned default NULL, `access` enum('Public','Personal&#

ADO to MySQL interface?

er, and MS Access. I'm wondering if there is an ADO adapter out there that will work with MySQL. I know of the ODBC connector, but I'm told ADO replaces ODBC(?). If possible we'd like to stick with MySQL, rather than paying large licensing fees for either Oracle or S