Sasha:
Replication means keeping multiple copies of the database, each
copy being serviced by one server running in one processor. Also, each query
in one database is repeated on the second one. From this understanding, I
dont see any potential performance improvement. (I have not read the
replication code in MySQL yet, though). But this way
each query would have to be done twice.
Our system allows for having a single copy of the database, visible to
all processors.
As you said in your note, the key is to get the locking right.
Can you suggest which files I should look for placing the
inter-processor locks ? (I am leery of making every call to pthread_mutex
into a global lock, since this may hinder parallelism un-necessarily).
I think we only need to lock around opening and closing files (tables) by
each processor. What do you think ? (& Thanks for taking the time
to help with this issue).
regards
Mauricio
>From: Sasha Pachev <sasha@stripped>
>To: "Mauricio Breternitz" <mbjsql@stripped>, internals@stripped
>Subject: Re: parallel Mysql ?
>Date: Tue, 23 Jan 2001 19:19:19 -0700
>
>
> >
> >Any suggestions at which files should I look into as reasonable place to
>put
> >inter-processor locks ?
> >(I'm currently delving in the sql/*.cc files and looking at things
> >like open_and_lock_tables ),
>
>I have only one suggestion. Try replication. If it is not fast enough,
>explain why. MySQL works best when the disk is local and there is no
>external
>lock contention.
>
>--
>MySQL Development Team
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Sasha Pachev <sasha@stripped>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
>/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
> <___/
>
>---------------------------------------------------------------------
>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 internals-thread365@stripped
>To unsubscribe, e-mail <internals-unsubscribe@stripped>
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
