New Posts  All Forums:Forum Nav:

Sync Sql databases

post #1 of 9
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
FX - 6300 M5A 78L-M USB3 MSI 460 GTX Cylcone Edition Kingston Hyper X Fury 
Hard DriveOSMonitorPower
1TB Win 7 Ultimate 64bit SP1 23" LED 450W 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
FX - 6300 M5A 78L-M USB3 MSI 460 GTX Cylcone Edition Kingston Hyper X Fury 
Hard DriveOSMonitorPower
1TB Win 7 Ultimate 64bit SP1 23" LED 450W 
  hide details  
Reply
post #2 of 9
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?
Ol' Sandy
(28 items)
 
"Zeus"
(12 items)
 
Elite Preview
(6 items)
 
CPUMotherboardGraphicsRAM
Intel Xeon E3-1230v3 Gigabyte GA-Z97X-UD5H-BK MSI Gaming GTX 980 Kingston 32GB (4x8) 
Hard DriveHard DriveHard DriveHard Drive
Plextor PX-256M5S 256GB Samsung EVO 1TB 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 8 Pro 64-bit Dell U2412M 
MonitorMonitorMonitorKeyboard
Dell U2412M Dell U2212HM Dell U2713HM Topre Realforce 87UB | Ducky DK9087 G2 Pro 
PowerCaseMouseMouse Pad
Corsair AX-750 Corsair Obsidian 650D Logitech G700 XTRAC Ripper XXL 
AudioAudioAudioAudio
Beyerdynamic DT-770 Pro 250ohm Schiit Bifrost DAC Schiit Asgard 2 HiVi Swan M50W 2.1 
CPUMotherboardRAMHard Drive
Intel Xeon E5-2620 Super Micro X9SRL-F-B 128GB 1333MHz LSI 9271-8i 
OSPowerCase
VMware ESXi 5.5 SeaSonic SS-400FL2 Fractal Define R3 
CPUMotherboardGraphicsRAM
Intel Core i5-3437U HP EliteBook Folio 9470m  Intel HD Graphics 4000  16GB DDR3 SDRAM 
Hard DriveOS
256GB SSD Windows 10 Insider Preview 
  hide details  
Reply
Ol' Sandy
(28 items)
 
"Zeus"
(12 items)
 
Elite Preview
(6 items)
 
CPUMotherboardGraphicsRAM
Intel Xeon E3-1230v3 Gigabyte GA-Z97X-UD5H-BK MSI Gaming GTX 980 Kingston 32GB (4x8) 
Hard DriveHard DriveHard DriveHard Drive
Plextor PX-256M5S 256GB Samsung EVO 1TB 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 8 Pro 64-bit Dell U2412M 
MonitorMonitorMonitorKeyboard
Dell U2412M Dell U2212HM Dell U2713HM Topre Realforce 87UB | Ducky DK9087 G2 Pro 
PowerCaseMouseMouse Pad
Corsair AX-750 Corsair Obsidian 650D Logitech G700 XTRAC Ripper XXL 
AudioAudioAudioAudio
Beyerdynamic DT-770 Pro 250ohm Schiit Bifrost DAC Schiit Asgard 2 HiVi Swan M50W 2.1 
CPUMotherboardRAMHard Drive
Intel Xeon E5-2620 Super Micro X9SRL-F-B 128GB 1333MHz LSI 9271-8i 
OSPowerCase
VMware ESXi 5.5 SeaSonic SS-400FL2 Fractal Define R3 
CPUMotherboardGraphicsRAM
Intel Core i5-3437U HP EliteBook Folio 9470m  Intel HD Graphics 4000  16GB DDR3 SDRAM 
Hard DriveOS
256GB SSD Windows 10 Insider Preview 
  hide details  
Reply
post #3 of 9
Thread Starter 
Mysql, inno
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
FX - 6300 M5A 78L-M USB3 MSI 460 GTX Cylcone Edition Kingston Hyper X Fury 
Hard DriveOSMonitorPower
1TB Win 7 Ultimate 64bit SP1 23" LED 450W 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
FX - 6300 M5A 78L-M USB3 MSI 460 GTX Cylcone Edition Kingston Hyper X Fury 
Hard DriveOSMonitorPower
1TB Win 7 Ultimate 64bit SP1 23" LED 450W 
  hide details  
