什么是mysqlsandbox
一群海豚在属于自己的海滩上自由的玩耍，尽管只是一个方盒的大小，但是设备一样的齐全，同样可以玩的很开心，这就是我今天要说的——MySQL Sandbox2.0，3.0也将要推出。
MySQL   Sandbox是一个非常简单快捷部署MySQL技术的一个工具套件，它可以让你在同一台机器上，更加快速的无干扰的去达到你的最终目的，比如，作为软件 测试人员只是要测试软件系统的良好性不需要在mysql的安装上纠缠过多，不需要对MySQL数据库有太多的经验；有的时候我们只是对新版本的一些特性感 兴趣，尽可能快速结束安装部署，而是重点地去体验它的一些特性；可以使用sandbox最短时间部署我们需要的数据库应用架构 (ReplicationCluster)，以配合我们的现有的应用系统进行性能测试。
MySQL Sandbox 快速，是用秒来衡量的。下面我们就来感受一下sandbox给我们的F1般的速度,你可以在每次安装前使用time命令统计出real/user/sys三项的使用时间。
安装mysqlsandbox
下载MySQL-Sandbox-3.0.25.tar.gz，
下载mysql-5.x.xx-linux-i686-glibc23.tar.gz
解压mysqlsandbox
tar -xf MySQL-Sandbox-3.0.25.tar.gz -C /mnt
安装简单的几个步骤
perl Makefile.PL
make
make test
make install
开始快速部署mysql
make_sandbox mysql-5.1.42-linux-i686-icc-glibc23.tar.gz
到这里可能会有报错
用export设置变量使ROOT用户可用
export SANDBOX_AS_ROOT=1
最好的做法是写到root用户的 .bash_prefile下
echo>>exportSANDBOX_AS_ROOT=1.bash_profile
然后继续执行make_sandbox
make_sandbox mysql-5.1.42-linux-i686-icc-glibc23.tar.gz
Use of uninitialized value in concatenation (.) or string at /usr/bin/make_sandbox line 111.
unpacking /mnt/mysql-5.1.42-linux-i686-icc-glibc23.tar.gz
Executing low_level_make_sandbox --basedir=/mnt/5.1.42 \
--sandbox_directory=msb_5_1_42 \
--install_version=5.1 \
--sandbox_port=5142 \
--no_ver_after_name \
--my_clause=log-error=msandbox.err
The MySQL Sandbox,  version 3.0.25
(C) 2006-2012 Giuseppe Maxia
installing with the following parameters:
upper_directory                = /root/sandboxes
sandbox_directory              = msb_5_1_42
sandbox_port                   = 5142
check_port                     =
no_check_port                  =
datadir_from                   = script
install_version                = 5.1
basedir                        = /mnt/5.1.42
tmpdir                         =
my_file                        =
operating_system_user          = root
db_user                        = msandbox
remote_access                  = 127.%
ro_user                        = msandbox_ro
rw_user                        = msandbox_rw
repl_user                      = rsandbox
db_password                    = msandbox
repl_password                  = rsandbox
my_clause                      = log-error=msandbox.err
master                         =
slaveof                        =
high_performance               =
prompt_prefix                  = mysql
prompt_body                    =  [\h] {\u} (\d) >
force                          =
no_ver_after_name              = 1
verbose                        =
load_grants                    = 1
no_load_grants                 =
no_run                         =
no_show                        =
y
loading   grants
. sandbox server  started
Your sandbox server was installed in $HOME/sandboxes/msb_5_1_42
安装完成后会提示告知你安装在什么路径
运行一个mysql
[root@centos129 msb_5_1_42]# cd /root/sandboxes/msb_5_1_42/
[root@centos129 msb_5_1_42]# ls
change_paths  data          msb             proxy_start  start   tmp
change_ports  grants.mysql  my              restart      status  use
clear         load_grants   my.sandbox.cnf  send_kill    stop    USING
[root@centos129 msb_5_1_42]# ./use
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.1.42 MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql [localhost] {msandbox} ((none)) >
提示进入成功！
./stop (停止数据库服务)
./start (打开数据库服务)
mysqlsandbox部署mysql-replication
[root@centos129 msb_5_1_42]# make_replication_sandbox /mnt/mysql-5.1.42-linux-i686-icc-glibc23.tar.gz
installing and starting master
Use of uninitialized value in concatenation (.) or string at /usr/bin/make_sandbox line 111.
installing slave 1
Use of uninitialized value in concatenation (.) or string at /usr/bin/make_sandbox line 111.
installing slave 2
Use of uninitialized value in concatenation (.) or string at /usr/bin/make_sandbox line 111.
starting slave 1
. sandbox server started
starting slave 2
. sandbox server started
initializing slave 1
initializing slave 2
replication directory installed in $HOME/sandboxes/rsandbox_mysql-5_1_42
[root@centos129 msb_5_1_42]#
在master上添加一个数据库haha
./m -e 'create database haha'
在slave1和slave2上查看是否有数据库haha
[root@centos129 rsandbox_mysql-5_1_42]# ./s2 -e 'show databases'
+--------------------+
| Database           |
+--------------------+
| information_schema |
| haha               |
| mysql              |
| test               |
+--------------------+
[root@centos129 rsandbox_mysql-5_1_42]# ./s1 -e 'show databases'
+--------------------+
| Database           |
+--------------------+
| information_schema |
| haha               |
| mysql              |
| test               |
+--------------------+
./stop_all 关闭所有节点
[root@centos129 rsandbox_mysql-5_1_42]# ./stop_all
executing "stop" on slave 1
executing "stop" on slave 2
executing "stop" on master
[root@centos129 rsandbox_mysql-5_1_42]#

