On Thu, Feb 12, 2009 at 10:13 PM, Matej Hasul <[email protected]> wrote:

>
>
> On Thu, Feb 12, 2009 at 2:33 PM, Gurjeet Singh <
> [email protected]> wrote:
>
>> On Thu, Feb 12, 2009 at 6:54 PM, Devan Goodwin <[email protected]>wrote:
>>
>>> -----BEGIN PGP SIGNED MESSAGE-----
>>> Hash: SHA1
>>>
>>> On Tue, 10 Feb 2009 16:48:16 +0100
>>> Matej Hasul <[email protected]> wrote:
>>>
>>> > Hello everyone,
>>> > I will try to port spacewalk DB to mysql as part of my master's
>>> > thesis.
>>> >
>>> > I installed spacewalk server and 2 clients and tried some basic
>>> > operations (installing/removing packages, configuration channel, etc).
>>> >
>>> > In following days I will browse DB schema and try to identify what
>>> > functionality is mysql missing and how to replace it.
>>> >
>>> > Any help, suggestions or tips are appreciated.
>>> >
>>> > Matej Hasul
>>>
>>> With a PostgreSQL effort underway, could you outline why you're driven
>>> to add the MySQL support? What advantages does it offers over
>>> PostgreSQL?
>>>
>>> Would you have interest in participating in the PostgreSQL porting
>>> effort first?
>>>
>>
>> This is what I was also going to ask...
>>
>>  Matej, can you not work on Postgres porting as part of your thesis? Just
>> curious.
>>
>
> Well, here is the story. At the beginning I was looking for thesis topic. I
> found mysql support for spacewalk, which sounds good and useful to me.
> Practical part of thesis was porting DB schema to mysql. Then I met my
> thesis leader (not Miroslav, other one). He told me, that porting DB schema
> as practical part and describing differences between oracle and mysql as
> theoretical part will not pass because there was thesis with similar
> theoretical part done recently. So we decided to include performance
> analysis (performance diffs) to theoretical part. I can't do performance
> analysis without spacewalk in mysql (or at least part of it), so porting to
> mysql is prerequisite.
>
> In my opinion, I can do performance diffs analysis on oracle+postgres
> instead of oracle+mysql and help with porting to postgres. But this should
> be decided and approved by both thesis leaders.
>
>>
I discussed it with thesis leaders and final conclusion is that I will stay
with mysql.
Miroslav Suchy adviced me to use mysql proxy (
http://forge.mysql.com/wiki/MySQL_Proxy). Main advantage of this solution is
that there is no need for mysql  DB schema.


>>
>> Best regards,
>> --
>> gurjeet[[email protected]
>> EnterpriseDB      http://www.enterprisedb.com
>>
>> singh.gurj...@{ gmail | hotmail | indiatimes | yahoo }.com
>>
>>
>> _______________________________________________
>> Spacewalk-devel mailing list
>> [email protected]
>> https://www.redhat.com/mailman/listinfo/spacewalk-devel
>>
>
>
_______________________________________________
Spacewalk-devel mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Reply via email to