topic Re: mysql in Operating System - OpenVMS

mysql

Bojan Nemec — Thu, 14 Jun 2007 06:49:19 GMT

Hi,

A few days ago I look to the mysql source distribution from the freeware CD. I realise that it is possible to write a custom storage engine. My idea is to write a storage engine which works with RMS files (index files for begining) and supports the VMS data types so I can access to old RMS files with SQL.
First tests looks good. The mysql storage engine fits to RMS without many problems.

Now the questions:

Has anybody try to do a similar work?

Anybody knows what is with the VMS port for mysql 5.1?

Bojan

Re: mysql

Jean-François Piéronne — Thu, 14 Jun 2007 08:36:32 GMT

Hi,

I have had some requests for a RMS engine but I haven't done any work.

Do you plan to release your RMS engine ?

The current 5.1 port on VMS is 5.1.11, I have planned to port the latest 5.1, but, yet, no schedule.

JF

Re: mysql

Hoff — Thu, 14 Jun 2007 08:47:24 GMT

RMS connector: donno. Haven't heard of one specifically for MySQL. There are certainly ODBC connectors for RMS. Probably JDBC.

MySQL 5.1 beta (old discussions):

http://dba.openvms.org/phorum/list.php?9

http://www.openvms.org/stories.php?story=06/04/22/5056423

Contact info for SysGroup SARL was included.

In either case, Jean-FranÃ§ois PiÃ©ronne (jfp) would (also) be a likely contact.

Re: mysql

Bojan Nemec — Thu, 14 Jun 2007 10:17:17 GMT

Jean-FranÃ§ois,

As I said, I am only on the first steps. I done an engine rewriting the ha_example engine. It can read,write,update and can use indexes, it can also do some data conversions from mysql to VMS data types and viceversa. For now no locking, table creation etc...

If I succed in my implementation I will certainly release the code.

I am intersted in any 5.1 version. The storage engine specification is slightly different in this versions. As I see there are some more functions in the "handlerton" and it will probably be possible to use transactions when RMS Journaling is available.

It is possible to somehow get yours last port?

Hoff,

Thanks for the links, I found them when I was searching for the release.

Bojan

PS
10 points for Jean-FranÃ§ois are for his great work on mysql and other freeware port to VMS.

Re: mysql

Jean-François Piéronne — Fri, 15 Jun 2007 03:26:58 GMT

Bojan,

I will try to finish the port of MySQL 5.1.14, I have started this port a month or two ago but I did not finish due to the lack of time. Then I will put it online.

I can also put online 5.1.11 which is a MySQL 5.1 beta but which seem to work fairly well as some VMS sites are running this version for near a year without many problems.

JF

Re: mysql

Bojan Nemec — Fri, 15 Jun 2007 03:53:23 GMT

Jean-Francois,

For my experiments the beta version will be OK. Probably better than working on the old MySQL 4.1.14.

I will appreciate if you can put online MySQL 5.1.11.

Thanks in advance.

Bojan

Re: mysql

Jean-François Piéronne — Fri, 15 Jun 2007 07:33:06 GMT

Bojan,

I have put online 5.1.11, same location as 4.1.14 kit.
I will try to finish the port of 5.1.14 next month.

JF

Re: mysql

Bojan Nemec — Mon, 18 Jun 2007 01:17:51 GMT

Jean-Francois,

Thanks for putting online 5.1.11, I have downloaded it.
Now I have to see which are the differences betwen the old version an the new one.

Thanks one more time

Bojan

Re: mysql

Robert Atkinson — Mon, 18 Jun 2007 05:47:21 GMT

Bojan, how is the definition for the existing RMS file stored, i.e. field types, sizes, etc?

Rob.

Re: mysql

Bojan Nemec — Mon, 18 Jun 2007 06:17:19 GMT

Robert,

As I said this are my first steps. For now I have put the descriptions of the existing fields in the comment string of each field.
In the comment you put the size,type,class (string or decimal scalar string) and optional scale and digits from the decimal scalar string.

This comment is parsed when the file is open and VMS descriptors are made for fields which need conversion. When the field is transfered from MySQL or to MySQL LIB$CVT_DX_DX is called. In the future maybe some more optimal method will be used.

Now I downloaded the 5.1.11 version and have some troubles in compiling from sources.

Bojan

Re: mysql

Jean-François Piéronne — Mon, 18 Jun 2007 14:51:23 GMT

Bojan,

what problems do you have ?

I was able to rebuild from sources without any problem.

JF

Re: mysql

Bojan Nemec — Tue, 19 Jun 2007 02:22:35 GMT

