~dveeden/mysql-sandbox/mysql-sandbox

1 by Giuseppe Maxia
- Preparation for version 3.0
1
2.0.98 29-Mar-2009
2
	- Preparation for version 3.0
3
	- refactoring code to use with ExtUtilis::MakeMaker and install a proper
4
	Perl module 
5
2.0.18 22-Mar-2009
6
	- added change_port script to installed sandboxes
7
	- added 'port' operation to sbtool
8
	- added --new_port option to sbtool
9
2.0.17 15-Mar-2009
10
	- improved sbtool error checking
11
	- improved sbtool built-in help
12
	- added "report-port" to replication slave setup
13
2.0.16 14-Mar-2009
14
	- added 'copy' option to sbtool, to clone a sandbox data directory into another.
15
2.0.15 09-Mar-2009
16
	- added "report-host" option to slave creation
17
	- fixed server_id for values larger than 10. Instead of folding from 109
18
	  to 100, it was doing 109 to 1010.
19
2.0.15 19-Feb-2009
20
	- added sbtool, a multi purpose program to do administrative tasks
21
	  with the sandbox. Supported operations: port list, replication tree,
22
	  moving single and multiple sandboxes
23
2.0.14 08-Feb-2009
24
	- added code to the "clear" script to truncate the table logs if they
25
	  exist
26
	- improved error messages when using wrong directories or tarballs
27
	- added a "change_paths" script to change the sandbox paths quickly
28
	  when moving the sandbox to a new location.
29
2.0.13 27-Jan-2009
30
	- added parameters to "start" and "restart" scripts. If you pass an option,
31
	  it will be passed directly to mysqld_safe. e.g. "start --log=mylog.log"
32
	- fixed bug in test_sandbox.pl. Using "ls -d /path/*/" doesn't work on
33
	  Solaris. Replaced with a more robust routine.
34
	- Allow the unpacking of tarballs to work on Solaris if "gtar" is found.
35
2.0.12 16-Oct-2008
36
	- Fixed small bug in 'clear' script. When the server is not responsive,
37
	  it was calling the wrong 'kill' script
38
	- Applied Greg Haase patch to fix a bug in --datadir_from=dir:xxxx
39
2.0.11 05-Oct-2008
40
	- Fixed bug#278394, "character '-' in database names" (added backticks to
41
	'clear' script)
42
	- added a command to change read attributes inside expanded tarballs
43
	  to avoid a possible failure in MySQL test suite, should a user run it
44
2.0.10 27-Aug-2008
45
	- fixed minor bug in make_multiple_sandbox and make_replication_sandbox
46
	  when passing additional parameters. No space were added at the end.
47
	  Further parameters were glued together, resulting in a startup error.
48
	- added NODE_OPTIONS to work in make_replication_sandbox (it adds options
49
	  to both MASTER_OPTIONS and SLAVE_OPTIONS)
50
2.0.9 22-Aug-2008
51
	- fixed bug#260265 "installation fails with log-error option and version < 5"
52
	  - removed "log-error" from default file
53
	  - added this option conditionally only if major version > 4
54
2.0.8 16-Aug-2008
55
	- fixed problem with "~" not being expanded as $HOME
56
	- fixed problem with not existent path for tarball
57
	- fixed bug#258523 Mysql Sandbox looks for tar.gz in wrong location
58
	  in make_replication_sandbox, make_sandbox, make_multiple_sandbox,
59
	  make_multiple_custom_sandbox, and in the test suite
60
	- fixed minor problem in MyScripts.pm. log-slow-queries was misspelled,
61
	  although commented.
62
2.0.7 06-Aug-2008
63
	- added shortcut option "--circular=N" to make_replication_sandbox
64
	  corresponding to "--topology=circular --how_many_nodes=N"
65
	- added Falcon creation to smoke test (if version >= 6)
66
2.0.6 20-Jul-2008
67
	- added "check_slaves" script to replication sandboxes
68
2.0.5 14-Jul-2008
69
	- added named error log to configuration file
70
	- add removal of *.err-old files in "clear" script
71
	- Fixed bug in circular replication. Unnecessary initialization
72
	  after stop_all. Added the same check used in standard replication
73
	- fixed bug in circular replication. start_all and
