Success -- MySQL / MyODBC install

[michael d hoskins]

Are you needing to replicate those two machines' databases, keeping KC
and St. Louis in-sync with each other?  Unfortunately, MySQL doesn't
*directly* provide for that.

There is a way to sorta force it to happen semi-live, using MySQL's
logging feature and by piping the data to the other MySQL server node.
However, (and the doc doesn't tell you this,) you need to write a script
that periodically resyncs things, if they can't talk to each other for
awhile.  Of course, you better use unique keys, if you try this option.
In the docs, there is a section on how to do backup and recovery,
logging, and "replication:"
http://www.mysql.net/Manual/manual.html#Common_problems  It's Chapter
20, "Solving Common Problems."  Eventually, MySQL should be adding
one-way replication as a standard feature:
http://www.mysql.com/Manual_chapter/manual_TODO.html

MySQL is a very cool SQL database.  It is a real SCREAMER for speed, and
the ability to work with programming languages is unparalleled.  The
sheer numbers of web and Open Source programmers is staggering.  And,
it's got source code and great docs.

I'd strongly recommend the O'Reilly book MySQL & msql:
http://www.oreilly.com/catalog/msql/ and the index is at
http://www.oreilly.com/catalog/msql/inx.html  (It's a VERY good book.)
Other books can be found at http://www.mysql.net/mysql-books.html

As good as MySQL is, however, it does miss foreign keys; a good,
standard backup and recovery feature; transactions, including rollback
and commit; and true, built-in procedures/stored objects.  These are all
left out for speed and size considerations.  As a result, don't expect
is scale like an Oracle or a DB/2.  Now Postgres has all of this, I
think, and it's truly free, but it's so much slower that you gotta
strongly consider MySQL.

Compared to M$ Acce$$, though....  Egad, MySQL is awesome!

I haven't *yet* tried MyODBC.  I've been (rapidly) weaning myself off of
booting up M$ at all, at least at home, so I haven't (yet) had the need,
but I want to try it, some day, soon.

If you use MySQL commercially, you might have to pay $200.00, depending
on circumstances.  Otherwise, it's free.  You can buy a support
contract, if you feel you ever need it.  Just read the license before
you go live:
http://www.mysql.net/Manual_chapter/manual_Licensing_and_Support.html
In fact, read it if you do anything other than 100% personal use.  The
Windoze version always costs.

-----Original Message-----
From: bradmiller [mailto:bradmiller at dslonramp.com]
Sent: Thursday, April 06, 2000 1:43 PM
To: kclug
Cc: bradmiller
Subject: kclug - Success -- MySQL / MyODBC install

Boy -- I become more impressed with Linux every day.  I finally figured
out
how to get my home box (Cold Fusion) to talk to my Linux server running
MySQL.   I then figured out the granting privileges and told my server
in
St. Louis how to get to it and viola -- it works like a charm.   This
will
be so nice to test with MySQL instead of Access as a database.  I can
use
the same dataset in both locations too -- which will make debugging in
my
test vs. production environment a lot better too.   I'm learning as much
as
I can so we can put a Linux/MySQL box in St. Louis just to handle our
database chores.   Then we'll also be adding a Linux server here in KC
also.

Just wanted to let everyone know how things are going.   I can probably
give a few pointers here and there . . . I've been across ?? sites worth
of
notes and documentation.   Whew!

Bradley Miller, Programmer/webmaster
AccessZone Design - www.accesszonedesign.com
Blue Springs, Missouri office
Phone: 816-228-3814 Fax: 559-663-4046