学习uboot sandbox

1.Sandbox
  The ‘sandbox’ architecture is designed to allow U-Boot to run under Linux on almost any hardware. To achieve this it builds U-Boot (so far as possible) as a normal C application with a main() and normal C libraries.
  All of U-Boot’s architecture-specific code therefore cannot be built as part of the sandbox U-Boot. The purpose of running U-Boot under Linux is to test all the generic code, not specific to any one architecture. The idea is to create unit tests which we can run to test this upper level code.
Sandbox configurations includes:

CONFIG_SANDBOX
CONFIG_SANDBOX_BIG_ENDIAN

There are two versions of the sandbox:

32-bit-wide integers
64-bit-wide integers.

  Note：by default, the sandbox it built for a 32-bit host. The sandbox using 64-bit-wide integers can only be built on 64-bit hosts.
2.Basic Operation
  To run sandbox U-Boot use something like:
 $make sandbox_defconfig all
 $./u-boot

Note:  If you get errors about ‘sdl-config: Command not found’ you may need to install libsdl1.2-dev or similar to get SDL support. Alternatively you can build sandbox without SDL (i.e. no display/keyboard support) by removing the CONFIG_SANDBOX_SDL line in include/configs/sandbox.h or using:
#Some machines do not have SDL libraries installed, and it is still useful to build sandbox without LCD/keyboard support.
$sudo apt-get install libsdl1.2-dev
$make sandbox_defconfig all NO_SDL=1
$./u-boot

U-Boot will start on your computer, showing a sandbox emulation of the serial
console:
U-Boot 2014.04 (Mar 20 2014 - 19:06:00)
DRAM:  128 MiB
Using default environment

In:    serial
Out:   lcd
Err:   lcd
=>

  You can issue commands as your would normally. If the command you want is not supported you can add it to include/configs/sandbox.h.
  To exit, type ‘reset’ or press Ctrl-C.
  You can use the test-dm.sh：
  1 #!/bin/sh
  2 
  3 die() {
  4     echo $1
  5     exit 1
  6 }
  7 
  8 NUM_CPUS=$(cat /proc/cpuinfo |grep -c processor)
  9 make O=sandbox sandbox_config  || die "Cannot configure U-Boot"
 10 make O=sandbox -s -j${NUM_CPUS} || die "Cannot build U-Boot"
 11 
 12 dd if=/dev/zero of=spi.bin bs=1M count=2
 13 echo -n "this is a test" > testflash.bin
 14 dd if=/dev/zero bs=1M count=4 >>testflash.bin
 17 ./sandbox/u-boot -d sandbox/arch/sandbox/dts/test.dtb -i "dm test"        
 18 #./sandbox/u-boot -d sandbox/arch/sandbox/dts/test.dtb -c "dm test"                                                                                    
 19 rm -f spi.bin
 20 rm -f testflash.bin

