New Posts  All Forums:Forum Nav:

Sync Sql databases

post #1 of 9
8/22/12 at 3:38pm
Thread Starter 
Hey guys,
I have a problem. Say I have two computers. Pc-A and Pc-B. Now on both pc's I have the same sql database. So now Pc-A will say ask a user to enter name email address etc, and then it adds it to the database. Now here is where i am having trouble. When the new entry goes into the database on Pc-A, how can i make Pc-B update its database to hold he new entry? essentially Pc-B is like a realtime backup. And i would like to have the database on both pc's in the event of something going wrong with either. How can i accomplish this?
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
E4400 2.0GHz ECS = Extra Crappy err... MSI 460 GTX Cylcone Edition 2 x 1GB Transcend PC2-5300 
Hard DriveOSMonitorPower
2x 1TB Vista Ultimate 64bit SP1 23" LED 450W 
View all
  hide details  
Reply
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
E4400 2.0GHz ECS = Extra Crappy err... MSI 460 GTX Cylcone Edition 2 x 1GB Transcend PC2-5300 
Hard DriveOSMonitorPower
2x 1TB Vista Ultimate 64bit SP1 23" LED 450W 
View all
  hide details  
Reply
post #2 of 9
8/22/12 at 5:53pm
Quote:
Originally Posted by BioniC187 View Post

Hey guys,
I have a problem. Say I have two computers. Pc-A and Pc-B. Now on both pc's I have the same sql database. So now Pc-A will say ask a user to enter name email address etc, and then it adds it to the database. Now here is where i am having trouble. When the new entry goes into the database on Pc-A, how can i make Pc-B update its database to hold he new entry? essentially Pc-B is like a realtime backup. And i would like to have the database on both pc's in the event of something going wrong with either. How can i accomplish this?

What database system is being used?
My System
(30 items)
 
"Zeus"
(13 items)
  		 
CPUMotherboardGraphicsRAM
Intel Core i5 2500K (4.5ghz @ 1.320v) Gigabyte Z68X-UD3R-B3 MSI R7970 Lightning Corsair 16GB (4x4GB) 
Hard DriveHard DriveHard DriveHard Drive
Plextor PX-256M5S 256GB Crucial M4 128GB Hitachi HDS721010CLA332 Hitachi HDS723020BLA642 
Hard DriveHard DriveHard DriveOptical Drive
Hitachi HDS723020BLA642 Hitachi HUA722010CLA330 WDC WD10EARS-00Z5B1 TSSTcorp CDDVDW SH-S223B 
CoolingCoolingOSMonitor
Phanteks PH-TC14PE with TY-140's Lamptron FCv5 (x2) Windows 7 Ultimate 64-bit Dell U2412M 
MonitorMonitorMonitorKeyboard
Dell U2412M Dell U2212HM Dell U2212HM Ducky DK9087 G2 Pro 
PowerCaseMouseMouse Pad
Corsair AX-750 Corsair Obsidian 650D Microsoft IntelliMouse Optical  XTRAC Ripper XXL 
AudioAudioAudioAudio
Westone W3 IEMs RE-272 IEMs Shure SE-215 IEMs Schiit Bifrost DAC 
AudioAudio
Schiit Asgard 2 amp HiVi Swan M50W 2.1 
View all
CPUMotherboardGraphicsRAM
Intel Core i7 950 GA-X58-UD3R Radeon HD 5450  24GB Corsair @ 1333mhz 
Hard DriveOSPowerCase
4x WD Cavair Red 1TB in RAID 0 Windows Server 2008 R2 x64 Corsair HX-520 LianLi LanCool 
View all
  hide details  
Reply
My System
(30 items)
 
"Zeus"
(13 items)
  		 
CPUMotherboardGraphicsRAM
Intel Core i5 2500K (4.5ghz @ 1.320v) Gigabyte Z68X-UD3R-B3 MSI R7970 Lightning Corsair 16GB (4x4GB) 
Hard DriveHard DriveHard DriveHard Drive
Plextor PX-256M5S 256GB Crucial M4 128GB Hitachi HDS721010CLA332 Hitachi HDS723020BLA642 
Hard DriveHard DriveHard DriveOptical Drive
Hitachi HDS723020BLA642 Hitachi HUA722010CLA330 WDC WD10EARS-00Z5B1 TSSTcorp CDDVDW SH-S223B 
CoolingCoolingOSMonitor
Phanteks PH-TC14PE with TY-140's Lamptron FCv5 (x2) Windows 7 Ultimate 64-bit Dell U2412M 
MonitorMonitorMonitorKeyboard
Dell U2412M Dell U2212HM Dell U2212HM Ducky DK9087 G2 Pro 
PowerCaseMouseMouse Pad
Corsair AX-750 Corsair Obsidian 650D Microsoft IntelliMouse Optical  XTRAC Ripper XXL 
AudioAudioAudioAudio
Westone W3 IEMs RE-272 IEMs Shure SE-215 IEMs Schiit Bifrost DAC 
AudioAudio
Schiit Asgard 2 amp HiVi Swan M50W 2.1 
View all
CPUMotherboardGraphicsRAM
Intel Core i7 950 GA-X58-UD3R Radeon HD 5450  24GB Corsair @ 1333mhz 
Hard DriveOSPowerCase
4x WD Cavair Red 1TB in RAID 0 Windows Server 2008 R2 x64 Corsair HX-520 LianLi LanCool 
View all
  hide details  
