Solved

multiple mySQL data directories?

Posted on 2013-02-03
3
436 Views
Last Modified: 2013-02-05
I would like to use multiple data directories.  Right now my.ini points to a single d:\mysqldata directory.
I would like to do something as in Microsoft SQLServer that allows storing database files anywhere (e.g. d:\sqldata, e:\sqldata, f:\sqldata).

Why?  I have many large (5Gb+) mySQL databases.  SSD is the way to go, but drives bigger than 128G are for now expensive.  Plus a single point of failure for all the databases...
So I would like to add 128G SSD drives in my Windows machine, as I do in my SQL Servers.
0
Comment
Question by:Francois Koutchouk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 2

Author Comment

by:Francois Koutchouk
ID: 38850057
Thank you, my bad, I failed to indicate that I am using
innodb_file_per_table option (the only way with many large databases like mine).
The second article indicates that .sym files are not supported in this mode.
Any other options in Windows?
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 38850169
I fear that then you have to go the innodb way with tablespaces, where you can locate the tablespaces as you wish, or to another database engine (like MS SQL Server or ORACLE that do allow this kind of configuration) ...
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question