Note:

  To execute commands directly, use the -c option. When -c is used, U-Boot exits after the command is complete,but you can force it to go to interactive mode instead with -i.
You can use the command below：
Documents/work/code/u-boot/u-boot$ ./sandbox/u-boot -help
U-Boot 2019.07-rc3-dirty (May 31 2019 - 19:10:05 +0800)

u-boot, a command line test interface to U-Boot

Usage: u-boot [options]
Options:
      --show_of_platdata         Show of-platdata in SPL
  -L, --log_level        <arg>   Set log level (0=panic, 7=debug)
  -v, --verbose                  Show test output
  -t, --terminal         <arg>   Set terminal to raw/cooked mode
  -l, --show_lcd                 Show the sandbox LCD display
  -n, --ignore_missing           Ignore missing state on read
  -w, --write                    Write state FDT on exit
  -r, --read                     Read the state FDT on startup
  -s, --state            <arg>   Specify the sandbox state FDT
      --rm_memory                Remove memory file after reading
  -m, --memory           <arg>   Read/write ram_buf memory contents from file
  -j, --jump             <arg>   Jumped from previous U-Boot
  -i, --interactive              Enter interactive mode
  -D, --default_fdt              Use the default u-boot.dtb control FDT in U-Boot directory
  -d, --fdt              <arg>   Specify U-Boot's control FDT
  -c, --command          <arg>   Execute U-Boot command
  -b, --boot                     Run distro boot commands
  -h, --help                     Display help


2.1.Console / LCD support
  Assuming that CONFIG_SANDBOX_SDL is defined when building, you can run the sandbox with LCD and keyboard emulation, using something like:

./u-boot -d u-boot.dtb -l

Note : -l causes the LCD emulation window to be shown.

  This will start U-Boot with a window showing the contents of the LCD. If that window has the focus then you will be able to type commands as you would on the console. You can adjust display settings in the device tree file - arch/sandbox/dts/sandbox.dts.
3.Supported Drivers
 174U-Boot sandbox supports these emulations:
 175
 176- Block devices
 177- Chrome OS EC
 178- GPIO
 179- Host filesystem (access files on the host from within U-Boot)
 180- I2C
 181- Keyboard (Chrome OS)
 182- LCD
 183- Network
 184- Serial (for console only)
 185- Sound (incomplete - see sandbox_sdl_sound_init() for details)
 186- SPI
 187- SPI flash
 188- TPM (Trusted Platform Module)

There are unfortunately quite a few variants at present:
There are unfortunately quite a few variants at present:
 200
 201 sandbox - should be used for most tests
 202 sandbox64 - special build that forces a 64-bit host
 203 sandbox_flattree - builds with dev_read_...() functions defined as inline.
 204    We need this build so that we can test those inline functions, and we
 205    cannot build with both the inline functions and the non-inline functions
 206    since they are named the same.
 207 sandbox_noblk - builds without CONFIG_BLK, which means the legacy block
 208    drivers are used. We cannot use both the legacy and driver-model block
 209    drivers since they implement the same functions
 210 sandbox_spl - builds sandbox with SPL support, so you can run spl/u-boot-spl
 211    and it will start up and then load ./u-boot. It is also possible to
 212    run ./u-boot directly.

4.Testing
  U-Boot sandbox can be used to run various tests, mostly in the test/ directory. These include:
 401  command_ut
 402     - Unit tests for command parsing and handling
 403  compression
 404     - Unit tests for U-Boot's compression algorithms, useful for
 405       security checking. It supports gzip, bzip2, lzma and lzo.
 406  driver model
 407     - Run this pytest
 408          ./test/py/test.py --bd sandbox --build -k ut_dm -v
 409  image
 410     - Unit tests for images:
 411          test/image/test-imagetools.sh - multi-file images
 412          test/image/test-fit.py        - FIT images
 413  tracing
 414     - test/trace/test-trace.sh tests the tracing system (see README.trace)
 415  verified boot
 416      - See test/vboot/vboot_test.sh for this
 417

Note： To run all tests use “make check”.
5.Related code about the sandbox:

include/configs/sandbox.h
arch/sandbox/
board/sandbox/
test/dm/

参考资料：

https://lxr.missinglinkelectronics.com/uboot/board/sandbox/README.sandbox