Reply
post #3 of 9
8/22/12 at 8:06pm
Thread Starter 
Mysql, inno
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
E4400 2.0GHz ECS = Extra Crappy err... MSI 460 GTX Cylcone Edition 2 x 1GB Transcend PC2-5300 
Hard DriveOSMonitorPower
2x 1TB Vista Ultimate 64bit SP1 23" LED 450W 
View all
  hide details  
Reply
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
E4400 2.0GHz ECS = Extra Crappy err... MSI 460 GTX Cylcone Edition 2 x 1GB Transcend PC2-5300 
Hard DriveOSMonitorPower
2x 1TB Vista Ultimate 64bit SP1 23" LED 450W 
View all
  hide details  
Reply
post #4 of 9
8/22/12 at 8:07pm
What you want is data replication smile.gif

http://dev.mysql.com/doc/refman/5.0/en/replication.html
http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html
My System
(30 items)
 
"Zeus"
(13 items)
  		 
CPUMotherboardGraphicsRAM
Intel Core i5 2500K (4.5ghz @ 1.320v) Gigabyte Z68X-UD3R-B3 MSI R7970 Lightning Corsair 16GB (4x4GB) 
Hard DriveHard DriveHard DriveHard Drive
Plextor PX-256M5S 256GB Crucial M4 128GB Hitachi HDS721010CLA332 Hitachi HDS723020BLA642 
Hard DriveHard DriveHard DriveOptical Drive
Hitachi HDS723020BLA642 Hitachi HUA722010CLA330 WDC WD10EARS-00Z5B1 TSSTcorp CDDVDW SH-S223B 
CoolingCoolingOSMonitor
Phanteks PH-TC14PE with TY-140's Lamptron FCv5 (x2) Windows 7 Ultimate 64-bit Dell U2412M 
MonitorMonitorMonitorKeyboard
Dell U2412M Dell U2212HM Dell U2212HM Ducky DK9087 G2 Pro 
PowerCaseMouseMouse Pad
Corsair AX-750 Corsair Obsidian 650D Microsoft IntelliMouse Optical  XTRAC Ripper XXL 
AudioAudioAudioAudio
Westone W3 IEMs RE-272 IEMs Shure SE-215 IEMs Schiit Bifrost DAC 
AudioAudio
Schiit Asgard 2 amp HiVi Swan M50W 2.1 
View all
CPUMotherboardGraphicsRAM
Intel Core i7 950 GA-X58-UD3R Radeon HD 5450  24GB Corsair @ 1333mhz 
Hard DriveOSPowerCase
4x WD Cavair Red 1TB in RAID 0 Windows Server 2008 R2 x64 Corsair HX-520 LianLi LanCool 
View all
  hide details  
Reply
My System
(30 items)
 
"Zeus"
(13 items)
  		 
CPUMotherboardGraphicsRAM
Intel Core i5 2500K (4.5ghz @ 1.320v) Gigabyte Z68X-UD3R-B3 MSI R7970 Lightning Corsair 16GB (4x4GB) 
Hard DriveHard DriveHard DriveHard Drive
Plextor PX-256M5S 256GB Crucial M4 128GB Hitachi HDS721010CLA332 Hitachi HDS723020BLA642 
Hard DriveHard DriveHard DriveOptical Drive
Hitachi HDS723020BLA642 Hitachi HUA722010CLA330 WDC WD10EARS-00Z5B1 TSSTcorp CDDVDW SH-S223B 
CoolingCoolingOSMonitor
Phanteks PH-TC14PE with TY-140's Lamptron FCv5 (x2) Windows 7 Ultimate 64-bit Dell U2412M 
MonitorMonitorMonitorKeyboard
Dell U2412M Dell U2212HM Dell U2212HM Ducky DK9087 G2 Pro 
PowerCaseMouseMouse Pad
Corsair AX-750 Corsair Obsidian 650D Microsoft IntelliMouse Optical  XTRAC Ripper XXL 
AudioAudioAudioAudio
Westone W3 IEMs RE-272 IEMs Shure SE-215 IEMs Schiit Bifrost DAC 
AudioAudio
Schiit Asgard 2 amp HiVi Swan M50W 2.1 
View all
CPUMotherboardGraphicsRAM
Intel Core i7 950 GA-X58-UD3R Radeon HD 5450  24GB Corsair @ 1333mhz 
Hard DriveOSPowerCase
4x WD Cavair Red 1TB in RAID 0 Windows Server 2008 R2 x64 Corsair HX-520 LianLi LanCool 
View all
  hide details  
