Mixing
MariaDB as a backend database
Clash Royale CLAN TAG#URR8PPP
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0;
up vote
6
down vote
favorite
I know WordPress expects to use MySQL as it's database backend, but can I switch to using MariaDB instead?
MariaDB is a fork of MySQL that includes a bunch of really nice improvements for management and has some great SQL language improvements.
database
asked Aug 22 at 16:38
Max Vernon
1567
add a comment |Â
up vote
6
down vote
favorite
I know WordPress expects to use MySQL as it's database backend, but can I switch to using MariaDB instead?
MariaDB is a fork of MySQL that includes a bunch of really nice improvements for management and has some great SQL language improvements.
database
asked Aug 22 at 16:38
Max Vernon
1567
add a comment |Â
up vote
6
down vote
favorite
up vote
6
down vote
favorite
I know WordPress expects to use MySQL as it's database backend, but can I switch to using MariaDB instead?
MariaDB is a fork of MySQL that includes a bunch of really nice improvements for management and has some great SQL language improvements.
database
asked Aug 22 at 16:38
Max Vernon
1567
I know WordPress expects to use MySQL as it's database backend, but can I switch to using MariaDB instead?
MariaDB is a fork of MySQL that includes a bunch of really nice improvements for management and has some great SQL language improvements.
database
asked Aug 22 at 16:38
Max Vernon
1567
asked Aug 22 at 16:38
Max Vernon
1567
asked Aug 22 at 16:38
Max Vernon
1567
asked Aug 22 at 16:38
Max Vernon
1567
1567
add a comment |Â
add a comment |Â
3 Answers
3
active
oldest
votes
up vote
9
down vote
accepted
Yes, you can use MariaDB. MariaDB is a drop-in replacement for MYSQL so compatibility is not an issue. WordPress even lists MariaDB as an option within the requirements on their website:
We recommend servers running version 7.2 or greater of PHP and MySQL version 5.6 OR MariaDB version 10.0 or greater.
Here is a resource from MariaDB on this topic https://mariadb.com/resources/blog/how-install-and-run-wordpress-mariadb.
answered Aug 22 at 16:43
mbacon40
385210
1
Wordpress itself also recognizes MariaDb as a backend en-au.wordpress.org/about/requirements "MySQL version 5.6 or greater OR MariaDB version 10.0 or greater."
– Gary Myers
Aug 22 at 22:40
add a comment |Â
up vote
3
down vote
There is no problem. It's compatible. remember you need to install php-mysql library.
answered Aug 22 at 16:43
Santiago Cerro López
612
add a comment |Â
up vote
3
down vote
Right now the answer is "yes". The problem may begin when the difference between maria and mysql will be in sql syntax level in a way which prevents having compatibility between them.
As both products do not live alone in the world and have to rely on 3rd party developer (like the developers of the php mysql module), I think that there is no chance that a major difference between the two on the "API" level will happen in the short to medium time frame. Most likely the differences between the two will continue to be in performance and admin side.
answered Aug 22 at 16:45
Mark Kaplun
19.6k52552
MariaDB 10.3 already has syntax divergences from MySQL
– Max Vernon
Aug 22 at 16:46
2
@MaxVernon, sure, but as long as you do not need them to access data in the db, create tables etc, you can have a common ground. Those divergences are right now just extensions. At some point the amount or type of them will cause a problem, but I think that looking from the WP POV, which by itself partially relies on PHP integration with both, it will take time until thise changes will reach a state in which you just can not write compatible SQL between the both of them
– Mark Kaplun
Aug 22 at 16:51
add a comment |Â
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
9
down vote
accepted
Yes, you can use MariaDB. MariaDB is a drop-in replacement for MYSQL so compatibility is not an issue. WordPress even lists MariaDB as an option within the requirements on their website:
We recommend servers running version 7.2 or greater of PHP and MySQL version 5.6 OR MariaDB version 10.0 or greater.
Here is a resource from MariaDB on this topic https://mariadb.com/resources/blog/how-install-and-run-wordpress-mariadb.
answered Aug 22 at 16:43
mbacon40
385210
1
Wordpress itself also recognizes MariaDb as a backend en-au.wordpress.org/about/requirements "MySQL version 5.6 or greater OR MariaDB version 10.0 or greater."
– Gary Myers
Aug 22 at 22:40
add a comment |Â
up vote
9
down vote
accepted
Yes, you can use MariaDB. MariaDB is a drop-in replacement for MYSQL so compatibility is not an issue. WordPress even lists MariaDB as an option within the requirements on their website:
We recommend servers running version 7.2 or greater of PHP and MySQL version 5.6 OR MariaDB version 10.0 or greater.
Here is a resource from MariaDB on this topic https://mariadb.com/resources/blog/how-install-and-run-wordpress-mariadb.
answered Aug 22 at 16:43
mbacon40
385210
1
Wordpress itself also recognizes MariaDb as a backend en-au.wordpress.org/about/requirements "MySQL version 5.6 or greater OR MariaDB version 10.0 or greater."
– Gary Myers
Aug 22 at 22:40
add a comment |Â
up vote
9
down vote
accepted
up vote
9
down vote
accepted
Yes, you can use MariaDB. MariaDB is a drop-in replacement for MYSQL so compatibility is not an issue. WordPress even lists MariaDB as an option within the requirements on their website:
We recommend servers running version 7.2 or greater of PHP and MySQL version 5.6 OR MariaDB version 10.0 or greater.
Here is a resource from MariaDB on this topic https://mariadb.com/resources/blog/how-install-and-run-wordpress-mariadb.
answered Aug 22 at 16:43
mbacon40
385210
Yes, you can use MariaDB. MariaDB is a drop-in replacement for MYSQL so compatibility is not an issue. WordPress even lists MariaDB as an option within the requirements on their website:
We recommend servers running version 7.2 or greater of PHP and MySQL version 5.6 OR MariaDB version 10.0 or greater.
Here is a resource from MariaDB on this topic https://mariadb.com/resources/blog/how-install-and-run-wordpress-mariadb.
answered Aug 22 at 16:43
mbacon40
385210
edited Aug 23 at 20:49
answered Aug 22 at 16:43
mbacon40
385210
answered Aug 22 at 16:43
mbacon40
385210
answered Aug 22 at 16:43
mbacon40
385210
385210
1
Wordpress itself also recognizes MariaDb as a backend en-au.wordpress.org/about/requirements "MySQL version 5.6 or greater OR MariaDB version 10.0 or greater."
– Gary Myers
Aug 22 at 22:40
add a comment |Â
1
Wordpress itself also recognizes MariaDb as a backend en-au.wordpress.org/about/requirements "MySQL version 5.6 or greater OR MariaDB version 10.0 or greater."
– Gary Myers
Aug 22 at 22:40
1
1
Wordpress itself also recognizes MariaDb as a backend en-au.wordpress.org/about/requirements "MySQL version 5.6 or greater OR MariaDB version 10.0 or greater."
– Gary Myers
Aug 22 at 22:40
Wordpress itself also recognizes MariaDb as a backend en-au.wordpress.org/about/requirements "MySQL version 5.6 or greater OR MariaDB version 10.0 or greater."
– Gary Myers
Aug 22 at 22:40
add a comment |Â
up vote
3
down vote
There is no problem. It's compatible. remember you need to install php-mysql library.
answered Aug 22 at 16:43
Santiago Cerro López
612
add a comment |Â
up vote
3
down vote
There is no problem. It's compatible. remember you need to install php-mysql library.
answered Aug 22 at 16:43
Santiago Cerro López
612
add a comment |Â
up vote
3
down vote
up vote
3
down vote
There is no problem. It's compatible. remember you need to install php-mysql library.
answered Aug 22 at 16:43
Santiago Cerro López
612
There is no problem. It's compatible. remember you need to install php-mysql library.
answered Aug 22 at 16:43
Santiago Cerro López
612
answered Aug 22 at 16:43
Santiago Cerro López
612
answered Aug 22 at 16:43
Santiago Cerro López
612
answered Aug 22 at 16:43
Santiago Cerro López
612
612
add a comment |Â
add a comment |Â
up vote
3
down vote
Right now the answer is "yes". The problem may begin when the difference between maria and mysql will be in sql syntax level in a way which prevents having compatibility between them.
As both products do not live alone in the world and have to rely on 3rd party developer (like the developers of the php mysql module), I think that there is no chance that a major difference between the two on the "API" level will happen in the short to medium time frame. Most likely the differences between the two will continue to be in performance and admin side.
answered Aug 22 at 16:45
Mark Kaplun
19.6k52552
MariaDB 10.3 already has syntax divergences from MySQL
– Max Vernon
Aug 22 at 16:46
2
@MaxVernon, sure, but as long as you do not need them to access data in the db, create tables etc, you can have a common ground. Those divergences are right now just extensions. At some point the amount or type of them will cause a problem, but I think that looking from the WP POV, which by itself partially relies on PHP integration with both, it will take time until thise changes will reach a state in which you just can not write compatible SQL between the both of them
– Mark Kaplun
Aug 22 at 16:51
add a comment |Â
up vote
3
down vote
Right now the answer is "yes". The problem may begin when the difference between maria and mysql will be in sql syntax level in a way which prevents having compatibility between them.
As both products do not live alone in the world and have to rely on 3rd party developer (like the developers of the php mysql module), I think that there is no chance that a major difference between the two on the "API" level will happen in the short to medium time frame. Most likely the differences between the two will continue to be in performance and admin side.
answered Aug 22 at 16:45
Mark Kaplun
19.6k52552
MariaDB 10.3 already has syntax divergences from MySQL
– Max Vernon
Aug 22 at 16:46
2
@MaxVernon, sure, but as long as you do not need them to access data in the db, create tables etc, you can have a common ground. Those divergences are right now just extensions. At some point the amount or type of them will cause a problem, but I think that looking from the WP POV, which by itself partially relies on PHP integration with both, it will take time until thise changes will reach a state in which you just can not write compatible SQL between the both of them
– Mark Kaplun
Aug 22 at 16:51
add a comment |Â
up vote
3
down vote
up vote
3
down vote
Right now the answer is "yes". The problem may begin when the difference between maria and mysql will be in sql syntax level in a way which prevents having compatibility between them.
As both products do not live alone in the world and have to rely on 3rd party developer (like the developers of the php mysql module), I think that there is no chance that a major difference between the two on the "API" level will happen in the short to medium time frame. Most likely the differences between the two will continue to be in performance and admin side.
answered Aug 22 at 16:45
Mark Kaplun
19.6k52552
Right now the answer is "yes". The problem may begin when the difference between maria and mysql will be in sql syntax level in a way which prevents having compatibility between them.
As both products do not live alone in the world and have to rely on 3rd party developer (like the developers of the php mysql module), I think that there is no chance that a major difference between the two on the "API" level will happen in the short to medium time frame. Most likely the differences between the two will continue to be in performance and admin side.
answered Aug 22 at 16:45
Mark Kaplun
19.6k52552
answered Aug 22 at 16:45
Mark Kaplun
19.6k52552
answered Aug 22 at 16:45
Mark Kaplun
19.6k52552
answered Aug 22 at 16:45
Mark Kaplun
19.6k52552
19.6k52552
MariaDB 10.3 already has syntax divergences from MySQL
– Max Vernon
Aug 22 at 16:46
2
@MaxVernon, sure, but as long as you do not need them to access data in the db, create tables etc, you can have a common ground. Those divergences are right now just extensions. At some point the amount or type of them will cause a problem, but I think that looking from the WP POV, which by itself partially relies on PHP integration with both, it will take time until thise changes will reach a state in which you just can not write compatible SQL between the both of them
– Mark Kaplun
Aug 22 at 16:51
add a comment |Â
MariaDB 10.3 already has syntax divergences from MySQL
– Max Vernon
Aug 22 at 16:46
2
@MaxVernon, sure, but as long as you do not need them to access data in the db, create tables etc, you can have a common ground. Those divergences are right now just extensions. At some point the amount or type of them will cause a problem, but I think that looking from the WP POV, which by itself partially relies on PHP integration with both, it will take time until thise changes will reach a state in which you just can not write compatible SQL between the both of them
– Mark Kaplun
Aug 22 at 16:51
MariaDB 10.3 already has syntax divergences from MySQL
– Max Vernon
Aug 22 at 16:46
MariaDB 10.3 already has syntax divergences from MySQL
– Max Vernon
Aug 22 at 16:46
2
2
@MaxVernon, sure, but as long as you do not need them to access data in the db, create tables etc, you can have a common ground. Those divergences are right now just extensions. At some point the amount or type of them will cause a problem, but I think that looking from the WP POV, which by itself partially relies on PHP integration with both, it will take time until thise changes will reach a state in which you just can not write compatible SQL between the both of them
– Mark Kaplun
Aug 22 at 16:51
@MaxVernon, sure, but as long as you do not need them to access data in the db, create tables etc, you can have a common ground. Those divergences are right now just extensions. At some point the amount or type of them will cause a problem, but I think that looking from the WP POV, which by itself partially relies on PHP integration with both, it will take time until thise changes will reach a state in which you just can not write compatible SQL between the both of them
– Mark Kaplun
Aug 22 at 16:51
add a comment |Â
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fwordpress.stackexchange.com%2fquestions%2f312186%2fmariadb-as-a-backend-database%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password