Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 127
  • 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
 
marrowyungAuthor 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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
marrowyungAuthor 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
 
marrowyungAuthor 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
 
marrowyungAuthor 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
 
marrowyungAuthor 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
 
marrowyungAuthor Commented:
well done and tks.
0
 
Dave BaldwinFixer of ProblemsCommented:
For all basic operations, they act like they are identical.  You're welcome.
0
 
marrowyungAuthor 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
 
marrowyungAuthor Commented:
ok ok. got it sir.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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