Reply
post #5 of 9
8/22/12 at 9:36pm
Thread Starter 
Alright, thanks, i shall have a look at those links and post back here smile.gif
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
E4400 2.0GHz ECS = Extra Crappy err... MSI 460 GTX Cylcone Edition 2 x 1GB Transcend PC2-5300 
Hard DriveOSMonitorPower
2x 1TB Vista Ultimate 64bit SP1 23" LED 450W 
View all
  hide details  
Reply
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
E4400 2.0GHz ECS = Extra Crappy err... MSI 460 GTX Cylcone Edition 2 x 1GB Transcend PC2-5300 
Hard DriveOSMonitorPower
2x 1TB Vista Ultimate 64bit SP1 23" LED 450W 
View all
  hide details  
Reply
post #6 of 9
8/27/12 at 7:00am
Thread Starter 
i have done some research, and maybe i should've explained better.

I want to have 10 pc's each with its own database, same tables, but not the same data in the tables, and different databaase names possibly - Pc1DB, Pc2DB, Pc3DB etc etc.
like the data is based on the user entry, and will not be linked to any of the other user pc's - unique data entry on each pc.

Now, i want my pc to be able to have my own databse that has all the other databases updated with each of the other computers.

Is it possible to have my pc connected to 10 other pc's and have on my pc, the seperate databases stored?

So for example i can go on my pc, click on Pc3DB and have a look at what user 3 has entered in table 'qwer' in row 3, and then possibly compare it to Pc5DB table 'qwer' row 3, to see if its the same etc etc.
Also to have all the databses backed up on my pc, so even after if the users pc's are off i can still compare.

And even if they are on a laptop, they are at home, they input data, then come to me, i would like my pc's database to update if there were changes made to theirs so i can view
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
E4400 2.0GHz ECS = Extra Crappy err... MSI 460 GTX Cylcone Edition 2 x 1GB Transcend PC2-5300 
Hard DriveOSMonitorPower
2x 1TB Vista Ultimate 64bit SP1 23" LED 450W 
View all
  hide details  
Reply
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
E4400 2.0GHz ECS = Extra Crappy err... MSI 460 GTX Cylcone Edition 2 x 1GB Transcend PC2-5300 
Hard DriveOSMonitorPower
2x 1TB Vista Ultimate 64bit SP1 23" LED 450W 
View all
  hide details  
Reply
post #7 of 9
8/27/12 at 7:38pm
Quote:
Originally Posted by BioniC187 View Post

i have done some research, and maybe i should've explained better.
I want to have 10 pc's each with its own database, same tables, but not the same data in the tables, and different databaase names possibly - Pc1DB, Pc2DB, Pc3DB etc etc.
like the data is based on the user entry, and will not be linked to any of the other user pc's - unique data entry on each pc.
Now, i want my pc to be able to have my own databse that has all the other databases updated with each of the other computers.
Is it possible to have my pc connected to 10 other pc's and have on my pc, the seperate databases stored?
So for example i can go on my pc, click on Pc3DB and have a look at what user 3 has entered in table 'qwer' in row 3, and then possibly compare it to Pc5DB table 'qwer' row 3, to see if its the same etc etc.
Also to have all the databses backed up on my pc, so even after if the users pc's are off i can still compare.
And even if they are on a laptop, they are at home, they input data, then come to me, i would like my pc's database to update if there were changes made to theirs so i can view

You still want to use replication for that... smile.gif
You replicate each DB from those 10 PCs to their corresponding DB on your computer - your computer can have 10 DBs on it without issue.
My System
(30 items)
 
"Zeus"
(13 items)
  		 
