Execute MySQL statement to two different servers at same time
Execute MySQL statement to two different servers at same time
Execute MySQL statement to two different servers at same time
Execute MySQL statement to two different servers at same time
Execute MySQL statement to two different servers at same time
Execute MySQL statement to two different servers at same time Execute MySQL statement to two different servers at same time Execute MySQL statement to two different servers at same time Execute MySQL statement to two different servers at same time Execute MySQL statement to two different servers at same time Execute MySQL statement to two different servers at same time Execute MySQL statement to two different servers at same time Execute MySQL statement to two different servers at same time
Execute MySQL statement to two different servers at same time Execute MySQL statement to two different servers at same time
Execute MySQL statement to two different servers at same time
Go Back  Xtreme Visual Basic Talk > > > Execute MySQL statement to two different servers at same time


Reply
 
Thread Tools Display Modes
  #1  
Old 06-28-2013, 01:48 AM
sanketgroup sanketgroup is offline
Newcomer
 
Join Date: Jun 2013
Posts: 3
Unhappy Execute MySQL statement to two different servers at same time


I have one central server and 4 branches at different locations. Each branch has its own MySQL server installed withing their branch premises.

I need each branch data to be sent and saved at central server also. At point, i thought to work with replication but MySQL server has limitation. If i make central server as slave then it would connect to only one master (one branch). MySQL slave cannot connect to multiple masters. They are some lengthy ways to connect multiple masters but those are lengthy book keeping and not preferred by MySQL it self.

Hence i decided to change coding of our application. I am thinking to execute each statement under my application to two different server at same time. All MySQL (insert, delete, update) statements would be executed at two different servers at same time from my application, One at local server (installed at branch) and at same time it would also execute statement to remote server (central server). Database and table structure are same at both server so should not be issue executing statements.

But my problem is how do i make make this task working in vb.net application. I am not sure if i can make two connections to two different MySQL servers from single same application and execute all statements at same time to two different server.

Please help me to resolve the issue.

Thanks
Sanket
Reply With Quote
  #2  
Old 06-28-2013, 03:40 AM
Flyguy's Avatar
FlyguyExecute MySQL statement to two different servers at same time Flyguy is offline
Lost Soul

Super Moderator
* Guru *
 
Join Date: May 2001
Location: Vorlon
Posts: 19,162
Default

I'm not sure whether managing multiple (synchronise) databases from within your application is the best approach.

First start reading about database replication (master/slave):
http://en.wikipedia.org/wiki/Replica...se_replication
Reply With Quote
  #3  
Old 06-28-2013, 03:46 AM
sanketgroup sanketgroup is offline
Newcomer
 
Join Date: Jun 2013
Posts: 3
Default

Hi Flyguy
i am aware of replication and was using it.
But due to limitation of MySQL where it does not allow slave to connect more than one master, i cannot use replication.
I am also ready explore other ways to resolve my requirement.

Thanx
Sanket
Reply With Quote
  #4  
Old 07-01-2013, 11:26 AM
sanketgroup sanketgroup is offline
Newcomer
 
Join Date: Jun 2013
Posts: 3
Smile

any update?

Reply With Quote
Reply

Tags
mysql, vb.net


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Execute MySQL statement to two different servers at same time
Execute MySQL statement to two different servers at same time
Execute MySQL statement to two different servers at same time Execute MySQL statement to two different servers at same time
Execute MySQL statement to two different servers at same time
Execute MySQL statement to two different servers at same time
Execute MySQL statement to two different servers at same time Execute MySQL statement to two different servers at same time Execute MySQL statement to two different servers at same time Execute MySQL statement to two different servers at same time Execute MySQL statement to two different servers at same time Execute MySQL statement to two different servers at same time Execute MySQL statement to two different servers at same time
Execute MySQL statement to two different servers at same time
Execute MySQL statement to two different servers at same time
 
Execute MySQL statement to two different servers at same time
Execute MySQL statement to two different servers at same time
 
-->