Shulou(Shulou.com)05/31 Report--

This article mainly introduces "what is the MySQL of the original production environment without installation". In the daily operation, I believe that many people have doubts about what is the MySQL of the original production environment without installation. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "what is the MySQL of the original production environment without installation?" Next, please follow the editor to study!

This is it:

Com.wix wix-embedded-mysql x.y.z test

The code is also simple, directly define the version you need, database information, to initialize the SQL to it, go.

MysqldConfig config = aMysqldConfig (v5 charset (UTF8) .withPort (2215) .withUser ("user1", "pwd2") .withTimeZone ("Europe/Vilnius") .withTimeout (2, TimeUnit.MINUTES) .withServerVariable ("max_connect_errors", 666) .build (); EmbeddedMysql mysqld = anEmbeddedMysql (config) .addSchema ("aschema", ScriptResolver.classPathScript ("db/001_init.sql")) .start () / / do work mysqld.stop (); / / optional, as there is a shutdown hook

What's the advantage of this:

Tests can be run in the same environment as the production environment, the same version, the same coding and configuration, database/schema/user settings, etc.

It's easier than installing one, and if you want to switch versions, it's easier to change the configuration.

Each local project can use a different version, different configuration, nothing to worry about.

Support for multiple versions of MySQL-5.5,5.6,5.7,8.0

Supported by a variety of platforms and environments.

Principle

How is it realized behind this?

We are the official account of "digging to the bottom". Let's have a look.

After the start is configured in the above code, what exactly does start do?

Let's look at the following snippets of code:

Protected EmbeddedMysql (final MysqldConfig mysqldConfig, final DownloadConfig downloadConfig) {this.config = mysqldConfig; IRuntimeConfig runtimeConfig = new RuntimeConfigBuilder (). Defaults (mysqldConfig, downloadConfig). Build (); MysqldStarter mysqldStarter = new MysqldStarter (runtimeConfig); localRepository.lock (); try {this.executable = mysqldStarter.prepare (mysqldConfig);} finally {localRepository.unlock () } try {executable.start (); getClient (SCHEMA, mysqldConfig.getCharset ()). ExecuteCommands (format ("CREATE USER'% slots%% IDENTIFIED BY'% slots;", mysqldConfig.getUsername (), mysqldConfig.getPassword ());} catch (IOException e) {throw new RuntimeException (e) }} protected MysqldProcess start (final Distribution distribution, final MysqldConfig config, final IRuntimeConfig runtime) throws IOException {logger.info ("Preparing mysqld for startup"); Setup.apply (config, executable, runtime); logger.info ("Starting MysqldProcess"); return new MysqldProcess (distribution, config, runtime, this);}

In fact, it depends on an open source project called embed.process.

Public AbstractProcess (Distribution distribution, T config, IRuntimeConfig runtimeConfig, E executable) throws IOException {this.config = config; this.runtimeConfig = runtimeConfig; this.executable = distribution; / / pid file needs to be set before ProcessBuilder is called this.pidFile = pidFile (this.executable.getFile (). Executable ()); ProcessOutput outputConfig = runtimeConfig.getProcessOutput (); / / Refactor me-to much things done in this try/catch String nextCall= "" Try {nextCall= "onBeforeProcess ()"; onBeforeProcess (runtimeConfig); nextCall= "newProcessBuilder ()"; ProcessBuilder processBuilder = ProcessControl.newProcessBuilder (runtimeConfig.getCommandLinePostProcessor (). Process (distribution, getCommandLine (distribution, config, this.executable.getFile ()), getEnvironment (distribution, config, this.executable.getFile ()), true); nextCall= "onBeforeProcessStart ()"; onBeforeProcessStart (processBuilder, config, runtimeConfig) NextCall= "start ()"; process = ProcessControl.start (config.supportConfig (), processBuilder); nextCall= "writePidFile ()"; if (process.getPid ()! = null) {writePidFile (pidFile, process.getPid ());} nextCall= "addShutdownHook ()"; if (runtimeConfig.isDaemonProcess () & &! executable.isRegisteredJobKiller ()) {ProcessControl.addShutdownHook (new JobKiller ()) RegisteredJobKiller = true;} nextCall= "onAfterProcessStart ()"; onAfterProcessStart (process, runtimeConfig);} catch (IOException iox) {stop (); throw iox;}}

What does it operate? As you can guess from the name, it manipulates the process directly, actually downloading a MySQL at run time, and then starting and stopping through a script.

When it starts for the first time, it will be downloaded directly.

With these, you can load the initialization SQL script at startup, just like the production environment, and start your work.

Github address: https://github.com/wix/wix-embedded-mysql

At this point, the study on "what is the MySQL of the original production environment without installation" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.