Migrate RDM on MS SQL to GNU/Linux with Mariadb or MySQL

Hello,
I would like to warn you that DVLS does not support MariaDB. We try to implement all the SQL Server features in MariaDB but it's always the last thing we do. I don't think that a lot of features are missing and if something is missing, let us know and we will evaluate why it's not here.

Regards

Hi David,

What about MySQL? Is there a supported way of doing this or you guys would recommend only using MS SQL for he time being?

I would like to get away from MS, licensing and the excess of resources needed to have a SQL server running for RDM.

Thanks!

Hello,

David mentioned MariaDB in his post, but it's the same for MySQL :)

Best regards,

But that means it would not be good for production in your opinion?

Is there anyone using mysql in production?

Hello,

Indeed, we have clients using MariaDB and/or MySQL in production as their data source.

Maybe you can start with a test database and switch it into production when you are satisfy with the results.

Best regards,

Is there any documentation for this process?

Hello,

In RDM, you can create as many data sources that you want. You can switch between your data sources by using the dropdown menu.


This means that it would be possible for you to create a new MySQL data source via File -> Data Sources -> New.

After, it would be possible to switch between your SQL Server and MySQL data source using the dropdown mentioned at the top.

If you want to import your data in this new data source, please consult this link
https://help.remotedesktopmanager.com/tipsandtricks_data_migration.htm

Using MySQL, the user creation is also located in Administration -> Users. This means that is the same process for the user creation.

If you have other questions, feel free to post them here or in a new thread.

Best regards,

Okay thanks

Are there performance benefits in your opinion moving database from MS SQL to MySQL/MariaDB? I'm noticing RDM a bit slow when reading data from SQl, it is located on a remote site over a 100mbit fibre line with 6ms latency but at times I'm feeling it could be improved.

Thanks!

Hello,

The performance of MariaDB, MySQL or MSSQL should be relatively the same.

However, the performance could be affected by a lot of things, like the number of users, the number of sessions, the entry types, the number of logs, ect...

Would you like us to have a look at the performance issue that you have with your MSSQL data source?

Best regards,

Hi Jeff,

We are sharing the SQL server with another service that also uses IIS which I think hogs the server, so that may be affecting the performance at time.

I want first to split the roles among different servers and Linux/MySQL seems a lean way of doing it.

I'll try to give it a go first with CentOS/MySQL and see how it goes

Just an update, I've got CentOS installed with mariaDB and migrated the database over to test, so far working absolutely fine. I believe it would be beneficial for other customers to know this is a easy route and that is works. The server that was about 80GB now is just under 2GB, no license costs for Windows and MS SQL is another big reason to migrate.

I'm happy to share my step-by-step guide that I created for my techs here, may be useful for you too? The more people using Linux and mariaDB better it would be as development would need to focus over there :)

Hello,

Indeed, if you want to share your step-by-step document, this could be helpful for other customer.

Best regards,

Hello,

@Mephisto, I am interested in your document. Did you post it on the forum? Can you direct me to the document where ever its located?

Hello, I'm also planning on migrating from MS SQL to MariaDB. Are there any step-by-step guides available on how to do it?

@rick

Can I ask why you want to move from SQL Server to MariaDB?

I would strongly suggest against moving from SQL Server to MySQL/MaraiDB for the simple reason is we plan on deprecating the support of MySQL/MariaDB.

Why? For a few reasons:

• Internal cost of the support tickets generated by MySQL/MariaDB. They, by far, outnumber the tickets related to SQL Server, yet usage is about 15 to 1 in favour of SQL Server.
• SQL Server is now available for both platforms (Linux & Windows)
  • You can use SQL Server Express (it's free)
• Our Devolutions Server (DVLS) product will never support MySQL/MaraiDB