<div dir="ltr">So, I think you are saying what Daniel Salinas said in a previous reply:<div><br></div><div> "<span style="font-family:arial,sans-serif;font-size:12.800000190734863px">Trove allows you to deploy a single vm with 1 server instance of whichever service supported. So for example, if you were to deploy a mysql instance, you would have 1 vm with 1 mysql instance running on it. You can put as many databases on that one server instance as you would like with as many database users as you would like."</span></div>
<div><font face="arial, sans-serif"><br></font></div><div><font face="arial, sans-serif">For example, considering the use of the DBMS MySQL, Trove (today) allows to create 1 VM with 1 MySQL instance, in which Trove creates as many database as if I wrote:</font></div>
<div><span style="font-family:arial,sans-serif">mysql> CRETAE database DB_01;</span><br></div><div><span style="font-family:arial,sans-serif">mysql> CRETAE database DB_02;</span></div><div><font face="arial, sans-serif">etc....</font></div>
<div><font face="arial, sans-serif">To do this, I should use the API <a href="https://github.com/openstack/database-api/blob/master/openstack-database-api/src/markdown/database-api-v1.md#users-v1instances">/v1/instances</a> writing:</font></div>
<div><font face="arial, sans-serif"><br></font></div><div><pre style="font-family:Consolas,'Liberation Mono',Courier,monospace;font-size:13px;margin-top:15px;margin-bottom:15px;background-color:rgb(248,248,248);border:1px solid rgb(221,221,221);line-height:19px;overflow:auto;padding:6px 10px;border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;color:rgb(51,51,51)">
<code style="font-family:Consolas,'Liberation Mono',Courier,monospace;font-size:12px;margin:0px;padding:0px;border:none;background-color:transparent;border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px">{
"instance": {
"databases": [
{
"character_set": "utf8",
"collate": "utf8_general_ci",
"name": "DB_01"
},
{
"name": "DB_02"
}</code></pre><pre style="font-family:Consolas,'Liberation Mono',Courier,monospace;font-size:13px;margin-top:15px;margin-bottom:15px;background-color:rgb(248,248,248);border:1px solid rgb(221,221,221);line-height:19px;overflow:auto;padding:6px 10px;border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;color:rgb(51,51,51)">
<code style="font-family:Consolas,'Liberation Mono',Courier,monospace;font-size:12px;margin:0px;padding:0px;border:none;background-color:transparent;border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px">etc....</code></pre>
</div><div><font face="arial, sans-serif"><br></font></div><div><font face="arial, sans-serif"><br></font></div><div><font face="arial, sans-serif">Now, I have an endpoint in which the MySQL instance is running and databases were created like above. At this point, an application can USE databases (in order to CREATE tables and INSERT/SELECT data in the fields) by connecting to that endpoint (<a href="https://ip_address:3306">https://ip_address:3306</a>) using, for example, the WSO2 Data Services Server.</font></div>
<div><font face="arial, sans-serif"><br></font></div><div><font face="arial, sans-serif">Is it right?</font></div><div><font face="arial, sans-serif"><br></font></div><div><font face="arial, sans-serif">Thank you all,</font></div>
<div><font face="arial, sans-serif">Giuiseppe<br></font><div class="" style="margin-top:10px;color:rgb(67,67,67);font-size:12px;line-height:19.428571701049805px"></div><div class="gmail_extra"><br><br><div class="gmail_quote">
2013/9/10 Michael Basnight <span dir="ltr"><<a href="mailto:mbasnight@gmail.com" target="_blank">mbasnight@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div class=""><div class="h5">On Sep 10, 2013, at 6:01 AM, Brian Aker <<a href="mailto:brian@tangent.org">brian@tangent.org</a>> wrote:<br>
<br>
> Hi!<br>
><br>
> On Sep 9, 2013, at 9:46 AM, Michael Basnight <<a href="mailto:mbasnight@gmail.com">mbasnight@gmail.com</a>> wrote:<br>
><br>
>> On Sep 9, 2013, at 8:38 AM, Clint Byrum wrote:<br>
>><br>
>>> Perhaps: "Trove is designed to support a multi-user database for a single<br>
>>> OpenStack tenant within a Nova instance."<br>
>><br>
>> +1. Very succinct, and it does remove ambiguity. Giuseppe, feel free to update the wiki to reflect this, and help remove ambiguity in other areas. Thank you Clint and Giuseppe.<br>
><br>
> Let me be a little nit-picky.<br>
><br>
> Trove when mapped to other RDBMS then MySQL may actually create multiple "DATABASES".<br>
><br>
> MySQL maps "CREATE DATABASE" to "CREATE SCHEMA" and Trove has inherited this inconsistency. A number of other RDBMS have both of these implemented and I would expect that they will call "CREATE DATABASE" instead.<br>
><br>
> It would be more accurate to say that Trove supports the creation of "DBMS" systems (though frankly some of the NO-SQL solutions don't fit that definition due to their lack of data integrity).<br>
><br>
> Additionally I would drop the "multi-user" part since some of the proposed implementations lack "users" as well.<br>
><br>
> Trove is a service that handles the maintenance, provisioning, etc… of DBMS systems.<br>
><br>
<br>
</div></div>Very good points. I've been in many a meeting trying to explain what Brian just wrote. Ill be sure to add all this to the wiki today. Thank you Brian.<br>
<br>
> Cheers,<br>
> -Brian<br>
<div class=""><div class="h5">><br>
><br>
><br>
<br>
_______________________________________________<br>
Mailing list: <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
Post to : <a href="mailto:openstack@lists.openstack.org">openstack@lists.openstack.org</a><br>
Unsubscribe : <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
</div></div></blockquote></div><br></div></div></div>