~giuseppe-maxia/mysql-sandbox/mysql-sandbox-3 : revision 1

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.