Bugzilla using MS SQL server rather than mySQL
John Warren
Microsoft's SQL server (2000 or 2005) rather than using mySQL. I know
that our company would feel better running having the bug database
running on enterprise SQL server.
John Warren
Network Operations Administrator
Prudent Rx Inc.
Frank
I would have to wonder why one would want to do such a thing? MySQL has
the capabilities to be just about as enterprise as SQL Server. And
possibly for a cheaper price. If it is the "open-source, no support"
fear, you can easily pay for a support contract with mysql just like
paying for support with MSSQL and get very much the same level of
attention from either.
Check out this article - I found it enlightening -
http://www.tophosts.com/articles/003373.html
Regards,
Frank
Frank
I would have to wonder why one would want to do such a thing? MySQL has
Shankar Unni
> John Warren wrote:
>> Microsoft's SQL server (2000 or 2005) rather than using mySQL. I know
>
> the capabilities to be just about as enterprise as SQL Server.
That's not the issue at all. Cost of the one DB instance is often only a
minor consideration, and the feature set is almost inconsequential. Much
more important is the cost of administering it.
If I have several corporate MSSQL (or Oracle) databases, and a small
staff of experienced DBAs to administer them, it would be a whole lot
easier for me to add one more instance for them to administer, as
opposed to developing MySQL expertise in house or going off to hire a
MySQL administrator.
Even if it cost me $10000/year for the software and support for the DB,
that's a pittance compared to the cost and inconvenience of developing
or bringing in MySQL expertise into my organization.
Of course, beyond some point, I might ask myself why I'm ponying up so
much for MSSQL, but as an incremental buying decision, it's a slam dunk.
Benton, Kevin
> running on enterprise SQL server.
Hmmm - I don't understand. I hear you bringing up the "enterprise" when
discussing MySQL versus MS-SQL, but what I don't hear is what concerns
me. Is the real issue open-source? Bugzilla is open-source just like
MySQL. While I don't speak for others, I can tell you that we've been
using Bugzilla for years and have not had any issues with MySQL as a
back-end. Maintenance on the DB has been minimal at worst and nearly
non-existent at best (not that we haven't cared to maintain things).
BTW - our MySQL installation has had over 4 9's of uptime and it's not
just idle.
If the real argument is you would rather not have two database server
types installed, that's easier to digest. Currently, MS-SQL is not
supported by Bugzilla, though the source is out there and we could
always use help making it happen. The team recently added full support
for PostgreSQL and plans are in the works to add Oracle support.
By the way, MySQL runs just fine on Microsoft Windows Servers.
---
Kevin Benton
Perl/Bugzilla Developer/Administrator, Perforce SCM Administrator
AMD - ECSD Software Validation and Tools
The opinions stated in this communication do not necessarily reflect the
view of Advanced Micro Devices and have not been reviewed by management.
This communication may contain sensitive and/or confidential and/or
proprietary information. Distribution of such information is strictly
prohibited without prior consent of Advanced Micro Devices. This
communication is for the intended recipient(s) only. If you have
received this communication in error, please notify the sender, then
destroy any remaining copies of this communication.
eda...@spamcop.net
the original poster.
The reason my Department is interested in using MSSQL rather than MySQL
is completely political. I don't agree with the management position.
Personally, I run Linux at home and work with MySQL but I don't make
the decisions for our department.
Yep, it sucks. I would be interested in knowing if anyone has run
Bugzilla using MSSQL.
John Warren
You hit the nail right on the head. That along with the backup issues
are the two main reasons I'd like to have the database running on my
MS SQL server. For me the backup issue is the biggest reason and
currently the only way I've found to backup is to backup the hard
files while their open.
Even if we could use our MS SQL server for the database services
bugzilla would still be running on the linux system but connecting to
it's database across the wire. I have no reason nor do I want to run
bugzilla on a windows server. Our linux server is used to run
bugzilla, big brother, hylafax and mailman and I want to keep it that
way.
So I'll run mySQL until the day comes that it will work with MS SQL
but when that happens we'll move it in a heart beat.
John Warren
Network Operations Administrator
Prudent Rx Inc.
> _______________________________________________
> support-bugzilla mailing list
> support-...@lists.mozilla.org
> https://lists.mozilla.org/listinfo/support-bugzilla
> PLEASE put support-...@lists.mozilla.org in the To: field when
> you reply.
Benton, Kevin
> are the two main reasons I'd like to have the database running on my
> MS SQL server. For me the backup issue is the biggest reason and
> currently the only way I've found to backup is to backup the hard
> files while their open.
Are you referring to backups of MySQL or MS-SQL? MySQL uses a few
methods that allow for production backups. They are mysqldump,
mysqlhotcopy, and MySQL server replication.
Mysqldump takes a client view of a database/table/server and writes out
data in a format you tell it. By default, it writes standard SQL. To
re-load data from a mysqldump, simply mysql -u <mysqldump.sql.
mysqldump can be run from any host by a user with adequate permissions.
mysqlhotcopy must be run on the mysql server host and interacts with the
server to copy the live data by locking tables prior to copying them,
then releasing them when done.
MySQL server replication provides the ability for a single master server
to talk to any (reasonable) number of slaves that get every update that
the master gets. That makes the slave a mirror of the master. In the
event that the master fails, the slave can be made the master.
FYI - from this end, once MySQL was set up, maintenance of it has become
nearly a non-issue (<.1% of my time in the past two years has been spent
on MySQL server maintenance across seven production Bugzilla
installations). For that, you may want to consider hiring a Bugzilla
consultant that already knows MySQL. That would be a lot cheaper than
1) waiting for Bugzilla to become MS-SQL compatible, and 2) hiring an
individual to maintain your Bugzilla installation in-house.
Richard Broersma Jr
> > are the two main reasons I'd like to have the database running on my
> > MS SQL server. For me the backup issue is the biggest reason and
> > currently the only way I've found to backup is to backup the hard
> > files while their open.
>
> Are you referring to backups of MySQL or MS-SQL? MySQL uses a few
> methods that allow for production backups. They are mysqldump,
> mysqlhotcopy, and MySQL server replication.
I would also imagine that the Bugzilla community would be more than willing to accept a patch from
MS-SQL DBA/developers community, if they willing "scratched their own itch."
I imagine that this is what occurred when Bugzilla added to PostgreSQL as a use-able RDMS.
Regards,
Richard Broersma Jr.
Robert Long
I am a little confused about the "software and support for the MySQL DB"
part.
I am just a blackbox QA guy, not a developer or DBA and it took me about 10
min of investment in the mysqldump man page.
About another 1/2 hour to set up the automated backups of the DB and about 3
hours to test restore procedures.
The investment turned out to be rather small.
Max Kanat-Alexander
> I would also imagine that the Bugzilla community would be more than
> willing to accept a patch from MS-SQL DBA/developers community, if
> they willing "scratched their own itch."
We would of course love it if somebody would help us make Bugzilla
support MS-SQL. Here's the bug for it:
https://bugzilla.mozilla.org/show_bug.cgi?id=285122
Anybody who has any questions about working on MS-SQL support should
get in touch with me, either by email or on IRC. (I'm "mkanat" in
#mozwebtools on irc.mozilla.org.)
-Max
--
http://www.everythingsolved.com/
Everything Solved: Competent, Friendly Bugzilla and Linux Services