Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 150
  • Last Modified:

MySQL 5.6 or MariaDB

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
marrowyung
Asked:
marrowyung
  • 8
  • 7
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
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
 
marrowyungSenior Technical architecture (Data)Author Commented:
"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
 
Dave BaldwinFixer of ProblemsCommented:
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
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
marrowyungSenior Technical architecture (Data)Author Commented:
" 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
 
Dave BaldwinFixer of ProblemsCommented:
That is correct.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
ok tks..so why there are diff kinds of MySQL ?

what good is  mariaDB ?
0
 
Dave BaldwinFixer of ProblemsCommented:
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
 
marrowyungSenior Technical architecture (Data)Author Commented:
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
 
Dave BaldwinFixer of ProblemsCommented:
Why would they know?  MariaDB and MySQL act exactly the same.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
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
 
marrowyungSenior Technical architecture (Data)Author Commented:
well done and tks.
0
 
Dave BaldwinFixer of ProblemsCommented:
For all basic operations, they act like they are identical.  You're welcome.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
and which part is not the same ?
0
 
Dave BaldwinFixer of ProblemsCommented:
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
 
marrowyungSenior Technical architecture (Data)Author Commented:
ok ok. got it sir.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

  • 8
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now