74
	  set_circular_replication.sh were not stopping and starting the
75
	  slaves in the righ order.
76
	- improved 'stop' script. If the server is a slave, calls "stop slave"
77
	  before closing down.
78
2.0.4 12-Jul-2008
79
	- fixed bug in test suite. Parameter passing to check routine 
80
      was often failing on negative tests. Added subroutine prototype
81
	  to fix the problem.
82
2.0.3 12-Jul-2008
83
	- Fixed smoke test bugs in test suite.
84
	  - fixed race condition while checking the pid file
85
	  - added cleanup of extracted binary with smoke test
86
	  - added stricter check for InnoDB tables
87
	- added some replication tests to test suite
88
2.0.2 6-Jul-2008
89
	- Fixed minor bugs in low_level_make_sandbox. 
90
	  - When started with --force and --load grants, it said that it 
91
	    failed to comply. In fact, the grants were already loaded.
92
	  - when started with --force, it invokes $sandbox_dir/start
93
	    without checking if such script exists
94
2.0.1 5-Jul-2008
95
	- fixed minor bug on test suite. It fails on Solaris with "ps -ea". Changed
96
	  to "ps -ef"
97
	- added README.wiki
98
	- added "smoke" test to test suite
99
	- added --no_confirm to all single sandbox testing
100
2.0.0 2-Jul-2008
101
	- fixed minor bug in generated scripts. Removed bash-specific operator
102
	"=="
103
1.99.10 1-Jul-2008
104
	- Fixed bug in test suite. Process count was not taking into account the
105
	  pre-test processes.
106
	- Fixed bug in test suite. Portability. ps was being used with non
107
	  portable options.
108
    - added --prompt_body option to low_level_make_sandbox
109
	- added $SANDBOX_BINARY environment variable, to replace default
110
 	  $HOME/opt/mysql
111
	- fixed error message of make_sandbox when invoked without options
112
	- added a check in make_sandbox to make sure that we are using GNU tar.
113
1.99.9 30-Jun-2008
114
	- Fixed bug #244236 (low_level_make_sandbox accepts unnecessary arguments)
115
	- Fixed bug in low_level_make_sandbox. sandbox_home was not checked
116
	  for correctness. It is a simple name, and it should not accept 
117
	  full paths.
118
	- INCOMPATIBLE CHANGE
119
	  home_directory was not supposed to be home. Its name is misleading, and
120
	  thus it was changed to upper_directory.
121
	- Fixed typos in README
122
	- Initial fix for bug #239630 (possible failure on non-GNU tar)
123
	- fixed script names in "sandbox" script
