English 中文(简体)
从单一机器操作硬化银
原标题:Running a sharded DB from a single machine

这种音响平,但我有一个软弱的行文,我认为我不再需要用2台机器操作,而是用一个机器操作。

任何关于如何能够做到这一点的想法? 在如何实现反常方面,有许多资源,但对于如何做到这一点,资源却很少。

最佳回答

如果你将两个单独的数据库程序(及其储存)移至一个单一机器,则你有两种选择。

  1. Start the executable for the database twice, each from different config files (which specify different ports). The client will need to be able to connect to the two instances on their respective ports. Depending on your database and operating system, this might not be possible.
  2. Run two virtual images, on per db/shard. The client connects to each by whatever IP address you configure the VM to have.
问题回答

暂无回答




相关问题
SQL SubQuery getting particular column

I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...

please can anyone check this while loop and if condition

<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...

php return a specific row from query

Is it possible in php to return a specific row of data from a mysql query? None of the fetch statements that I ve found return a 2 dimensional array to access specific rows. I want to be able to ...

Character Encodings in PHP and MySQL

Our website was developed with a meta tag set to... <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> This works fine for M-dashes and special quotes, etc. However, I ...

Pagination Strategies for Complex (slow) Datasets

What are some of the strategies being used for pagination of data sets that involve complex queries? count(*) takes ~1.5 sec so we don t want to hit the DB for every page view. Currently there are ~...

Averaging a total in mySQL

My table looks like person_id | car_id | miles ------------------------------ 1 | 1 | 100 1 | 2 | 200 2 | 3 | 1000 2 | 4 | 500 I need to ...

热门标签