On May 31, 2003 07:11, Thomas Cataldo wrote: ... > Well the sapdb case is pretty different : sapdb front-end has more > features than the mysql one (subqueries, oracle syntax, etc) and > relegating sapdb to a storage engine is a big feature regression from a > sapdb point of view.
Initially, I believe that it should be a case of teaching SAPDB the MySQL client-server protocol (and perhaps modifying the protocol to support needed features) Tighter integration will come later. I will address these points in detail in the soon-to-come FAQ. > 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. > 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. Cheers! --zak _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
