Re: Synchronizing two MySQL servers over slow network

2007-08-26 Thread C K
Thank you very much. The VPN bandwidth will be 128/256 kbps. Also we have to make updates to both locations simultaneously and our application is provided with locking mechanism for updating records and resolving conflicts to update same record. Also please give the details about term

Query sloooow

2007-08-26 Thread Jim Douglas
I installed MySQL on Fedora 6 and simple queries are very slow. I have ten databases with very few hundred records and there are only a few hundred records in the table I am querying. I only have this issue on Fedora ONLY. The same query on on my Windows machine is as expected. What can I

Re: MySQL in read-only mode

2007-08-26 Thread Mathieu Bruneau
Clyde Lewis - DBA a écrit : The idea here is to perform this change without restarting the server. Is that possible? I know that by updating the config file, then restarting will allow the database to be in read-only mode, but need to know if it is possible without restarting. Thanks, CL At

Re: Synchronizing two MySQL servers over slow network

2007-08-26 Thread Baron Schwartz
If you must manually sync, MySQL Table Sync is designed for efficient syncing over a slow network. http://mysqltoolkit.sourceforge.net/ It's still not finished, but I use it in production all the time. If there's any way you can possibly do this via replication, I would recommend you do that