CPUMotherboardGraphicsRAM
Intel Core i5 2500K (4.5ghz @ 1.320v) Gigabyte Z68X-UD3R-B3 MSI R7970 Lightning Corsair 16GB (4x4GB) 
Hard DriveHard DriveHard DriveHard Drive
Plextor PX-256M5S 256GB Crucial M4 128GB Hitachi HDS721010CLA332 Hitachi HDS723020BLA642 
Hard DriveHard DriveHard DriveOptical Drive
Hitachi HDS723020BLA642 Hitachi HUA722010CLA330 WDC WD10EARS-00Z5B1 TSSTcorp CDDVDW SH-S223B 
CoolingCoolingOSMonitor
Phanteks PH-TC14PE with TY-140's Lamptron FCv5 (x2) Windows 7 Ultimate 64-bit Dell U2412M 
MonitorMonitorMonitorKeyboard
Dell U2412M Dell U2212HM Dell U2212HM Ducky DK9087 G2 Pro 
PowerCaseMouseMouse Pad
Corsair AX-750 Corsair Obsidian 650D Microsoft IntelliMouse Optical  XTRAC Ripper XXL 
AudioAudioAudioAudio
Westone W3 IEMs RE-272 IEMs Shure SE-215 IEMs Schiit Bifrost DAC 
AudioAudio
Schiit Asgard 2 amp HiVi Swan M50W 2.1 
View all
CPUMotherboardGraphicsRAM
Intel Core i7 950 GA-X58-UD3R Radeon HD 5450  24GB Corsair @ 1333mhz 
Hard DriveOSPowerCase
4x WD Cavair Red 1TB in RAID 0 Windows Server 2008 R2 x64 Corsair HX-520 LianLi LanCool 
View all
  hide details  
Reply
My System
(30 items)
 
"Zeus"
(13 items)
  		 
CPUMotherboardGraphicsRAM
Intel Core i5 2500K (4.5ghz @ 1.320v) Gigabyte Z68X-UD3R-B3 MSI R7970 Lightning Corsair 16GB (4x4GB) 
Hard DriveHard DriveHard DriveHard Drive
Plextor PX-256M5S 256GB Crucial M4 128GB Hitachi HDS721010CLA332 Hitachi HDS723020BLA642 
Hard DriveHard DriveHard DriveOptical Drive
Hitachi HDS723020BLA642 Hitachi HUA722010CLA330 WDC WD10EARS-00Z5B1 TSSTcorp CDDVDW SH-S223B 
CoolingCoolingOSMonitor
Phanteks PH-TC14PE with TY-140's Lamptron FCv5 (x2) Windows 7 Ultimate 64-bit Dell U2412M 
MonitorMonitorMonitorKeyboard
Dell U2412M Dell U2212HM Dell U2212HM Ducky DK9087 G2 Pro 
PowerCaseMouseMouse Pad
Corsair AX-750 Corsair Obsidian 650D Microsoft IntelliMouse Optical  XTRAC Ripper XXL 
AudioAudioAudioAudio
Westone W3 IEMs RE-272 IEMs Shure SE-215 IEMs Schiit Bifrost DAC 
AudioAudio
Schiit Asgard 2 amp HiVi Swan M50W 2.1 
View all
CPUMotherboardGraphicsRAM
Intel Core i7 950 GA-X58-UD3R Radeon HD 5450  24GB Corsair @ 1333mhz 
Hard DriveOSPowerCase
4x WD Cavair Red 1TB in RAID 0 Windows Server 2008 R2 x64 Corsair HX-520 LianLi LanCool 
View all
  hide details  
Reply
post #8 of 9
8/28/12 at 12:12am
Thread Starter 
I have it working for one pc to my pc as it is. If i want the other 10 to be on my pc does that mean i have to create 10 different db's on my pc? Different as in different names, same structure - then i'll name them DB1, DB2 etc etc. Thanks, you have been a big help, i got the db's working lastnight because you shared those links biggrin.gif
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
E4400 2.0GHz ECS = Extra Crappy err... MSI 460 GTX Cylcone Edition 2 x 1GB Transcend PC2-5300 
Hard DriveOSMonitorPower
2x 1TB Vista Ultimate 64bit SP1 23" LED 450W 
View all
  hide details  
Reply
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
E4400 2.0GHz ECS = Extra Crappy err... MSI 460 GTX Cylcone Edition 2 x 1GB Transcend PC2-5300 
Hard DriveOSMonitorPower
2x 1TB Vista Ultimate 64bit SP1 23" LED 450W 
View all
  hide details  
Reply
post #9 of 9
9/6/12 at 5:16am
Thread Starter 
I have it set up and it's working well. I have encoutered a problem. If one the slave or master gets turned off and then back on, i have to go to the master and use "show master status" to get the log file and the position, and then go to the slave and enter the details for it to start replicating. Is there a way i can do this automatically?
Thanks
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
E4400 2.0GHz ECS = Extra Crappy err... MSI 460 GTX Cylcone Edition 2 x 1GB Transcend PC2-5300 
Hard DriveOSMonitorPower
2x 1TB Vista Ultimate 64bit SP1 23" LED 450W 
View all
  hide details  
Reply
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
E4400 2.0GHz ECS = Extra Crappy err... MSI 460 GTX Cylcone Edition 2 x 1GB Transcend PC2-5300 
Hard DriveOSMonitorPower
2x 1TB Vista Ultimate 64bit SP1 23" LED 450W 
View all
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Coding and Programming