-
And people said it wasn't possible...
So, the other day I decided to actually do something with the CABAL server for a change (I haven't touched the official server files for quite a while). I was really bored, so I thought I'd take a look at the DB, in particular. I've always had this feeling that I could get MySQL working if I used the ODBC drivers, but I never tried. Everyone kept saying it wasn't possible, but I never quite believed this... So, I tried, and I succeeded :) It was simply a matter of installing mysql-server and mysql-connector-odbc on the CentOS machine, setting up a mysql account for the server, and manually changing a few configuration files. I set the CabalAccount SQL setup to use my newly-installed MySQL server, added an empty database, called it "ACCOUNT", then started up the CABAL server. Sure enough, I started getting errors about non-existant stored procedures in the GlobalDBAgent logs :) I then added some hardcoded versions of these stored procedures in the ACCOUNT DB that merely returned the required information (account number, login status, etc). Once this was done, I managed to log in and get to the character screen :D From this point on, CABAL was only using the GameDB database, so connecting to the world and everything else was working as it should be. Since then, I've been manually converting/rewriting and documenting the necessary stored procedures and tables from the MSSQL ACCOUNT DB. I've learned quite a bit, so far, and I've been making sure to comment all the code to make it easier for others to edit :P
Anyways, getting to the point, now. What do you guys think about using MySQL with CABAL instead of MSSQL? Would you switch your existing databases to MySQL? MySQL offers the benefit of being able to run on Linux, so MySQL DB's would completely rid the need of VMWare/Windows. However, MSSQL is a great piece of software. I'm waiting to here what you think :)
P.S. If you vote, please be so kind as to leave a comment. Thanks.
-
Re: And people said it wasn't possible...
Congrats... But, I rather prefer MSSQL. Dunno, just an inception in my mind. MSSQL is that piece of awsome software, which you mentioned. And I think nothing can compare to it, it's Microsoft's work.
But, your succes, can prove that nothing is impossible. And for running for low resources, it's the best option.
What i've wrote here, it's just my opinion.
Thanks, and have a nice day.
-
Re: And people said it wasn't possible...
I do consider MSSQL more powerful but MySQL is good enough for what we need. It's better make our software work with open source database solutions.
-
Re: And people said it wasn't possible...
wel i normaly have both mysql and mssql on the same machine but i lake the idea of geting rid om ms (prefer linux) to run a cabal server
great work tho Yamachi
-
Re: And people said it wasn't possible...
Quote:
Originally Posted by
cypher
I do consider MSSQL more powerful but MySQL is good enough for what we need. It's better make our software work with open source database solutions.
/agree, unique OS for Cabal pserver is powerful.
-
Re: And people said it wasn't possible...
Totally agree with LostSpirit and cypher. And congratz for ur amazing idea/job.
-
Re: And people said it wasn't possible...
mysql is stable, 90% of servers use it, as do we.
-
Re: And people said it wasn't possible...
on my server i use mssql and i wld advise u(yama) focus on fixing the broken procs there, rather than transcoding it all to mysql for ease of use ... seems pointless to me, i use mysql for website only, but procs work faster in mssql from what i know :P but i may be wrong and some users wld maybe like a tdp release that doesn't imply using 2 hosts :D but that's only my opinion :)
-
Re: And people said it wasn't possible...
I think MySQL would be faster.. I'm not sure, but ofc, MySQL should have its advantages :) Good job macaco.
-
Re: And people said it wasn't possible...
Quote:
Originally Posted by
x30unlimited
on my server i use mssql and i wld advise u(yama) focus on fixing the broken procs there, rather than transcoding it all to mysql for ease of use ... seems pointless to me, i use mysql for website only, but procs work faster in mssql from what i know :P but i may be wrong and some users wld maybe like a tdp release that doesn't imply using 2 hosts :D but that's only my opinion :)
Don't worry, x. Once I've converted these DB's, I'll pretty much know the SQL DB inside and out. Ofcourse, this means I'll be fixing anything I think is broken. I'll also trim down the DB's by removing anything that's not needed. I'll probably add a lot of comments, too. We'll see.
-
Re: And people said it wasn't possible...
Quote:
Originally Posted by
Yamachi
Don't worry, x. Once I've converted these DB's, I'll pretty much know the SQL DB inside and out. Ofcourse, this means I'll be fixing anything I think is broken. I'll also trim down the DB's by removing anything that's not needed. I'll probably add a lot of comments, too. We'll see.
would be nice and a reason to switch my server to mysql only :thumbup:
-
Re: And people said it wasn't possible...
-
Re: And people said it wasn't possible...
-
Re: And people said it wasn't possible...
-
Re: And people said it wasn't possible...
I think,moving to MYSQL the whole procedures would be a tough work.
I don't think that the advantages that MYSQL provides are worthing this effort.
And ofcourse most of people are afriad of "something *NEW* " which can lead to a lot of new bugs.
-
Re: And people said it wasn't possible...
The stored procedures actually aren't that hard to convert. I've been manually converting them over the past few days, and currently have login, character creation, world entry, etc all fully working (with lots of comments in the SP's, might I add). I have noticed that the server responds much quicker than it does with MSSQL, but that's obviously going to be the case seeing as the MySQL server is local to the CABAL server. TBH, I think it's mostly going to come down to personal preference.
-
Re: And people said it wasn't possible...
However,there is still a lot of work to do.
I agree it's much faster,but i think the environment it's more complicated than the mssql one.
Most of people are not used with mysql and the bugs may appear...
So I guess it's a personal choice
-
Re: And people said it wasn't possible...
There's really not that much difference between the 2 :P Also, MySQL is used a LOT with most server emulators, so people will be familiar with it.
-
Re: And people said it wasn't possible...
Both got their pros and cons but I'd probably go for MySQL :):.
-
Re: And people said it wasn't possible...
Id go for mysql too i guess. But to complete the information on this new journey would take like 1-2 months of continues running server for the owner to realize if its stable or not. This sure to help alot of new cabal admins when the development is fully finished
-
Re: And people said it wasn't possible...
I would use MySQL without a second thought. A while back I posted about possibilities to merge to an oracle DB but this will be great too. On the reboot of my server next month I can then give more resources to the actual server as VBox in CentOs easily takes up ram worth a channel :)
Thanks certainly are in order!
-
Re: And people said it wasn't possible...
RoFl i prefer MSSQL
Cheers for it =D MSSQL is powerful
-
Re: And people said it wasn't possible...
Definitely MySQL is better and more lightweight. The fact other Linux hosting companies give out offloaded mysql when you order a vps from them gives you more flexibility in hosting a server. May I know why its not mysql from the start? As i read, mysql has stored procedures too. Dont know about the linked server but we could remove that too right. Hope this becomes successfull. Will support this fully! Cheers!
-
Re: And people said it wasn't possible...
I like the idea of converting it to MySql. Its easier for me tho.
..easier for me to understand mysql so to speak.
-
Re: And people said it wasn't possible...
i like the idea aswell,
for me mysql runs faster and loads faster imo...
-
Re: And people said it wasn't possible...
Why do you think so.
Because doing so is not easy.
Because the foundation of the system will be upgraded all.
Which is difficult to do. But do not use that do not.
My motto, "do / do not / or did not do. ".
But if it can really very good.
It will save you. A lot of resources.
We cheer.
-
Re: And people said it wasn't possible...
-
Re: And people said it wasn't possible...
I use MySql a lot. :thumbup:
The question should be wtf exactly is MSSql?
-
Re: And people said it wasn't possible...
i would use MySql but i dont really know the diffrence between the two ive been using guides to do most of my work so if there is a guide on how to setup both then i would choose the faster one
-
Re: And people said it wasn't possible...
MySQL For Appserv So good
-
Re: And people said it wasn't possible...
As stated by everyone else, there are pros and cons for both SQL's but I'll go for MSSQL anytime of the day. Less ram consumption compared to MYSQL. MSSQL is more on business related applications unlike MYSQL, which is open-sourced, which means more compatibility.
-
Re: And people said it wasn't possible...
-
Re: And people said it wasn't possible...
Quote:
Originally Posted by
Kero Yugi
Guys will you just talk or u will do it.
I'm sure u can. I mean the professionals :D
I'm already doing it... I stated that at the very beginning of this thread. I haven't been working on it recently, though, as I tend to switch from project to project.
-
Re: And people said it wasn't possible...
-
Re: And people said it wasn't possible...
Bugs are to be solved, i`m sure mysql will work faster than mssql just coz you can place it on a linux system.
I am waiting from a long time this to happen, so keep up the good work Yamachi ... and share the stuff please :)
-
Re: And people said it wasn't possible...
Offtopic:
Emulator for cabal will surely fire the trigger of mass updates :P
On Topic:
Really appreciated this Yam, Id like this to be implemented and released to public ^^
-
Re: And people said it wasn't possible...
I like MSSQL as well because its a powerful database server, However having MySQL eliminates the need for a windows machine entirely which is more convenient I think. A BIG thanks to all of TDP for the superb job they are doing, keep up the excellent work! :wink:
-
Re: And people said it wasn't possible...
mysql does a lot more queries then mssql.
But can you make the site work on mysql to?
-
Re: And people said it wasn't possible...
how would i set up the my sql same as MSSql?
-
Re: And people said it wasn't possible...
Congratulations on your initiative, mysql forever. This is only my opinion.
-
Re: And people said it wasn't possible...
Quote:
Originally Posted by
MecBew
Congratulations on your initiative, mysql forever. This is only my opinion.
Oracle has the best database engines. MySQL and MSSQL are toys in front of Oracle technology so please...
-
Re: And people said it wasn't possible...
Quote:
Originally Posted by
cypher
Oracle has the best database engines. MySQL and MSSQL are toys in front of Oracle technology so please...
Oh, don't even go there.
-
Re: And people said it wasn't possible...
Quote:
Originally Posted by
cypher
Oracle has the best database engines. MySQL and MSSQL are toys in front of Oracle technology so please...
I do not disagree with you friend. But here the post is related to the "cabal" correct? Those who voted that mysql was perhaps prefer the ease of use? Can not say much because I never used oracle. But what counts is the bigger part is not it?
-
Re: And people said it wasn't possible...
Being able to put MySQL and the server in the same machine/system would save much RAM/CPU, so I would like you to take the revenge, it would be a great change to Cabal scene.
-
Re: And people said it wasn't possible...
myslq is a bit faster and easy to ues but mssql is more more more secure.people like mysql more than mssql because is free and easy to use but the best database choice is mssql.
-
Re: And people said it wasn't possible...
Quote:
Originally Posted by
traxes
myslq is a bit faster and easy to ues but mssql is more more more secure.people like mysql more than mssql because is free and easy to use but the best database choice is mssql.
I think you'll find that MSSQL is faster.
-
Re: And people said it wasn't possible...
i used My Sql to setup a RO2 server in the past and it was cool there was no lag or anything if we could have cabal on a windows platform like i did with Ro2 it would be nice i really dont see how but would be nice
-
Re: And people said it wasn't possible...
One big question.Is the minerva going to use mysql?
-
Re: And people said it wasn't possible...
Minerva is written in such a way that it doesn't require a specific database type; Plugins can be written to support any format.
-
Re: And people said it wasn't possible...
Will there be guides on how to setup Minerva with My SQL and MSSQL i really would like to knwo the difrence between the 2
-
Re: And people said it wasn't possible...
Well there are differences:
1. The price. One of them is free the other one you need to pay for it (unless your happy with the limited crappy version).
2. The syntax is a bit changed but you can do more powerful queries.
3. The processing speed is higher (not as high as Oracle but higher than MySQL)
4. You can use the SQL Agent to perform various tasks like scheduled tasks or maintenance tasks.
5. MSSQL > MySQL . End of story.
-
Re: And people said it wasn't possible...
Quote:
Originally Posted by
cypher
Well there are differences:
1. The price. One of them is free the other one you need to pay for it (unless your happy with the limited crappy version).
2. The syntax is a bit changed but you can do more powerful queries.
3. The processing speed is higher (not as high as Oracle but higher than MySQL)
4. You can use the SQL Agent to perform various tasks like scheduled tasks or maintenance tasks.
5. MSSQL > MySQL . End of story.
Thank you for answering cypher :thumbup:
-
Re: And people said it wasn't possible...
I have a little question.. Minerva still require Centos or can be run on a ubuntu machine??
Congratz ;D
-
Re: And people said it wasn't possible...
I'd so use MySQL over MSSQL, for one simple reason. I'm a web developer, and use MySQL all the time to store data.. but I don't have the MSSQL DLL so I get constant errors and can't connect to MSSQL! Only MySQL! So that would help me a lot in the website part.
-
Re: And people said it wasn't possible...
no one can compare mssql with mysql.
It like comparing windos 95 with 7 =))
-
Re: And people said it wasn't possible...
@PopaAndrei you wrong so much,everyone have his own opinion even if MSSQL its stronger then MySql.Not everyone is using MSSQL and not everyone is using MYSQL because some peoples don`t need a strong database,maybe they use MySql for simple things and viceversa.And about windows its same with what i wrote above.
-
Re: And people said it wasn't possible...
why do you like to come and say a thing and in fact you have no clue what you are talking about?
I worked with both of them and for example at mssql are a lot more security problems then at mysql.
-
Re: And people said it wasn't possible...
Quote:
Originally Posted by
Popa Andrei
... at mssql are a lot more security problems then at mysql.
I'd love to see you prove that point.
-
Re: And people said it wasn't possible...
so i get banned for releasing hacks to break cabal toolz? neah ;)
-
Re: And people said it wasn't possible...
Instead of bullcraping this is more secure than this, bloody proove it. MSSQL is faster than MYSQL, and I'd always use MSSQL, even if MYSQL does have a really smaller load, I'd still use MSSQL.
-
Re: And people said it wasn't possible...
Well in my opinion I use a lot of time mysql, and I have some experience in mssql, for web apps it's more fun mysql, mssql sucks in that, and for who thinks that mssql its less secure mmmm it's a little bit more complicated to hack a mssql database, the mysql can be hacked in a matter of minutes of course depends on the experience, for performance and consolidation of cabal my vote is for mysql.
-
Re: And people said it wasn't possible...
Yamachi so when We would see the port of mysql for Cabal :thumbup1:
-
Re: And people said it wasn't possible...
Sadly Yamachi has left us for an undetermined time. Please don't reply to this.
-
Re: And people said it wasn't possible...
@cypher, He will be back, i know he will.
-
Re: And people said it wasn't possible...
..well for me, i use MySQL for my server It suits very well :)
-
Re: And people said it wasn't possible...
Quote:
Originally Posted by
xDefused
..well for me, i use MySQL for my server It suits very well :)
Care to share?
From what I saw of Yamachi's work it shouldn't be too hard to port to MySQL. A few Stored Procedures need writing but it works.
-
Re: And people said it wasn't possible...
Quote:
Originally Posted by
chumpywumpy
Care to share?
From what I saw of Yamachi's work it shouldn't be too hard to port to MySQL. A few Stored Procedures need writing but it works.
Stored procedures and some SQL queries, such as "SELECT TOP", because MySQL doesn't support that.
I managed with ODBC MySQL drivers connect, and i can show logs. Here: http://pastebin.com/xxAmQe5F
As i can see, we have query: "SELECT TOP 3 UserCount FROM LOG_NATION ORDER BY LOGTIME DESC, Nation" and correct syntax for MySQL would be: "SELECT UserCount FROM LOG_NATION ORDER BY LOGTIME DESC, Nation LIMIT 3"
Dunno, if we can change that query or give somehow support for "SELECT TOP".
-
Re: And people said it wasn't possible...
The queries are all in plain text in the server binaries so you could hex them. They are pretty tight on space though so you will probably have to look at relocating the strings and change all of the pointers that reference the old location to the new one. Unfortunately my hexing skills are ancient and I have only done this on Windows binaries in the past. The string you are looking for is at A7E18.
Tricky but not impossible.
-
Re: And people said it wasn't possible...
anyone interested in this idea? It would be great if we could make this happen so we only need 1 VM for both the server and DB. If there is anyone who wants to work on this with me, please send me a message or reply to this thread.
-
Re: And people said it wasn't possible...
Quote:
Originally Posted by
AbS
anyone interested in this idea? It would be great if we could make this happen so we only need 1 VM for both the server and DB. If there is anyone who wants to work on this with me, please send me a message or reply to this thread.
There's no need for this anymore: https://www.microsoft.com/en-us/sql-...ql-server-2017 & https://docs.microsoft.com/en-us/sql...-setup-red-hat