VMware Communities: Create Databases? ...

Up to Discussions in vCenter Server 2.5 on Linux

This Question is Possibly Answered

1 "correct" answer available (10 pts)

1 2 Previous Next 17 Replies Last post: Mar 25, 2009 5:39 AM by whitemice

Create Databases? posted: Feb 23, 2009 11:37 AM

Texiwill

10,205 posts since
Jan 13, 2004

Hello,

I do not have oracle so I have been trying to setup MySQL. Now I can get CentOS5 MySQL ODBC connectors connected, etc. But I need to know the name of the tool to create the databases using ODBC. I can see those connections being made by looking at netstat -an. But what command can I issue to create the actual database tables?

Any way to force this? It is easy enough to get MySQL to work over ODBC, but the tables are not automatically created.

Best regards,
Edward L. Haletky
VMware Communities User Moderator
====
Author of the book 'VMWare ESX Server in the Enterprise: Planning and Securing Virtualization Servers', Copyright 2008 Pearson Education.
Blue Gears and SearchVMware Pro Blogs -- Top Virtualization Security Links -- Virtualization Security Round Table Podcast

Re: Create Databases?

1. Feb 23, 2009 5:29 PM

in response to: Texiwill

wholmes

20 posts since
Jan 19, 2008

Is Oracle Database 10g Express Edition supported? That version of Oracle is free.

Wade H.

Re: Create Databases?

2. Feb 24, 2009 7:58 PM

in response to: Texiwill

shankarunni

4 posts since
Nov 21, 2006

I do not have oracle so I have been trying to setup MySQL.

I'm afraid that won't work at all. The database code in vCenter Server is tailored to the databases it supports. For the vCenter 2.5 code base, that list is basically just Oracle and Microsoft SQL server. For the Linux tech preview appliance, we only tested with Oracle, since it's easy for users to get a free Oracle (XE) for evaluation purposes.

--
Shankar Unni
VMware, Inc.

Re: Create Databases?

3. Feb 25, 2009 10:47 AM

in response to: shankarunni

ceemour

74 posts since
Apr 7, 2006

Have installed OracleXE but cannot get linux vc to talk to it. It is listening on port 1521

Have looked thru the pdf but cannot find info on what may be required at the oracle server end (do u need to create an application ??)

I put in the ip address of the oracle xe, nothing for the instance, and then sys or system and the password as set up in the oraclexe install

Chris

Re: Create Databases?

4. Feb 25, 2009 12:22 PM

in response to: ceemour

shankarunni

4 posts since
Nov 21, 2006

Actually, you do need something for the instance, always. From what I can remember, Oracle XE installs default to creating an instance called "XE" (unless you do something with a custom install). Try that..

Re: Create Databases?

5. Feb 25, 2009 1:27 PM

in response to: ceemour

egray

42 posts since
Oct 4, 2005

Do you have a tablespace and user account set up for vCenter?

Take a look: http://www.vcritical.com/2009/02/installing-vcenter-on-linux-technical-preview/

Re: Create Databases?

6. Feb 25, 2009 8:11 PM

in response to: shankarunni

ceemour

74 posts since
Apr 7, 2006

Instance XE did the trick thank you.

Chris

Re: Create Databases?

7. Feb 25, 2009 8:44 PM

in response to: ceemour

ceemour

74 posts since
Apr 7, 2006

Hmmm

Tried to connect to the ip address with browser

http://ipaddress

no go

looking at vm by doing netstat -l and it is not listening on port 80

can connect on https://ipaddress:5480 but cannot do anything useful as far as vc is concerned

grabbed the vi client from vm (used scp to grab this)

installed it and connot connect to the server on its ip address

maybe i am missing sumthin here

Chris

Re: Create Databases?

8. Feb 27, 2009 1:55 PM

in response to: ceemour

Texiwill

10,205 posts since
Jan 13, 2004

Hello,

I have successfully created the databases within MySQL just to find out that the only databases you recognize are Oracle, Mssql, PostgresSQL and OTHER, what ever other is.

We really need MySQL or some form of LINUX database not oracle available. Can someone at least add into the tech preview the ability to accept MySQL as an acceptable database so that I can finish testing to see if this will even work. If so then I will gladly give it back to VMware to have at it. I have all the Views and Databases created and loaded with default values.

Best regards,
Edward L. Haletky
VMware Communities User Moderator, VMware vExpert 2009
====
Author of the book 'VMWare ESX Server in the Enterprise: Planning and Securing Virtualization Servers', Copyright 2008 Pearson Education.
Blue Gears and SearchVMware Pro Blogs -- Top Virtualization Security Links -- Virtualization Security Round Table Podcast

Re: Create Databases?

9. Feb 27, 2009 3:22 PM

in response to: Texiwill

shankarunni

4 posts since
Nov 21, 2006

Unfortunately it's a significant amount of work to make it work with a different database. vCenter server doesn't have a convenient O/R layer that hides the differences between the underlying databases, so a port to a new database involves a large number of changes where we have had to account for the minor and major differences between the variousdatabases that we support. Stored procedures, in particular, are a big pain.

