Page Comparison

...

For a relational data store, we recommend running MySQL locally with three databases:

one for KFS OLTP
one for standalone Rice OLTP
one with KFS/Rice bundled for unit testing

the following statements will setup a new MySQL database/user (kfs) for development purposes; NOTE: this is for development use only as it grants all privileges; in a production environment it would make more sense to have multiple users, a more privileged one who can run DDL and create the database objects, and a less privileged users to run the application¹.

Code Block

create user kfs@localhost identified by 'kfs';
create user kfs@'%' identified by 'kfs';
create database kfs default character set 'utf8' default collate 'utf8_bin';
grant all on kfs.* to kfs@localhost with grant option;
grant all on kfs.* to kfs@'%' with grant option;

Info
1 - For example, the DDL user would have all privileges except FILE and EXECUTE. The less privileged APP user would have CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, INDEX, INSERT, LOCK TABLES, SELECT, SHOW VIEW, UPDATE, and TRIGGER privileges.

For the document data store, we recommend running MongoDB locally.

Info

Mysql requires some settings in the my.cnf file. You need to add the following settings. After adding them, you must restart mysql.

[mysqld]
max_allowed_packet=64M
transaction-isolation=READ-COMMITTED
lower_case_table_names=1
max_connections=1000
innodb_file_per_table=OFF

Info
For more information on how to setup MongoDB, or load data into the relational data store or document data store, see Technology Changes Post 6.0.

...

Versions Compared

Old Version 5

New Version 6

Key