Questions About Sja On Linux…

[Kukulkan]

Hi,

I just testet SJA for Linux and this is really a great product! It worked from the beginning! Using cron. No problems so far!

I wonder about the performance. Actually I have only a little test-database with a few entrys but I plan to use it on a database with many millions of entry's. There are a lot of questions about using SJA now:

– Can someone give me a view of the expected behaviour?

– I plan to start it every 15 minutes! Is this possible?

– How much will it slow down my database?

– Is the database fully functional while transfering?

– Is it better to use this tool on source- or destination-side (network-traffic)?

– Is it really only transferring manipulated, deleted and new entrys?

– How long does it take to find out what to transfer on many million entrys?

Or in one question:

– Is there any experience on using it for very large productive databases?

I like the way of SJA much more than MySQL replication! Can someone please answer my questions?

Thank you.

Kukulkan

[peterlaursen]

Syncing a very big productions database every 15th minute …

much depends on data structure, server resources and connection quality.

Please read this article:

http://webyog.com/en/whitepapers/Using_SQL…L_Databases.pdf

.. an understand how to use the and the options.

[Kukulkan]

Hi peterlaursen,

Thank you. That helped me a lot. I have the job to guarantee a maximum of 30 minutes to loose in case of a database-crash. I don't like the complex job of replicating MySQL. And I did not find a good german tutorial about replicating MySQL-servers. So I found SJA. But I think it will not fit my requirements for the future so I have to deal with replication. But actually I have two MySQL-Servers. Using SJA every on of those can backup the data of the other. That was fine!

Kukulkan

[Author]

Posts