Solved

MySQL 5.6 or MariaDB

Posted on 2016-07-20
15
105 Views
Last Modified: 2016-08-02
hi,

Recently keep hearing about MariaDB, what is mariaDB? no SQL by oracle? I see a company hiring this with MySQL with MariaDB.

1) Can we Development with MariaDB? what tools to use ? I don't see Toad offer this.
2) Who own Maria DB now ? MySQL is owned by Oracle now.
3) how to integrate between MariaDB and MySQL ?
4) for HA, how is MysQL version of MS Always on now? still one primary and 4 x slave ? how about Maria DB?


please share your thought.
0
Comment
Question by:marrowyung
  • 8
  • 7
15 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 41722120
MariaDB is OpenSource, owned by MariaDB Corp https://mariadb.org/about/trademark/.  MariaDB is functionally identical to MySQL Community version and does not need any other tools.  https://mariadb.org/  MariaDB is in essence MySQL from the original developers.  It uses the same file names and commands.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 41722121
"MariaDB is OpenSource, owned by MariaDB Corp https://mariadb.org/about/trademark/.  MariaDB is functionally identical to MySQL Community version and does not need any other tools. "

no tools is need, then how can we manage that and program that ?

https://mariadb.org/  MariaDB is in essence MySQL from the original developers.  It uses the same file names and commands."

tks.

it seems that latest version can handle subqueries, this is good.

how about select distinct and cursor and loop ?
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 41722131
If you can do it in MySQL, it should work exactly the same in MariaDB.  It does not need any other tools... beside the ones you already use with MySQL.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:marrowyung
ID: 41722289
" It does not need any other tools..."

yes, I just learned that MariaDB is another branch of MysQL, right?

I use Toad for MySQL and this tools is free.

so this tools should be able to manage mariaDB, right?
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 41722839
That is correct.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 41724410
ok tks..so why there are diff kinds of MySQL ?

what good is  mariaDB ?
0
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 41724541
Why not?  Why are there different kinds of apples?  Some people don't like the fact that Oracle now owns MySQL.  They're afraid that Oracle will stop providing a Community version for free.  MariaDB has said that their's will always be Open Source and free.  They do have paid support if you want it.

MariaDB is just as good as MySQL and it is used for the same purposes.  If you look at the MariaDB web pages, you can see who is saying that they are using it.  https://mariadb.org/about/supporters/   A lot of people are probably using it without knowing it because their web hosting company is providing MariaDB rather than MySQL.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 41737070
sorry, on vocation for a week, no connection to the web at all.

"MariaDB has said that their's will always be Open Source and free.  They do have paid support if you want it."

ok, good answer. this mean this can make oracle buy one more... :):)

" A lot of people are probably using it without knowing it because their web hosting company is providing MariaDB rather than MySQL."

I am sorry, using it without knowing it? how come? you mean the user don't even know what DB the web site is connecting to it ?

ok, this product only means a DB supposed to be free forever.. but who knows ..
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 41737074
Why would they know?  MariaDB and MySQL act exactly the same.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 41737201
good ! I just don't understand what you are saying. so they just change the name and they are the same,

MariaDB has Windows server version ?
0
 
LVL 1

Author Closing Comment

by:marrowyung
ID: 41737202
well done and tks.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 41737204
For all basic operations, they act like they are identical.  You're welcome.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 41737217
and which part is not the same ?
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 41737222
You can get special, enterprise, and commercial versions of both of them for more advanced purposes.  You could go read the specs on their web sites.  They make it pretty clear.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 41738548
ok ok. got it sir.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question