Got timeout reading communication packets
Hello, I am running MySQL 3.23.37-log and I was looking at my .err log file. What I found was a ton of entries like this one: 010709 16:35:01 Aborted connection 1040 to db: 'xsparts' user: 'xsparts_user' host: `localhost' (Got timeout reading communication packets) Any idea what this means? How do I fix this? My platform is FreeBSD 4.2, Apache and PHP 4 for website development stuff... 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
RE: ACCESS DB, and MySQL which one better to handle database driven webpage
First off, I wouldn't really want to call Access a database, as its little more than just a file with 1/2 of a program trying to access it. And second, I would say that MS SQL is both over-priced, and way too bloated, buggy, slow, etc, etc. (but then again, everyone has their own opinion on this). As far as MySQL goes, it seems to be a very excellent database system. Its fast, lightweight, fairly bug-free (much, much, much better then the two above), the support is unmatched, easy to use (if you understand SQL, which you should for any database), etc, etc. One of the most popular combinations to drive a dynamic web site is Apache, MySQL, PHP, all running on either Linux or FreeBSD. Many, many, many more sites on the internet run in this combination meaning that if you ever get stuck somewhere you won't have a hard time finding any help on it. MySQL can handle infinately more concurent connections to it, and handle a much bigger load than MDB can even dream of doing. A few years back I used to write database apps in visual basic and MDB. It was running on the network, with only about 5 people accessing it at one time. MDB had corrupted the files at least twice. I was very sad :o) Anyway, I have since been writing all my database apps using the PHP language, on Apache web server and accessing the MySQL database. The results? Never ever ever have I had a corrupted database, very fast - can easily handle loads of 100+ users at one time without even missing a step. This is good news to me! And best of all, its 100% free (unless you would like to donate anything to the project, or opt for professional support from the makers of the db). I know all of this sounds much like just a personal opinion, so I'll have you check out this link for yourself: http://www.mysql.com/information/benchmarks.html Hope this helps! Patrick # -Original Message- # From: Colin TMC [mailto:[EMAIL PROTECTED]] # Sent: Friday, June 22, 2001 6:56 AM # To: [EMAIL PROTECTED] # Subject: ACCESS DB, and MySQL which one better to handle # database driven # webpage # # # Can anybody help with the question about which one is the # best to handle database driven webpage, Since, we are # running on ACCESS DB, and MS SQL for a long time, but, We # just have our new Lynex server it is running MySQL, my question is: # # 1) What's the different between MDB and MySQL. I mean the # string of code? # 2) Is it worth to have this upgrade? # # Thanks for the time # - 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
RE: what is the difference between, MDB and MySQL
Well, that all depends on what language your apps are written in. VB? Delphi? C? PHP? Perl? and what database architecture are you using within the language (ie, in VB are you using ADO, or ODBC, or DAO, etc)... Also, for a good comparison of databases, look at this: http://www.mysql.com/information/crash-me.php Patrick # -Original Message- # From: Colin [mailto:[EMAIL PROTECTED]] # Sent: Wednesday, June 20, 2001 10:35 PM # To: Siomara Pantarotto # Cc: [EMAIL PROTECTED] # Subject: Re: what is the difference between, MDB and MySQL # # # I mean, the connecting string, what is the different # # MySQL. Interbase SQL, ACCESS and MS SQL # # is it the same, since, I have coded webstore by using # ACCESS's MDB, but, # currently, we need to move to Lynex OS comes with mySQL installed in # server.. so, if program move to lynex, will it work properly? # # Thanks # # # # # # - Original Message - # From: Siomara Pantarotto [EMAIL PROTECTED] # To: [EMAIL PROTECTED]; [EMAIL PROTECTED] # Sent: Thursday, June 21, 2001 10:46 PM # Subject: Re: what is the difference between, MDB and MySQL # # # MySQL is a database just like others: # # Oracle (Oracle) # SQL Server (Microsoft - for large systems) # Access (Microsoft - for small systems) # DB2(IBM) # etc... # # MDB, as I know, is the termination (extension) given to a database # generated # by MS Access. # # For example: NorthWind.mdb (example provided by Microsoft # when you install # Access) # # Siomara # # # From: Colin [EMAIL PROTECTED] # To: [EMAIL PROTECTED] # Subject: what is the difference between, MDB and MySQL # Date: Wed, 20 Jun 2001 22:47:15 -0500 # # # # # __ # ___ # Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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
RE: [MySQL] DATE_FORMAT
$Result = @mysql_query (SELECT DATE_FORMAT(EventStartDate,'%M %D %Y') AS EventStartDate FROM EventsTable); $Row = mysql_fetch_array($Result); printf(Event Date:%s, %Row['EventStartDate']; Hope this helps :o) --Patrick # -Original Message- # From: Tim Thorburn [mailto:[EMAIL PROTECTED]] # Sent: Tuesday, May 29, 2001 12:40 PM # To: [EMAIL PROTECTED] # Subject: [MySQL] DATE_FORMAT # # # Hi, # # I've setup a database to keep track of various events. Now # I'm working on # displaying these events on the screen through a web browser. # I've got all # the crucial information displaying - now its time for a # little fine tuning. # # All the dates in my database are ISO format, so -MM-DD, # I'd like to # display them in a more user friendly format. For example, # there is an # event taking place this Wednesday, in ISO 2001-05-30 - I'd like it to # display as May 30th, 2001. # # Through the command line, I know I do this by typing: # select DATE_FORMAT(EventStartDate, '%M %D %Y'); # # My question is how would i get this information to display via 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
RE: RTFM - Show locks
I too have wondered this... it looks like the manual just says (in your case) user 'b' will wait indefinitely for the lock held by user 'a' to be released. Maybe you could just have user 'a' hold a READ or READ LOCAL lock and not a WRITE lock, therefore user 'b' will still be able to do SELECTS ok... ?? Patrick # -Original Message- # From: Warren van der Merwe [mailto:[EMAIL PROTECTED]] # Sent: Friday, May 04, 2001 3:39 AM # To: [EMAIL PROTECTED] # Subject: RTFM - Show locks # Importance: High # # # database, sql # # Hi there # # I have tried looking in the manual but can't see the solution to this. # # user a issues a lock on table1, userb then tries to do a select and # obviously the select will wait until the lock is released. # # So my questions are :- # # 1. How do you change the 'timeout' period that userb will wait for? # # 2. When the timeout is reached, I want to give the user a # message box that # shows them who is currently locking the table. How do I see # who is locking # table1? # # Regards # Warren # # ~ # Warren van der Merwe # Software Director # PRT Trading (Pty) Ltd t/a RedTie # Durban, South Africa # Cell (+27-83) 262-9163 # Office (+27-31) 767-0249 # # # # - # 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
Auto_increment or manual??
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
RE: Auto_increment or manual??
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
RE: Auto_increment or manual??
Thank you Chris with this info! This will greatly help me out, so as I see it now, there is absolutely no advantage to generating your own unique numbers manually - just let MySQL do it for you am I correct in this assumption? Again, thanks! Patrick # http://www.mysql.com/doc/R/e/Replication_Features.html # # Replication will be done correctly with AUTO_INCREMENT, # LAST_INSERT_ID, and # TIMESTAMP values. # # 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?? # # # - # 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
What is most stable??
How stable is InnoDB, BDB, MyISAM, etc?? I am developing a production system using MySQL, and wanted to know that stability status on these table types. I wanted to use transactions if I could - is the transaction-enabled table types stable enough for production? Or should I stick with MyISAM and engineer transaction-like behavior into my code?? 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
How Stable is InnoDB / BDB
I am in the process of building a database/php app that is going to require transaction support. Which table type should I go with? BerkeleyDB or Innobase?? It looks like the InnoDB has some neat features like row-level locking, etc. but is it stable enough for a production system, or should it be considered Alpha?? 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
RE: Need help with a Freebsd install..
Larry, if you haven't resolved this yet - you might want to install from the sources, like I do. I am also running FreeBSD 4.2, here is what I did, and it seems to work like a champ. 1) get the source from www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.37.tar.gz 2) put this file in some directory on your system (mine is /usr/src) 3) go to that directory and run 'gunzip mysql-3.23.37.tar.gz' 4) now run 'tar -xvf mysql-3.23.37.tar' 5) now run 'cd mysql-3.23.37' 6) type './configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data --with-mysqld-user=mysql --with-thread-safe-client --enable-assembler' 7) now type 'make' 8) then 'make install' 9) now, it should be installed to /usr/local/mysql, but we told mysql that we want to run it as user 'mysql' (--with-mysqld-user=) so, create a user account named 'mysql' and make him part of the group 'mysql' by running 'adduser' 10) now you can create the grant tables if they aren't already there, run '/usr/local/mysql/bin/mysql_install_db' 11) now, make sure the user 'mysql' has access to the mysql stuff, run 'chown -R mysql /usr/local/mysql' and 'chgrp -R mysql /usr/local/mysql' 12) also, make the start/stop scripts executable by him, run 'chmod u+x /usr/local/mysql/share/mysql/mysql.server' and 'chown u+x /usr/local/mysql/share/mysql/mysql.server' 13) now, the last thing is to copy the mysql config file to /etc (this will make the config options global), so do this 'cp /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf' and be sure to look at the file /etc/my.cnf to see if you need to change anything there. 14) now we should be good to go, test the server by running '/usr/local/mysql/share/mysql/mysql.server start' it should start just fine, you might even want to check the error logs in /usr/local/mysql/data/(whatever.foo.bar.err) I hope this helps you out! Patrick # -Original Message- # From: Larry Caragay [mailto:[EMAIL PROTECTED]] # Sent: Wednesday, April 18, 2001 3:45 PM # To: [EMAIL PROTECTED] # Subject: Need help with a Freebsd install.. # # # Can any one help me install Mysql on my Freebsd 4.2 box.. # the first thing I did was: # # got a copy of Mysql for mysql.com # # placed in in the /usr/local # # then: # # gzip -dc mysql-3_23_36-unknown-freebsdelf4_2-i386_tar.gz | tar -vxf - # # created a mysql directory. # /usr/local/mysql # # then # ./configure --prefix=/usr/local/mysql # # After all that it will not attach to any DB.. It will run but # I can restart # it once it is stopped with out doing ./configure # --prefix=/usr/local/mysql # again.. # # Help.. # # Larry # # # - # 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
RE: Inserting data to multiple table at once
Yeah, it does require one insert command per table, thats why some people
like transaction capability in tables. If we all could insert data into
multiple tables with one insert command then we wouldn't need transaction
support would we? H, that would be nice though! :o)
Patrick
-Original Message-
From: Peter Skipworth [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 11:47 AM
To: Fates
Cc: [EMAIL PROTECTED]
Subject: Re: Inserting data to multiple table at once
mySQL requires one insert command per
table. Stop being lazy, *grin*
P
On Wed, 18 Apr 2001, Fates wrote:
How do I insert data into multiple tables without having to use multiple
insert statements? Can I just do Insert into table1 (data) table2
(data)
table3 (data) or do I have to use seperate INSERT statements for each
table? I would like to add all at once from web page form
$query = "INSERT INTO $table VALUES ('$menu_id', '$server',
'$menunumber', '$menuname')";
--
This email was sent using w3mail.
-
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
--
---
Peter Skipworth
Perl Developer/Unix Systems Administrator
[EMAIL PROTECTED]
+44 795 055 0029
---
4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61
20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a
-
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
Re: INSERT records into multiple tables
Yeah, this is why some people like the idea of having transaction supports
in the tables, to make sure both the inserts to the two tables succeed, or
none of them do. Currently MyISAM does not support this, only the newly
introduced Berkeley DB tables support this feature although it is assumed
quite a bit slower than the native MyISAM tables (albet a bit buggier as
well)...
Good luck!
Patrick
you can't. You have to do 2 seperate inserts. (Sorry)
Cal
http://www.calevans.com
-Original Message-
From: Bryan Wheelock [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 3:47 PM
To: [EMAIL PROTECTED]
Subject: INSERT records into multiple tables
I'm just learning how to use MySQL and I am searching for a more simple
way
of doing an INSERT query into multiple tables simultaneously.
I have done my best to nominalize my DB but that creates but I'm confused
as
to how to insert data into the DB and have all the related table be
updated.
I think that I can work out some way using conditional statements in PHP
to
insert the data into all the records, but I'm thinking there must be a
more
elegant and faster way of doing this.
e.g.
table people
1Bryanstudent
2Jill teacher
3 Bob student
table job
1student
2teacher
If I want to insert a record to table PEOPLE :
insert into people values('4', 'Jon', doctor)
How can I do this without having to also do a separate insert into table
JOB?
You need to Understand the rules so you can break them intelligently,"
the Dalai Lama
-
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
RE: Simple Multi-Master/Slave Fail-Over Set Up {Was Re: parallel Mysql ?}
You might want to take a look at this site:
http://www.phpbuilder.com/columns/tanoviceanu2912.php3
--Patrick
-Original Message-
From: Van [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 8:02 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Simple Multi-Master/Slave Fail-Over Set Up {Was Re: parallel
Mysql ?}
Michael Widenius wrote:
We plan to use the following algorithm on top of our current
replication code to achieve this:
http://www.fault-tolerant.org/recall/
Regards,
Monty
Greetings All:
2 Parts...
Part 1:
I reference the above because the Recall project hasn't had any activity
since
September 2000 and, after wasting 2 1/2 hours building the ACE and Pth
dependencies want to know if MySQL still has interests in the Recall
project, or
just the algorithm, and, if so, what is the algorithm? This might seem a
brain-dead question, but, what the Screenshots on the Recall web-site
display
looks promising and could have viable uses for a multi-node application;
specifically a fail-over multi-node; multi-master/slave MySQL
implementation.
Unfortunately, recall-0.8 cannot be built on any of my systems.
Part 2:
Specifically, I'm building the following high availability configuration. I
have two networks, and potentially others once the proof of concept is in
place. The primary site runs several stand-alone MySQL applications for
several
domains on one server. Mostly web-server logging. So, this server needs to
update itself.
The second network will have 5 IP addresses and each will run a fully
mirrored
Apache/MySQL application server. Each will track it's own traffic.
Additionally, I'd like it to update all other nodes with traffic activity.
Unique ID's on auto-increment fields aren't a consideration. Each server
will
simply log the hit and notify each slave that it should update itself. Each
node should be a master and a slave. If one slave goes down, it will be
notified by the nearest (network distance; that is) master of the updates it
needs. Since this slave is also a master, it will need to notify the
nearest
slave to replicate any data that was saved to the server that just came back
up,
if any.
On paper it looks simple. Reading the master/slave implementation currently
available, I don't see that the current state of replication can support
this,
but, perhaps the above algorithm is similar to the Recall algorithm. If so,
what's necessary to do this, and, what are the complications in having each
node
be a slave and master and all nodes listen to each node for updates as well
as
notifying other nodes when updates are needed?
Thanks for any useful thoughts.
Best Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com
=
-
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
MySQL Database and NAS
Hello all; Are there any known problems with storing the database files on a NAS (network attached storage) device?? also, can you run multiple MySQL daemons pointing to one common database, so you could have a "cluster" of database servers and one database?? 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
