Versions Compared

Old Version 1

changes.mady.by.user MS (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user MS (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Table of Contents
maxLevel3
outlinetrue
stylenone
printablefalse

...

Expand
titleExample...

Code Block
SELECT * FROM accounting_parameters WHERE paramName="VirtualMachine-hypervisorType";
+---------+-------------------------------+------------+
| idParam | paramName                     | paramValue |
+---------+-------------------------------+------------+
|      17 | VirtualMachine-hypervisorType | 0          |
+---------+-------------------------------+------------+
1 row in set (0.00 sec)



Description of resources

Abiquo stores this data about the use of these resources in the Accounting events tables. Then Administrators can configure which resources are accounted in the Accounting event detail table.

Resource

Description

Unit

Billing Type

Association

Cores

vCPUs in VMs created by users

vCPU

Consumption

VM

Cores ON

vCPUs in VMs deployed and running

vCPU

Consumption

VM

Cores OFF

vCPUs in VMs deployed and stopped

vCPU

Consumption

VM

RAM

RAM in VMs created by users

Megabytes

Consumption

VM

RAM ON

RAM in VMs deployed and running

Megabytes

Consumption

VM

RAM OFF

RAM in VMs deployed and stopped

Megabytes

Consumption

VM

Local Storage

Disk space connected to the hypervisor as datastores for VM disks,
including secondary hard disks

Bytes

Consumption

VM

External Storage

Disk space for use as external volumes created by users on VMs

Bytes

Reservation

VM/Independent

Public IPs

IP addresses with Internet access for use by VMs

No. of IP addresses

Reservation

VM/Independent

VLANs

Private VLANs for VMs

  • Unmanaged, external and public network VLANs are not accounted
  • A private VLAN is automatically created when a user creates a VDC

No. of VLANs

Reservation

VDC

FirewallFirewalls created by the userNo. of FirewallsReservationVDC
Load BalancerLoad balancers created by the userNo. of Load BalancersReservationVDC

Hypervisor Type

The hypervisor type for the VM

HV type

Consumption

VM

Cost Code

Optional cost codes for virtual image templates

Cost code

Consumption

VM

BackupBackup policies applied to VMs deployedBackup policyConsumptionVM
Hardware profileVM Hardware profileHardware profileConsumptionVM
Hardware profile ONVM Hardware profile in the ON stateHardware profileConsumptionVM
Hardware profile OFFVM Hardware profile in the OFF stateHardware profileConsumptionVM
DR protected VMVM is protected by the disaster recovery service (DRAAS)True or falseConsumptionVM
HA Hosted VM(minus) VM deployed on an Abiquo high-availability rackTrue or falseConsumptionVM
Reserved Physical
Machine Cores		CPU of each server that has been explicitly reserved for an enterprise.
Recorded even if the server is not being used.		vCPUReservationEnterprise
Reserved Physical
Machine RAM		RAM of each server that has been explicitly reserved for an enterprise.
Recorded even if the server is not being used.		MegabytesReservationEnterprise
Repository Storage

Repository space is used when:

  • Customers create a VM instance
  • Customers upload disk images into the template repository
  • Abiquo converts instances and templates to other hypervisor formats

Abiquo accounts for space used by instances and templates (cases 1 and 2).
If you wish to account conversions, create a custom metric (case 3).

Bytes used by each
template		ConsumptionEnterprise
Anti-affinity VMVM deployed in an anti-affinity layer separate from other VMs in the same layerTrue or falseConsumptionVM
Tiered local
datastore storage		Local storage on hypervisor datastores by datastore tiers (including primary and secondary
non-persistent hard disks) 		Bytes used by each diskConsumptionVM
CustomSee Custom Accounting Resource DefinitionsUser definedUser definedUser defined

...

Expand
titleExample: Set the record maximum age to two years...:


Code Block
UPDATE accounting_parameters SET paramValue="17520" WHERE paramName="DeleteRegEventsDeleteHours";



Retrieve Accounting data

Warning
iconfalse

It is important to avoid running queries on the accounting_event_detail table. Queries on this table may negatively affect the Abiquo Server.

You should replicate the accounting data to allow user access through accounting queries. See Kinton Database replication for further information.

...