[Labs-l] Sql server

[Petr Bena]

I believe that people will miss a root on this server. So I think that it
would make sense to make it possible to request a separate sql server
process listening on different port for projects where it is needed with
full access. So that for instance we can have own instance of mysql for
deployment-prep with root so that we can easily set up whole project and
all db's + keep functionality of maintenance scripts we have (addwiki
require permission to create a new database). Also database names must be
identical to production, this will be required by many projects, so I think
it would be really nice to have more mysql servers running there. What do
you think about it?

On Fri, Jan 20, 2012 at 1:19 PM, Petr Bena <benapetr at gmail.com> wrote:

> That is nice, let me know what is server ip, and where the config files
> are stored in puppet once it's up, also technical specs (ram, storage,
> cpu's etc) would be cool :) (it's not easy to optimize configs when I don't
> know the tech specs).
>
> Also open port for nrpe from labs so that I can insert it to nagios please.
>
> Once you create an account for us and explain how is it going to be
> managed, I can start moving some big db's there. If it's going to take 3
> weeks for this to start (I suppose there is no backup system for now) can
> you create a new project deployment-prepbackups please so that I can backup
> all stuff from deployment there?
>
> Thank you
>
>
> On Fri, Jan 20, 2012 at 2:00 AM, Ryan Lane <rlane32 at gmail.com> wrote:
>
>> Indeed.
>>
>> We have hardware we can use for it. I think we should at least start
>> by adding databases manually for now. It'll still be a while, though.
>> 2-3 weeks, I'd guess.
>>
>> - Ryan
>>
>> On Thu, Jan 19, 2012 at 7:40 AM, John Du Hart <compwhizii at gmail.com>
>> wrote:
>> >
>> >
>> > On Thu, Jan 19, 2012 at 10:08 AM, Petr Bena <benapetr at gmail.com> wrote:
>> >>
>> >> Hi Ryan,
>> >>
>> >> can we get an update related to setup of dedicated sql server?
>> >>
>> >> _______________________________________________
>> >> Labs-l mailing list
>> >> Labs-l at lists.wikimedia.org
>> >> https://lists.wikimedia.org/mailman/listinfo/labs-l
>> >>
>> >
>> > I'm pretty sure Ryan's focus has been on SOPA-related activities these
>> last
>> > few days, so I don't think there's anything new to report.
>> >
>> > --
>> > John
>> >
>> > _______________________________________________
>> > Labs-l mailing list
>> > Labs-l at lists.wikimedia.org
>> > https://lists.wikimedia.org/mailman/listinfo/labs-l
>> >
>>
>> _______________________________________________
>> Labs-l mailing list
>> Labs-l at lists.wikimedia.org
>> https://lists.wikimedia.org/mailman/listinfo/labs-l
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.wikimedia.org/pipermail/labs-l/attachments/20120124/0cd22491/attachment.html>