1

When configuring a MySQL or MariaDB server, the terms 'standalone' and 'embedded' are referred to, but without reference to what they are, or what they do that is different from each other.

  • What does the term 'embedded' refer to? Is this like on an IP camera or something?

  • Also are these the only the two types of MariaDB/MySQL servers? Or are there other similar servers, like for example are 'galera', or enterprise other types of servers?

  • What is the difference between these two or other server types? In other words, what are they used for that is different, or how are they installed that are different, etc.

Note: When installing, these groups seem to apply:

[server]     apply to both mysqld and embedded   (note: 'mysqld' = 'standalone')
[mysqld]     apply to only mysqld             
[embedded]   apply to only            embedded

From context: in Debian desktop, I think I'm running a 'standalone' server only.

Improve this question

1 Answer 1

Reset to default
3

"embedded" is for applications that link to a server library and run a database internal to their application. They don't have a connection and all their SQL is via library calls. These aren't that common.

"standalone" seems most appropriate for your use.

embedded and "networked (including sockets)" are the main two server types. Withing networked there are MySQL cluster and MariaDB's galera as special kinds of networked configurations.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.