We are looking at the possibility of adding one of the open-source databases to our supported database set. Personally, however, I'm a little wary of MySQL, because we have strong transactionality and performance requirements. Postgres is a more likely choice if we do go down that path, but we are definitely interested in receiving feedback on this topic.

Re: Create Databases?

10. Feb 27, 2009 3:27 PM

in response to: shankarunni

Texiwill

10,205 posts since
Jan 13, 2004

Hello,

Stored procedures are relatively easy to port over, as they are already in .sql format on the vCenter Linux distro. Unless there is something buried within the server itself. Why not just abstract that to other .sql files that can be edited as necessary. You would get quite a bit of 'open source' style support for these things.

Best regards,
Edward L. Haletky
VMware Communities User Moderator, VMware vExpert 2009
====
Author of the book 'VMWare ESX Server in the Enterprise: Planning and Securing Virtualization Servers', Copyright 2008 Pearson Education.
Blue Gears and SearchVMware Pro Blogs -- Top Virtualization Security Links -- Virtualization Security Round Table Podcast

Re: Create Databases?

11. Feb 27, 2009 6:25 PM

in response to: Texiwill

Texiwill

10,205 posts since
Jan 13, 2004

Hello,

I also ported the SQL schema files to PostgreSQL... Working on this possibility now.

Best regards,
Edward L. Haletky
VMware Communities User Moderator, VMware vExpert 2009
====
Author of the book 'VMWare ESX Server in the Enterprise: Planning and Securing Virtualization Servers', Copyright 2008 Pearson Education.
Blue Gears and SearchVMware Pro Blogs -- Top Virtualization Security Links -- Virtualization Security Round Table Podcast

Re: Create Databases?

12. Mar 10, 2009 10:35 AM

in response to: wholmes

Flicka

50 posts since
Feb 12, 2005

These are the limitations on Oracle 10g Express:

4gb data
1gb memory usage
uses only 1 cpu on physical server

Based on other feedback here, this free DB appears to work fine. Personally, I have never used it, but a friend has built a career on Oracle, and he claims that their upgrade path (though expensive) is unparalleled. This brings up the key question (pardon my ignorance here): is a vCenter server going to quickly fill up more than 4gb of space on a virtual appliance in an SMB environment?

Of course, there are other philosophical issues with Oracle, but are there other technical limitations I'm not seeing? For instance- are there licensing issues with having more than 1 10g Express instance running in the same environment at the same time?

I think we would all benefit if one of you VMware engineers could comment on this, and clarify whether 10g Express is a viable choice.

Thanks!

P.S. This blog post sheds some light on the answer to my question, although it does bring up other questions...

Message was edited by: Flicka- found more info...

Re: Create Databases?

13. Mar 10, 2009 12:38 PM

in response to: Flicka

Texiwill

10,205 posts since
Jan 13, 2004

Hello,

For some Oracle XE will undoubtly work, for others it will not. Just like MSDE is viable for some installs and not for the vast majority of installs. For small installs I expect use of XE will be quite acceptable, but for larger installs it will not be......

Best regards,
Edward L. Haletky
VMware Communities User Moderator, VMware vExpert 2009
====
Author of the book 'VMWare ESX Server in the Enterprise: Planning and Securing Virtualization Servers', Copyright 2008 Pearson Education.
Blue Gears and SearchVMware Pro Blogs -- Top Virtualization Security Links -- Virtualization Security Round Table Podcast

Re: Create Databases?

14. Mar 16, 2009 12:47 AM

in response to: Flicka

depping

2,997 posts since
Jan 17, 2005

Dear Flicka, keep in mind that this is a Technology Preview. It's not meant to run production or whatsoever. In other words, I wouldn't be bothered by any limitations on Oracle's side at this point in time. Just test it, see if it works, get a feeling about the new opportunities you will have. Give feedback, that's what's important at this point in time!

Duncan
VMware Communities User Moderator

Blogging: http://www.yellow-bricks.com
Twitter: http://www.twitter.com/depping

If you find this information useful, please award points for "correct" or "helpful".

1 2 Previous Next Go to original post

Go to original post

Search VMware Communities Advanced Search

Actions

View as PDF

Up to Discussions in vCenter Server 2.5 on Linux

This Question is Possibly Answered

Create Databases? posted: Feb 23, 2009 11:37 AM

Re: Create Databases?

Re: Create Databases?

Re: Create Databases?

Re: Create Databases?

Re: Create Databases?

Re: Create Databases?

Re: Create Databases?

Re: Create Databases?

Re: Create Databases?

Re: Create Databases?

Re: Create Databases?

Re: Create Databases?

Re: Create Databases?

Re: Create Databases?

Actions

Communities

Community Resources

VMworld

Get Support

Other Links

This Question is Possibly Answered

Create Databases? posted: Feb 23, 2009 11:37 AM

Actions

VMware Developer

Developer Sample Code

VMworld Sessions & Labs

Purchase PSO Credits Online

Community Hardware Software

VMware vSphere

Community Resources

VMworld

Get Support

Other Links