Hi,
This might be somewhat off-topic, if so, I do apologize,
but I'd really appeciate any help on this.
Now that I have my DBMail working (thank you all), there
is one more thing I would like to do before moving on to
testing with real data.
Is there a way I can have 2 live mirrors of DBMail se
Hard to help you, if you don't say what database, and what database
version, you are using. MySQL supports replication:
http://dev.mysql.com/doc/mysql/en/Replication.html
I don't know much about postgre,. I found this on the web:
http://gborg.postgresql.org/project/pgreplication/projdisplay.php
That approach is essentially .
What I would like to be able to do is at least one level
above database replication:
I would like 2 DBMail servers to be in sync irrespective
of their RDBMS engines etc.
Apparently, the magic google keyword is 'IMAP replication'
with which I found this link.
htt
Although dbmail is hardly optimized for such tools as they rely heavily on imap searching, you might check out
offlineimap, which is a robust imap sync tool.
But this really is a flawed approach wrt dbmail. Using imap to sync dbmail storages is a highly convoluted
approach to database replicati
ocl wrote on 2004-11-28 16:49:
That approach is essentially .
Opps, sorry. I meant to write:
That approach is essentially database replication.
Ray,
I'm not sure if I've read your aims correctly, but... From what I've
Googled, maybe big DB boxes with Slony for data replication, and
multiple IMAP front ends (LVS maybe?) could be a possibility?
http://gborg.postgresql.org/project/slony1/projdisplay.php
Richard.
On Mon, 2004-11-29 at 03:49
Why not use DB replication? MySQL supports this in 4.x i believe.
~Rob
On Mon, 2004-11-29 at 03:49, ocl wrote:
> That approach is essentially .
>
> What I would like to be able to do is at least one level
> above database replication:
>
> I would like 2 DBMail servers to be in sync irrespective
Paul J Stevens wrote on 2004-11-28 17:29:
Although dbmail is hardly optimized for such tools as they rely heavily
on imap searching, you might check out offlineimap, which is a robust
imap sync tool.
But this really is a flawed approach wrt dbmail. Using imap to sync
dbmail storages is a hig
Richard Barrington wrote on 2004-11-28 22:46:
I'm not sure if I've read your aims correctly, but... From what I've
Googled, maybe big DB boxes with Slony for data replication, and
multiple IMAP front ends (LVS maybe?) could be a possibility?
http://gborg.postgresql.org/project/slony1/projdisplay
> So, instead of 2 DBMail boxes, I will have one Cyrus box (which the users
will connect to), and a DBMail box which will only be used for statistical
analysis and archive purposes. DBMail is perfectly
> suited for that purpose; it saves me a lot of coding.
Unless you've got a particular need to
Mark Mackay - Orcon wrote on 2004-11-29 03:05:
So, instead of 2 DBMail boxes, I will have one Cyrus box (which the users
will connect to), and a DBMail box which will only be used for statistical
analysis and archive purposes. DBMail is perfectly
suited for that purpose; it saves me a lot of c
ocl wrote:
So, instead of 2 DBMail boxes, I will have one Cyrus box (which
the users will connect to), and a DBMail box which will only be
used for statistical analysis and archive purposes. DBMail is
perfectly suited for that purpose; it saves me a lot of coding.
This is why any replication
ocl wrote:
...
-- Single copy. Again, our people simply thrive on sending CC/BCC stuff
to 10 dozen people for every single mail. Again, without Cyrus,
we'd all be working for disk manufacturers.
Correct me if I'm wrong, but isn't this the purpose of the physmessage
table, so the sa
On Mon, 29 Nov 2004 04:44:03 -0800, Blake Mitchell
<[EMAIL PROTECTED]> wrote:
> ocl wrote:
> > ...
> > -- Single copy. Again, our people simply thrive on sending CC/BCC stuff
> > to 10 dozen people for every single mail. Again, without Cyrus,
> > we'd all be working for disk manufacture
Stefano Radice <[EMAIL PROTECTED]> writes:
> but it sounds more like a project for future support. Maybe somebody
> in the list can help us on pg.
http://slony.info/. It is very reliable, but you must have a primary
key on every table to be replicated.
Mike
--
You better not mess with Major Tom
Michael Alan Dorman wrote:
Stefano Radice <[EMAIL PROTECTED]> writes:
but it sounds more like a project for future support. Maybe somebody
in the list can help us on pg.
http://slony.info/. It is very reliable, but you must have a primary
key on every table to be replicated.
You can also
Hi list,
ALthough this sounds like more of an MySQL question, my knowledge in
MySQL is very limited as of now so please bear with me :).
In one of my server, I used the command:
mysql -u root -p < sql/mysql/create_tables.mysql
to create the mysql database.
I would like to mirror that in one o
You should probably read the MySQL manual on this. There's a chapter on
replication there, which might have some info on mixing InnoDB and
MyISAM tables.
Ilja
On Wed, 2004-04-28 at 03:02, Kenneth Oncinian wrote:
> Hi list,
> ALthough this sounds like more of an MySQL question, my knowledge in
>
Thanks Ilja,
Yes, I'm reading the MySQL manual at this very moment.
Thanks again.
regards,
Kenneth
Ilja Booij wrote:
You should probably read the MySQL manual on this. There's a chapter on
replication there, which might have some info on mixing InnoDB and
MyISAM tables.
Ilja
On Wed, 2004-0
t; Sendt: 28. april 2004 10:02
> Til: DBMail mailinglist
> Emne: Re: [Dbmail] mirroring dbmail mySQL database
>
> Thanks Ilja,
>
> Yes, I'm reading the MySQL manual at this very moment.
> Thanks again.
>
>
> regards,
> Kenneth
>
>
> Ilja Booij w
First the question. Are their any plans to add the client compression
protocol as a configuration option?
I am using Cyrus as my primary imap server. I have around 600 users. I
currently rsync nightly between to different locations to back up the
server. I also wound up using Amavisd-new and d
meddelelse-
Fra: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] På vegne af Kenneth Oncinian
Sendt: 28. april 2004 10:02
Til: DBMail mailinglist
Emne: Re: [Dbmail] mirroring dbmail mySQL database
Thanks Ilja,
Yes, I'm reading the MySQL manual at this very moment.
Thanks again.
regards,
Kenneth
atelog and
manage on its own.
Hope this helps...
Joakim
-Ursprungligt meddelande-
Från: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] För
Kenneth Oncinian
Skickat: den 28 april 2004 10:54
Till: DBMail mailinglist
Ämne: Re: SV: [Dbmail] mirroring dbmail mySQL database
Hi Mikael,
Ok :)
Althou
On Wed, Apr 28, 2004 at 11:32:23AM +0200, Jocke wrote:
> If you want to set it all up, just make sure you start an update-log on your
> master server and connect the slave to it.. then if you're running mysql 4.0
> or higher just issue the command "LOAD DATA FROM MASTER;" and the slave will
> becom
Thanks Jocke and Christian for your reply, I appreciate it.
I tried "mysqldump --opt dbmail > backup-dbmail.sql" to backup the
dbmail and restore the database to the temporary server using "mysqldump
--opt dbmail > backup-dbmail.sql" but it errors with the error message:
ERROR 1064 at line 37
Hi,
From what I have read is MySQL cluster really fast. It is geared
toward telecom applications. There is only one drawback, the
complete database currently resides in the computer RAM.
Magnus
Christian G. Warden wrote:
On Wed, Apr 28, 2004 at 11:32:23AM +0200, Jocke wrote:
If you want t
BMail mailinglist
Subject: Re: SV: SV: [Dbmail] mirroring dbmail mySQL database
On Wed, Apr 28, 2004 at 11:32:23AM +0200, Jocke wrote:
> If you want to set it all up, just make sure you start an update-log
on your
> master server and connect the slave to it.. then if you're running
mysql 4.0
27 matches
Mail list logo