Setting up multiple MySQL databases with scalability options -


I need to install a MySQL environment that will help connect many unique databases over time (thousands, in fact ). I think I have to start adding mySQL server at some point, and I would already like my environment to be ready for this matter, so that the second, third, 100th server can be easier.

And to make it just interesting, it would be very convenient if the solution was modeled so that applications querying the database send all questions to the same address and get the results. It should be unaware of the number and location of the server. The name of the database is unique and can be used to determine which database holds the database.

I did some research, and the MySQL proxy fashion as the main candidate, but I can not find anything special about doing it as described above.

Anyone?

Good questions I know that many companies have done this (Facebook jumps out as the biggest No one is happy, but the options also suck, too.

More to consider - What happens when some of these databases or servers fail? What happens when you need to do a cross-database query (and you, even if you do not like it now). Here's FriendFeeded Solution:

This is a Bit "back-asswards" because they are basically using MySQL as a glorified key-value store. I'm not sure why they just do not take middlemen and use things like Berkeleybee to store their objects. Connection management, maybe? It seems that the cost to pay something like this in the upper part of MySQL, which can easily add (famous last word)

What you are actually seeing (I think) is a distributed shared-nothing database. Many Open-Source Technologies such as MySQL and PostgreSQL have been built on top, but none is available for free. If you are in the mood of purchase, then check these companies: ,,,,,

There are also many distributed key-value storage solutions available. For a lack of better context, here's a starting point.


Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more