Feature #206

one 1.6 should support other SQL backends in side of sqlite

Added by Marlon Nerling about 11 years ago. Updated almost 11 years ago.

Status:ClosedStart date:03/22/2010
Priority:NormalDue 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

Revision b211fc3b
Added by Ruben S. Montero about 11 years ago

feature #206: Interface for DB backends.

Revision 31ef166e
Added by Ruben S. Montero about 11 years ago

featrure #206: Abstract interface for generic DB engine. Callback interface for ObjectSQL class

Revision eacaa30e
Added by Ruben S. Montero about 11 years ago

feature #206: sqlite class implements the SqlDB interface

Revision 4aaac043
Added by Ruben S. Montero about 11 years ago

feature #206: New interace for callbacks

Revision 88f7cbe8
Added by Ruben S. Montero about 11 years ago

feature #206: Moved Pool classes to the new DB interface

Revision ed3994ab
Added by Ruben S. Montero about 11 years ago

feature #206: Removed unneeded reference

Revision 9b9fa8b1
Added by Ruben S. Montero about 11 years ago

feature #206: initialize error string pointer

Revision e20171a5
Added by Ruben S. Montero about 11 years ago

feature #206: Template Class now uses the new SQL interface

Revision 47108138
Added by Ruben S. Montero about 11 years ago

feature #206: Host moved to the new SQL classes

Revision 7d16e4b0
Added by Ruben S. Montero about 11 years ago

feature #206: User classes ported to the new SQL interface

Revision a190d11e
Added by Ruben S. Montero about 11 years ago

feature #206: Tests moved to the new Sql engine

Revision 4f741720
Added by Ruben S. Montero about 11 years ago

feature #206: update casting in generic sqlite callback function

Revision aeb27c10
Added by Ruben S. Montero about 11 years ago

feature #206: Moved the Virtual Network to new DB classes

Revision ce7d0681
Added by Ruben S. Montero about 11 years ago

feature #206: VirtualMachine uses SqlDB

Revision d215c5dc
Added by Ruben S. Montero about 11 years ago

feature #206: Some minor fixes

Revision b85ff59a
Added by Ruben S. Montero about 11 years ago

feature #206: moved Nebula to SqlDB and missing file for Virtual Netwokrs

Revision e60e22da
Added by Carlos Martín about 11 years ago

feature #206: New Class to interface MySQL DBs

Revision 24b86382
Added by Ruben S. Montero about 11 years ago

feature #192, #206: Moved tests to SqlDB interface

Revision 7418d6fa
Added by Carlos Martín almost 11 years ago

feature #206: Table creation redefinition (only Sqlite compilant)

Revision 4d0d92ec
Added by Carlos Martín almost 11 years ago

feature #206: Isolation of INSERT and REPLACE SQL queries for User objects.

Revision 26c3d5b3
Added by Tino Vázquez almost 11 years ago

feature #206: Host table creation redefinition (only Sqlite compilant), host uniqueness defined by hostname and mads)

Revision 5cf9d453
Added by Tino Vázquez almost 11 years ago

feature #206: Formatting, indenting and commenting hosts clases

Revision 0e1a3647
Added by Tino Vázquez almost 11 years ago

feature #206: Isolation of INSERT and REPLACE SQL queries for Host objects.

Revision 8d882edf
Added by Carlos Martín almost 11 years ago

feature #206: User table definition is now MySQL compliant

Revision eb07cd94
Added by Tino Vázquez almost 11 years ago

feature #206: Isolation of INSERT and REPLACE SQL queries for VirtualMachine objects.

Revision 3f9611e0
Added by Tino Vázquez almost 11 years ago

feature #206: VM Template needs to be inserted, not inserted_replaced

Revision 8349f1ac
Added by Carlos Martín almost 11 years ago

feature #206: VirtualNetworks now MySQL compliant

Revision 9adc81d8
Added by Carlos Martín almost 11 years ago

feature #206: Check Vnet update return codes

Revision 63c4caec
Added by Carlos Martín almost 11 years ago

feature #206: More work on Vnet pool tests

Revision 4f273d47
Added by Carlos Martín almost 11 years ago

feature #206: Proper check of virtual network allocate return code

Revision f91f9de9
Added by Tino Vázquez almost 11 years ago

feature-#206: Modified return value of VM pool allocate to comply with virtual definition

Revision 56e49136
Added by Tino Vázquez almost 11 years ago

feature #206: Isolation of INSERT and REPLACE SQL queries for History objects

Revision 28c7f107
Added by Tino Vázquez almost 11 years ago

feature-#206: History is updated now, not inserted.

Revision 3e4a7b75
Added by Carlos Martín almost 11 years ago

feature #206: SQL queries for HostPool compatible with both sqlite and mysql

Revision 0981af46
Added by Tino Vázquez almost 11 years ago

feature-#206: Augmented mad names size

Revision e9ba339e
Added by Tino Vázquez almost 11 years ago

feature-#206: Rolling back augmented mad name size, mysql index cannot be over 1000 bytes

Revision ce6116bf
Added by Ruben S. Montero almost 11 years ago

feature #206: New configuration parameters to select the DB backend

Revision 85be6f3f
Added by Carlos Martín almost 11 years ago

feature #206: DB xml dump of VMs with history items now works for both Sqlite and MySQL.

Revision ebfd201b
Added by Carlos Martín almost 11 years ago

feature #206: SQL Table creation queries modified to include IF NOT EXISTS

Revision 94669f99
Added by Ruben S. Montero almost 11 years ago

feature #206: fix mysql_config tool

Revision 1d4653f7
Added by Ruben S. Montero almost 11 years ago

feature #206: Thread safe for MySQL class

Revision 1b9ada2f
Added by Tino Vázquez almost 11 years ago

feature-#206: MySQL syntax doesnt like ==

Revision a8905b27
Added by Ruben S. Montero almost 11 years ago

feature #206: OpenNebula can now be compiled with several DB backends

Revision e059b35d
Added by Carlos Martín almost 11 years ago

feature #206: Initial refactor of Scheduler code

Revision 6b03c3ff
Added by Carlos Martín almost 11 years ago

feature #212 #206: Tests for Scheduler's Host

Revision 8832b9d8
Added by Carlos Martín almost 11 years ago

feature #206: Wrong check in VM allocate

Revision 74aa41ba
Added by Ruben S. Montero almost 11 years ago

feature #206: New methods to get NIC & DISK attributes

Revision c7c08489
Added by Ruben S. Montero almost 11 years ago

feature #206: Include last_seq in VM XML render

Revision 9ea3ae7b
Added by Ruben S. Montero almost 11 years ago

feature #206: Updated pool tests to handle sqlite and mysql

Revision 807b67fc
Added by Abel Coronado about 4 years ago

Updated .yaml's and restyled radio-buttons in Create VMGroup (#206)

History

#1 Updated by Ruben S. Montero about 11 years ago

  • Category changed from 8 to Core & System

#2 Updated by Ruben S. Montero about 11 years ago

  • Tracker changed from Request to Feature

#3 Updated by Ruben S. Montero almost 11 years ago

  • Assignee set to Tino Vázquez

#4 Updated by Tino Vázquez almost 11 years ago

  • % Done changed from 0 to 100
  • Resolution set to fixed

Test, documentations and merge cheked.

#5 Updated by Tino Vázquez almost 11 years ago

  • Status changed from New to Closed

Also available in: Atom PDF