Hiya matt,

Sorry for the delay reply,

Thank you for the idea. As for the workaround for the ID Conflict, that;s why I 
want to use Percona / Galera cluster, co-worker said that they have automated 
system about the conflict ID. But for starter, I will try to implement that 
master-slave sync to james. For the ID- Problem, some people said that : each 
server (example 2 server)  can only create specific number of sequence, Server 
1 can only create ID 1,3,5 and so on while Server 2 can only create ID 2,4,6  
and so on to avoid conflict.

How things coded and how it works , detect if my server back up online and 
syncing up everything is still unknown to me. But at least I have an idea how 
things work. But im guessing firstly I have to create a custom Mailet and using 
javamail to send the “unsynchronized” message to all server when its back 
online.

Thank you for the suggestion / Idea , sorry for any wrong word .

Sincerely, Jason

Sent from Mail for Windows 10

From: cryptearth
Sent: Friday, July 19, 2019 4:50 PM
To: server-user@james.apache.org
Subject: Re: About database Clustering on james server

Hey Jason,

it's not clustering in the multi-directional way but I use master-slave 
sync for my setup: On my root-server my main instance run - and at home 
my backup instance sync each night. There's this one main issue: When 
mails get delivered to my backup at home they don't sync back up to the 
main - and may can get lost when mails on the root already taken IDs 
wich my backup assigned to other mails. So it's not the best to use in 
production as ID-conflicts can happen wich only can be handled by James 
itself. The other idea I can come up with would be to use IMAP to sync 
the mails instead of sync the databases cause as said James has to 
handel possible ID conflicts wich could occur when try to sync multiple 
instances.

Matt

Am 19.07.2019 um 06:46 schrieb Jason Tjankilisan:
> Halo,
> Im curios if james can be modified to have Database Clustering. Since James 
> can use MariaDB and Mysql.Assuming it can, is it better to choose Mysql 
> Percona XtraDB Cluster, or MariaDB Galera Cluster? we already have 3 James 
> server ready to be synchronized for database clustering.
> Our team agree to implement Percona Extradb Cluster since many people said 
> has better perfomance than MariaDB Galera Cluster,but i did want to know 
> which suit better for james? Also considering the statement that mysql been 
> bought by Sun and changing the license so redistributing it wouldn't be easy 
> as before (might have to read more about this) Re: Applying JDKIM and SPF to 
> the Mailets
> After some reading on server-user archive, Clustering isnt available on james 
> last time, is it available now? there's many different opinion and thought, 
> can anybody shed some light?
> Re: Clustering James 2.3    -> Im not really sure if this was clustering
> Does james-ha work well?   -> using one database on mutiple james server, so 
> i guess its the oposite of  clustering
> Does james support cluster in order to build a mail delivery cluster? -> i 
> want to believe the answer but there;s no further explanation
> https://www.mail-archive.com/server-user@james.apache.org/msg15622.html   -> 
> im guessing clustering is too heavy for james to handle?
>
>
> |  |  |
> Does james support cluster in order to ...
>   |
>
>
>
>
>
>
> |  |  |
> Does james-ha work well?
>   |
>
>
>
>
>
>
> |  |  |
> Re: Clustering James 2.3
>   |
>
>
>
>
>
>
> |  |  |
> Re: Applying JDKIM and SPF to the Mailets
>   |
>
>
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org
For additional commands, e-mail: server-user-h...@james.apache.org


Reply via email to