Reply
post #4 of 9
Ol' Sandy
(28 items)
 
"Zeus"
(12 items)
 
Elite Preview
(6 items)
 
CPUMotherboardGraphicsRAM
Intel Xeon E3-1230v3 Gigabyte GA-Z97X-UD5H-BK MSI Gaming GTX 980 Kingston 32GB (4x8) 
Hard DriveHard DriveHard DriveHard Drive
Plextor PX-256M5S 256GB Samsung EVO 1TB 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 8 Pro 64-bit Dell U2412M 
MonitorMonitorMonitorKeyboard
Dell U2412M Dell U2212HM Dell U2713HM Topre Realforce 87UB | Ducky DK9087 G2 Pro 
PowerCaseMouseMouse Pad
Corsair AX-750 Corsair Obsidian 650D Logitech G700 XTRAC Ripper XXL 
AudioAudioAudioAudio
Beyerdynamic DT-770 Pro 250ohm Schiit Bifrost DAC Schiit Asgard 2 HiVi Swan M50W 2.1 
CPUMotherboardRAMHard Drive
Intel Xeon E5-2620 Super Micro X9SRL-F-B 128GB 1333MHz LSI 9271-8i 
OSPowerCase
VMware ESXi 5.5 SeaSonic SS-400FL2 Fractal Define R3 
CPUMotherboardGraphicsRAM
Intel Core i5-3437U HP EliteBook Folio 9470m  Intel HD Graphics 4000  16GB DDR3 SDRAM 
Hard DriveOS
256GB SSD Windows 10 Insider Preview 
  hide details  
Reply
Ol' Sandy
(28 items)
 
"Zeus"
(12 items)
 
Elite Preview
(6 items)
 
CPUMotherboardGraphicsRAM
Intel Xeon E3-1230v3 Gigabyte GA-Z97X-UD5H-BK MSI Gaming GTX 980 Kingston 32GB (4x8) 
Hard DriveHard DriveHard DriveHard Drive
Plextor PX-256M5S 256GB Samsung EVO 1TB 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 8 Pro 64-bit Dell U2412M 
MonitorMonitorMonitorKeyboard
Dell U2412M Dell U2212HM Dell U2713HM Topre Realforce 87UB | Ducky DK9087 G2 Pro 
PowerCaseMouseMouse Pad
Corsair AX-750 Corsair Obsidian 650D Logitech G700 XTRAC Ripper XXL 
AudioAudioAudioAudio
Beyerdynamic DT-770 Pro 250ohm Schiit Bifrost DAC Schiit Asgard 2 HiVi Swan M50W 2.1 
CPUMotherboardRAMHard Drive
Intel Xeon E5-2620 Super Micro X9SRL-F-B 128GB 1333MHz LSI 9271-8i 
OSPowerCase
VMware ESXi 5.5 SeaSonic SS-400FL2 Fractal Define R3 
CPUMotherboardGraphicsRAM
Intel Core i5-3437U HP EliteBook Folio 9470m  Intel HD Graphics 4000  16GB DDR3 SDRAM 
Hard DriveOS
256GB SSD Windows 10 Insider Preview 
  hide details  
Reply
post #5 of 9
Thread Starter 
Alright, thanks, i shall have a look at those links and post back here smile.gif
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
FX - 6300 M5A 78L-M USB3 MSI 460 GTX Cylcone Edition Kingston Hyper X Fury 
Hard DriveOSMonitorPower
1TB Win 7 Ultimate 64bit SP1 23" LED 450W 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
FX - 6300 M5A 78L-M USB3 MSI 460 GTX Cylcone Edition Kingston Hyper X Fury 
Hard DriveOSMonitorPower
1TB Win 7 Ultimate 64bit SP1 23" LED 450W 
  hide details  
Reply
post #6 of 9
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
FX - 6300 M5A 78L-M USB3 MSI 460 GTX Cylcone Edition Kingston Hyper X Fury 
Hard DriveOSMonitorPower
1TB Win 7 Ultimate 64bit SP1 23" LED 450W 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
FX - 6300 M5A 78L-M USB3 MSI 460 GTX Cylcone Edition Kingston Hyper X Fury 
Hard DriveOSMonitorPower
1TB Win 7 Ultimate 64bit SP1 23" LED 450W 
  hide details  
