Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Ruby

nicholas maddren
nicholas maddren
12,793 Points
Posted by nicholas maddren
nicholas maddren
12,793 Points

Accessing remote database using Ruby

Can I access a mysql database from a remote server and make changes to it from my server? Or even import the database onto server A, make the changes needed and deliver it back to server B? It would need a be a completely secure method, is this even possible?

Thanks

2 Answers

Robert Ho
PLUS
Robert Ho
Courses Plus Student 11,383 Points
Robert Ho
Robert Ho
Courses Plus Student 11,383 Points

Hey Nicholas,

I'm pretty this is possible. I remember learning that huge web applications use what are called dedicated database servers to handle more requests so that the application can scale as they grow.

Here is a site that generally shows you how the internet and web applications work; go to step 9 to see the remote / dedicated database server.

http://nilclass.com/courses/how-websites-work/database-server

Good luck!

Aaron Graham
Aaron Graham
18,033 Points
Aaron Graham
Aaron Graham
18,033 Points

I'm not sure I entirely follow, but it sounds like you are either trying to shard: http://en.wikipedia.org/wiki/Shard_(database_architecture), or replicate: http://en.wikipedia.org/wiki/Replication_(computing) your database.