I just set up a master/slave replication scheme and all is well,
but through the procedure did get bit on the tail.
After the setup, and after the master and slave mysql servers
had been started, I got some error messages that pointed to
a type in the slave's my.cnf file. I shut the slave down,
Grigory Bakunov wrote:
Hello!
TW Hi all,
TW I'm running MySQL Ver 3.23.32 for -freebsd4.2 on i386, With PHP4
TW compiled statically into Apache 1.3.17. All connections
to the database
TW are non-persistent connections. It's a pretty busy
server, hitting
TW about 60 queries
It seems certainly possible to automate 2 mysql servers
in circular replication, each being master/slave to the
other, provided your code is written in such a way to
circumvent the auto_increment issue. Generating unique ids
on a machine basis and using those values instead of an
autoincrement
I suppose there will always be that facet out there
that think spending $46zillion dollars on Oracle
is ok because saying 'we use Oracle' is just plain sexy
and the option includes, you know, a free t-shirt and
hat.
Im sure there are specific valid reasons for not using
MySQL. None of them were
I've had no problems at all with this setup.
Locate libmysqlclient.so.10 and make sure the
dir its in is in /etc/ld.so.conf, and run ldconfig.
From a source install, its in /usr/local/mysql/lib/mysql.
Mike Robinson
IT / Developer - Toronto Star TV
Phone: 416.945.8786
Fax: 416.869.4566