Feature #206
one 1.6 should support other SQL backends in side of sqlite
| Status: | Closed | Start date: | 03/22/2010 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Tino Vázquez | % Done: | 100% | |
| Category: | Core & System | |||
| Target version: | Release 2.0 | |||
| Resolution: | fixed | Pull request: |
Description
By mine experience with opennebula, the sqlite backend only brings many issues and not many advantages.
I think as example on the issue where some VMs stay as zombies after delete, simply caused by the DB beeing locked by other operations.
Of course we could resolve this issue it by other means.
As advantage of say Mysql I could name:
1) Central DB: DB can be in other host than the open master.
2) High availability.
3) Better SQL.
4) Granular access rights..
Associated revisions
feature #206: Interface for DB backends.
featrure #206: Abstract interface for generic DB engine. Callback interface for ObjectSQL class
feature #206: sqlite class implements the SqlDB interface
feature #206: New interace for callbacks
feature #206: Moved Pool classes to the new DB interface
feature #206: Removed unneeded reference
feature #206: initialize error string pointer
feature #206: Template Class now uses the new SQL interface
feature #206: Host moved to the new SQL classes
feature #206: User classes ported to the new SQL interface
feature #206: Tests moved to the new Sql engine
feature #206: update casting in generic sqlite callback function
feature #206: Moved the Virtual Network to new DB classes
feature #206: VirtualMachine uses SqlDB
feature #206: Some minor fixes
feature #206: moved Nebula to SqlDB and missing file for Virtual Netwokrs
feature #206: New Class to interface MySQL DBs
feature #206: Table creation redefinition (only Sqlite compilant)
feature #206: Isolation of INSERT and REPLACE SQL queries for User objects.
feature #206: Host table creation redefinition (only Sqlite compilant), host uniqueness defined by hostname and mads)
feature #206: Formatting, indenting and commenting hosts clases
feature #206: Isolation of INSERT and REPLACE SQL queries for Host objects.
feature #206: User table definition is now MySQL compliant
feature #206: Isolation of INSERT and REPLACE SQL queries for VirtualMachine objects.
feature #206: VM Template needs to be inserted, not inserted_replaced
feature #206: VirtualNetworks now MySQL compliant
feature #206: Check Vnet update return codes
feature #206: More work on Vnet pool tests
feature #206: Proper check of virtual network allocate return code
feature-#206: Modified return value of VM pool allocate to comply with virtual definition
feature #206: Isolation of INSERT and REPLACE SQL queries for History objects
feature-#206: History is updated now, not inserted.
feature #206: SQL queries for HostPool compatible with both sqlite and mysql
feature-#206: Augmented mad names size
feature-#206: Rolling back augmented mad name size, mysql index cannot be over 1000 bytes
feature #206: New configuration parameters to select the DB backend
feature #206: DB xml dump of VMs with history items now works for both Sqlite and MySQL.
feature #206: SQL Table creation queries modified to include IF NOT EXISTS
feature #206: fix mysql_config tool
feature #206: Thread safe for MySQL class
feature-#206: MySQL syntax doesnt like ==
feature #206: OpenNebula can now be compiled with several DB backends
feature #206: Initial refactor of Scheduler code
feature #206: Wrong check in VM allocate
feature #206: New methods to get NIC & DISK attributes
feature #206: Include last_seq in VM XML render
feature #206: Updated pool tests to handle sqlite and mysql
Updated .yaml's and restyled radio-buttons in Create VMGroup (#206)
History
#1
Updated by Ruben S. Montero over 11 years ago
- Category changed from 8 to Core & System
#2
Updated by Ruben S. Montero over 11 years ago
- Tracker changed from Request to Feature
#3
Updated by Ruben S. Montero about 11 years ago
- Assignee set to Tino Vázquez
#4
Updated by Tino Vázquez about 11 years ago
- % Done changed from 0 to 100
- Resolution set to fixed
Test, documentations and merge cheked.
#5
Updated by Tino Vázquez about 11 years ago
- Status changed from New to Closed