1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
|
/***********************************************************************
Copyright (c) 2011, 2025, Oracle and/or its affiliates.
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License, version 2.0,
as published by the Free Software Foundation.
This program is designed to work with certain software (including
but not limited to OpenSSL) that is licensed under separate terms,
as designated in a particular file or component or in included license
documentation. The authors of MySQL hereby grant you an additional
permission to link the program and your derivative works with the
separately licensed software that they have either included with
the program or referenced in the documentation.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License, version 2.0, for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
***********************************************************************/
/**************************************************/ /**
@file innodb_config.h
Created 03/15/2011 Jimmy Yang
*******************************************************/
#ifndef innodb_config_h
#define innodb_config_h
#if defined(WITH_INNODB_MEMCACHED) && defined(UNIV_DEBUG)
#define UNIV_MEMCACHED_SDI
#endif
#include "api0api.h"
#include "innodb_utility.h"
typedef void *hash_node_t;
/* Database name and table name for our metadata "system" tables for
InnoDB memcache. The table names are the same as those for the
NDB memcache, to make the memcache setup compatible between the two.
There are 3 "system tables":
1) containers - main configure table contains row describing which InnoDB
table is used to store/retrieve Memcached key/value if InnoDB
Memcached engine is used
2) cache_policies - decide whether to use "Memcached Default Engine" or "InnoDB
Memcached Engine" to handler the requests
3) config_options - for miscellaneous configuration options */
#define MCI_CFG_DB_NAME "innodb_memcache"
#define MCI_CFG_CONTAINER_TABLE "containers"
#define MCI_CFG_CACHE_POLICIES "cache_policies"
#define MCI_CFG_CONFIG_OPTIONS "config_options"
/** Max table name length as defined in univ.i */
#define MAX_TABLE_NAME_LEN 192
#define MAX_DATABASE_NAME_LEN MAX_TABLE_NAME_LEN
#define MAX_FULL_NAME_LEN (MAX_TABLE_NAME_LEN + MAX_DATABASE_NAME_LEN + 14)
/** structure describes each column's basic info (name, field_id etc.) */
typedef struct meta_column {
char *col_name; /*!< column name */
size_t col_name_len; /*!< column name length */
int field_id; /*!< column field id in
the table */
ib_col_meta_t col_meta; /*!< column meta info */
} meta_column_t;
/** Following are enums defining column IDs indexing into each of three
system tables */
/** Columns in the "containers" system table, this maps the Memcached
operation to a consistent InnoDB table */
typedef enum container {
CONTAINER_NAME, /*!< name for this mapping */
CONTAINER_DB, /*!< database name */
CONTAINER_TABLE, /*!< table name */
CONTAINER_KEY, /*!< column name for column maps to
memcached "key" */
CONTAINER_VALUE, /*!< column name for column maps to
memcached "value" */
CONTAINER_FLAG, /*!< column name for column maps to
memcached "flag" value */
CONTAINER_CAS, /*!< column name for column maps to
memcached "cas" value */
CONTAINER_EXP, /*!< column name for column maps to
"expiration" value */
CONTAINER_NUM_COLS /*!< number of columns */
} container_t;
/** columns in the "cache_policy" table */
typedef enum cache_policy {
CACHE_POLICY_NAME, /*!< "name" column, for the "cache_policy"
name */
CACHE_POLICY_GET, /*!< "get" column, specifies the cache policy
for "get" command */
CACHE_POLICY_SET, /*!< "set" column, specifies the cache policy
for "set" command */
CACHE_POLICY_DEL, /*!< "delete" column, specifies the cache
policy for "delete" command */
CACHE_POLICY_FLUSH, /*!< "flush_all" column, specifies the
cache policy for "flush_all" command */
CACHE_POLICY_NUM_COLS /*!< total 5 columns */
} cache_policy_t;
/** columns in the "config_options" table */
typedef enum config_opt {
CONFIG_OPT_KEY, /*!< key column in the "config_option" table */
CONFIG_OPT_VALUE, /*!< value column */
CONFIG_OPT_NUM_COLS /*!< number of columns (currently 2) in table */
} config_opt_t;
/** Following are some value defines describes the options that configures
the InnoDB Memcached */
/** Values to set up "m_use_idx" field of "meta_index_t" structure,
indicating whether we will use cluster or secondary index on the
"key" column to perform the search. Please note the index must
be unique index */
typedef enum meta_use_idx {
META_USE_NO_INDEX = 1, /*!< no cluster or unique secondary index
on the key column. This is an error, will
cause setup to fail */
META_USE_CLUSTER, /*!< have cluster index on the key column */
META_USE_SECONDARY /*!< have unique secondary index on the
key column */
} meta_use_idx_t;
/** Describes the index's name and ID of the index on the "key" column */
typedef struct meta_index {
char *idx_name; /*!< index name */
int idx_id; /*!< index id */
meta_use_idx_t srch_use_idx; /*!< use cluster or secondary
index for the search */
} meta_index_t;
/** Cache options, tells if we will used Memcached default engine or InnoDB
Memcached engine to handle the request */
typedef enum meta_cache_opt {
META_CACHE_OPT_INNODB = 1, /*!< Use InnoDB Memcached Engine only */
META_CACHE_OPT_DEFAULT, /*!< Use Default Memcached Engine
only */
META_CACHE_OPT_MIX, /*!< Use both, first use default
memcached engine */
META_CACHE_OPT_DISABLE, /*!< This operation is disabled */
META_CACHE_NUM_OPT /*!< Number of options */
} meta_cache_opt_t;
/** The "names" in the "config_option" table to identify possible
config options. Both are optional.
"COLUMN_SEPARATOR" is the delimiter that separates multiple columns and
"TABLE_MAP_SEPARATOR" is the delimiter that separates table map name
and key value */
#define COLUMN_SEPARATOR "separator"
#define TABLE_MAP_SEPARATOR "table_map_delimiter"
/* list of configure options we support */
typedef enum option_id {
OPTION_ID_COL_SEP, /*!< ID for character(s) separating
multiple column mapping */
OPTION_ID_TBL_MAP_SEP, /*!< ID for character(s) separating
table map name and key */
OPTION_ID_NUM_OPTIONS /*!< number of options */
} option_id_t;
/** Maximum delimiter length */
#define MAX_DELIMITER_LEN 32
typedef struct option_value {
char value[MAX_DELIMITER_LEN + 1];
/* option value */
int value_len; /* value length */
} option_value_t;
/** structure to define some default "config_option" option settings */
typedef struct option {
option_id_t id; /*!< option id as in enum option_id */
const char *name; /*!< option name for above option ID,
currently they can be "COLUMN_SEPARATOR"
and "TABLE_MAP_SEPARATOR" */
option_value_t default_value; /*!< default value */
} option_t;
/** Get configure option value. If the value is not configured by
user, obtain its default value from "config_option_names"
@param meta_info metadata structure contains configure options
@param option option whose value to get
@param val value to fetch
@param val_len value length */
#define GET_OPTION(meta_info, option, val, val_len) \
do { \
val_len = meta_info->options[option].value_len; \
\
if (val_len == 0) { \
val = config_option_names[option].default_value.value; \
val_len = config_option_names[option].default_value.value_len; \
} else { \
val = meta_info->options[option].value; \
} \
} while (0)
/** In memory structure contains most necessary metadata info
to configure an InnoDB Memcached engine */
typedef struct meta_cfg_info {
meta_column_t col_info[CONTAINER_NUM_COLS]; /*!< column info */
meta_column_t *extra_col_info; /*!< additional columns
specified for the value field */
int n_extra_col; /*!< number of additional
value columns */
meta_index_t index_info; /*!< Index info */
bool flag_enabled; /*!< whether flag is enabled */
bool cas_enabled; /*!< whether cas is enabled */
bool exp_enabled; /*!< whether exp is enabled */
option_value_t options[OPTION_ID_NUM_OPTIONS];
/*!< configure options, mostly
are configured delimiters */
meta_cache_opt_t set_option; /*!< cache option for "set" */
meta_cache_opt_t get_option; /*!< cache option for "get" */
meta_cache_opt_t del_option; /*!< cache option for
"delete" */
meta_cache_opt_t flush_option; /*!< cache option for
"delete" */
hash_node_t name_hash; /*!< name hash chain node */
} meta_cfg_info_t;
/**********************************************************************/ /**
This function opens the default configuration table, and find the
table and column info that used for InnoDB Memcached, and set up
InnoDB Memcached's meta_cfg_info_t structure. If the "name" parameter
is not NULL, it will find the specified setting in the "container" table.
If "name" field is NULL, it will then look for setting with the name of
"default". Otherwise, it returns the setting corresponding to the
first row of the configure table.
@return meta_cfg_info_t* structure if configure option found, otherwise NULL */
meta_cfg_info_t *innodb_config(
/*==========*/
const char *name, /*!< in: config option name */
size_t name_len, /*!< in: option name length */
hash_table_t **meta_hash); /*!< in: engine hash table */
/**********************************************************************/ /**
This function verifies the table configuration information, and fills
in columns used for memcached functionalities (cas, exp etc.)
@return true if everything works out fine */
bool innodb_verify(
/*==========*/
meta_cfg_info_t *info, /*!< in: meta info structure */
void *thd /*!< in/out: MySQL THD */
);
/**********************************************************************/ /**
This function frees meta info structure */
void innodb_config_free(
/*===============*/
meta_cfg_info_t *item); /*!< in/own: meta info
structure */
/**********************************************************************/ /**
This function opens the "containers" table, reads in all rows
and instantiates the metadata hash table.
@return the default configuration setting (whose mapping name is "default") */
meta_cfg_info_t *innodb_config_meta_hash_init(
/*=========================*/
hash_table_t *meta_hash, /*!< in/out: InnoDB Memcached
engine */
void *thd); /*!< in/out: MySQL THD */
#endif
|
