Mailing List Archive: Table management

Table management

emailgrant at gmail

Sep 24, 2016, 7:25 PM

Post #1 of 7 (1724 views)

How do you guys manage your mysql tables?

I dropped a table column via the mysql command line interface
recently, but subsequently exporting that table to .txt file in IC
showed that the column was still there. Making changes to a
dbconf/mysql/*.mysql file or .txt file, deleting the associated .sql
file, and restarting IC to import a table can be a very slow process
which locks out all IC users in the meantime. I tried using:

Database tablename AutoCommit 0

to speed that up, and it worked, but then the table didn't work.

Is there a best way to do this kind of stuff when you're using IC?

- Grant

_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

Re: Table management [ In reply to ]

andrew at pullingshots

Sep 25, 2016, 1:39 PM

Post #2 of 7 (1708 views)

On 25 Sep 2016 04:25, Grant <emailgrant@gmail.com> wrote:
>
> How do you guys manage your mysql tables?

Hi Grant,

We use the DatabaseAuto directive which I think should solve your issues.

http://interchange.rtfm.info/icdocs/config/DatabaseAuto.html

>
> I dropped a table column via the mysql command line interface
> recently, but subsequently exporting that table to .txt file in IC
> showed that the column was still there.Â Making changes to a
> dbconf/mysql/*.mysql file or .txt file, deleting the associated .sql
> file, and restarting IC to import a table can be a very slow process
> which locks out all IC users in the meantime.Â I tried using:
>
> Database tablename AutoCommit 0
>
> to speed that up, and it worked, but then the table didn't work.
>
> Is there a best way to do this kind of stuff when you're using IC?
>
> - Grant
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

Re: Table management [ In reply to ]

emailgrant at gmail

Sep 28, 2016, 3:11 AM

Post #3 of 7 (1697 views)

>> How do you guys manage your mysql tables?
>
> Hi Grant,
>
> We use the DatabaseAuto directive which I think should solve your issues.
>
> http://interchange.rtfm.info/icdocs/config/DatabaseAuto.html

Maybe the key there is the NoImport statement which DatabaseAuto puts
into effect for each table? It sounds like NoImport moves table
management out of IC.

Also Andrew, I took a look at pullingshots.ca:

"I have been successfully running Interchange 5 using a stack of Plack
+ Nginx in production since February, 2016 on a busy site"

Your config is really simple. Has anyone else tried this? Any drawbacks?

- Grant

>> I dropped a table column via the mysql command line interface
>> recently, but subsequently exporting that table to .txt file in IC
>> showed that the column was still there. Making changes to a
>> dbconf/mysql/*.mysql file or .txt file, deleting the associated .sql
>> file, and restarting IC to import a table can be a very slow process
>> which locks out all IC users in the meantime. I tried using:
>>
>> Database tablename AutoCommit 0
>>
>> to speed that up, and it worked, but then the table didn't work.
>>
>> Is there a best way to do this kind of stuff when you're using IC?

_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

Re: Table management [ In reply to ]

jlavin at endpoint

Sep 28, 2016, 8:24 AM

Post #4 of 7 (1697 views)

Quoting Grant (emailgrant@gmail.com):
> Also Andrew, I took a look at pullingshots.ca:
>
> "I have been successfully running Interchange 5 using a stack of Plack
> + Nginx in production since February, 2016 on a busy site"
>
> Your config is really simple. Has anyone else tried this? Any drawbacks?

https://github.com/jdigory/interchange-extras/tree/master/plack

:-D

I haven't done it in production, but others have.

--
Josh Lavin
End Point Corporation

_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

Re: Table management [ In reply to ]

emailgrant at gmail

Sep 29, 2016, 3:25 AM

Post #5 of 7 (1693 views)

>> Also Andrew, I took a look at pullingshots.ca:
>>
>> "I have been successfully running Interchange 5 using a stack of Plack
>> + Nginx in production since February, 2016 on a busy site"
>>
>> Your config is really simple. Has anyone else tried this? Any drawbacks?
>
> https://github.com/jdigory/interchange-extras/tree/master/plack
>
> :-D
>
> I haven't done it in production, but others have.

Ah OK, it sounds like plack is slow.

- Grant

_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

Re: Table management [ In reply to ]

jlavin at endpoint

Sep 29, 2016, 8:14 AM

Post #6 of 7 (1693 views)

Quoting Grant (emailgrant@gmail.com):
> >> Also Andrew, I took a look at pullingshots.ca:
> >>
> >> "I have been successfully running Interchange 5 using a stack of Plack
> >> + Nginx in production since February, 2016 on a busy site"
> >>
> >> Your config is really simple. Has anyone else tried this? Any drawbacks?
> >
> > https://github.com/jdigory/interchange-extras/tree/master/plack
> >
> > :-D
> >
> > I haven't done it in production, but others have.
>
> Ah OK, it sounds like plack is slow.

To clarify, if you run Plack alone with my little example, then yes. But
if you use Nginx in front to handle the static resources (images, etc),
then I don't think it's slow at all, but others who use it in production
can speak to that.

--
Josh Lavin
End Point Corporation

_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

Re: Table management [ In reply to ]

andrew at pullingshots

Sep 29, 2016, 1:39 PM

Post #7 of 7 (1693 views)

On 29 Sep 2016 17:14, Josh Lavin <jlavin@endpoint.com> wrote:
>
> Quoting Grant (emailgrant@gmail.com):
> > >> Also Andrew, I took a look at pullingshots.ca:
> > >>
> > >> "I have been successfully running Interchange 5 using a stack of Plack
> > >> + Nginx in production since February, 2016 on a busy site"
> > >>
> > >> Your config is really simple.Â Has anyone else tried this?Â Any drawbacks?
> > >
> > > https://github.com/jdigory/interchange-extras/tree/master/plack
> > >
> > > :-D
> > >
> > > I haven't done it in production, but others have.
> >
> > Ah OK, it sounds like plack is slow.
>
> To clarify, if you run Plack alone with my little example, then yes. But
> if you use Nginx in front to handle the static resources (images, etc),
> then I don't think it's slow at all, but others who use it in production
> can speak to that.

We have been using Plack+Starman behind nginx which is very, very fast in our experience.

You can use nginx to serve static resources and also do caching.

Andrew

>
> --
> Josh Lavin
> End Point Corporation
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users