Need help with MySQL(Windows) Federated plugin

simcher

Supremacy Member
Joined
May 6, 2000
Messages
6,917
Reaction score
6
Hi guys,
I just setup MySQL 5.6.13 community server, and I realised that Federated is not supported even after i added federated into the my-default.ini found in C:\Program Files\MySQL\MySQL Server 5.6\

How can I enable Federated plugin? Been trying, but can't seems to get it working.

Quote from my-default.ini
# For advice on how to change settings please see
# MySQL :: MySQL 5.6 Reference Manual :: 5.1.2 Server Configuration Defaults
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]
federated

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....


# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

Screenshot from MySQL Workbench
Federated.jpg
 

Rock-kun

Senior Member
Joined
Sep 10, 2007
Messages
991
Reaction score
1
on Linux I run

Code:
./mysqld --federated

to enable the Federated storage engine.

Discard the GUI and run MySQL in command line mode if you have to.
 
Important Forum Advisory Note
This forum is moderated by volunteer moderators who will react only to members' feedback on posts. Moderators are not employees or representatives of HWZ Forums. Forum members and moderators are responsible for their own posts. Please refer to our Community Guidelines and Standards and Terms and Conditions for more information.
Top