Solved

MySQL 5.6 or MariaDB

Posted on 2016-07-20
15
80 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
 
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

This article describes some very basic things about SQL Server filegroups.
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
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…

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now