As mentioned in this thread, I already wrote some code & tested code in the original SQL spooling in SGE 6.1 against SQLite 3.6.22.
But if Univa is going to further develop the code and release it as open source, then there is no point for us (ie. Open Grid Scheduler) to spend time on this, as the hwloc & GPGPU code developed by us were also re-implemented by Univa... Rayson On Mon, Oct 24, 2011 at 8:55 AM, William Bryce <[email protected]> wrote: > It is a good point Chi. We did say PostgresSQL, but honestly we will look at > other databases as well. SQLite is much easier. > > Regards, > > Bill. > > On 2011-10-23, at 1:58 AM, Chi Chan wrote: > >> Someone told me Univa is bringing back the PostgreSQL spooling which was >> deleted by Sun in SGE 6.2, and will release it with an upcoming version of >> UGE. >> >> >> Can someone clarify why PostgreSQL is used again, instead of an embedded >> database like SQLite as mentioned by Hung-Sheng & Rayson in this thread? >> IMHO, SQLite seems to be easier to maintain and far better as a spooling >> database. >> >> >> --Chi >> >> >> >> >> ----- 原始信件 ---- >> 寄件者： Ron Chen <[email protected]> >> 收件者： [email protected]; Rayson Ho <[email protected]> >> 副本： >> 寄件日期： 2011/9/27 (二) 11:35 AM >> 主旨： Re: [gridengine users] SQL spooling >> >> --- On Tue, 9/27/11, Rayson Ho <[email protected]> wrote: >>> I just did a very quick test with SQLite 3.6.22, some of >>> the SQL >>> statements used by SGE were able to run against an SQLite >>> DB without >>> any changes - in the end, we are doing simple >>> INSERT/UPDATE/DELETE >>> SQL, plus some table maintenance code & table/index >>> creation code... >> >> And SELECT statements as well! Luckily, the SELECT statements are also >> simple, not nested queries. >> >> -Ron >> >> >>> most SQL DBs could be used as the SGE spooling backend with >>> min. changes to the SQL spooling code. >>> >>> (BTW, talking about Andy, I exchanged emails with him >>> earlier this >>> month, he and the Oracle Grid Engine team are doing good at >>> Oracle.) >>> >>> Rayson >>> >>> >>> >>> On Fri, Sep 9, 2011 at 3:42 PM, "Hung-Sheng Tsao (Lao Tsao >>> 老曹) Ph.D." >>> <[email protected]> >>> wrote: >>>> >>>> recently oracle introduce a SQLlite frontend to >>> berkleyDB >>>> not sure you can take advantage this new FE to query >>> the berkleyDB in GE >>>> regards >>>> >>>> On 9/9/2011 2:51 PM, Chi Chan wrote: >>>>> >>>>> It is good that Ron Chen said that there is new >>> features (IPV6, GPU >>>>> integration) -- but any forks working on SQL >>> spooling? >>>>> >>>>> We don't need GPU integration now (with AMD >>> bulldozer shipping soon, the >>>>> need for a seperate GPU for handling GPGPU type of >>> workload may be even >>>>> less), and our clusters will not be migrated to >>> IPV6 any time soon. >>>>> >>>>> However, SQL spooling is really useful, and I can >>> query the job DB and >>>>> find out what is there. In 2003 the code was in >>> the source tree, but I >>>>> looked at the SGE forks yesterday and found that >>> the code is gone. >>>>> >>>>> So what has happened to SQL spooling, and any one >>> planning to get it back >>>>> to life? >>>>> >>>>> >>>>> --Chi >>>>> >>>>> _______________________________________________ >>>>> users mailing list >>>>> [email protected] >>>>> https://gridengine.org/mailman/listinfo/users >>>> >>>> _______________________________________________ >>>> users mailing list >>>> [email protected] >>>> https://gridengine.org/mailman/listinfo/users >>>> >>>> >>> >>> _______________________________________________ >>> users mailing list >>> [email protected] >>> https://gridengine.org/mailman/listinfo/users >>> >> >> _______________________________________________ >> users mailing list >> [email protected] >> https://gridengine.org/mailman/listinfo/users >> >> >> _______________________________________________ >> users mailing list >> [email protected] >> https://gridengine.org/mailman/listinfo/users > > William Bryce | VP of Products > Univa Corporation - 1001 Warrenville Road, Suite 100 Lisle, Il, 65032 USA > Email [email protected] | Mobile: 512.751.8014 | Office: 416.519.2934 > > _______________________________________________ users mailing list [email protected] https://gridengine.org/mailman/listinfo/users