JF,

I attach the errors from the build procedure.
The build procedure (in this case) was:

$ @logicals
$ @symbols
$ @build_all JFP_SSL ZLIB SERVER LONG MIXED

But I have try also with:

$ @build_all VMS_SSL ZLIB SERVER SHORT MIXED
$ @build_all JFP_SSL ZLIB SERVER SHORT MIXED

I hae also tried to exclude the ha_example from the final link. But it seems that most of objects located in MYSQL051_ROOT:[vms.mysql.o_alpha.sql] are missing (there are only two my_lock.OBJ and net_serv.OBJ).

Bojan

PS
Maybe my compilers versions are to old?

$ cxx/version
Compaq C++ V6.5-004 for OpenVMS Alpha V7.3-2
$ cc/version
Compaq C V6.5-001 on OpenVMS Alpha V7.3-2

Re: mysql

labadie_1 — Tue, 19 Jun 2007 02:26:10 GMT

I think you should get C and C++ 7.1 or 7.2, earlier versions fail.

Re: mysql

Jean-François Piéronne — Tue, 19 Jun 2007 03:47:03 GMT

Bojan,

To build the server you have to run
1. logicals.com
2. build_server.com, you may have to update this procedure which contains
$ @python_vms:setup
$ set def mysql051_root:[vms.mysql]
$ python genbuild_mms.py server 32 mixed
$ set def mysql051_root:[vms]
$ @build_all JFP_SSL ZLIB SERVER SHORT MIXED

You need to execute the python script to generate the correct mms files.

Sometimes I will build a separate tree for the server and all the clients but, currently, this share the same tree structure, so it is necessary to clean all object and libraries (olb) before the build.

I have somewhere a procedure which do all the job (build the server and the various clients).
But to only build the server you just need the 2 procedures logicals.com and build_server.com

JF

Re: mysql

Bojan Nemec — Tue, 19 Jun 2007 04:51:11 GMT

JF,

I will try to generate mms files but first I have to install Python (it seems that the installation needs some time).

Thanks
Bojan

Re: mysql

Jean-François Piéronne — Tue, 19 Jun 2007 05:02:39 GMT

Bojan,

Install python is very easy, you just have to download and mount 2 ld images, you probably can probably install Python in a couple of minutes.
More informations:
http://vmspython.dyndns.org/DownloadAndInstallationPython

JF

Re: mysql

Bojan Nemec — Tue, 19 Jun 2007 05:12:31 GMT

JF,

Just in the process of downloading the ld images. When I try to install python from PCSI it seems to go in an infinite loop after the line:
Compiling /python_root/local/rpdb2.py ...

Thanks

Bojan

Re: mysql

labadie_1 — Tue, 19 Jun 2007 05:20:20 GMT

If you just want to use Movable Python, once you have the two .dsk files

1) if you want Python just for your process

$ ld connect jfppy0006/symbol
$ mount $1$lda'ld_unit' jfppy0006
$ @ $1$lda'ld_unit':[000000]python_logicals
$ ld connect jfplib0001/symbol
$ mount $1$lda'ld_unit' jfplib0001
$ @ $1$lda'ld_unit':[000000]lib_logicals
$ @python_vms:setup
$ python python_root:beer.py

2) if you want Python available for all processes

$ ld connect jfppy0006/symbol
$ mount/system $1$lda'ld_unit' jfppy0006
$ @ $1$lda'ld_unit':[000000]python_logicals
$ ld connect jfplib0001/symbol
$ mount/system $1$lda'ld_unit' jfplib0001
$ @ $1$lda'ld_unit':[000000]lib_logicals
$ @python_vms:setup
$ python python_root:beer.py

Re: mysql

labadie_1 — Tue, 19 Jun 2007 05:48:11 GMT

Sorry, I made a mistake, the second part should be

2) if you want Python available for all processes

$ ld connect jfppy0006/symbol
$ mount/system $1$lda'ld_unit' jfppy0006
$ @ $1$lda'ld_unit':[000000]python_logicals
$ ld connect jfplib0001/symbol
$ mount/system $1$lda'ld_unit' jfplib0001
$ @ $1$lda'ld_unit':[000000]lib_startup
$ @python_vms:setup
$ python python_root:beer.py

Re: mysql

Bojan Nemec — Tue, 19 Jun 2007 06:00:30 GMT

I succesfuly installed the movable ld images and executed the mms file creation.
Now the build_all command procedure is building the server image. I work on a slow alpha workstation 600au and this will take time. For now only a few informationals and two warnings.

Thanks
Bojan