Author Topic: Separating asterisk and mysql from the core  (Read 4768 times)

posterberg

  • Veteran
  • ***
  • Posts: 82
    • View Profile
Separating asterisk and mysql from the core
« on: May 13, 2007, 04:28:59 pm »
Is there any way to do this?

I already have a really heavy machine running as a MySQL server in my network at home, I also already have an Asterisk server running that is properly configured.

I would make perfect sense to use those instead of heavy that extra load running on my LinuxMCE core.

Have anyone done this before?

Main concern is to move MySQL. Is there a single point to change where LinuxMCE looks for the db or would I have to change 100 different config files?

/p

sharlee_angelo

  • Guru
  • ****
  • Posts: 316
    • View Profile
Re: Separating asterisk and mysql from the core
« Reply #1 on: May 14, 2007, 12:41:07 pm »
you can't do this because mysql and asterisk are linked with linuxmce.
Read the F****** Logs!!!

posterberg

  • Veteran
  • ***
  • Posts: 82
    • View Profile
Re: Separating asterisk and mysql from the core
« Reply #2 on: May 14, 2007, 03:19:35 pm »
Linked? How's that?

Doesn't LinuxMCE talk to the database via a network socket using standard SQL statements?

kir

  • Guru
  • ****
  • Posts: 183
    • View Profile
Re: Separating asterisk and mysql from the core
« Reply #3 on: May 17, 2007, 03:03:38 pm »
Not sure, if this will work for all the pieces of LinuxMCE (it should, if all pieces are using the same config), but here is how to move the LinuxMCE MySQL DB to other host (from host1 which is Core to host2 which is your heavy machine): the DB that is used by LinuxMCE is specified in /etc/pluto.conf, so you can move DB and reconfigure LinuxMCE:

0) stop the inuxMCE if it is running
1) on host1 backup database 'pluto_main'
2) on host1 backup configuration file /etc/pluto.conf
3) copy backup of 'pluto_main' DB to host2 and restore DB there
4) edit the /etc/pluto.conf to change the values of MySqlHost, and username/password if they are different; verify that you can connect to DB on host2 it from host1
5) stop the mysql server on host1
6) start LinuxMCE and see if it still works

note that if you have extra M/D (media directors), you probably need to change their configuration file also

Don't know about Asterisk..

posterberg

  • Veteran
  • ***
  • Posts: 82
    • View Profile
Re: Separating asterisk and mysql from the core
« Reply #4 on: December 20, 2007, 11:50:30 am »
Better late than never... Thanks a lot!

Do you possibly know if myth's data base is contained with in the pluto db and if changing pluto.conf is sufficient for having myth redirected as well?

I can probably find out of that myself. I've play quite some with myth...

Again, thanks a lot. I would love to be able to shut down mysql on my core....

Matthew

  • Douchebag
  • Addicted
  • *
  • Posts: 567
    • View Profile
Re: Separating asterisk and mysql from the core
« Reply #5 on: December 20, 2007, 05:27:12 pm »
Better late than never... Thanks a lot!

Do you possibly know if myth's data base is contained with in the pluto db and if changing pluto.conf is sufficient for having myth redirected as well?

I can probably find out of that myself. I've play quite some with myth...

Again, thanks a lot. I would love to be able to shut down mysql on my core....

Have you figured out how to factor LMCE's Asterisk to a separate network host?

Would you update the wiki with some instructions for any of these factoring tasks? Even if you just identify all the dependency points on the DB, that would be very useful in the wiki.

For people with an existing DB (or Asterisk or MythTV), factoring those servers out of the Core host can reduce the HW requirements for the Core, or just improve performance of a cheaper existing Core.

posterberg

  • Veteran
  • ***
  • Posts: 82
    • View Profile
Re: Separating asterisk and mysql from the core
« Reply #6 on: December 20, 2007, 06:49:07 pm »
I'll pick up that task as soon as I have had some time to test things...

Thanks for the suggestion!