Topic: mysql mirror

[darmasanthi]

Hi All,
Can anybody help me how to sync / mirror "mysql" data with 2 SME 7.3 server

regards,
darmasanthi

[cactus]

Hi All,
Can anybody help me how to sync / mirror "mysql" data with 2 SME 7.3 server

regards,
darmasanthi

That is a MySQL issue not a SME Server issue, it is called replication, see the MySQL manual for that.

It might be necessary to have MySQL run on a port for that instead of a socket, it is necessary to lower it security settings, but this is all described in the FAQ:
http://wiki.contribs.org/MySQL#Access_MySQL_from_the_local_network
http://wiki.contribs.org/MySQL#Access_MySQL_from_a_remote_network

I further suggest you read the manuals in the wiki thoroughly, possibly 3 times, (yes you have read that correctly ) as a lot of SME Server can be learned from that.

Furthermore try to search the forums and the bugtracker as a lot of your questions seem to be (partially) answered  on other locations already as more users have had similar problems and issues like you are experiencing.

[darmasanthi]

That is a MySQL issue not a SME Server issue, it is called replication, see the MySQL manual for that.

It might be necessary to have MySQL run on a port for that instead of a socket, it is necessary to lower it security settings, but this is all described in the FAQ:
http://wiki.contribs.org/MySQL#Access_MySQL_from_the_local_network
http://wiki.contribs.org/MySQL#Access_MySQL_from_a_remote_network

I further suggest you read the manuals in the wiki thoroughly, possibly 3 times, (yes you have read that correctly ) as a lot of SME Server can be learned from that.

Furthermore try to search the forums and the bugtracker as a lot of your questions seem to be (partially) answered  on other locations already as more users have had similar problems and issues like you are experiencing.

Hi Cactus,
thank you for your reply,
what i need is how to make identical data between 2 mysql automaticaly.
it just like fail over data or redundancy data.

regards,
darmasanthi

[cactus]

Hi Cactus,
thank you for your reply,
what i need is how to make identical data between 2 mysql automaticaly.
it just like fail over data or redundancy data.

Yes but from other posts in the forum I get the opinion you are trying to mirror way more than only MySQL data. As stated in earlier posts for MySQL database syncing see the replication topic in the MySQL manual.

[darmasanthi]

Yes but from other posts in the forum I get the opinion you are trying to mirror way more than only MySQL data. As stated in earlier posts for MySQL database syncing see the replication topic in the MySQL manual.

Yes we only need to sync mysql data only,
cause each server has domain controller for each client
with deferent domain/workgroup

regards,
darmasanthi