Results 1 to 4 of 4

Thread: MySQL federated engine support in 11.2

  1. #1
    viorel_serbu NNTP User

    Default MySQL federated engine support in 11.2

    Hi All

    Can someone answer if MySQL 5.1.36, included in 11.2 is distributed with federated engine support enabled?

    thx

  2. #2
    Join Date
    Jun 2008
    Location
    Groningen, Netherlands
    Posts
    19,652
    Blog Entries
    14

    Default Re: MySQL federated engine support in 11.2

    If you tell me how to check, I have 11.2, I have MySQL 5.1.36 running smoothly with a couple of demo sites/databases on my laptop.
    ° Appreciate my reply? Click the star and let me know why.

    ° Perfection is not gonna happen. No way.

    https://en.opensuse.org/openSUSE:Board#Members
    http://en.opensuse.org/User:Knurpht
    http://nl.opensuse.org/Gebruiker:Knurpht

  3. #3
    viorel_serbu NNTP User

    Default Re: MySQL federated engine support in 11.2

    Hi Knurpht

    Just need to open a mysql console connected to one of your running services and execute "show engines" command.

    If federated database is supported by the service you should see on the list of supported engines something like

    "FEDERATED","YES","Federated MySQL storage engine"
    or
    "FEDERATED","DISABLED","Federated MySQL storage engine"

    Depending if you have the "federated" option (or not) under [mysqld] section in your my.cnf file

    If it's not supported then
    "FEDERATED","NO","Federated MySQL storage engine"

    With the 5.0.67 included in 11.1 the support is not enabled in the binaries distributed (see this post MySQL and Federated Storage Engine - openSUSE Forums). Hope in 11.2 with the new binaries the support to be enabled.

    thx

  4. #4
    viorel_serbu NNTP User

    Default Re: MySQL federated engine support in 11.2

    Well it does.

    Dont panic if you see
    "FEDERATED","NO","Federated MySQL storage engine"
    when you execute show engines command.

    That means you start the mysqld[_multi] either without --federated option, or you didnt specify the federated option under [mysqld[x]] section in my.conf.

    If you add this option you shall see
    "FEDERATED","YES","Federated MySQL storage engine"
    ... and it really works!

    enjoy

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •