At 04:02 AM 7/4/2003 -0500, woody at nfri dot com wrote:
What kind of traffic volume is generated with replication, our database
has a pretty steady read/update volume throughout the day and its pretty
much 50/50 read/write. I do plan to offload some of the reads (such as
for daily reports and
if that should ever be necessary. This is not always so
easy when relying on embedded trigger and active SQL technologies in some
databases.
_M
Pete McNeil (Madscientist)
President, MicroNeil Research Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
At 05:59 PM 6/17/2003 -0700, Jeff Weeks wrote:
I can't access MySQL using Java on Linux! It's killing my project. I
can access that very MySQL from PHP just fine. I have the same database
running on Windows so I can develop what I need to. Just can't run
anything for our users!!!
I don't
to cause significant loading since
the same record is always in the database cache and in precisely the same
location. A prepared statement can also help here.
Hope this helps,
_M
Pete McNeil (Madscientist)
President, MicroNeil Research Corporation.
--
MySQL General Mailing List
For list archives
Usually the best way to do this is to store the images in an accessible
directory and then store the URL for the image in the database. It's a
fairly simple exercise also to create an upload function that will associate
the two for you automatically.
Hope this helps,
_M
]-Original
You might also consider using two integer type fields - one for the
numerator and another for the denominator. This way storage and recovery are
easy and the mathematics are wide open.
_M
]-Original Message-
]From: MySQL [mailto:[EMAIL PROTECTED]]
]Sent: Thursday, September 19, 2002 7:51
We've got a sloppy database that we must import to from another sloppy
database. The slop is due to user data entry and process inconsistencies
- that can't be fixed here.
The query we need to do (loosely) is this:
insert into table B
select SPO, Field2, Field3, etc... from table A
where
We use a strategy of giving each node a unique ID and using the combination
of the NodeId and the AUTO_INCREMENT value as the key for the objects. The
AUTO_INCREMENT field ensures uniqueness between records in a single node.
The NodeID ensures uniqueness between nodes.
This way nodes that are
Hi,
We're doing something weird (what else is new). We're hoping to use
MySQL as the base of a distributed database with peer replication. Most
of the peering and control mechanisms will be in the core application
code, but we're counting on MySQL's ability to replicate for some of the
