Tighter integration will come later.
You should also be carefull with this statement. What does "integration" mean?
1. Integrate SAPDB into MySQL - bad idea 2. Integrate MySQL into SAPDB - bad idea too?
You have to learn from SAPDB! See which features and possibilities it offers, and than let us talk again!
Also consider another point : mysql database concept is just a schema for sap. With sapdb every database instance is a separate set of process, with different set of users. For exemple with sapdb you can tune your memory settings with a database granularity, for example I can have a test database with 64MB and 1 CPU allocated and a production database with 1GB allocated and 4CPU allocated. MySQL is a mono instance database, so every "database" runs in the same address space and that is a big concern for me. InnoDB is pretty cool, but the mysql architecture enforces the one machine/one database model. The most disturbing thing for me with mysql is the 'mysql' database, and storing the users in a global area instead of a per instance area.
Very cool! I admit that my knowledge of SAP DB is very weak currently and that I am enjoying learning more about the database.
We all might have thought, that you all at MySQL took a look at SAPDB. Than you would have noticed the x-server and that you can have multiple database-kernels installed etc...
Of course I'm far from being a mysql expert so if I can have address space/process separation between database instances and storage separation between all the database, feel free to correct me.
If I were faced with a similar need in MySQL, I would run multiple, separate instances of the server on the same machine. This would achieve a similar level of separation - though to be honest, I am not sure that we can bring the isolation down to restricting how many CPUs in a multi-CPU machine each instance uses. I fear that I have not had to do this, and do not personally know. I will ask one of the developers.
Both MySQL instances would have to listen on different TCP ports, or even different IPs just to make that possible.
As i already said, SAPDB is already doing better with the program called x-server: You can connect to one IP/Port combination, and the x-server adresses the right kernel-instance according to the database you choose.
It will be very hard for MySQL to compete against all those features, so _PLEASE_ talk to the SAP guys and get yourself an overview of SAPDB.
MySQL looks like a toy in comparison with SAPDB - MySQL _really_ _is_ much simpler than SAPDB.
You cannot integrate SAPDB into MySQL without loosing all those features that make SAPDB this beautifull.
I have to repeat my self: - _learn_ from SAPDB - don't even think of integrating SAPDB into MySQL - build a new product with all good concepts of both products
I feel like you MySQL-people are assimilating SAPDB. At least the Borg claim to learn things while assimilating other species. I'm not sure if MySQL will.
Please supply us with a plan what will be done!
We need it! Proove, that you are not foolish enough, to create a product that is not as good as the one we already have (i should say "had", because SAPDB is no more - R.I.P)
Thx Sven
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