Reply
post #7 of 9
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.
Ol' Sandy
(28 items)
 
"Zeus"
(12 items)
 
Elite Preview
(6 items)
 
CPUMotherboardGraphicsRAM
Intel Xeon E3-1230v3 Gigabyte GA-Z97X-UD5H-BK MSI Gaming GTX 980 Kingston 32GB (4x8) 
Hard DriveHard DriveHard DriveHard Drive
Plextor PX-256M5S 256GB Samsung EVO 1TB 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 8 Pro 64-bit Dell U2412M 
MonitorMonitorMonitorKeyboard
Dell U2412M Dell U2212HM Dell U2713HM Topre Realforce 87UB | Ducky DK9087 G2 Pro 
PowerCaseMouseMouse Pad
Corsair AX-750 Corsair Obsidian 650D Logitech G700 XTRAC Ripper XXL 
AudioAudioAudioAudio
Beyerdynamic DT-770 Pro 250ohm Schiit Bifrost DAC Schiit Asgard 2 HiVi Swan M50W 2.1 
CPUMotherboardRAMHard Drive
Intel Xeon E5-2620 Super Micro X9SRL-F-B 128GB 1333MHz LSI 9271-8i 
OSPowerCase
VMware ESXi 5.5 SeaSonic SS-400FL2 Fractal Define R3 
CPUMotherboardGraphicsRAM
Intel Core i5-3437U HP EliteBook Folio 9470m  Intel HD Graphics 4000  16GB DDR3 SDRAM 
Hard DriveOS
256GB SSD Windows 10 Insider Preview 
  hide details  
Reply
Ol' Sandy
(28 items)
 
"Zeus"
(12 items)
 
Elite Preview
(6 items)
 
CPUMotherboardGraphicsRAM
Intel Xeon E3-1230v3 Gigabyte GA-Z97X-UD5H-BK MSI Gaming GTX 980 Kingston 32GB (4x8) 
Hard DriveHard DriveHard DriveHard Drive
Plextor PX-256M5S 256GB Samsung EVO 1TB 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 8 Pro 64-bit Dell U2412M 
MonitorMonitorMonitorKeyboard
Dell U2412M Dell U2212HM Dell U2713HM Topre Realforce 87UB | Ducky DK9087 G2 Pro 
PowerCaseMouseMouse Pad
Corsair AX-750 Corsair Obsidian 650D Logitech G700 XTRAC Ripper XXL 
AudioAudioAudioAudio
Beyerdynamic DT-770 Pro 250ohm Schiit Bifrost DAC Schiit Asgard 2 HiVi Swan M50W 2.1 
CPUMotherboardRAMHard Drive
Intel Xeon E5-2620 Super Micro X9SRL-F-B 128GB 1333MHz LSI 9271-8i 
OSPowerCase
VMware ESXi 5.5 SeaSonic SS-400FL2 Fractal Define R3 
CPUMotherboardGraphicsRAM
Intel Core i5-3437U HP EliteBook Folio 9470m  Intel HD Graphics 4000  16GB DDR3 SDRAM 
Hard DriveOS
256GB SSD Windows 10 Insider Preview 
  hide details  
Reply
post #8 of 9
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
FX - 6300 M5A 78L-M USB3 MSI 460 GTX Cylcone Edition Kingston Hyper X Fury 
Hard DriveOSMonitorPower
1TB Win 7 Ultimate 64bit SP1 23" LED 450W 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
FX - 6300 M5A 78L-M USB3 MSI 460 GTX Cylcone Edition Kingston Hyper X Fury 
Hard DriveOSMonitorPower
1TB Win 7 Ultimate 64bit SP1 23" LED 450W 
  hide details  
Reply
post #9 of 9
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
FX - 6300 M5A 78L-M USB3 MSI 460 GTX Cylcone Edition Kingston Hyper X Fury 
Hard DriveOSMonitorPower
1TB Win 7 Ultimate 64bit SP1 23" LED 450W 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
FX - 6300 M5A 78L-M USB3 MSI 460 GTX Cylcone Edition Kingston Hyper X Fury 
Hard DriveOSMonitorPower
1TB Win 7 Ultimate 64bit SP1 23" LED 450W 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Coding and Programming