Solved

MySQL 5.6 or MariaDB

Posted on 2016-07-20
15
73 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 82

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 82

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 82

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 82

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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
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 82

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 82

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 82

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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
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…

746 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

18 Experts available now in Live!

Get 1:1 Help Now