Loadbalancing Database

asked 2014-09-23 05:31:49 -0500

PatRock gravatar image

I'm searching for a way to create a scaling Database, that I can generate more Instances when the storage or the CPU of my Database gets over a specific limit. A normal AutoScalingGroup (with alarms and policys) will generate a new Database, but the DATA of the first Database needs to be shared as well. So that the generated Database can response to any requests like the first one.

So I need to copy the first Database instead of generating a new one. Is there a way of realising this theory or is it even done yet?

edit retag flag offensive close merge delete


This seems less like an openstack question and more of a basic database scalability question. You are looking for a way of dynamically adding replicas into a database cluster for better performance. How you do this (and if it's possible) will depend a lot on which database product you're using.

larsks gravatar imagelarsks ( 2014-09-23 08:50:41 -0500 )edit

1 answer

Sort by ยป oldest newest most voted

answered 2014-09-23 09:39:07 -0500

PatRock gravatar image

updated 2014-09-23 09:39:18 -0500

Could this perhaps be possible with Trove (DBaaS)?

"OpenStack Trove offers vertical scalability by allowing you to move database instances to larger virtual machines. Horizontal scalability and high availability will be provided by the Trove clustering API which is currently under development."

edit flag offensive delete link more

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower


Asked: 2014-09-23 05:31:49 -0500

Seen: 165 times

Last updated: Sep 23 '14