This sounds encouraging, but are there any known problems with the MySQL
replication model currently available?? Would the slave servers have the
same auto_inc column attributes? Could this conflict somehow with the master
server??
Thanks for the quick reply!
Patrick
# Personnaly, i have found autoincrement fields to be rock solid.
# I use'em all over the place on a 1 Gb database, web based.
# Don't do it manually . You'll end up doing the same thing
# that mysql gives you for free.
#
# Christopher Lambrou,
# CGL Computer Services, Inc.
# Empire State Building,
# PMB 16J Suite 3304
# New York, NY 10118
# Tel: (212) 971-9723
# Fax: (212) 564-1135
# URL: http://www.cglcomputer.com
# Email: [EMAIL PROTECTED]
#
# On 5/3/2001 15:57:38, you said:
# >Hello!
# >I have a database with about 10 tables in it. In every table I have a
# >RECORD_ID
# >field so that I can at least uniquely identify a row if I
# need to, also its
# >used in relationships. The question is should I use the
# AUTO_INCREMENT for
# >this, or should I manually generate this value, getting the
# next highest
# >number, then putting it in there. Is there any known
# replication problems if
# >I use AUTO_INCREMENT??? Would I be safer in just doing this
# manually myself
# >in my code?? This is going to be a web-based app, so many
# users will be
# >using the db at the same time.
# >Thanks!
# >
# >Patrick
# >
# >---------------------------------------------------------------------
# >Before posting, please check:
# > http://www.mysql.com/manual.php (the manual)
# > http://lists.mysql.com/ (the list archive)
# >
# >To request this thread, e-mail <[EMAIL PROTECTED]>
# >To unsubscribe, e-mail
# <[EMAIL PROTECTED]>
# >Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php