Hi,
I have a problem as below-
We have a MySQL server for our ERP database. Now we have to implement the
ERP for Head office. HO is away from the current setup and connection
between the two is through VPN at slow speed. How can we synchronize the two
MySQL servers?
Replication,
Cluster, or
I would probably recommend replication. It's not that bad to setup and once
it catches up on the slave then it will continue to be an easy sync in the
future as long as both are running. How big is the database you wish to
synchronize? What connection are both servers on?
Is there anyway possible
We are using ODBC and Win Server 2K3. Also the database size is not so big (
i.e. upto 300 MB). The major problem is that both the databases at two
servers will be same in structure and will be used by local group of users
for daily operations. One of them must be treated as a MASTER for data.
Hi guys,
I'm moving a database to InnoDB because I need some transaction related
features but I'm having big problems with perrformances.
I have a big table with 5mln rows on which I need to run some SELECTs.
It's the Call Detail Record of a telco, so each record has a 'calldate'
field with
for generating Statutory reports. Also cluster can not be a solution
as
it
requires min. 100 MB network.
Says who?
But clustering won't help. You are looking for active/active, which
could be accomplished but this would possibly lead to specific conflicts
if people are trying to edit the