Usage service with external database

[Dmitriy Pavlov <de...@gmail.com>]

Hello,

Is there any official way to separate "cloud" and "cloud_usage" 
databases between different servers? Like following:
mysql_server1 - runs "cloud" database
mysql_server2 - runs "cloud_usage" database

I have tried to dump cloud_usage database, move it to alternative server 
and point db.properties file via db.usage.host option to the IP address 
of new server, but cloudstack-usage service still tries to query 
cloud.usage_event table locally to server separated in db.usage.host and 
not via IP address from db.cloud.host.

Thanks,

Dmitriy

Re: Usage service with external database

[ilya <il...@gmail.com>]

Dmitriy

Perhaps a bug.. Please file it under https://issues.apache.org/jira/

Do you have a complete error? if so please include in Jira ticket.

Thanks
ilya

On 1/6/16 2:57 AM, Dmitriy Pavlov wrote:
> Hello,
> 
> Is there any official way to separate "cloud" and "cloud_usage"
> databases between different servers? Like following:
> mysql_server1 - runs "cloud" database
> mysql_server2 - runs "cloud_usage" database
> 
> I have tried to dump cloud_usage database, move it to alternative server
> and point db.properties file via db.usage.host option to the IP address
> of new server, but cloudstack-usage service still tries to query
> cloud.usage_event table locally to server separated in db.usage.host and
> not via IP address from db.cloud.host.
> 
> Thanks,
> 
> Dmitriy