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: [email protected] 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/[email protected]/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: [email protected] For additional commands, e-mail: [email protected]
