How to configure MySQL backend in Plastic SCM 2.0

It's very simple to set up, you only need to create (or edit) a file named 'db.conf' at the server installation directory.

Its content must be like the following:

<DbConfig>

  <ProviderName>mysql</ProviderName>

  <ConnectionString>
    Server=_SERVER_;User ID=_USER_;
    Password=_PASSWORD_;Database={0};Pooling=true
  </ConnectionString>

  <DatabasePath></DatabasePath>

</DbConfig>

replacing the parameters _SERVER_, _USER_ and _PASSWORD_ with the appropiate ones according to the server configuration that you want to use. Thus, a valid 'db.conf' file in our development environment would be:

<DbConfig>

  <ProviderName>mysql</ProviderName>

  <ConnectionString>
    Server=venus;UserID=myuser;
    Password=mypwd;Database={0};Pooling=true
  </ConnectionString>

  <DatabasePath></DatabasePath>

</DbConfig>

Finally, we must set the mysql configuration parameter max_allowed_packet to support up to 10MB. If you require more information about how configure this parameter, you can take a look at this article.