124
    - (Thanks to John Embretsen for most of the reports on today's changes)
125
1.99.8 29-Jun-2008
126
	- INCOMPATIBLE CHANGE
127
	  $HOME/sandboxes is now the default SANDBOX_HOME, which users
128
	  however can override.
129
	- INCOMPATIBLE CHANGE
130
	  "multi_cmd" was renamed "use_all" for name consistency
131
	- added a call to low_level_make_sandbox --help when 
132
	  make_sandbox is invoked without the proper syntax.
133
	- README has been completely rewritten
134
	- added a ./docs directory with the README.pod source for README
135
	- added POD to ./sandbox script, to show the documentation
136
	  when called as "./sandbox manual|help"
137
1.99.7 28-Jun-2008
138
	- added configurable options for test suite
139
	  users can now choose which versions and which tests to run
140
	  from the command line
141
	- removed deprecated test_sandbox.sh
142
	- moved test suite to ./tests directory
143
	- added tests/README
144
	- improved "stop" script by combining it with the "kill" script
145
	- adjusted make_dist script to use the ./test directory
146
	- improved test suite with the ability of running from one or more
147
	  tarballs instead of the default directories ([$HOME]/opt/mysql)
148
1.99.6 28-Jun-2008
149
	- enhanced the "clear" script. Now it removes all databases form the
150
	  data directory, first trying via SQL, then using the OS.
151
	- added tests to the test suite to check on this feature
152
1.99.5 27-Jun-2008
153
	- INCOMPATIBLE CHANGE
154
	  make_sandbox renamed low_level_make_sandbox
155
	  easy_sandbox renamed make_sandbox
156
	- fixed bug in make_replication_sandbox (base port was not isolated)
157
	- added test for circular replication
158
	- improved testing for number of processes in the test suite
159
	- added circular replication features to make_multiple_sandbox 
160
	  with options --master_master and --circular (this should not be
161
	  used directly)
162
	- added circular replication features to make_replication_sandbox
163
	  with options --master_master and --topology={standard|circular} .
164
	  This feature uses make_multiple_sandbox internally. 
165
	- circular replication uses a separate directory name and port
166
	- fixed bug in make_multiple_sandbox. It did not use the $SANDBOX_HOME
167
	  directory.
168
1.99.4 21-Jun-2008
169
	- added more extensive test suite in Perl 
170
	- fixed bug in make_multiple_custom_sandbox (install directory was not set
171
	  when calling easy_sandbox)
172
1.99.3 21-Jun-2008
173
	- INCOMPATIBLE CHANGE
174
	  all Perl script names were changed to make them more intuitive
175
		install.pl -> make_sandbox
176
		express_install.pl -> easy_sandbox
177
		set_replication.pl -> make_replication_sandbox
178
		set_many -> make_multiple_sandbox
179
		set_custom_many.pl -> make_multiple_custom_sandbox
180
	- created a './sandbox' script that lists all applications and eventually
181
	  executes the one that is passed as argument
182
	- mapped "stop" script to faster and safer "kill" script
183
	- replaced "sleep 3" with a loop + timeout in shell scripts
184
	- removed "sleep" commands from Perl scripts
185
	- fixed bug in get_help() : parse_options were not passed to the $msb object
186
1.99.2 20-Jun-2008
187
	- fixed minor bug. mysql_install_db script in some cases is
188
	  found in the "bin" directory rather than "scripts"
189
	- added ability to log start operations into a log file
190
1.99.1 19-Jun-2008
191
	- added "kill" script to each sandbox
192
	- replace call to "stop" with "kill" in "clear" script
193
1.99.0 15-Jun-2008
194
	- Started new development branch for Sandbox 2.0
195
	- added MySandbox.pm module, to use the same routines across scripts
196
1.22 15-Jun-2008
197
	- added support for default options file ($HOME/.msandboxrc)
198
	- fixed minor bug in set_replication.pl. Added #master to multi_cmd
199
      output.
200
	- fixed bug related to location of sample option files. The installer
201
	  was only looking under "./support-files" while recent packaging use
202
	  "./share/mysql"
203
    - fixed Bug#240121, with a collision between my_file and replication.
204
	- added the execution of a "./clear" command when "--force" was used
205
	  to avoid overwriting a running server.
206
	- cleaned up current_changes to contain only not empty options
207
	- created a basic test suite (not in distribution yet, only in RCS)
208
1.21 09-Jun-2008
209
	- added SANDBOX_HOME environmental variable to override $HOME
210
	- default sandbox home is now $HOME/sandboxes (if exists) or else
211
	  it is $HOME, as before
212
	- added scripts to start/stop/clear/use all sandboxes at once (if
213
	  $SANDBOX_HOME != $HOME)
214
1.20 11-Apr-2008
215
	- Added set_custom_many.pl to install different versions of the server
216
	  in one go. (Thanks to Ronald Bradford for the idea)
217
	- enhanced "multi_cmd" to say which server is running
218
	- added support for MYCLIENT_OPTION user variable to pass
219
	  options to the client (./use and ./multi_cmd)
220
1.19 06-Apr-2008
221
	- changed installer files so that they can be called from 
222
	  outside the installation directory.
223
1.18 02-Apr-2008 
224
	- Fixed bug in set_many and set_replication. Undefined group directory 
225
	  when setting custom port
226
	- Added help to ./express_install
227
1.17 16-Mar-2008 (not released)
228
	- fixed minor bug in "clear: script. It did not remove subdirectories in
229
	  test db
230
	- fixed minor bug on the choice od source dir. If $HOME/opt/mysql exists,
231
	  it is preferred to /opt/mysql
232
1.16 04-Jan-2008 (not released)
233
    - added stronger check on the result of mysql_install_db.
234
	- added removal of general log files and falcon files with 
235
	  the "clear" command.
236
1.15 09-Dec-2007
237
	- fixed bug in grants.mysql. Removed anonymous users 
238
	  from mysql.db
239
	- added $HOME/opt/mysql as possible default for binaries.
240
	- added proxy_start script to start a MySQL Proxy instance
241
	  using the sandboxed server
242
243
1.14 24-Oct-2007
244
	- added a set_many.pl command to create several servers
245
	  not in replication
246
	- fixed bug in replication ports assignment. Two replication
247
	  systems using adjacent versions (e.g. 5.1.22 and 5.1.23) would
248
	  have clashing port numbers.
249
250
1.13 23-Oct-2007
251
	- (INCOMPATIBLE CHANGE) removed '.sh' suffix from all scripts
252
	- added version differentiation to replication port and
253
	  directory. Instead of being always the same, now they 
254
	  are based on the version number, unless modified by
255
	  the user.
256
	- added a multi_cmd script to the replication system,
257
	  to send a query to each node.
258
	- added a 'my' script to call mysql* tools
259
	- fixed bug about using 6.0 binaries on Mac OS X (dynamic library
260
	  path requires a different environment variable)
261
	- fixed bug in replication. After a "clear_all", the replication
262
	  did not start again. Added a "initialize_slaves" script that
263
	  get called by "start_all" if a clear_all was called.
264
265
1.12 17-Oct-2007
266
	- hidden mysql_install_db output on successful execution
267
	- fixed argument handling bug in replication scripts
268
269
1.11 16-Oct-2007
270
	- all shell scripts are now created from install.pl (not copied)
271
	- changed default username, password, and sandbox directory name
272
	- forbid using a relative path of tarball
273
274
1.10 16-Oct-2007 (not released)
275
	- fixed bug on mysql_install_db usage 
276
277
1.9 15-Oct-2007 (not released)
278
	- deprecated the 'archive' method of installation and removed
279
	  the compressed data directories
280
	- express_install can now expand a server tarball.
281
	- added support for replicated servers (set_replication.pl)
282
	  using CHANGE MASTER TO rather than replication options
283
	- added 'load_grants' option to install.pl
284
	- added 'prompt_prefix' option to install.pl
285
	- fixed bug about client library not being available due
286
	  to LD_LIBRARY_PATH not set
287
288
1.8 14-Sep-2007
289
	- Added support for MySQL 6.0
290
291
1.7 05-Jul-2006 (not released)
292
    - Added support for Mysql 5.2-alpha
293
294
1.6 27-May-2006
295
    - Added 'my_clause' command line option to define my.cnf file parameters;
296
    - changed interactive routine to allow multi-item options;
297
    - changed the shell scripts to be less bash specific. the sandbox
298
      should be now more cross-platform than before.
299
      During the installation, if bash is not found, then tcsh is used.
300
    - new Tutorial available at http://datacharmer.org/#tutorials
301
    - bugs fixed:
302
        -- clear.sh was using $HOME directory instead of _HOME_DIR_
303
        -- install_version calculated by express_install.pl could be lower
304
           than 1024.
305
        -- install_version was added twice when loading options from
306
           'current_options.conf' (Thanks to Imran Chaudhry for reporting it)
307
308
1.5 24-May-2006
309
    - added 'back' and 'quit' keywords in interactive mode
310
    - added express_install.pl, to install quickly from a binary package
311
    - Bug fixed. 'start.sh' and 'stop.sh' scripts where using
312
	  the actual $HOME dorectory instead of the user's defined
313
	  _HOME_DIR_
314
315
1.4 17-May-2006 (not released)
316
    - added support for 3.23, 4.0 and 4.1 installs
317
    - default install is now 5.0
318
    - default addition of version to sandbox directory name
319
    - added option "no_ver_after_name" to control the above change
320
321
1.3 05-May-2006
322
    - added "interactive" option to install through a sort of a wizard 
323
    - added current_options.conf  to record the options used for installing
324
    - fix bug in configuration file
325
326
1.2 02-May-2006
327
    - minor bug fixes 
328
329
1.1 19-Apr-2006
330
    - added multiple sources for data directory
331
332
1.0 18-Apr-2006
333
    - initial release.