Stack Overflow
Stack Overflow

Questions tagged [mysql-fabric]

MySQL Fabric is a system for managing a farm of MySQL servers.

MySQL Fabric is a system for managing a farm of MySQL servers.

MySQL Fabric is part of MySQL Utilities

Important Links:

Reference Manual.

Download Page.

13 questions
7
votes
0 answers

MySQL fabric server error when adding group

Fabric : 10.101.90.5 Master : 10.101.90.6 Slave: 10.101.90.7 I add the slave to the group and I get the below error: mysqlfabric group add mygroup 10.101.90.7 Password for admin: Fabric UUID: 5calable-a007-feed-food-cab3fe13249e Time-to-live:…
KKL Michael
  • 795
  • 1
  • 13
  • 31
2
votes
1 answer

I can't connect to mysqlfabric

I can't connect to mysqlfabric on port 32275. I am connecting on port 3306 to database so all the grants are in place . On port 32275 I get a message ERROR 1044 (42000): [Fabric] Access denied for user and in log I can see [INFO]…
miaw
  • 21
  • 3
1
vote
0 answers

MySQL sharding and stored procedures

Is there a way to dispatch stored procedure invocation on particular shard, based on sharding key (passed as procedure argument or somehow separately)? For example we have a table, sharded between 3 nodes using HASH sharding strategy. All rows with…
silent-box
  • 1,649
  • 3
  • 21
  • 40
1
vote
1 answer

Connect to MySQL Fabric with PHP

I only have a high availability group in my MySQL Fabric configuration and I would like to connect to it with PHP. I check http://dev.mysql.com/doc/mysql-utilities/1.4/en/fabric.html for Fabric aware connector in PHP. However, I only find Java and…
Greenhand
  • 681
  • 2
  • 9
  • 17
0
votes
1 answer

ImportError: No module named fabric when run mysqlfabric command

My VM is using Ubuntu 14.04. I followed the official manual to install MySql Fabric: First, install Connector/Python GA Next, install MySQL Utilities 1.5.6 However, when I tried to test the mysqlfabric help command, it threw error like: Traceback…
haotang
  • 5,520
  • 35
  • 46
0
votes
1 answer

Error Executing : mysqlfabric sharding add_table 1 employees.employees emp_no

When I execute the following command for creating shard : mysqlfabric sharding add_table 1 employees.employees emp_no I get the following error: DatabaseError: Command (INSERT INTO shard_tables(shard_mapping_id, table_name, column_name)…
Shantanu Bansal
  • 29
  • 1
  • 5
0
votes
1 answer

Does MySQLFabric support mysql replication semi synchronous ( 5.7 version) when failover happens?

Semi synchronous Replication can be established in Mysql Server 5.7. If in a cluster or HA group of 5.7 mysql servers is used in latest MySQL Fabric, when secondary becomes primary does the secondary automatically get the semi synchronous settings?…
Gaurav Kukal
  • 1
  • 1
0
votes
1 answer

Connecting Php application with MySQL Fabric (using php aware connector)

I have implemented MySQL Sharding using MySQL Fabric as following steps: Steps: 1. Install latest (mysql-utilities-1.5.2 utility) for MySQL Fabric and enable mysqlnd_ms for php-aware-connector 2. Set up and manage MySQL Fabric 3. Create group…
Kuldeep Singh
  • 13
  • 4
0
votes
2 answers

MySQL Fabric failover and Connection Pooling with Hibernate

I'm attempting to implement automatic failover via a MySQL Fabric Server Group using a JNDI Resource, Hibernate, and Connection Pooling. Our DB farm is properly setup with MySQL Fabric and I'm attempting to implement the client/connector. I have a…
StevenNord
  • 11
  • 2
0
votes
1 answer

How to set Hibernate Configuration properties to connect to Mysql using Fabric driver

I'm trying to get some old code working thats creates some tables for a hibernate configuration in a Mysql Database, but the code referred to a datasource config that I no longer have and I just want to run it as standalone Java (not within Tomcat…
Paul Taylor
  • 13,411
  • 42
  • 184
  • 351
0
votes
1 answer

MySQL Fabric add group report User (fabric) does not have appropriate privileges when user have privilege

group add command throws an error $ mysqlfabric group add group_id-1 127.0.0.1:70002 Fabric UUID: 5ca1ab1e-a007-feed-f00d-cab3fe13249e Time-To-Live: 1 ServerError: User (fabric) does not have appropriate privileges (ALL PRIVILEGES) on server…
wener
  • 7,191
  • 6
  • 54
  • 78
-1
votes
1 answer

How to restart MySQL Fabric with authentication enabled?

I was working on a MySQL Fabric installation, and had been working with disable_authentication set to yes: ... [protocol.xmlrpc] address = 0.0.0.0:32274 threads = 5 user = admin password = hunter2 disable_authentication = yes realm = MySQL…
cincodenada
  • 2,877
  • 25
  • 35
-3
votes
1 answer

ImportError: No module named fabric

I am new to mysql fabric. I am getting the following error: root@ajith-System-Product-Name:/home/ajith# mysqlfabric Traceback (most recent call last): File "/usr/bin/mysqlfabric", line 33, in from mysql.fabric import ( ImportError: No…
Ajith Au
  • 11
  • 2